java程序连接access数据库，路径问题？

Question

下面是连接Access的代码
import java.sql.*;
public class Test
{

public static void main(String args[])
{
Connection con;
Statement stmt;
ResultSet rs;
try
{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

}
catch(ClassNotFoundException e)
{

System.out.println(""+e);
}
try
{
con=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=[b]D:\123\data.mdb[/b]","","");
stmt=con.createStatement();
rs=stmt.executeQuery("select * from info");
while(rs.next())
{
String title=rs.getString(2);

System.out.print(" title："+title+"\t");
}
con.close();
}
catch(SQLException e) {System.out.println(e);}
}

}

我想把它改成相对路径，即DBQ中不用绝对路径。
让当前程序能找到data.mdb，那么这个语句该怎么写。
帮忙修改一下连data.mdb的语句，谢谢！

Answer 1

给楼主一个完整的例子吧：
假设abc.mdb放到data子目录下边：

[code="java"]package mytest.db.access;

import java.sql.*;

public class TestAccess
{
public static void main(String args[])
{
Connection con;
Statement stmt;
ResultSet rs;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (ClassNotFoundException e)
{
System.out.println("" + e);
}
try
{
String path = TestAccess.class.getClassLoader().getResource("data\abc.mdb").getPath()
.substring(1);
path = java.net.URLDecoder.decode(path);
System.out.println(path);
con = DriverManager.getConnection(
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=" + path, "", "");
stmt = con.createStatement();
rs = stmt.executeQuery("select 1");
while (rs.next())
{
String title = rs.getString(1);
System.out.print(" title：" + title + "\t");
}
con.close();
}
catch (SQLException e)
{
System.out.println(e);
}
}
}
[/code]