I have a java.util.Date object stored in one of my objects and I want to insert it into a MS Access database.
patient.getPtDOB() returns a java.util.Date object. I initially thought that I need to convert it to a java.sql.Date object in order to insert it into my database, but I understand that java.sql.Date does not contain time data. So, should I convert it to java.sql.Date or java.sql.Timestamp? Also, how do I do the conversion?
Thank you for your help!!!
**************************
*
Here is my code:
PreparedStatement ps = null;
String ptFName = patient.getPtFName();
String ptMName = patient.getPtMName();
String ptLName = patient.getPtLName();
Date ptDOB = patient.getPtDOB();
String insert = "INSERT INTO PATIENT (F_NAME, M_NAME, L_NAME, DOB) " + "VALUES (?, ?, ?, ?)";
ps = conn.prepareStatement(inse
rt);
ps.setString(1, ptFName);
ps.setString(2, ptMName);
ps.setString(3, ptLName);
ps.setDate(4, ptDOB);
ps.executeUpdate();
ps.close();
Start Free Trial
