注意Driver后面一定要带空格!不带空格就有错!
import java.sql.*;
public class DBConnection {
public void DBC (){
try{
String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\SQL\\db.mdb";//你的ACCESS文件位置
//String strurl ="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=db.mdb";//此为NO-DSN方式
//String strurl="jdbc:odbc:test";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(strurl);
System.out.println("连接成功!");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from test");
if(rs.next())
{
//System.out.println(rs.getString("name"));
}
}catch(Exception e)
{
e.printStackTrace();
}
}
public static void main(String[] args) throws ClassNotFoundException {
DBConnection dbc = new DBConnection();
}
}
(责任编辑：包春林)
|
