import cn.hutool.core.util.IdUtil;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class test3 {
public static void main(String[] args) throws Exception {
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";// 设置连接字符串
String username = "hrxj";
String password = "hrxj";
Connection con= DriverManager.getConnection(url,username,password);
String sql = "INSERT INTO HRXJ.表名(REQUEST_ID, DEVID, BRAND, MODEL, OS_NAME, OS_VERSION, SCREEN_WIDTH, LOCATION_ENABLE, MINI_TYPE, CUR_TIME, WINDOW_HEIGHT, VERSION, SCREEN_BRIGHTNESS, APPID, FONT_SIZE, LANGUAGE, BLUETOOTH_ENABLE, PLATFORM, CACHE_ID, STATUS_BAR_HEIGHT, SCREEN_HEIGHT, REMOTE_IP, SDK_VERSION, PIXEL_RATIO, WINDOW_WIDTH, NETWORK_TYPE, WIFI_ENABLE, USER_AGENT, CREATE_TIME, SYSTEM, LONGITUDE, LATITUDE, THEME, AUTH_SETTING) " +
" VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
PreparedStatement pstmtAdd = con.prepareStatement(sql);
Long start = System.currentTimeMillis();
for(int i=0;i<10001;i++){
pstmtAdd.setString(1, IdUtil.objectId()+""+"whtest");
pstmtAdd.setString(2, "855bba5af7f248baf369a0bb3a939e38");
pstmtAdd.setString(3, "aaaa");
pstmtAdd.setString(4, "xxx");
pstmtAdd.setString(5, "dddd");
pstmtAdd.setString(6, "10");
pstmtAdd.setString(7, "360");
pstmtAdd.setString(8,"false");
pstmtAdd.setString(9, "wechat");
pstmtAdd.setString(10, "1609312777145");
pstmtAdd.setString(11, "719");
pstmtAdd.setString(12, "7.0.22");
pstmtAdd.setString(13, "0.27058825");
pstmtAdd.setString(14, "com.example.demo");
pstmtAdd.setString(15, "16");
pstmtAdd.setString(16, "zh_CN");
pstmtAdd.setString(17, "true");
pstmtAdd.setString(18, "android");
pstmtAdd.setString(19, "ca180be78cd308497e8810e88d69f7c9");
pstmtAdd.setString(20, "39");
pstmtAdd.setString(21, "800");
pstmtAdd.setString(22, "114.250.29.86");
pstmtAdd.setString(23, "2.14.1");
pstmtAdd.setString(24, "3");
pstmtAdd.setString(25, "360");
pstmtAdd.setString(26, "wifi");
pstmtAdd.setString(27, "true");
pstmtAdd.setString(28, "null");
pstmtAdd.setDate(29, Date.valueOf("1990-10-11"));
pstmtAdd.setString(30, "Android 10");
pstmtAdd.setString(31, "NULL");
pstmtAdd.setString(32, "NULL");
pstmtAdd.setString(33, "NULL");
pstmtAdd.setString(34, "xxxxx");
//pstmtAdd.execute();
pstmtAdd.addBatch();
}
System.out.println("循环时间"+(System.currentTimeMillis()-start));
long start0 = System.currentTimeMillis();
pstmtAdd.executeBatch();
System.out.println("执行sql时长"+(System.currentTimeMillis()-start0)+"ms");
pstmtAdd.close();
con.close();
}
}
Main系列之数据库
最新推荐文章于 2024-03-12 10:29:49 发布