Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con = DriverManager
.getConnection
("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test","sa", "");
con.setAutoCommit(false);
PreparedStatement ps=con.prepareStatement("insert into table1 (id,name) values(?,?)");
ps.setString(1, "1");
ps.setString(2, "c++");
ps.addBatch();
ps.setString(1, "2");
ps.setString(2, "ja");
ps.addBatch();
ps.executeBatch();
con.commit();
for(int m = 0;m<a.length;m++){
System.out.println(a[m]);
} ps.close();
con.close();
}会出现错误:Statements that produce result sets are not allowed in batch commands.
Connection con = DriverManager
.getConnection
("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test","sa", "");
con.setAutoCommit(false);
PreparedStatement ps=con.prepareStatement("insert into table1 (id,name) values(?,?)");
ps.setString(1, "1");
ps.setString(2, "c++");
ps.addBatch();
ps.setString(1, "2");
ps.setString(2, "ja");
ps.addBatch();
ps.executeBatch();
con.commit();
for(int m = 0;m<a.length;m++){
System.out.println(a[m]);
} ps.close();
con.close();
}会出现错误:Statements that produce result sets are not allowed in batch commands.
安装 JDBC Service Pack 3 SQL Server 2000 驱动程序。http://www.microsoft.com/downloads/details.aspx?FamilyID=07287b11-0502-461a-b138-2aa54bfdc03a&DisplayLang=en
JDBC Service Pack 3 SQL Server 2000 好像没有相关链接了,我正在找。
准备结贴了。