Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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() {};
		
	}
}
Posted 27-Dec-12 19:28pm
Edited 30-Dec-12 22:51pm
v2
Comments
WajihAhmed at 31-Dec-12 3:52am
   
What are you trying to show with 'error' in the try block?
TorstenH. at 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

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

please see whether DSN is configured properly in administrative tools.
  Permalink  

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

  Print Answers RSS
0 Sascha Lefévre 365
1 Sergey Alexandrovich Kryukov 325
2 Maciej Los 240
3 Abhinav S 184
4 Peter Leow 120
0 Sergey Alexandrovich Kryukov 6,773
1 OriginalGriff 6,311
2 Maciej Los 2,692
3 Peter Leow 2,654
4 Abhinav S 2,562


Advertise | Privacy | Mobile
Web01 | 2.8.150414.1 | Last Updated 31 Jan 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100