// 15901046093
// 10000000000
public String randomNum() {
Random random = new Random();
int num = random.nextInt(1000000000 - 2);
int f = random.nextInt(9);
String str = String.format("1%d%09d", f, num);
return str;
}
public String randomArea() {
Random random = new Random();
int f = random.nextInt(a1.length);
int f1 = random.nextInt(99);
int g = random.nextInt(a2.length);
int g1 = random.nextInt(99);
return a1[f] + f1 + "_" + a2[g] + g1;
}
public void batchInsertData(int dataSize) {
try {
mConnection.setAutoCommit(false);
long time = System.currentTimeMillis();
String sql = "INSERT INTO Info1(num,addr) values(?,?)";// 要执行的SQL语句
PreparedStatement prepareStatement = mConnection.prepareStatement(sql);
for (int i = 0; i < dataSize; i++) {
String num = randomNum();
String area = randomArea();
prepareStatement.setString(1, num);
prepareStatement.setString(2, area);
prepareStatement.addBatch();
}
prepareStatement.executeBatch();
mConnection.commit();
prepareStatement.close();
System.out.println("time : " + (System.currentTimeMillis() - time));
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void insertData(int dataSize) {
long time = System.currentTimeMillis();
try {
Statement statement = mConnection.createStatement();
for (int i = 0; i < dataSize; i++) {
String num = randomNum();
String area = randomArea();
String sql = "INSERT INTO Info1(num,addr) values('%s','%s')";// 要执行的SQL语句
statement.addBatch(String.format(sql, num, area));
if (i % 5000 == 0 && i > 0) {
System.out.println("====5000");
}
}
statement.executeBatch();
System.out.println("time : " + (System.currentTimeMillis() - time));
statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}