[size=large]import java.sql.Connection;
import java.sql.PreparedStatement;
public class jdbc13a {
public static void main(String[]args){
Connection con=null;
PreparedStatement ps =null;
try{
con=jdbcUtil.getConnection();
con.setAutoCommit(false);
String sql="insert into nba values(?,?)";
ps = con.prepareStatement(sql);
System.out.println(new java.util.Date());
for(int i=1;i<=10000;i++){
ps.setString(1,"cba"+i);
ps.setInt(2, i);
ps.addBatch();
if(i%100==0){
ps.executeBatch();
}
}
con.commit();
System.out.println(new java.util.Date());
}catch(Exception e){
e.printStackTrace();
try{
con.rollback();
}catch(Exception el){
el.printStackTrace();
}
}finally{
jdbcUtil.release(null,ps, con);
}
}
}
[/size]
import java.sql.PreparedStatement;
public class jdbc13a {
public static void main(String[]args){
Connection con=null;
PreparedStatement ps =null;
try{
con=jdbcUtil.getConnection();
con.setAutoCommit(false);
String sql="insert into nba values(?,?)";
ps = con.prepareStatement(sql);
System.out.println(new java.util.Date());
for(int i=1;i<=10000;i++){
ps.setString(1,"cba"+i);
ps.setInt(2, i);
ps.addBatch();
if(i%100==0){
ps.executeBatch();
}
}
con.commit();
System.out.println(new java.util.Date());
}catch(Exception e){
e.printStackTrace();
try{
con.rollback();
}catch(Exception el){
el.printStackTrace();
}
}finally{
jdbcUtil.release(null,ps, con);
}
}
}
[/size]