insert statement problem
need help urgently,am useing microsoft access as my database,whenever i try to insert data into the table i have in my database it tells me syntax error in INSERT INTO statement.please how do i overcome this problem.my code is below.thanks in advance.
'\n'
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
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","","");
String insert="INSERT parsonaltransaction(date,name,phone,addres,deposit,balance)";
insert=insert+" VALUES(?,?,?,?,?,?)";
stat=con.prepareStatement(insert);
stat.setString(1,dateF.getText());
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);
}
}
