在Student类中, sEntryDate的数据类型为Date,而要进行插入语句,这需要用到STR_TO_DATE()方法,但最终的输出为字符串,为解决此问题,就需要用到SimpleDateFormat
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
String entryDate = sdf.format(student.getsEntryDate());
String sql = "insert into student (s_name,s_sex,s_age,s_no,s_entry_date) values('"+ student.getsName() +"','"+ student.getsSex() +"',"+ student.getsAge() +","+ student.getsNo() +",STR_TO_DATE('"+ entryDate +"','%Y-%m-%d'))";