批处理

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

public class Test{
    

	public static Connection getConnection(){
		Connection conn=null;
			try{
				conn=DriverManager.getConnection("jdbc:mysql://localhost/mydb?" +
				"user=root&password=12345678");
			}catch(Exception ex){
				ex.printStackTrace();
			}
			
		return conn;
		}
	
	public static void main(String args[]){
		
		
		ResultSet rs = null;
		Statement stmt=null;
		try {
			stmt = Test.getConnection().createStatement();
			rs = stmt.executeQuery("SELECT * FROM testtable");
			while(rs.next()){
				System.out.println("the name is:"+rs.getString(2)+"the address is"+rs.getString("address"));
				System.out.println("the result is"+(String)rs.getString(1));
			}
		}catch (SQLException ex){
			//handle any errors
			System.out.println("SQLException: " + ex.getMessage());
			System.out.println("SQLState: " + ex.getSQLState());
			System.out.println("VendorError: " + ex.getErrorCode());
		}
		finally {
		//it is a good idea to release
		//resources in a finally{} block
		//in reverse-order of their creation
		//if they are no-longer needed
		if (rs != null) {
		try {
		rs.close();
		} catch (SQLException sqlEx) { } // ignore
		rs = null;
		}
		if (stmt != null) {
		try {
		stmt.close();
		} catch (SQLException sqlEx) { } // ignore
		stmt = null;
		}	
	}
		
		Test test = new Test();
		test.batchInsertData(test.getConnection());
		
	}
	
	public void batchInsertData( Connection con){
		 
		 PreparedStatement preparedStatement= null;
		 
         
		   try{
			   preparedStatement=con.prepareStatement("insert into testtable(id,name,address) values(?,?,?)");
			   int size = 100000;

			   for (int i = 1; i < size; i++) {
			   preparedStatement.setInt(1, i);
			   preparedStatement.setString(2, "hongwei" + i);
			   preparedStatement.setString(3, "address" + i);
			   preparedStatement.addBatch();
			   }

			   preparedStatement.executeBatch();

			   preparedStatement.close();
			   con.close();
		   }catch(Exception ex){
			   ex.printStackTrace();
			   
		   }
		   

		
	}
	
	}