第13章使用JBC进行库连接.ppt

* /** 这是 main 方法*/ public static void main(String [] args) { try { Class.forName(“com.mysql.jdbc.Driver); } catch (ClassNotFoundException ce) { System.out.println(ce); } try { String url = “jdbc:mysql://localhost/test; String str = INSERT INTO “ + friends(name,address,salary)“ + “VALUES(‘朱宏‘,’深圳 ‘,25690); Connection con = DriverManager.getConnection(url); Statement s = con.createStatement(); int rowcount = s.executeUpdate(str); String str1 = select name, sum(salary) “