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

import?org.junit.Test;




public?class?BatchMysql?{
	
	
	@Test
	
	public?static?void?batchInsert（）?throws?ClassNotFoundException?SQLException{
????????long?start?=?System.currentTimeMillis（）;
????????Class.forName（“com.mysql.jdbc.Driver“）;
????????Connection?connection?=?DriverManager.getConnection（
????????????????????????“jdbc:mysql://127.0.0.1:3306/wemall?useServerPrepStmts=false&rewriteBatchedStatements=true“
????????????????????????“root“?“123456“）;

????????connection.setAutoCommit（false）;
????????PreparedStatement?pstm?=?connection
????????????????.prepareStatement（“INSERT?INTO?wemall_user（idaddtimedeleteStatusMSNQQWWaddressavailableBalancebirthdayemailfreezeBlancegoldintegrallastLoginDatelastLoginIploginCountloginDateloginIpmobile‘password‘reportsexstatustelephonetrueNameuserNameuserRoleuser_creditphoto_idstore_idqq_openidsina_openidstore_quick_menuparent_idyearsarea_idtokensalesman_idlogoUrlweixinzfbidentityIdreferrerIdValidateCodeValidateTimecommissionRateagentIdproviderIdsalesmanIdlegal_IdCardlegal_namelegal_telephonenumberlegal_business_licencebuyersellernametl_useridbanned_statusdepositdeposit_statedeposit_timeTL_uuid）?VALUES（????????????????????????????????????????????????????????????）“）;
????????
????????for?（int?i?=?132001000;?i?????????	pstm.setInt（1?i）;
????		pstm.setString（2?“20170104“）;
????		pstm.setString（3?““）;
????	????pstm.setString（4?“85236547@qq.com“）;
????	????pstm.setString（5?“856985472“）;
????	????pstm.setString（6?“wwww.dkjf.com“）;
????	????pstm.setString（7?“廣州市“）;
????	????pstm.setString（8?“9620“）;
????	????pstm.setString（9?“19930104“）;
????		pstm.setString（10?“86523654@ww.com“）;
????	????pstm.setString（11?“12“）;
????	????pstm.setString（12?“0“）;
????	????pstm.setString（13?“2“）;
????	????pstm.setString（14?“20170104“）;
????		pstm.setString（15?“0:0:0:0:0:0:0:1“）;
????	????pstm.setString（16?“1“）;
????	????pstm.setString（17?“20170104“）;
????	????pstm.setString（18?“0:0:0:0:0:0:0:1“）;
????	????pstm.setString（19?“15236547852“）;
????	????pstm.setString（20?“e10adc3949ba59abbe56e057f20f883e“）;
????		pstm.setString（21?“0“）;
????	????pstm.setString（22?“0“）;
????	????pstm.setInt（23?1）;
????	????pstm.setString（24?“156022876281“）;
????	????pstm.setString（25?“0“）;
????	????pstm.setInt（26?i）;
????		pstm.setString（27?“BUYER“）;
????	????pstm.setString（28?“0“）;
????	????pstm.setInt（29?1）;
????	????pstm.setInt（30?32818）;
????	????pstm.setString（31?“123“）;
????	????pstm.setString（32?““）;
????		pstm.setString（33?““）;
????	????pstm.setInt（34?i）;
????	????pstm.setString（35?“0“）;
????	????pstm.setInt（36?4521984）;
????	????pstm.setString（37?“f5fbd4d9a77f471c9d376f4440d340b

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

?????文件????????461??2017-06-09?11:30??MysqlDemo\.classpath

?????文件????????385??2017-06-09?11:10??MysqlDemo\.project

?????文件????????629??2017-06-09?11:10??MysqlDemo\.settings\org.eclipse.jdt.core.prefs

?????文件???????3889??2017-06-09?18:17??MysqlDemo\bin\BatchMysql.class

?????文件???????4791??2017-06-09?17:43??MysqlDemo\bin\mysqltest.class

?????文件???????4210??2017-06-09?18:17??MysqlDemo\src\BatchMysql.java

?????文件???????6882??2017-06-09?17:43??MysqlDemo\src\mysqltest.java

?????目錄??????????0??2017-06-09?11:10??MysqlDemo\.settings

?????目錄??????????0??2017-06-09?18:05??MysqlDemo\bin

?????目錄??????????0??2017-06-09?18:05??MysqlDemo\src

?????目錄??????????0??2017-06-09?11:10??MysqlDemo

-----------?---------??----------?-----??----

????????????????21247????????????????????11