67,513
社区成员
发帖
与我相关
我的任务
分享
public static void dataUpdate() throws SQLException {
String quary = "select FID,fQUYUBIANHAO from XX WHERE fLEIXING='乡镇'";// 查询
List<Map<String, String>> quqrylist = DBUtils.execQueryforList("oa", quary);
Connection conn = null;
PreparedStatement ps = null;
try {
conn = DBUtils.getAppConn("oa");
for (int i = 0; i < quqrylist.size(); i++) {
int q=i++;
String no=quqrylist.get(i).get("fQUYUBIANHAO").substring(0, 9);
String ffid=quqrylist.get(i).get("FID");
ps = conn.prepareStatement("update XX SET fFUID='"+ffid+"' WHERE fLEIXING='村' AND SUBSTRING(fQUYUBIANHAO, 1, 9) = '"+no+"'");
ps.executeUpdate();
System.out.println(q+":"+no);
}
} catch (Exception e) {
e.printStackTrace();
}finally {
DBUtils.CloseConn(conn, ps, null);
}
}
}