Package zmsjdbc; import java.sql. *; import java.sql.resultset; / ** * Built an access database DB1 has a field 1 ID character type, 2 Name character * / public class access1 {
Public static void main (string [] args) {Access1 x = new access1 (); string str = "select * from test1";
IF (x.execute1 (str)) {system.out.println ("Extraction Success");
} Public boolean execute111 (string sqlstr) {Try {class.forname ("sun.jdbc.odbc.jdbcodbcodbdriver"); string url = "jdbc: odbc: driver = {Microsoft Access Driver (* .mdb)}; DBQ = D : /Accdb/db1.mdb "; connection conn = drivermanager.getConnection (URL,", "" "; statement stmtnew = conn.createstatement (); resultset = stmtnew.executeQuery (SQLSTR); if (rs.next )) {System.out.println (rs.getstring ("id")); system.out.println (rs.getstring ("name");}
Return true;} catch (sqlexception e) {system.out.println (E.getMessage ()); return false;} catch (exception e) {system.out.println ("error"); return false;}
}
}
