批量更新(batch)

package com.jdbctest.batch;
import com.jdbctest.Util.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

//PreparedStatement接口的批量更新
public class PreparedStatementBatchtest {

	public static void main(String args[]){
		Connection conn = null;
		PreparedStatement ps = null;

		conn = JDBCUtil.getConnection();

		String sql="INSERT INTO score(sno,sname,score)"+"VALUES(?,?,?)";

		try {
			long start =System.currentTimeMillis();
			ps = conn.prepareStatement(sql);
			for(int i = 0 ; i<10000;i++){
				ps.setString(1, "20060800"+i);
				ps.setString(2, "wuyu");
				ps.setString(4, 88);
				ps.addBatch();
			}
			ps.executeBatch();
			long end=System.currentTimeMillis();
			System.out.println("用时: "+(end-start));
		} catch (SQLException e) {

			e.printStackTrace();
		}

	}


}


package com.jdbctest.batch;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

import com.jdbctest.Util.JDBCUtil;

/**
 * Statement 批量更新
 * @author wuyu
 *
 */
public class StatementBatchTest {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		Connection conn = null;
		Statement stmt = null;

		conn = JDBCUtil.getConnection();

		try {long begin=System.currentTimeMillis();
			stmt = conn.createStatement();
			for(int i = 1; i<10000;i++){
				stmt.addBatch("INSERT INTO score(sno,sname,score)"+"VALUES('20006080"+i+"','wuyu',88.9)");

			}
			stmt.executeBatch();
			long end = System.currentTimeMillis();
			System.out.println("用时："+(end-begin));
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

}