compile error ?

Hey guys! I get the following compile error when I try to run the below referenced code:

com\chicken\DoIt2.java:88: cannot find symbol
symbol :method setDate(int,java.util.Date)
location: interface java.sql.PreparedStatement
in.setDate(1, previousDate);

I can't figure this out. I've looked at the javdocs, etc.

package com.chicken; 
  
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.PreparedStatement; 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.util.Date; 
import java.text.SimpleDateFormat;
 
public class DoIt2
{
    public static void main(String[] args)
    { 
        String url      = "jdbc:mysql://localhost:3306/mysql";
        String username = "root";
        String password = "";
        String driver   = "com.mysql.jdbc.Driver";
 
        //Defind a basic prepared statement that will read each line 
        String query = "SELECT * FROM tick_data WHERE id = ?;"; 
        String insert = "INSERT (date, open, high, low, close) VALUES (?,?,?,?,?) INTO daily";    
 
        Connection cnnctn = null;
 
 
        try
        {
            Class.forName(driver);
            cnnctn = DriverManager.getConnection(url, 
                username, password);
  
            PreparedStatement psttmnt = cnnctn.prepareStatement(query);
            PreparedStatement in      = cnnctn.prepareStatement(insert); 
            psttmnt.execute("USE oanda");
            ResultSet rsltst = null; 
  
            SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); 
            Date previousDate = sdf.parse("2004-01-01"); 
            Date currentDate  = sdf.parse("2004-01-01");
            
    //Serves to hold the (bid + ask)/2 
            double avg = 0; 
            double high = 0;
            double low = 0; 
            double close = 0; 
            double open = 0; 
 
            int n = 0;  
 
            for(int id = 3; id < 10; id++)//23954617
            {              
                psttmnt.setInt(1,id);  
rsltst = psttmnt.executeQuery(); 
 
                while(rsltst.next())
                { 
                       int i        = rsltst.getInt(1);
                       currentDate  = rsltst.getDate(2); 
 
                       double bid = rsltst.getDouble("bid"); 
                       double ask = rsltst.getDouble("ask");
 
                       avg = (bid + ask)/2; 
                } 
 
                if(previousDate.equals(currentDate))
                { 
                       n++; 
                       System.out.println("n = " + n);
                       if(high < avg)
                       { 
                           high = avg;
                           System.out.println("high = " + high);  
                       } 
                       else if(low > avg) 
                       { 
                           low = avg;
                           System.out.println("low = " + low);  
                       } 
                       
                       close = avg; 
                       
                }
                else 
                { 
                       open = avg;  
                       in.setDate(1, previousDate);
                       in.setDouble(2, open); 
                       in.setDouble(3, high); 
                       in.setDouble(4, low); 
                       in.setDouble(5, close); 
                       in.executeUpdate(); 
                       n = 0;  
                       previousDate = currentDate;
                       high = 0; 
                       low  = 0; 
          
                } 
            }
        }
        catch(Exception e)
        { 
           System.out.println("Something bad happened"); 
        } 
        finally
        {
            try
            { 
                 
                cnnctn.close();
            }
           catch(SQLException e)
           { 
                System.out.println("Could not close connection or connection already closed"); 
           }
       } 
    }
}

That method takes a parameter of type java.sql.Date, not java.util.Date.

Thanks Paul!

I should have paid closer attention. Now I need to figure out how to parse my initial date.

Just take the java.util.Date object which you already have, and convert it to a java.sql.Date object. You'll find that java.sql.Date does have a suitable constructor.