dbmd.getPrimaryKeys("","","users");

解决方案 »

  1.   

    麻烦看看我的部分代码:ResultSet dbRs;
            ResultSet dbrs2;
            java.sql.DatabaseMetaData dbmd;        conn=this.dbconn();
            if(conn!=null)
            {Statement stmt;
    stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
    dbRs=stmt.executeQuery("select * from Users");dbmd=conn.getMetaData();
    dbrs2=dbmd.getPrimaryKeys("","","Users");int j=0;
             while(dbRs.next())
                {
                 j++;
                 System.out.println(j);
                }            int i=0;
                if(!dbrs2.next())
                {
                    System.out.println("sssssssssss");
                }
                while(dbrs2.next())
                {
                        i++;
                    System.out.println(i);
                }       conn.close();
        }//--------------//
    结果是dbRs能够得到值,而dbrs2却是空的打印出了“ssssssss”