Connection 笔记

Connection conn;
PreparedStatement ps;
ResultSet rs;
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:db63", "username", "password");
String selectSql = "select * from emp order by id asc"; //关键1：sql一定加order by
String updateSql = "update emp set name=? where id=?";
ps = conn.prepareStatement(selectSql);
rs = ps.executeQuery();
int count = 0; //结果集数
if(rs.next()){
	count++;
}
rs.close();
for(int i = 0; i < count; i++){
	ps = conn.prepareStatement(updateSql);
	ps.setString(1, "name");
	ps.setLong(2, i);
	int n = ps.executeUpdate();
	if(n > 0){
		System.out.println("修改成功");
	}
	ps.close(); //关键2：当处理的数据较多时，关闭statement，否则报“超出打开游标的最大值”
}
conn.commit(); //关键3：修改与增加语句，一定不忘写commit提交
conn.close();