Date comparison

[hemantha kumar k]

  Connection conn = DatabaseConnection.getConnection();
                      String valueFordropDown ="select reg_no from rentaildetails "
                            + "where customer_id='"+rCustomerIdReq+"' and dateout='"+[b]reverseIt(vehicleDateOutReq.getText())[/b]+"'";
                      
                      PreparedStatement preparedStatement = conn.prepareStatement(valueFordropDown);
                      ResultSet set1 = preparedStatement.executeQuery();
                      while (set1.next()) {                         
                         selectedVehicle.addItem(set1.getString(1));
                         System.out.println(set1.getString(1)+"exe");
                     }

here it the piece of code i'm using in my project vehicleDateOutReq.getText() from the vehicleDateOutReq field i'm taking the string and converting into date format into mysql comparable Date format to compare the date, but my ResultSet is not populating, but if use it in command prompt it is giving the output

mysql> select reg_no from rentaildetails where dateout='1988/1/1' and customer_i d='ALM0';


it is returning the value

[Paul Clapham]

Normally my advice would be to use a PreparedStatement when you want to deal with dates in the database. You did that, but you completely missed the point of PreparedStatement, which is that you can put "parameters" in the query and have the database driver deal with formatting them in the right way. So your query should look like this:

String valueFordropDown ="select reg_no from rentaildetails where customer_id=? and dateout=?";  

Notice that you don't have to worry about quoting or not quoting parameters, nor do you have to worry about formatting date parameters. Just call the appropriate setXXX methods of PreparedStatement.

The one thing you have to deal with is that JDBC wants a java.sql.Date but you have a java.util.Date. Or at least, you will have one after you convert your text string into one. Here's how to get a java.sql.Date from a java.util.Date:

java.util.Date uDate = // conversion from String happens here
java.sql.Date sDate = new java.sql.Date(uDate.getTime());

[hemantha kumar k]

Paul Clapham wrote:Normally my advice would be to use a PreparedStatement when you want to deal with dates in the database. You did that, but you completely missed the point of PreparedStatement, which is that you can put "parameters" in the query and have the database driver deal with formatting them in the right way. So your query should look like this:

String valueFordropDown ="select reg_no from rentaildetails where customer_id=? and dateout=?";  

Notice that you don't have to worry about quoting or not quoting parameters, nor do you have to worry about formatting date parameters. Just call the appropriate setXXX methods of PreparedStatement.

The one thing you have to deal with is that JDBC wants a java.sql.Date but you have a java.util.Date. Or at least, you will have one after you convert your text string into one. Here's how to get a java.sql.Date from a java.util.Date:

java.util.Date uDate = // conversion from String happens here
java.sql.Date sDate = new java.sql.Date(uDate.getTime());

thank you Paul Clapham it is working now