在java里连接access数据库

package test;

import java.sql.*;

public class DBConnector
{
 Connection con;
 Statement stmt;
 ResultSet rs;
 String sql;
 String url;
 
 public DBConnector()
 {
  con = null;
  stmt = null;
  rs = null;
  url = "";
 }
 
    private Connection getCon()
    {
        return con;
    }
    private void setCon(Connection con)
    {
        this.con = con;
    }
    private ResultSet getRs()
    {
        return rs;
    }
    private void setRs(ResultSet rs)
    {
        this.rs = rs;
    }
    public String getSql()
    {
        return sql;
    }
    public void setSql(String sql)
    {
        this.sql = sql;
    }
    private Statement getStmt()
    {
        return stmt;
    }
    private void setStmt(Statement stmt)
    {
        this.stmt = stmt;
    }
    public String getUrl()
    {
        return url;
    }
    public void setUrl(String url)
    {
        this.url = url;
    }
   
 //创建数据库连接
 public void getConnection(String className, String url)
 throws Exception
 {
   Class.forName(className);
   con = DriverManager.getConnection(url);
 }
 
 //执行SQL语句,返回相应结果
 public ResultSet execute(String sqlStr)
 {
     try
     {
     stmt = con.createStatement();
     return stmt.executeQuery(sqlStr);
     }
     catch(Exception e){return null;}
 }
 
 //关闭数据库连接
  void close()
  throws Exception
  {
  con.close();
  }
 
 public static void main(String[] args)
 throws Exception
 {
     String className,url,sql;
     ResultSet rs;
  DBConnector t = new DBConnector();
  url = "jdbc:odbc:test";
  className = "sun.jdbc.odbc.JdbcOdbcDriver";
  
  t.getConnection(className,url);
  sql = "select * from project";
  rs = t.execute(sql);
  while(rs.next())
  {
      System.out.println("ID:/t" + rs.getInt("ID"));
      System.out.println("name:/t" + rs.getString("name"));
  }
  t.close();
 }
}