通过两条输出指令可以看到新密码已经生成,而且数目正常,但是为什么数据库里面密码的字段值还是没有修改成功呢?
源程序:
package javaapplication1;
import dbManager.dbManager;
import java.sql.*;
public class SetPWD {
public static void main(String[] args) {
dbManager dbm = new dbManager();
Statement stmt = null;
int n = 0;
try {
String sql1 = "select xh,zjhm,passwd from xsjbxx where nj='2009'";
ResultSet rs = dbm.getResultSet(sql1);
stmt = rs.getStatement();
while (rs.next()) {
n++;
String xh = rs.getString("xh").trim();
String zjhm = rs.getString("zjhm").trim();
String newPWD = MD5.getMD5("111111");
System.out.println(newPWD);
String sql2 = "update xsjbxx set passwd='" + newPWD + "' where xh='" + xh + "'";
stmt.addBatch(sql2);
}
stmt.executeBatch();
} catch (Exception ex) {
}
System.out.println(n);
}
}