java - 为什么我在 ResultSet 中得到 "oracle.jdbc.driver.OracleResultSetImpl@3ee82600"值而不是用户 ID 和密码

Question

我有以下 DAO 方法:

    public boolean validate(String UserName,String password) throws Exception
    {
        this.userName=UserName;
        this.password=password;


        boolean status=false;
        PreparedStatement pst = null;
        ResultSet rs = null; 
        Connection con = null;  
        DataBase db =new DataBase();
        con=db.dbConnection();
        User user=new User();
        try {
            pst=con.prepareStatement("select * from login where userId=? and password=?");
            pst.setString(1, user.getUserName());
            pst.setString(2, user.getPassword());
        } catch (SQLException e1) {
            e1.printStackTrace();
        }

        try {
            rs=pst.executeQuery();
            System.out.println("Result in  Resultset"+rs);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        try {
            while(rs.next())
            {
                if((rs.getString("USERID")==user.getUserName()) && (rs.getString("Password")==user.getPassword()))
                {           
                    status=true;
                }
                else
                {
                    status=false;
                }
            }
        } catch (SQLException e) {
            System.out.println("Data is not store in result set");
            e.printStackTrace();


    }
        return status;

}

这就是我在图像中遇到的问题，我在 ResultSet 对象 rs 中得到这个“oracle.jdbc.driver.OracleResultSetImpl@3ee82600”值，而不是来自数据库的用户 ID 和密码

Answer 1

您可以通过以下方式获取Userid和password的值

if(rs.next()) {
    String userId = rs.getString("userId");
    String password = rs.getString("password");
}