Inserting date into MySQL database using a PreparedStatement

Question

I want to update the string date into MySQL database using prepared statement. I have tried a lot and always got error java.util.Date cannot parse into java.sql.Date or vise versa. I didn't import anything here. Please import according to your answer.

public class Date1 
{ 
    public static void main(String args[]) 
    {
        String source="2008/4/5";              
        SimpleDateFormat format = new SimpleDateFormat("dd/MM/yyyy");                       
        java.sql.Date d=(Date) format.parse(source);             
        Class.forName("com.mysql.jdbc.Driver");        
        Connection con=(Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/employee", "root", "root");   
        PreparedStatement ps=con.prepareStatement("insert into ankur1 values(?)");          
        ps.setDate(1,(java.sql.Date) d);    
        ps.executUpdate();
    }
}

` I didn't import anything here` -> Not even java.sql.Date?? — Rohit Jain
– Rohit Jain, Commented Oct 16, 2012 at 13:59

Lukas Eder · Accepted Answer · 2012-10-16 14:09:00Z

7

Write this

java.sql.Date d= new java.sql.Date(format.parse(source).getTime());

instead of this:

java.sql.Date d=(Date) format.parse(source);

Because you cannot just cast java.util.Date to its subtype java.sql.Date. You have to convert it. Do also note that your format string doesn't match your actual date format, as Bill the Lizard commented.

edited Oct 16, 2012 at 14:09

answered Oct 16, 2012 at 13:59

Lukas Eder

223k138 gold badges731 silver badges1.6k bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Bill the Lizard Over a year ago

This is correct. Also note that "2008/4/5" is not in the format "dd/MM/yyyy".

Lukas Eder Over a year ago

@BilltheLizard: Right, I didn't even notice

ankur jadiya Over a year ago

@Lukas Eder i have write your line you provided it is successfully reflected on a database like i have this String str = "2006-12-28"; SimpleDateFormat formatter = new SimpleDateFormat("yyyy-mm-dd"); java.sql.Date d= new java.sql.Date(formatter.parse(str).getTime()); ps.setDate(1,d); it is reflecting but whatever i have providing the data it is reflected as 01 in month place in each case in mysql 5.2.38

Lukas Eder Over a year ago

@ankurjadiya: I'm not sure what you're trying to say. Do you have any other issues apart from what you had already mentioned in the question?

lkdg Over a year ago

@ankur jadiya: Your Formatstring in your comment is wrong. Use "yyyy-MM-dd". So the months in uppercase. in lowercase (mm) they are ment for minutes.

|

Blasanka · Accepted Answer · 2020-04-17 17:18:10Z

2

java.sql.Timestamp date = new java.sql.Timestamp(new java.util.Date().getTime());

pstmt.setTimestamp(1, date);

Try this it may work.. Thanks

edited Apr 17, 2020 at 17:18

Blasanka

22.6k12 gold badges107 silver badges109 bronze badges

answered Apr 6, 2013 at 10:27

Java D

4441 gold badge8 silver badges18 bronze badges

Comments

Yang_2333 · Accepted Answer · 2014-03-12 05:00:21Z

1

here is another simpler way to solve this:

preparedStatement = connect.prepareStatement("INSERT INTO test.TABLENAME VALUES (default, STR_TO_DATE( ?, '%m/%d/%Y'), STR_TO_DATE(?, '%l:%i %p'),?,?,?,?,?)");

Or, you can replace the "?" with real data.

This is how I insert date and time to mySQL, just figured it out.

We can adjust the kinds of parameters to meet our data's format, it's easy and clean.

answered Mar 12, 2014 at 5:00

Yang_2333

7148 silver badges11 bronze badges

Collectives™ on Stack Overflow

Inserting date into MySQL database using a PreparedStatement

3 Answers 3

7 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

7 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related