Java 8 JDBC: Insert Timestamp Code Example


mysql> desc my_uat.students;
+-----------------+-------------+------+-----+---------+----------------+
| Field           | Type        | Null | Key | Default | Extra          |
+-----------------+-------------+------+-----+---------+----------------+
| student_id      | int         | NO   | PRI | NULL    | auto_increment |
| student_name    | varchar(45) | NO   |     | NULL    |                |
| student_dob     | datetime    | NO   | PRI | NULL    |                |
| student_address | varchar(45) | NO   |     | NULL    |                |
+-----------------+-------------+------+-----+---------+----------------+

As you can see in the above students table I have a filed student_dob declared as datetime, in this example, we will see how to insert a timestamp into this field using JDBC PreparedStatement,



Code Example:
String url ="jdbc:mysql://localhost:3306/my_db";
String userName="root";
String password ="root123";
String insertQuery ="insert into students values(?,?,?,?)";

Connection connection = DriverManager.getConnection(url,userName,password);
PreparedStatement preparedStatement = connection.prepareStatement(insertQuery);
preparedStatement.setString(1, null);
preparedStatement.setString(2, "Huge");

preparedStatement.setObject(3,Instant.now());

preparedStatement.setString(4, "Ohio");
int result = preparedStatement.executeUpdate();

As you can see we have made use of the Java 8 Instance (Date and Time API) class in order to insert a timestamp into the Database using PreparedStatement setObject method.

Java JDBC insert TimeStamp Example


Have Questions? Post them here!
Advertisements
Try Out Code2care Dev Tools:

Advertisements

Advertisements
Code2care is an initiative to publish and share varied knowledge in programming and technical areas gathered during day-to-day learnings and development activities.

Students and software developers can leverage this portal to find solutions to their various queries without re-inventing the wheel by referring to our easy to understand posts. Technical posts might include learnings, tutorials, trouble-shooting steps, video tutorials, code snippets, how-to, blogs, articles, etc.

🎉 We are celebrating the 10th years of Code2care! Thank you for all your support!

We strongly support Gender Equality & Diversity.