如何将字符串转换为MySQL的DateTime或TimeStamp

Question

m dd yyyy hh:mm:ss
5 12 2015 17:40:53

这需要存储在MySQL表的一列中，其数据类型为TimeStamp

Answer 1

使用

String yourString = "5 12 2015 17:40:53";
Timestamp timestamp = null;
try{
    SimpleDateFormat sdf = new SimpleDateFormat("MM dd yyyy hh:mm:ss");
    Date parsedDate = sdf.parse(yourString);
    timestamp = new java.sql.Timestamp(parsedDate.getTime());
}catch(Exception e){
 //this generic but you can control the type of exception
}