JDBC开发步骤:
- 注册驱动:Class.forName(“com.mysql.jdbc.Driver”);
- 连接数据库:
String URL="jdbc:mysql://localhost:3306/数据库名?useUnicode=true&characterEncoding=utf8";
String username="root";
String password="123456"
Connection conn=DriverManager.getConnection(URL,username,password);
- 获取发送SQL的对象:
Statement statement=conn.createStatement();
SQL注入问题:上句改用:
PreparedStatement pstmt=conn.prepareStatement(“select * from user where username=? and password=?”);
pstmt.setString(1,username);
pstmt.setString(2,password); - 执行SQL语句,并接收执行结果
String sql=" …";
int result = statement.executeUpdate(sql);
或
ResultSet rs= statement.executeQuery(sql);
DML语句:增删改时,返回受影响行数(int类型)
DQL语句:查询时,返回结果数据(ResultSet结果集) - 处理结果
if(result == 1){
System.out.println(“Success”);
}else{
System.out.println(“执行失败!”)
}
或 结果集:
while(rs.next()){
String job_id=rs.getString(“job_id”);
int min_salary= rs.getInt(“min_salary”);
…
}
6.释放资源,先开后关原则
rs.close();//查询时
statement.close();
conn.close();
事务:
conn.setAutoCommit(false);关闭自动提交事务
conn.commit();提交事务
conn.rollback();事务回滚