connect java to MS Access Database

[needjavahelp]

Hi,

I am newbie to java programming. Now i am trying to connect the java program to Ms access database. So Far i have the following coding which i developed to connect to MS Access database. I am trying to change the name in the database table using the update query. Is this Code correct? And also Please tell me how to run the java program which has database connection?

Please Anyone here help me out in this regard...

import java.sql.*;

class a
{
public static void changelastname()
{
String sql = "update employee set lname='yyy' where id=1";
            st.executeUpdate(sql);

            System.out.println("Table updated.");
}
public static void main(String[] args)
{
try 
{

System.out.println(“Begining conn”);

Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);

String accessFileName = “company”;

String connURL=”jdbc:odbc:;DRIVER=Microsoft Access Driver (*.mdb);DBQ=”+accessFileName+”.mdb;PWD=”;

Connection con = DriverManager.getConnection(connURL, “”,”");

System.out.println(“Conn done succesfully”);

}
changelastname();
stmt.close();
con.close();
}
catch (Exception err) {
System.out.println(“ERROR: ” + err);
}
}
}

[Eranga]

Did you run this code on your IDE?

[Tolls]

"Is this code correct?" is not a good question.
You need to tell us what's wrong...we're not going to run it, but we can bug fix if you tell us what the bug is.

For starters does it compile?

[nitinverma]

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("Jdbc:Odbc:bank");
Statement st=con.createStatement();

bank is the DSN Name.

[masijade]

Okay? And this has to do with what? Especially since the OP is obviously inteding to make a DSNLess connection which is possible and inifinitly more flexible.

[JosAH]

For starters does it compile?

I guess not; the OP must've copied/pasted that code from an electronic text because most of those double quotes are incorrect. But not all of them so I suspect the code to be glued together; the new way of programming ...

kind regards,

Jos