jdbc批量操作

package org.lei.test;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.lei.util.JDBCUtil;

/**
 * @author renlei 
 * @E-mail:renlei0109@yeah.net
 * @version 创建时间：2014-6-18 下午4:21:27 简单说明
 */
public class TestBatchSql {
		public static void main(String[]args){
			batchInsert();
		
		}
		public static void batchInsert(){
			Connection conn = null;
			PreparedStatement ps = null;
			ResultSet rs = null;
			try {
				conn = JDBCUtil.getInstance().getConnection();
				String sql = "insert into lei values(?,?)";
				ps = conn.prepareStatement(sql);
				for(int i = 0;i<100;i++){
					ps.setInt(1, i);
					ps.setString(2, "renlei"+i);
					ps.addBatch();
					
				}
				//也可以使ps.addBatch(sql1);ps.addBatch(sql2)........addBatch(sql100);
				
				int []result = ps.executeBatch();
				if(result.length>0){
					System.out.println("插入成功");
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}
}