MySQL inserts a value of the date type

Two Methods for MySQL to insert a date value
1) string is used for receiving from the page, and preparedstatement. setstring () is directly used in Dao ();
2) Same, the string is used for receiving, and then formatted:
Simpledateformat SDF = new simpledateformat ("yyyy-mm-dd ");
Java. util. Date card_indate = NULL;
Card_indate = SDF. parse (indate );
InsertCode:
Preparedstatement. setdate (Num, new java. SQL. Date (card_indate.gettime ()));

 

I hope it will be useful to those who just started using MySQL.

Oracle, which has been used in the past, is still very powerful. There is a to_date function, which can be used directly with to_date ('value', 'yyyy-mm-dd ''').

No system functions need to be optimized for a while.

Haha