《今天学会JAVA如何连ACCESS数据，可以用来应付下平时的小程序，学校的，比赛的~》

三种实现代码：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();
}
}
}