Click here to Skip to main content
14,981,862 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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..................

Java
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() {};
		
	}
}
Posted
Updated 30-Dec-12 21:51pm
v2
Comments
WajihaAhmed 31-Dec-12 3:52am
   
What are you trying to show with 'error' in the try block?
TorstenH. 31-Dec-12 5:02am
   
..and why is the JFrame new_customer abstract? strange.

is the MS Access available in the settings of your windows OS?

1 solution

please see whether DSN is configured properly in administrative tools.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900