aspose file tools*
The moose likes JDBC and the fly likes jdbc odbc ms access issue? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "jdbc odbc ms access issue?" Watch "jdbc odbc ms access issue?" New topic
Author

jdbc odbc ms access issue?

Devendra Ghag
Greenhorn

Joined: Jun 19, 2013
Posts: 14
0 down vote favorite


I want to store a record but don't know what to do. When i start entering the details of a customer, at that time database connectivity is successfully created but I fail to store the data in the database.

The procedure is correct to create the database but I can't enter the details, what can I do?

Here is the code:
import java.awt.Container;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import javax.swing.*;
//package p1;
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","GujrajSamachar","KarnatakMalla","Vartahar","PunyaNagari"};
JButton b1;
JButton b2;
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);
}
public static void main(String[] args)
{
New_Customer nc=new New_Customer() {};
}
public void actionPerformed(ActionEvent e)
{

System.out.println("You clicked the button");
if(e.getSource()==b1)
{

}
if(e.getSource()==b2)
{
try
{
Connection con;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbcdbc:devendra");
try
{

java.sql.Statement st = con.createStatement();
PreparedStatement ps = con.prepareStatement(null);
ResultSet rs = ps.executeQuery("insert into Customer values(?,?,?,?)");
while(rs.next())
{
ps.setString(1,textFieldId.getText());
ps.setString(2,textFieldName.getText());
ps.setString(3,textFieldContactNo.getText());
ps.setString(4,combo.getName());
}

}
catch (SQLException s)
{
System.out.println("SQL code does not execute.");
}
}
catch (ClassNotFoundException | SQLException ee)
{
System.out.println("Error:connection not created");
}
}
}
}
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3707
    
    5

Have you tried executeUpdate() instead of executeQuery()? You don't iterate over a result set to insert values in the manner you are using for an insert. You need to change the parameters and call executeUpdate each time you perform the insert (or use a batch update which is useful, but only after you have the basics down).


My Blog: Down Home Country Coding with Scott Selikoff
Devendra Ghag
Greenhorn

Joined: Jun 19, 2013
Posts: 14
i try with executeUpdate query but i got error to rs.next()
what should i do ?
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3707
    
    5

You don't use ResultSet.next() with executeUpdate. That method is only used to return a result set. Performing an update does not generally return a result set.
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3707
    
    5

A simple search of Google will show you what an INSERT/UPDATE statement should look like: http://www.tutorialspoint.com/jdbc/jdbc-insert-records.htm

The problem you are having is that you are trying to use SELECT statement type code to create new database objects.
Devendra Ghag
Greenhorn

Joined: Jun 19, 2013
Posts: 14
i got the result thanks to all...
in further in my project i want to add singal name from dropdown list to ms access database how can i add it ???
Devendra Ghag
Greenhorn

Joined: Jun 19, 2013
Posts: 14
i did not get what you are saying ?
i just ask that i want to stored any single value from drop combo box to ms access database in java swing ??
Devendra Ghag
Greenhorn

Joined: Jun 19, 2013
Posts: 14
can you give me code
i already mention in my code
is these right



ps.setString(4,combo.getName());
Devendra Ghag
Greenhorn

Joined: Jun 19, 2013
Posts: 14
i do not want these ans from you..
please correct me if i am wrong in these code?/
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  60

No one here will "give you the code" and no one here will correct your code for you. See NotACodeMill and DoYourOwnHomework. Others might not be so keen on helping you given that you didn't want the very good answers provided by Scott.

Unfortunately, there are several problems with your code. I've only some general advice for you at this point:

1) Don't mix JDBC and Swing code. It it easier to tackle JDBC problems and Swing problems separately. Create classes to hold your data, and use them to pass the data between Swing and JDBC code. See Data Transfer Object for more details.

2) Read the Swing tutorial. Also, have a look what JComboBox.getName() does (hint: you're probably interested in the value of the component, not its name).

3) Read an SQL tutorial. I cannot recommend a specific one, so please chose one yourself.

4) Read the JDBC tutorial.

Feel free to ask here or in the Swing forum if you encounter anything unclear with these tutorials. If you ShowSomeEffort, folks here will be glad to help.
Devendra Ghag
Greenhorn

Joined: Jun 19, 2013
Posts: 14
sorry man i do not want any code i just ask because if i am wrong in my code then correct me or tel me what to do..
leave that topic sorry..
actually recentely i got solution of these problem of code...
Thanks to suggest me your link's
Thanks again...
 
 
subject: jdbc odbc ms access issue?