public static void update() {
String sql = "UPDATE item SET i_stock = ? WHERE i_id = ?";
Connection conn = null;
if (flag) {
conn = IMDGHelper.getConnection();
} else {
conn = DBHelper.getConnection();
}
try {
PreparedStatement pst = conn.prepareStatement(sql);
Random random = new Random(System.currentTimeMillis());
int count = 1000;
int range = 100000;
long start = System.currentTimeMillis();
for (int i = 0; i < count; i++) {
pst.setInt(1, random.nextInt(range) + 1);
pst.setInt(2, random.nextInt(range) + 1);
pst.executeUpdate();
}
long end = System.currentTimeMillis();
System.out.println("update time : " + (end - start) + " ms");
pst.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void valueQuery() {
String sql = "SELECT * FROM order_line, item WHERE ol_o_id = ? AND ol_i_id = i_id";
Connection conn = null;
if (flag) {
conn = IMDGHelper.getConnection();
} else {
conn = DBHelper.getConnection();
}
try {
PreparedStatement pst = conn.prepareStatement(sql);
ResultSet rs = null;
Random random = new Random(System.currentTimeMillis());
int count = 1000;
int range = 10000;
long start = System.currentTimeMillis();
for (int i = 0; i < count; i++) {
pst.setInt(1, random.nextInt(range) + 1);
rs = pst.executeQuery();
}
long end = System.currentTimeMillis();
System.out.println("valueQuery time : " + (end - start) + " ms");
rs.close();
pst.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void insertBatch() {
String sql =
"INSERT into order_line (ol_id, ol_o_id, ol_i_id, ol_qty, ol_discount, ol_comments) VALUES (?, ?, ?, ?, ?, ?)";
Connection conn = null;
if (flag) {
conn = IMDGHelper.getConnection();
} else {
conn = DBHelper.getConnection();
}
try {
PreparedStatement pst = conn.prepareStatement(sql);
Random random = new Random(System.currentTimeMillis());
int count = 1000;
int range = 10000;
long start = System.currentTimeMillis();
for (int i = 0; i < count; i++) {
pst.setInt(1, random.nextInt(range) + 2000);
pst.setInt(2, random.nextInt(range) + 2000);
pst.setInt(3, random.nextInt(range) + 2000);
pst.setInt(4, random.nextInt(range) + 2000);
pst.setDouble(5, (double) getRandomInt(0, 30) / 100);
pst.setString(6, getRandomAString(20, 100));
pst.addBatch();
}
pst.executeBatch();
pst.clearBatch();
long end = System.currentTimeMillis();
System.out.println("INSERT time : " + (end - start));
pst.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}