67,513
社区成员
发帖
与我相关
我的任务
分享
Class.forName("com.ibm.db2.jcc.DB2Driver");
Connection conn = DriverManager.getConnection("jdbc:db2://197.3.5.131:30000/pe", "uperxia", "AB1BsO7U");
PreparedStatement stmt = null;
ResultSet rs = null;
for(int i=0;i<5000;i++){
stmt = conn.prepareStatement("select "+i+" from sl_jc_sjrq where "+i+"="+i);
rs = stmt.executeQuery();
rs.next();
System.out.println(i+":"+rs.getString(1)+"");
rs.close();
//stmt.close();
}
stmt.close();
conn.close();