Java Read Access database data __ Database

Although simple, for beginners, without a piece of code can be successfully executed for reference, it is difficult to debug

First use access to build a database DB1. MDB, which has a table "table1", Inside the field "Name" and "age" casually fill in a few records, save to ODBC to build a system data source "Access2000" connected to this database

You can then use the following code to display all the records in the database.

database.java 
------------------ 
Import java.sql.*; 

class Database { 
public static void Main (String args[]) { 
try{ 
Class.forName ("Sun.jdbc.odbc.JdbcOdbcDriver"); &NBSP
String url= "jdbc:odbc:Access2000";  
Connection connection=drivermanager.getconnection (URL); &NBSP
Statement Statement = Connection.createstatement ();  
String sql= "SELECT * from table1";  
ResultSet rs = statement.executequery (sql);  
String tt; 
while (Rs.next ()) { 
System.out.print ("Name:" + rs.getstring ("name"));  
System.out.println ("Age:" + rs.getstring ("aged")); 
} 
Rs.close ();  
Connection.close ();  
} 
catch (Exception ex) { 
System.out.println (ex);  
System.exit (0);  
} 
} 
} 

------------
OK, compile run:
E:/java>javac Database.java

E:/java>java Database

Here is a URL notation

String url = "Jdbc:odbc:driver={microsoft Access driver (*.mdb)};D bq=c:/att2000. MDB ";

When connecting to other computers, share this file with the folder where the file resides. Like \\192.168.0.251\fileAtt\, then you can dbq=\\192.168.0.251\fileatt\att2000. MDB; The URL can be written as follows

String url = "Jdbc:odbc:driver={microsoft Access driver (*.mdb)};D bq=\\\\192.168.0.251\\fileatt\\att2000. MDB ";