jdbc操作测试类

package com.fs.test;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.SQLException;import java.sql.Statement;import java.sql.Timestamp;import java.util.Random;public class Test2 {public static String getNumber() {Timestamp now = new Timestamp(System.currentTimeMillis());String number = now.toString().replace("-", "").replace(" ", "").replace(":", "").replace(".", "");String str = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";Random r = new Random();for (int i = 0; i < 2; i++) {int n = r.nextInt(26);number = str.substring(n, n + 1) + number;}return number;}public void exec3(Connection conn, String sql) {try {conn.setAutoCommit(false);Long beginTime = System.currentTimeMillis();PreparedStatement pst = conn.prepareStatement(sql);Statement st = conn.createStatement();for (int i = 1; i <=22; i++) {long num = 13871124811l + i;System.out.println("num="+num);pst.setString(1, String.valueOf(num));pst.addBatch();if (i % 1000 == 0) {// 可以设置不同的大小;如50，100，500，1000等等System.out.println("==可以设置不同的大小;如50，100，500，1000等等==");pst.executeBatch();conn.commit();pst.clearBatch();}else if(i==22){System.out.println("==1000000==");pst.executeBatch();conn.commit();pst.clearBatch();}}//st.executeUpdate(sql);Long endTime = System.currentTimeMillis();System.out.println("pst+batch：" + (endTime - beginTime) / 1000+ "秒");conn.commit();st.close();pst.close();conn.close();} catch (Exception e) {// TODO: handle exceptione.printStackTrace();}}public static void main(String[] args) {// System.out.println(Test2.getNumber());try {Class.forName("com.ibm.db2.jcc.DB2Driver");Connection conn = DriverManager.getConnection("jdbc:db2://192.168.1.1:50110/masdb", "name","paswd");String sql1= "INSERT INTO TBL_SMSENDTASK (CREATORID,TASKNAME,SMSENDEDNUM,OPERATIONTYPE,"+ "SUBOPERATIONTYPE,SENDTYPE,ORGADDR,DESTADDR,SM_CONTENT,SENDTIME, "+ "NEEDSTATEREPORT,SERVICEID,FEETYPE,FEECODE,MSGID,SMTYPE,MESSAGEID, "+ "DESTADDRTYPE,SUBTIME,TASKSTATUS,SENDLEVEL,SENDSTATE,TRYTIMES,COUNT,"+ "SUCCESSID,RESERVE1,RESERVE2,SISMSID,MSGFMT,SENDMETHODTYPE,APPLICATIONID,"+ "SOURCEFLAG) VALUES"+ "('0000','ff',0,'WAS','66',1,'1111111',?,"+ "'这是测试，谢谢!','2011-05-31 15:43:15',0,'bbbbb','01',"+ "'10',null,0,'0',0,'2011-05-31 15:43:15',0,2,0,3,1,0,null,null,null,null,0,null,0)";Test2 te=new Test2();te.exec3(conn,sql1);} catch (Exception e) {e.printStackTrace();}}}