数据库查询及修改操作
可修改的结果集
由于执行性能的问题,一般不建议使用
public static void main(String[] args)throws Exception {
Class.forName("com.mysql.cj.jdbc.Driver");
String sql = "select * from tb_emp";
try(
Connection conn = DriverManager.getConnection("jdbc:mysql:///test?serverTimezone=UTC","root","123456");
PreparedStatement ps = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs = ps.executeQuery()
){
while (rs.next()) {
System.out.println(rs.getLong("id") + "\t" + rs.getString("name"));
//修改数据
if (rs.getDouble("salary") < 1000) {
double oldValue = rs.getDouble("salary");
rs.updateDouble("salary", oldValue + 200);
rs.updateRow();
}
}
//插入数据
rs.moveToInsertRow();
rs.updateString("name","傻子");
rs.updateDouble("salary",