java连接access包_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: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("delete from arts

where id = 2");

ps.executeUpdate();

//rs.close();

ps.close();

stmt.close();

conn.close();

}

catch(Exception ex){

ex.printStackTrace();

}

}

}