java and jdbc

gwladys boy

hi guys

i am trying to use this java code to get access to a ms access database file called fred, stored in the root of the c: drive.

i get a sql error when i run it in jbuilder.?


any tips?


__________________________________________________________________



package jdbc;

import javax.swing.UIManager;
import sun.jdbc.odbc.*;
import java.sql.*;
import sun.jdbc.odbc.*;


public class JdbcTest {

public JdbcTest() {
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:MS Access Database;DBQ=c:\\fred.mdb", "", "");
System.out.println("connected ok");

Statement stmt = con.createStatement();
// putting data into the database
String insertSQL="insert into Coffee (name, price, quantity, sales) values ('greg',12,12,5 )";
stmt.executeUpdate(insertSQL);

// getting data from the database
String selectSQL="select * from Coffee where sales < 9";
ResultSet rs = stmt.executeQuery(selectSQL);
while (rs.next()){
String name = rs.getString("name");
System.out.println(name);
}

}
catch(Exception ee)
{
System.out.println("ERROR connecting:"+ee);
}


}

public static void main(String[] args) {
JdbcTest jdbcTest1 = new JdbcTest();
}
}

Stark

You might want to post the error.