JAVABEAN中连接access，如何用相对路径详解？

来源：百度知道 编辑：UC知道 时间：2024/07/03 01:24:40
这是我用的javabean类，名字为：connDB.java
package beans;
import java.sql.*;
public class connDB{
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
public connDB(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException e){
System.err.println(e.getMessage());
}
}
public ResultSet executeQuery(String sql){
try{
conn=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\test\\gaozhi\\database\\swugz.mdb");
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql);

public boolean connect(){
try{
String path="";
Class theClass=DataBase.class;
System.out.println(getClass().getResourceAsStream("db/db.mdb"));
java.net.URL u= theClass.getResource("db/db.mdb");
System.out.println(u.getPath().substring(1,u.getPath().length()).replaceAll("%20", " "));
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+u.getPath().substring(1,u.getPath().length()).replaceAll("%20", " ");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("before connection");
conn=DriverManager.getConnection(url);
stmt=conn.createStatement();
}catch(Exception ee){
System.out.println("connect db error:&q