Type mismatch exception while accessing date from java to oledb

See more:

Java

OleDb

While inserting date this code is ok for me there is no error

SimpleDateFormat sdf = new SimpleDateFormat("dd-MMM-yy");
  String date1 = sdf.format(jDateChooser1.getDate());
  SimpleDateFormat df = new SimpleDateFormat("dd-MMM-yy");

java.util.Date date = df.parse(date1);
String query="Insert into customermilk values('"+l[p].getText()+"','"+new java.sql.Date(date.getTime())+"','"+mt+"',"+q1+","+t12+")";
x=stmt.executeUpdate(query);

But retrieving date from table it generate exception

SimpleDateFormat df = new SimpleDateFormat("dd-MMM-yy");
java.util.Date date = df.parse(date1);
query="select * from customermilk where name='"+cust[i]+"' AND date='"+new java.sql.Date(date.getTime())+"'";
ResultSet rs2=stmt.executeQuery(query);

It generate exception : Exception =java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

What I have tried:

But retrieving date from table it generate exception

SimpleDateFormat df = new SimpleDateFormat("dd-MMM-yy");
java.util.Date date = df.parse(date1);
query="select * from customermilk where name='"+cust[i]+"' AND date='"+new java.sql.Date(date.getTime())+"'";
ResultSet rs2=stmt.executeQuery(query);

It generate exception : Exception =java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.