Insert system time to oracle in java program

神秘男

Insert a piece of data into the oracle database, including the date type, but you can't get the time, you can only get the date! The procedures used in the dao program are:
pstmt.setDate (new java.sql.Date (new java.util.Date (). getTime ()));
pstmt.executeUpdate ();
The data obtained by querying in the database is:
2 127.0.0.1 2017-01-04 00: 00: 00.0
3 127.0.0.1 2017-01-04 00: 00: 00.0
4 127.0.0.1 2017-01-04 00: 00: 00.0
5 127.0.0.1 2017-01-04 00: 00: 00.0
Question: Why does the time appear as: 00:00:00? Is there any other good way to insert the system time and date into the database

whbilly

need

to_char (java.util.Date (). getTime (), 'YYYY-MM-DD HH24: MI: SS')

such as:
String sqlStr = "insert into" + tableName
+ "(name, age, height, add_date) values ​​(?,?,?, to_char (sysdate, 'YYYY-MM-DD HH24: MI: SS'))";
The
pstmt = con.prepareStatement (sqlStr);
pstmt.setString (1, client.getName ());
pstmt.setInt (2, client.getAge ());
pstmt.setInt (3, client.getHeight ());
//pstst.setString(4,sysdate);
The
pstmt.executeUpdate ();

神秘男

Thank youwhbilly;
  From your program, convert it to a string and store it in the database. Is it built as a varchar2 type when the table is created? Using your method I compiled errors in jbuilder,
The statement I wrote is:
 pstmt.setDate (2, to_char (new java.util.Date (). getTime (), 'YYYY-MM-DD HH24: MI: SS'));
The error is as follows:
"Dao.java": unclosed character literal at line 146, column 67
"Dao.java": unclosed character literal at line 146, column 89
Please take a look, thank you

神秘男

I also tried to change the attribute of the field to varchar2 type, this statement
  pstmt.setString (2, to_char (new java.util.Date (). getTime (), "YYYY-MM-DD HH24: MI: SS"));
jbuilder says "
Dao.java ": cannot find symbol; symbol: method to_char (long, java.lang.String), location: class dao.Dao at line 146, column 30
What the hell is going on! Thanks a lot!

liub950511

1. to_char first, then to_date

liub950511

There is such a demand that feels weird. Sysdate can be used to insert the system time.

In this case, the time of the machine where Java is located must be the same as the time of the machine where Oracle is located.

whbilly

It is recommended to use sysdate, not getdate ()
The following is the original code of jsp for reference

String sqlStr = "insert into" + tableName
+ "(name, age, height, add_date) values ​​(?,?,?, to_char (sysdate, 'YYYY-MM-DD HH24: MI: SS'))";

pstmt = con.prepareStatement (sqlStr);
pstmt.setString (1, client.getName ());
pstmt.setInt (2, client.getAge ());
pstmt.setInt (3, client.getHeight ());
//pstst.setString(4,sysdate);

pstmt.executeUpdate ();

sanque

You should use java.sql.Timestamp instead of java.sql.Date

神秘男

Thank you for the above answer, it is better to use the upstairs method, which is timestamp, but I use order by time in sql, which is also sorted by time, which can be sorted in oracle, but how to display the page in jsp Not sorted by time? Thanks for answering!