Java實(shí)現(xiàn)批量向mysql寫(xiě)入數(shù)據(jù)的方法

private static String user = "root";
private static String pass = "123456";
private static String URL = "jdbc:mysql://192.168.1.116:3306/test";
public static void main(String args[]) throws SQLException, ClassNotFoundException{
    //獲取時(shí)間信息
    SimpleDateFormat sfmt = new SimpleDateFormat("yyyyMMddHHmmss");
    Date lastHour = new Date(new Date().getTime() - 3600000);//1小時(shí)前
    String hourMeta = sfmt.format(lastHour).substring(0, 10);//小時(shí)的時(shí)間戳，用于大數(shù)據(jù)縮小搜索范圍
    int day = Integer.parseInt(sfmt.format(lastHour).substring(0, 8));
    int hour = Integer.parseInt(String.valueOf(lastHour.getHours()));
    //連接mysql數(shù)據(jù)庫(kù)
    Connection conn = DriverManager.getConnection(URL , user, pass);
    conn.setAutoCommit(false);
    //向mysql中插入數(shù)據(jù)
    String sql = "insert into test1 values(?,?)";
    PreparedStatement ps = conn.prepareStatement(sql);//要執(zhí)行sql語(yǔ)句的對(duì)象
    ps.setInt(1, day);
    ps.setInt(2, hour);
    //ps.setString(1, "aa");
    //ps.setString(2, "bb");
    ps.addBatch();//再添加一次預(yù)定義參數(shù)
    ps.executeBatch();//執(zhí)行批量執(zhí)行
    conn.commit();
    if (ps != null) {
      ps.close();
    }
    if (conn != null) {
      conn.close();
    }
}