Java Date – Insert into database

by

Before I answer your question, I’d like to mention that you should probably look into using some sort of ORM solution (e.g., Hibernate), wrapped behind a data access tier. What you are doing appear to be very anti-OO. I admittedly do not know what the rest of your code looks like, but generally, if you start seeing yourself using a lot of Utility classes, you’re probably taking too structural of an approach.

To answer your question, as others have mentioned, look into java.sql.PreparedStatement, and use java.sql.Date or java.sql.Timestamp. Something like (to use your original code as much as possible, you probably want to change it even more):

java.util.Date myDate = new java.util.Date("10/10/2009");
java.sql.Date sqlDate = new java.sql.Date(myDate.getTime());

sb.append("INSERT INTO USERS");
sb.append("(USER_ID, FIRST_NAME, LAST_NAME, SEX, DATE) ");
sb.append("VALUES ( ");
sb.append("?, ?, ?, ?, ?");
sb.append(")");

Connection conn = ...;// you'll have to get this connection somehow
PreparedStatement stmt = conn.prepareStatement(sb.toString());
stmt.setString(1, userId);
stmt.setString(2, myUser.GetFirstName());
stmt.setString(3, myUser.GetLastName());
stmt.setString(4, myUser.GetSex());
stmt.setDate(5, sqlDate);

stmt.executeUpdate(); // optionally check the return value of this call

One additional benefit of this approach is that it automatically escapes your strings for you (e.g., if were to insert someone with the last name “O’Brien”, you’d have problems with your original implementation).

More Related Contents:

  1. Hours and seconds are lost when storing a date in the database [closed]
  2. How to convert java.util.Date to java.sql.Date?
  3. Dates with no time or timezone component in Java/MySQL
  4. Insert & fetch java.time.LocalDate objects to/from an SQL database such as H2
  5. java.util.Date vs java.sql.Date
  6. “EEE MMM dd HH:mm:ss ZZZ yyyy” date format to java.sql.Date
  7. handling DATETIME values 0000-00-00 00:00:00 in JDBC
  8. Timezones in SQL DATE vs java.sql.Date
  9. How to get the day from timezone in java [duplicate]
  10. How do you format the day of the month to say “11th”, “21st” or “23rd” (ordinal indicator)?
  11. Efficient way to do batch INSERTS with JDBC
  12. How do I check if a date is within a certain range?
  13. Java: Check the date format of current string is according to required format or not [duplicate]
  14. Java, Calculate the number of days between two dates [duplicate]
  15. How can I calculate a time span in Java and format the output?
  16. What are the pros and cons of performing calculations in sql vs. in your application
  17. Calculating the difference between two Java date instances
  18. Spring Boot Jackson date and timestamp Format
  19. How to convert a date to milliseconds
  20. Comparing date strings in Java [duplicate]
  21. Generic support for ISO 8601 format in Java 6
  22. Why does Java’s Date.getYear() return 111 instead of 2011?
  23. Java: Get month Integer from Date
  24. java: how to mock Calendar.getInstance()?
  25. JPA Select latest instance for each item
  26. Should I use composite primary keys or not?
  27. How to use SELECT IN clause in JDBCTemplates?
  28. Why can’t OffsetDateTime parse ‘2016-08-24T18:38:05.507+0000’ in Java 8
  29. Get Daylight Saving Transition Dates For Time Zones in Java
  30. Getting last record from mysql

Leave a Comment