Question

关于Java连接数据库中一次增加多条命令要怎么做？

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class Add
{
public static void main(String[] args) throws ClassNotFoundException {
Connection conn;
Statement stmt = null;
conn = null;
try {
String ur1="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=D:/java web database/personal information.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(ur1);
stmt = conn.createStatement();
stmt.executeUpdate("insert into base values (3,'小王','XXX','XXX' )" );
//比如我这里还想增加 (4,'小王','XXX','XXX' )" ); (5,'小王','XXX','XXX' )" ); (6,'小王','XXX','XXX' )" );
//我试了在上面加个for循环貌似不行.难道SQL语句只能一句一句增加吗?
System.out.println("成功添加一条数据");
} catch (Exception e) {
System.out.println("sql出错:");
System.out.println(e);
}
finally{
try {
if(stmt!=null){
stmt.close();
stmt=null;
}
if(conn!=null){
conn.close();
conn=null;
}
}catch (SQLException e) {
e.printStackTrace();
}
}
}
}

Answer 1

把棚搏{3,'小王链凳祥','XXX','XXX'}做成一粗斗个JavaBean，然后把一个个JavaBean加入到数组中，在传到添加的方法中，循环添加

Answer 2

用PreparedStatement，通过他的addBatch()和executeBatch()方法可以轻松实现批量更睁消新，具悉携知隐伍体代码可参考
http://blog.csdn.net/tower888/article/details/10782781