import java.sql.SQLException;
import java.sql.Statement;
import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.Date;
import java.util.*;
import java.io.*;

public class bug11540 {

    protected static String dbUrl = "jdbc:mysql:///test?";
    protected static Connection conn = null;
    protected static ResultSet rs = null;
    protected static PreparedStatement cstmt = null;


    public static void main(String[] args) throws Exception {
        java.sql.Date buggydate; 
        Class.forName("com.mysql.jdbc.Driver").newInstance();

        conn = DriverManager.getConnection(dbUrl,"root","");


	PreparedStatement stmt = conn.prepareStatement(
                         "select string1,date1 from table1");
	ResultSet rs = stmt.executeQuery();
	rs.next(); buggydate = rs.getDate("date1");
                System.out.println(buggydate); 
       PreparedStatement stmt1 = conn.prepareStatement(
              "select string1, date1 from table1 where date1=?");
       stmt1.setDate(1,buggydate);
       ResultSet rs1 = stmt1.executeQuery();
       if (! rs1.next() )
       {
           System.out.println("No rows were returned");
       } else
       {
          System.out.println("Got date:"+rs1.getDate("date1"));
       };
    }

}