Using Access as a database

1 ImportJava.sql.*;2 3  Public classconnectaccess {4 5     6      Public Static voidMain (String args[]) {7Connectaccess CA =Newconnectaccess ();8         Try {9 ca.connectaccess ();Ten}Catch(Exception e) { One e.printstacktrace (); A         } -     } -  the      Public voidConnectaccess ()throwsException { -Class.forName ("Sun.jdbc.odbc.JdbcOdbcDriver"); -          -         /** + * Connect directly to an Access file.  -          */ +String url = "Jdbc:odbc:driver=microsoft Access DRIVER (*.mdb, *.accdb);D bq=access\\access.accdb; pwd=123456; "; A          at         /** - * Using ODBC to connect data sources -          */ - //String ur1 = "Jdbc:odbc:DataSource"; -          -Connection conn = drivermanager.getconnection (URL, "", ""); inStatement stmt =conn.createstatement (); -String sql = "SELECT * FROM T_system_user_info"; toResultSet rs =stmt.executequery (SQL); +          while(Rs.next ()) { -System.out.println (Rs.getstring (2)); theSystem.out.println (Rs.getstring (3)); *         } $ rs.close ();Panax Notoginseng stmt.close (); - conn.close (); the     } +  A}

For learning reference only.