retrieve the values from access database

All to gether different process. Java provides four types of driver(Type I - Type IV) for it. When u r creating DSN name and all for Type I driver.

We can not create DSN name for other types of driver. can you please go through the type of driver. After that, look at below code.

String databaseDriver = "org.gjt.mm.mysql.Driver";

Class.forName( databaseDriver );

String databaseName = "jdbc:mysql://localhost/test";

Connection con = null;

try{

con = DriverManager.getConnection(databaseName, "name","password");

String query = "select * from cust where id =2";

Statement st = con.createStatement();

ResultSet rs = st.executeQuery(query);

///////extra coding

Elango123a at 2007-7-8 1:59:55 >