Java教程 数据库.ppt

package jdbc; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class TestJDBC { public static void main(String[] args) { try { Class.forName(com.mysql.jdbc.Driver); } catch (ClassNotFoundException e) { e.printStackTrace(); } 使用try-with-resource的方式自动关闭连接 try ( Connection c = DriverManager.getConnection(jdbc:mysql://:3306/test?characterEncoding=UTF-8, root, admin); Statement s = c.createStatement(); ) { String sql = insert into hero values(null, + 提莫 + , + 313.0f + , + 50 + ); s.execute(sql); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } String sql = insert into hero values(null, + 提莫 + , + 313.0f + , + 50 + ); String sql = delete from hero where id = 5; String sql = update hero set name = name 5 where id = 3; 增、删、改语句 package jdbc; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class TestJDBC { public static void main(String[] args) { try { Class.forName(com.mysql.jdbc.Driver); } catch (ClassNotFoundException e) { e.printStackTrace(); } try (Connection c = DriverManager.getConnection(jdbc:mysql://:3306/test?characterEncoding=UTF-8, root, admin); Statement s = c.createStatement();) { executeQuery 执行SQL查询语句 String sql = select * from hero; // 执行查询语句，并把结果集返回给ResultSet ResultSet rs = s.executeQuery(sql); while (rs.next()) { int id = rs.getInt(id);// 可以使用字段名 String name = rs.getString(2);// 也可以使用字段的顺序 float hp = rs.getFloat(hp); int dama