java连接access不用jar包.docVIP

java连接access?不用jar包有两种方法，1种要配置，1种是要驱动你的这种写法是不用另加驱动的，但要配置操作如下：控制面板-管理工具-ODBC-系统DSN-添加Microsoft Access Driver(*.mdb)数据源名:sun (这个与你写的jdbc:odbc:sun对应)选择-你建的*.mdb的位置确定就可以用了 三种实现代码：import java.sql.*; class accessin{public static void main(String[] args) {try{Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);//String url = jdbc:odbc:wombat;//string url=“jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=“+application.getRealPath(“/Data/ReportDemo.mdb“);String url=jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=D:\\aa.mdb;Connection conn = DriverManager.getConnection(url,,);Statement stmt = conn.createStatement();//ResultSet rs = stmt.executeQuery(delete from arts where id = 2);//System.out.println(a row has beenn inserted;); PreparedStatement ps=conn.prepareStatement(insert into arts(title,hit) values(asd,4)); ps.executeUpdate();//rs.close();ps.close(); stmt.close();conn.close();}catch(Exception ex){ex.printStackTrace();}}} import java.sql.*; class access{public static void main(String[] args) {try{Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);//String url = jdbc:odbc:wombat;//string url=“jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=“+application.getRealPath(“/Data/ReportDemo.mdb“);String url=jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=D:\\aa.mdb;Connection conn = DriverManager.getConnection(url,,);Statement stmt = conn.createStatement();ResultSet rs = stmt.executeQuery(SELECT * FROM arts);System.out.println(Got ResultSet Now);//rs.beforeFirst();while(rs.next()){System.out.println(rs.getString(1));System.out.println(rs.getString(title));System.out.println(rs.getString(3));//System.out.println(rs.getString(hit));System.out.println();}rs.close(); stmt.close();conn.close();}catch(Exception ex){ex.printStackTrace();}}} import java.sql.*; class accessin{public static void main(String[] args) {try{Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);//String url = jdbc:odbc:wombat;//string url=“jdbc:odbc:D