菜鸟在学习jbuilder7方面取得重大进展，可以在窗体上显示整个表的内容了，可喜可贺，但是在查询方面还有问题要问？？

Question

try{
            Class.forName(dbprop.Get_DbDriver()).newInstance();
            Connection conn=DriverManager.getConnection(dbprop.Get_DbDsn());
            Statement stmt=conn.createStatement();
            ResultSet rs=stmt.executeQuery("select * from manager");            while(rs.next()){
               String user = new String();
                user.addElement(new Integer(rs.getInt("userid")));
             }
            conn.close();
            rs.close();
        }catch(Exception e){
            JOptionPane.showMessageDialog(null,"无法连接数据库","系统提示",JOptionPane.WARNING_MESSAGE);
        }

Answer 1

try{
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://ip地址:1433;DatabaseName=数据库名","sa","");  
            Statement stmt=conn.createStatement();
            ResultSet rs=stmt.executeQuery("select * from 表名 where 姓名=qq");            while(rs.next()){
               edit.setText(rs.getInt("userid").toString());
       }
       rs.close();
      stmt.close();
     conn.close();
            }catch(SQLException e){}
如果你用的是SQL的话，不过我不懂DEPHI，所以不对的地方请原谅！呵呵！