Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); Connection conn = DriverManager.getConnection( "jdbc:sqlserver://localhost:1443;databasename=zxtplat_ExamOnLine", "sa", "sa123456"); conn.setAutoCommit(false); String sql = "select userId,username from t_usertable where userid not in (1,2,3,4,5,6)"; //查询结果集 Statement stmt = conn.createStatement(); String presql = "update t_usertable set userpassword=? where userid=?"; PreparedStatement pstmt = (PreparedStatement) conn.prepareStatement(presql); ResultSet rs = stmt.executeQuery(sql); int i = 0; while (rs.next()) { int a = rs.getInt("userId"); String user = rs.getString("username"); if(user == null || "".equals(user)){ user = "1"; } pstmt.setString(1, new MD5().getMD5ofStr(user.trim())); pstmt.setInt(2,a); pstmt.addBatch(); i++; if(i%50 == 0){ pstmt.executeBatch(); i = 0; } } conn.commit(); pstmt.close(); stmt.close(); conn.close();
批量更新表的数据
最新推荐文章于 2024-10-28 21:28:36 发布