青春联盟

import java.sql.*;

public class TestBatchforPstmt1
{
public static void main(String[] args)
{

PreparedStatement pstmt=null;
Connection conn=null;
try
{
Class.forName(“com.mysql.jdbc.Driver”);
String url=”jdbc:mysql://127.0.0.1:3306/mysql”;
String user=”root”;
String password=”******”;
conn=DriverManager.getConnection(url,user,password);
pstmt=conn.prepareStatement(“insert into dbtest values(?,?,?)”);
conn.setAutoCommit(false);//首先把Auto commit设置为false,不让它自动提交
pstmt.setInt(1,15);
pstmt.setString(2,”nlh”);
pstmt.setInt(3,25);
pstmt.addBatch(); //将一组参数添加到此 PreparedStatement 对象的批处理命令中。
pstmt.setInt(1,16);
pstmt.setString(2,”nlh”);
pstmt.setInt(3,25);
pstmt.addBatch();
pstmt.setInt(1,17);
pstmt.setString(2,”nlh”);
pstmt.setInt(3,25);
pstmt.addBatch();

pstmt.executeBatch();
conn.commit();//进行手动提交（commit）
conn.setAutoCommit(true);//提交完成后回复现场将Auto commit,还原为true
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
if(pstmt!=null)
{
pstmt.close();
}
if(conn!=null)
{
conn.close();
}
}
catch(SQLException e)
{
e.printStackTrace();
}
}

}

}