MySQL Jdbc convert string to date

Question

SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
// date here is a string of format yyyy-MM-dd
 java.util.Date date_1 = df.parse(date) ;
java.sql.Date sqldate = new java.sql.Date(date_1.getTime());
sql = "select * from fgs_stock_report where Report_date = ? ";

PreparedStatement two = con.prepareStatement(sql);
two.setDate(1,sqldate);ResultSet rs ;
rs = two.executeQuery(sql) ;

Here I get a Java Sql Exception asking for the right syntax near? . I am a beginner and I searched a lot for a solution but couldnt find. Please help me.

Post the complete stack trace of the exception, so that we can know what the problem is. — JB Nizet
– JB Nizet, Commented Jun 29, 2014 at 17:00

Elliott Frisch · Accepted Answer · 2014-06-29 17:15:52Z

3

I think I see the problem, you are using a Statement.executeQuery(String) but you want PreparedStatement.executeQuery() - that is.

PreparedStatement two = con.prepareStatement(sql); // <-- Prepare a Statement.
two.setDate(1,sqldate);                            // <-- bind the parameter.
ResultSet rs ;
rs = two.executeQuery(sql) ;                       // <-- throw it away and use raw sql

What you want is,

 ResultSet rs = two.executeQuery();                // <-- I'd use one line

answered Jun 29, 2014 at 17:15

Elliott Frisch

202k20 gold badges166 silver badges265 bronze badges

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

Collectives™ on Stack Overflow

MySQL Jdbc convert string to date

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related