用ODBC看看
    public void conn()
    {
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con=DriverManager.getConnection("jdbc:odbc:rosen","administrator","");
        }
        catch (Exception e)
        {
            System.out.println(e);
        }
    }
    public ResultSet setId(String a)
    {
        id=a;
        ResultSet rs=null;
        Statement stm;
        try
        {
          String sql = "select count(*) from mytable";
          stm = con.createStatement();
          rs = stm.executeQuery(sql);
        }
        catch (Exception e)
        {
            System.out.println(e);
        }
        return rs;
    }