Validation/DB query question

[Ricky Jay]

I'm trying to validate for duplicate entries. I'm wanting to make sure that the value is not already in the table.

Is there a way to just return a value from a table without putting it in a bean? Should I just do a count and then return the count value?

[Bear Bibeault]

Moved to the JDBC forum.

[Ricky Jay]

Am I going the right direction with this??

  public static boolean duplicateUserid(String userid)
    {
        ConnectionPool pool = ConnectionPool.getInstance();
        Connection connect = pool.getConnection();
        PreparedStatement ps = null;
        ResultSet rs = null;
        String query =  "SELECT COUNT(Userid) FROM User WHERE userid = ?";
        boolean bCount = true;


        try
        {
            ps = connect.prepareStatement(query);
            ps.setString(1, userid);
            rs = ps.executeQuery();

            if(rs.equals(0))
            {bCount= true;}else{bCount =false;}
            return bCount;
        }
        catch(SQLException e)
        {
            e.printStackTrace();
        }
        finally
        {
            DBUtil.closePreparedStatement(ps);
            pool.freeConnection(connect);
        }

    }  

[Ricky Jay]

Replaced with these two lines of code.

String query =  "SELECT Userid FROM User WHERE userid = ?";   

     while (rs.next())
            {
               count++;
            }