JDBC封装类5大步骤

JDBC的步骤
1.注册驱动
Class.forName(“java.mysql.jdbc.Driver”)
2.获得连接对象
String url = “jdbc:mysql://localhost:3306/库名”;
String username = “root”; // mysql的用户名
String password = “123456”; // mysql的密码
Connection conn = DriverManager.getConnection(url, username, password);
3.获得执行语句对象
Statement s = conn.createStatement();
4.执行SQL
String sql = “insert into user values (5,‘张三’,‘女’,‘1990-01-01’,100)”;
int rowNum = s.executeUpdate(sql); // 增删改都是executeUpdate,返回值是受影响的行数
if(rowNum > 0) {
System.out.println(“执行成功”);
}
5.关流
s.close();
conn.close();