Java query access Database

Welcome to the Java Community Forum and interact with 2 million technical staff to enter packagechapter10; importjava. SQL. *; publicclassAccessData {publicAccessData () {} publicstaticvoidmain (String [] args) {newAccessData (); Stringurljdbc: odbc: mydbaccess; Stri

Welcome to the Java Community Forum and interact with 2 million technical staff> go to package chapter10; import java. SQL. *; public class AccessData {public AccessData () {} public static void main (String [] args) {new AccessData (); String url = "jdbc: odbc: mydbaccess"; Stri

Welcome to the Java Community Forum and interact with 2 million technical staff> enter

Package chapter10;

Import java. SQL .*;

Public class AccessData {

Public AccessData ()

{

}

Public static void main (String [] args ){

New AccessData ();

String url = "jdbc: odbc: mydbaccess ";

String query, name, mark;

Connection conn = null;

Statement statement = null;

ResultSet resultSet = null;

Try {

Class. forName ("sun. jdbc. odbc. JdbcOdbcDriver ");

Conn = DriverManager. getConnection (url );

Statement = conn. createStatement ();

Query = "select * from student ";

ResultSet=statement.exe cuteQuery (query );

While (resultSet. next ())

{

Name = resultSet. getString ("name ");

Mark = resultSet. getString ("mark ");

System. out. print ("name:" + name );

System. out. println ("score:" + mark );

}

}

Catch (SQLException e)

{

E. printStackTrace ();

}

Catch (Exception e)

{

E. printStackTrace ();

}

Finally {

Try {

If (resultSet! = Null) resultSet. close ();

If (statement! = Null) statement. close ();

If (conn! = Null) conn. close ();

}

Catch (SQLException e)

{

E. printStackTrace ();

}

}

}

}

Display result:

Name: Li Ming score: 81

Name: Zhang San score: 85

Name: Li Si score: 90

Name: Wang Wu score: 75

Name: Chen Six score: 68

Name: Zhao Ba score: 90

Name: yellow 9 score: 10

Name: Sun Hong score: 82