PreparedStatement的addbatch()具体怎么使用? 请问各位高手:PreparedStatement的addbatch()具体怎么使用?针对多条带参数的sql语句? 请高手指点一二!!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 PreparedStatement ps = conn.prepareStatement( "INSERT into employees values (?, ?, ?)");for (n = 0; n < 100; n++) { ps.setString(name[n]); ps.setLong(id[n]); ps.setInt(salary[n]); ps.addBatch();}ps.executeBatch(); connection.setAutoCommit(false);PreparedStatement statement = connection.prepareStatement("INSERT INTO TABLEX VALUES(?, ?)");statement.setInt(1, 1);statement.setString(2, "Cujo");statement.addBatch();statement.setInt(1, 2);statement.setString(2, "Fred");statement.addBatch();statement.setInt(1, 3);statement.setString(2, "Mark");statement.addBatch();int [] counts = statement.executeBatch();connection.commit(); java socket 怎么使用网上发布的包? 求助java中报表问题! 高手知道下学习J2EE的学习计划 java调用VC写的DLL,如何传递参数 Collection.Iterator,ArrayList,三者是一个什么样关系? 关于setPage路径的问题------在线给分 100分请教:SL275教材的电子版! 怎样在jbuilder中控制按钮的大小?恳请赐教 请问怎么把“1/40000”这个有理数形式的字符串转成double型 如何过滤System.in.read()后面的回车换行符 谁能给我一个最简单的使用JEditorPane的例子
conn.prepareStatement( "INSERT into employees values (?, ?, ?)");
for (n = 0; n < 100; n++) {
ps.setString(name[n]);
ps.setLong(id[n]);
ps.setInt(salary[n]);
ps.addBatch();
}
ps.executeBatch();
PreparedStatement statement =
connection.prepareStatement("INSERT INTO TABLEX VALUES(?, ?)");
statement.setInt(1, 1);
statement.setString(2, "Cujo");
statement.addBatch();
statement.setInt(1, 2);
statement.setString(2, "Fred");
statement.addBatch();
statement.setInt(1, 3);
statement.setString(2, "Mark");
statement.addBatch();
int [] counts = statement.executeBatch();
connection.commit();