Need help with insert values into access

[Almog mar]

I need help with this code:

import java.sql.*; 
import java.awt.*; 
import java.awt.event.*; 
import javax.swing.*; 
public class DBCon extends JFrame implements ActionListener 
{ 
JTextField name; 
JButton next; 
JButton addnew; 
JPanel p; 
public static final String url ="jdbcdbc:"+ "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="; 
public static final String driver ="sun.jdbc.odbc.JdbcOdbcDriver"; 
static Connection con; 
static ResultSet res; 
String path; 



public DBCon() { 
super("Our Application"); 
Container c = getContentPane(); 
c.setLayout(new GridLayout(5,1)); 
name = new JTextField(20); 
next = new JButton("Next"); 
p = new JPanel(); 
c.add(new JLabel("Enter Your Name",JLabel.CENTER)); 
c.add(name); 
c.add(p); 
p.add(next); 
next.addActionListener(this); 
pack(); 
setVisible(true); 
addWindowListener(new WIN()); 
path= "C:/eclipse/Unit4/MyProjects/ConnectDB/tutorial.mdb"; 
} 
public static void main(String args[]) { 
DBCon d = new DBCon(); 
d.go(); 
d.showRecord(res); 
} 
public void go() 
{ 
makeConnection(); 
addRecipe(); 
} 
private void makeConnection() 
{ 
System.out.println("Opening database...\n"); 
try 
{ 
Class.forName(driver); 
con=DriverManager.getConnection(url+path); 
} 
catch(Exception ex) 
{ 
System.out.println("Error opening the database!"); 
System.out.println(ex); 
System.out.println(0); 
} 
System.out.println("Success!"); 
} 

public void actionPerformed(ActionEvent e) { 
if(e.getSource() == next) { 
try { 
res.next(); 
} 
catch(Exception ee) {} 
showRecord(res); 
} 
} 
private void addRecipe() 
{ 
String fristName=name.getText(); 
String sql="INSERT INTO RECIPESTABLE(RECIPENAME,INGREDIENTS)"+"VALUES('"+ fristName + "','Ingredients')"; 
System.out.println("\nAdding a recipe: "); 
try 
{ 
Statement statement=con.createStatement(); 
int result=statement.executeUpdate(sql); 
System.out.println("Added "+result+" recipe(s)."); 
} 
catch(Exception ex) 
{ 
System.out.println("Error adding a recipe"); 
System.out.println(ex); 
} 
} 
public void showRecord(ResultSet res) { 
String sql="SELECT * FROM RECIPESTABLE"; 
System.out.println("\nRecipes in the database :\n"); 

try 
{ 
Statement statement=con.createStatement(); 
ResultSet rs=statement.executeQuery(sql); 
if(rs!=null) 
{ 
while(rs.next()) 
{ 
int recipeID=rs.getInt("RECIPEID"); 
//System.out.print("Name:"+" "); 
String recipeName=rs.getString("RECIPENAME"); 
System.out.println(recipeID+" "+recipeName); 
//System.out.println(); 
//System.out.print("ID:"+" "); 
//String recipeID=rs.getString("ID"); 
//System.out.print(recipeID); 
//System.out.println(); 
//System.out.print("Win:"+" "); 
//String recipeWin=rs.getString("Win"); 
//System.out.print(recipeWin); 
//System.out.println(); 
//System.out.print("Lose:"+" "); 
//String recipeLose=rs.getString("Lose"); 
//System.out.print(recipeLose); 
//System.out.println(); 
} 
} 
rs.close(); 
statement.close(); 
} 
catch(Exception ex) 
{ 
System.out.println("Error reading database information!"); 
System.out.println(ex); 
} 

} 
class WIN extends WindowAdapter { 
public void windowClosing(WindowEvent w) { 
JOptionPane jop = new JOptionPane(); 
jop.showMessageDialog(null,"Database","Thanks",JOptionPane.QUESTION_MESSAGE); 

} 


} 
} //end of the class 

I try to insert value into table in access but i dont succed...
I using with Eclipse.

You can fix my code for me?
I click on the botton NEXT and its no add the Name into the access...
Its add frame0.


Thanks you.

[David O'Meara]

There is a bug in the jdbc-odbc bridge. Try running a select on the same connection then see if the insert went through.

[Almog mar]

David O'Meara wrote:There is a bug in the jdbc-odbc bridge. Try running a select on the same connection then see if the insert went through.

I dont understand...
This code: String sql="INSERT INTO RECIPESTABLE(RECIPENAME,INGREDIENTS)"+"VALUES('"+ fristName + "','Ingredients')"; is insert value
all work good the Eclipse run it....

If I change the code like that:"INSERT INTO RECIPESTABLE(RECIPENAME,INGREDIENTS)"+"VALUES('Pizza ','Ingredients')"; is insert value pizza and I want when you Enter your name it insert your name
and i dont know how to change this code for that this will run.

Now when I run it the Output is:
Like this:

1 Any Recipe
2 frame0
3 frame0
4 frame0
5 frame0
6 null
7 frame0
8
9
10

and I try to write name like: Dan
and this not insert this.

you can try it in your computer and help me plss?I dont know what do to I have try everythings.

[David O'Meara]

I'd recommend getting rid of access and trying to use a real database like MySQL with the Type 4 driver.

Failing that, I recommend doing this for your insert:
* get connection
* get statement for insert
* execute insert
* close statement
* get statement for select
* execute select, close ResultSet, close Statement
* close Connection

While you just throw out the results from the select, it is required to 'push' the insert statement through the Type-1 driver since due to a bug it can get stuck.
Another option is to setAutocommit(true) when you open a database Connection

Your code doesn't appear to close database resources when it is done with them, and this can also be the source of errors.