package?cn.itcast.batch;

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

import?cn.itcast.utils.JdbcUtils;

public?class?PreparedStatementBatchTest?{

	public?static?void?main（String[]?args）?throws?SQLException?{
		//?向person表中插入1000條數據

		String?sql?=?“insert?into?person?values（??）“;

		Connection?con?=?JdbcUtils.getConnection（）;

		PreparedStatement?pst?=?con.prepareStatement（sql）;

		//?批處理
		long?l=System.currentTimeMillis（）;
		for?（int?i?=?1;?i?<=?100000;?i++）?{
			pst.setInt（1?i）;
			pst.setString（2?“name“?+?i）;
			pst.addBatch（）;
			
			if（i%1000==0）{
				pst.executeBatch（）;
				pst.clearBatch（）;?//清空緩存。
			}
			
		}
		
		//執行批處理
		pst.executeBatch（）;
		
		pst.close（）;
		con.close（）;
		
		System

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????619??2014-12-05?17:24??jdbcDemo\.classpath

?????文件????????294??2014-12-05?16:34??jdbcDemo\.mymetadata

?????文件???????1534??2014-12-05?16:34??jdbcDemo\.project

?????文件????????500??2014-12-05?16:34??jdbcDemo\.settings\.jsdtscope

?????文件????????395??2014-12-05?16:34??jdbcDemo\.settings\org.eclipse.jdt.core.prefs

?????文件????????459??2014-12-05?16:34??jdbcDemo\.settings\org.eclipse.wst.common.component

?????文件????????252??2014-12-05?16:34??jdbcDemo\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2014-12-05?16:34??jdbcDemo\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2014-12-05?16:34??jdbcDemo\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件?????170654??2014-12-05?16:55??jdbcDemo\a.txt

?????文件????????894??2014-12-05?17:25??jdbcDemo\src\cn\itcast\batch\PreparedStatementBatchTest.java

?????文件???????1004??2014-12-05?17:09??jdbcDemo\src\cn\itcast\batch\StatementBatchTest.java

?????文件???????2034??2014-12-05?16:50??jdbcDemo\src\cn\itcast\lob\MyBlobTest.java

?????文件???????1731??2014-12-05?17:01??jdbcDemo\src\cn\itcast\lob\MyTextTest.java

?????文件???????1489??2014-12-05?14:49??jdbcDemo\src\cn\itcast\utils\JdbcUtils.java

?????文件????????287??2014-12-05?17:23??jdbcDemo\src\jdbc.properties

?????文件????????829??2014-12-05?16:34??jdbcDemo\WebRoot\index.jsp

?????文件?????????36??2014-12-05?16:34??jdbcDemo\WebRoot\meta-INF\MANIFEST.MF

?????文件???????1606??2014-12-05?17:25??jdbcDemo\WebRoot\WEB-INF\classes\cn\itcast\batch\PreparedStatementBatchTest.class

?????文件???????1395??2014-12-05?17:24??jdbcDemo\WebRoot\WEB-INF\classes\cn\itcast\batch\StatementBatchTest.class

?????文件???????2432??2014-12-05?17:24??jdbcDemo\WebRoot\WEB-INF\classes\cn\itcast\lob\MyBlobTest.class

?????文件???????2224??2014-12-05?17:24??jdbcDemo\WebRoot\WEB-INF\classes\cn\itcast\lob\MyTextTest.class

?????文件???????1864??2014-12-05?17:24??jdbcDemo\WebRoot\WEB-INF\classes\cn\itcast\utils\JdbcUtils.class

?????文件????????287??2014-12-05?17:23??jdbcDemo\WebRoot\WEB-INF\classes\jdbc.properties

?????文件?????875339??2014-12-05?17:24??jdbcDemo\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.28-bin.jar

?????文件????????404??2014-12-05?16:34??jdbcDemo\WebRoot\WEB-INF\web.xml

?????目錄??????????0??2016-05-13?11:42??jdbcDemo\WebRoot\WEB-INF\classes\cn\itcast\batch

?????目錄??????????0??2016-05-13?11:42??jdbcDemo\WebRoot\WEB-INF\classes\cn\itcast\lob

?????目錄??????????0??2016-05-13?11:42??jdbcDemo\WebRoot\WEB-INF\classes\cn\itcast\utils

?????目錄??????????0??2016-05-13?11:42??jdbcDemo\WebRoot\WEB-INF\classes\cn\itcast

............此處省略18個文件信息