jdbc odbc connectivity with MS Acess

See more:

Java

JDBC

sir i want to add selected jcombo box value into ms access in perticular column??
help me plzzzzzzzz
i show in code error part??
the other value is added in to the database but when i selected any value from combobox and try to saved it will not get saved or shown value of selected value in ms access........
thanks in advanced..................

import java.awt.Container;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import javax.swing.*;
public abstract class New_Customer extends JFrame implements ActionListener
{
	JTextField textFieldId;
	JTextField textFieldName;
	JTextField textFieldContactNo;        
	JLabel l1;
	JLabel l2;
	JLabel l3;
	JLabel l4;
	JLabel l5;
	JLabel l6;        
        JComboBox combo;
       
        String course[] = {"Navakal","SandhyaKal","Pudhari","MidDay","Inqlab","BusinessLine","Mumbai    Samachar","Gujraj Samachar","Karnatak Malla","Vartahar","PunyaNagari"};  
     
	JButton b1;
	JButton b2;
        PreparedStatement ps;
        Container c = getContentPane();

	New_Customer()
	{
		super("Shree DattaDigambar Samarth");
		setBounds(140,250,777,555);
		c.setLayout(null);
		textFieldId = new JTextField();
		textFieldName = new JTextField();
		textFieldContactNo = new JTextField();
		l1 = new JLabel("New Customer Entry");
		l2 = new JLabel("Building No");
		l3 = new JLabel("Customer Name");
		l4 = new JLabel("Contact No");
		l5 = new JLabel("Paper");                
                combo = new JComboBox(course);
		l1.setBounds(10,10,340,20);
		l2.setBounds(10,20,140,70);
		l3.setBounds(110,20,140,70);
		l4.setBounds(300,50,140,20);
		l5.setBounds(400,50,140,20);
		textFieldId.setBounds(10,70,70,20);
		textFieldName.setBounds(110,70,180,20);
		textFieldContactNo.setBounds(300,70,90,20);
                combo.setBounds(400,70,130,20);
		b1 = new JButton("Add paper");
                b2 = new JButton("Ok");
		b1.setBounds(10,100,100,20);
		b2.setBounds(10,160,50,20);       
                c.add(combo);                
		c.add(b1);
		c.add(b2);
		c.add(l1);
		c.add(l2);
		c.add(l3);
		c.add(l4);
		c.add(l5);
		c.add(textFieldId);
		c.add(textFieldName);
		c.add(textFieldContactNo);   
                setVisible(true);
		setDefaultCloseOperation(EXIT_ON_CLOSE);     
                b1.addActionListener(this);
                b2.addActionListener(this);
                      }

    @Override
        public void actionPerformed(ActionEvent ae)
        {
            if(ae.getSource()==b2)
            {
                try
                {
                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                    Connection con;
                    con = DriverManager.getConnection("jdbc:odbc:Digambar_Dalvi");
                    ps=con.prepareStatement("insert into Customer(Building_No,Customer_Name,Contact_No,Paper_Name)values(?,?,?,?)");
				
				
			ps.setString(1,textFieldId.getText());
			ps.setString(2,textFieldName.getText());
			ps.setString(3,textFieldContactNo.getText());    
            error{      ps.setString(4,combo.getSelectedValue());
            error       ps.executeUpdate();
             error     }  
                    con.close();  
                    
                }
                catch(Exception ex)
			{
				System.out.println("Error 1:"+ex);
			}
            }
        }
        public static void main(String args[])
	{

	    New_Customer v = new New_Customer() {};
		
	}
}