Java中将时间转化成Timestamp格式，然后插入MySQL的datatime类型

现将数组转化成格式如yyyy-MM-dd HH:mm:ss的字符串，然后再SimpleDateFormat 格式化成字符串，最后转换成Timestamp类型，就可以成功插入数据库了。

public static String Datetime(int buffer[]){//时间解析函数

String datetime="";
String st="";
    for(int i=0;i<=5;i++){
st+=String.format("%02d", buffer[i]);
}

    String dt="20"+st;
  
    StringBuffer sb=new StringBuffer().append(dt);

datetime=sb.insert(4,"-").insert(7,"-").insert(10," ").insert(13,":").insert(16,":").toString();


return datetime;

}

public static void insertTrainArrival(String id,String date_type, String section_no, String datetime,String train_no){


Connection con = getConnection();
PreparedStatement pstmt = null;

try {

SimpleDateFormat df= new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

String time=df.format(df.parse(datetime));

Timestamp timeStamp=Timestamp.valueOf(time);//时间timeStamp

pstmt=con.prepareStatement("inser tinto t_train_arrival_info(ARRIVAL_ID,DATA_TYPE,SECTION_NO,TIME,TRAIN_NO) values(?,?,?,?,?)");
pstmt.setString(1, id); 
pstmt.setString(2, date_type); 
      pstmt.setString(3, section_no);  
      pstmt.setTimestamp(4,timeStamp );
      pstmt.setString(5, train_no);
     


pstmt.execute();



} catch (Exception e) {
e.printStackTrace();
}finally{
try{
if(pstmt != null){
pstmt.close();
pstmt = null;
}
}
catch(Exception e){
e.printStackTrace();
}
try{
if(con != null){
con.close();
con = null;
}
}
catch(Exception e){
e.printStackTrace();
}
}
}