Java inserts the current time to MySQL several ways and the Java time date format several ways: (Data reference network resources)1There are several ways in which Java inserts the current time into MySQL, the first of these: Convert the time of the java.util.Date type to the Java.sql.Date type recognized by the MySQL database time Note: Java.util.Date is the parent of java.sql.Date: I have defined a subclass cat, It inherits the animal class, then the latter is the parent class. Through Cat c=NewCat (); Instantiate a Cat object, but when I define this: Animal a =NewCat (); it means I have defined a reference to the animal type, pointing to the new Cat type object. Because Cat is inherited from its parent class animal, references to animal types can point to objects of the cat type. Date Time=Newjava.sql.Date (Newjava.util.Date (). GetTime ()); the second: Java uses PreparedStatement to setdate, assigning a date question mark in the form of a question mark
Pstmt.settimestamp (1,NewTimestamp (System.currenttimemillis ()));p Stmt.setdate (1,Newjava.sql.Date (Newdate (). GetTime ())); Third: How to use Hibernate to provide database operations
As long as the java.util.Date type is set, take Hibernate's Pojo class object as an example, Pojo.set (Newjava.util.Date ()); it is available. MySQL and Java time type the time type of MySQL has the corresponding time type in Ava date java.sql.Date Datetime java.sql.Ti Mestamp Timestamp Java.sql.Timestamp time java.sql.Time year java.sql.Date so is implemented in the following way: date Date=NewDate ();//get the system time.SimpleDateFormat SDF =NewSimpleDateFormat ("Yyyy-mm-ddhh:mm:ss"); String Nowtime= Sdf.format (date);//convert the time format to a format that meets the timestamp requirements.Timestamp dates =timestamp.valueof (nowtime);//Convert the time2. Java time Date format several methods Importjava.sql.Timestamp; Importjava.text.ParseException; Importjava.text.SimpleDateFormat; Importjava.util.Date; Public classTransformdate {/*** Direct the current time only by date (time 0) as the condition of the MySQL timestamp field * Final return time type Java.sql.Date*/ Publicvoidtransformcurdate () {SimpleDateFormat format=NewSimpleDateFormat ("yyyy-mm"); Java.sql.Date Timepara=NULL; Try{Timepara=NewJava.sql.Date (NewDate (). GetTime ()); System.out.println (Timepara); } Catch(Exception e) {e.printstacktrace (); } } /*** Convert the current time of Java to the specified format (yyyy-mm-0100:00:00 ") as a condition of the MySQL timestamp field * Final return time type Java.sql.Date*/ PublicVoidtransformcuryearmon () {SimpleDateFormat format=NewSimpleDateFormat ("yyyy-mm"); String Time= Format.format (NewDate ()). Concat (" -0100:00:00"); Java.sql.Date Timepara=NULL; Try{Timepara=Newjava.sql.Date (Format.parse (Time). GetTime ()); System.out.println (Timepara); } Catch(ParseException e) {e.printstacktrace (); } } /*** Turn the current time of Java into Timestamp as the condition for the MySQL timestamp field * Final return time type Java.sql.Timestamp*/ Public Static voidTestData () {Try{SimpleDateFormat SDF=NewSimpleDateFormat ("Yyyy-mm-ddhh:mm:ss"); Timestamp Date= Java.sql.Timestamp.valueOf ("2012-12-1201:12:11"); SYSTEM.OUT.PRINTLN (date); } Catch(Exception e) {e.printstacktrace (); } } /*** Processing current time only by date (time 0) * Final return time type Java.util.Date*/ Public Static voiddatatest () {Try{SimpleDateFormat format=NewSimpleDateFormat ("Yyyy-mm-dd"); String Time= Format.format (NewDate ()); Date Date= Format.parse (Time.concat ("00:00:00")); SYSTEM.OUT.PRINTLN (date); } Catch(Exception e) {e.printstacktrace (); } } }
Java insert time to MySQL, Time date format