error inserting into database

need help,am tryin to insert data into my database which contains date,

names,phone,address and deposit and it's giving this error message:

java.lang.ClassCastException:java.util.Date cannot be cast to java.sql.Date.

somebody help me please.thanks in advance.

code:

.....

'\n'

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import java.sql.*;

import java.text.*;

publicclass NewCustomerRecordextends JFrame{

private JTextField firstnameF,othernameF,phoneF,addressF,depositF,currentF,dateF;

private JButton registerbutton;

private Connection con;

private Statement st;

private ResultSet set;

private PreparedStatement stat;

public NewCustomerRecord(){

//super(f,"",true);

JPanel panel =new JPanel();

panel.setLayout(null);

JLabel firstL =new JLabel("First Name:");

firstL.setBounds(5,15,80,20);

panel.add(firstL);

firstnameF =new JTextField();

firstnameF.setBounds(70,15,100,20);

panel.add(firstnameF);

JLabel otherL =new JLabel("Other Names:");

otherL.setBounds(175,15,80,20);

panel.add(otherL);

othernameF =new JTextField();

othernameF.setBounds(255,15,100,20);

panel.add(othernameF);

JLabel phoneL =new JLabel("Phone No.:");

phoneL.setBounds(5,40,80,20);

panel.add(phoneL);

phoneF =new JTextField();

phoneF.setBounds(70,40,100,20);

panel.add(phoneF);

JLabel addressL =new JLabel("Address:");

addressL.setBounds(185,40,80,20);

panel.add(addressL);

addressF =new JTextField();

addressF.setBounds(255,40,100,20);

panel.add(addressF);

JLabel depositL =new JLabel("Deposit:");

depositL.setBounds(5,65,60,20);

panel.add(depositL);

depositF =new JTextField();

depositF.setBounds(70,65,100,20);

panel.add(depositF);

/*JLabel currentL = new JLabel("Current Bill:");

currentL.setBounds(135,65,80,20);

panel.add(currentL);

currentF = new JTextField();

currentF.setBounds(205,65,50,20);

panel.add(currentF);*/

JLabel dateL =new JLabel("Date:");

dateL.setBounds(185,65,50,20);

panel.add(dateL);

dateF =new JTextField();

dateF.setBounds(255,65,100,20);

panel.add(dateF);

registerbutton =new JButton("Register Customer");

registerbutton.setBounds(115,100,145,20);

registerbutton.addActionListener(new ActionListener(){

publicvoid actionPerformed(ActionEvent e){

insertRecord();

dispose();

}

});

registerbutton.setMinimumSize(new Dimension(50,20));

panel.add(registerbutton);

add(panel);

setSize(400,200);

setDefaultCloseOperation(EXIT_ON_CLOSE);

}

publicvoid insertRecord(){

double bal=0.0;

String s=depositF.getText();

double dep = Double.parseDouble(s);

bal+=dep;

//String ss=dateF.getText();

//short dd=Short.parseShort(ss);

String ss=Double.toString(dep);

String bb=Double.toString(bal);

String fullName=firstnameF.getText()+"\t"+othernameF.getText();

try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

con=DriverManager.getConnection("jdbc:odbc:sparkletransaction","","");

SimpleDateFormat sdf =new SimpleDateFormat("dd/mm/yy");//added

Date d = (Date)sdf.parse(dateF.getText());

//java.sql.Date date = new java.sql.Date();

//date.setTime(d.getTime());

String insert="INSERT INTO personaltransaction(date,name,phone,addres,deposit,balance) VALUES(?,?,?,?,?,?)";

//insert=insert+;

stat=con.prepareStatement(insert);

stat.setDate(1,d);

stat.setString(2,fullName);

stat.setString(3,phoneF.getText());

stat.setString(4,addressF.getText());

stat.setString(5,ss);

stat.setString(6,bb);

stat.executeUpdate();

stat.close();

}

catch(Exception e){

System.out.println(e);

}

}

publicstaticvoid main(String[] arg){

new NewCustomerRecord().setVisible(true);

}

}

[6740 byte] By [kc81a] at [2007-11-27 8:42:38]