java中如何在控制台输入年月日时分秒保存到mysql数据库中datetime类型列,在线等.急

Question

Scanner input=new Scanner(System.in);
String showtime=input.next();
SimpleDateFormat sdf=new SimpleDateFormat("yy-MM-dd HH:mm:ss") ;
sdf.setLenient(false);
java.util.Date st;
st = sdf.parse(showtime);

java.sql.Date stime=new java.sql.Date(st.getTime());

Answer 1

String sql = "INSERT INTO myTbl (name, stime)VALUES(?, ?)";
PreparedStatement ps=conn..........................; //创建Statement
ps.setString(1, "ZhangSan");
ps.setTimestamp(2, stime); //设置参数

ps.executeUpdate();