how to check if a query returns any rows?

[hbutt]

hi, im having trouble checking to see if any rows have been returned. here is the code:

public static void CC_Validate(String a)
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"
String url = "jdbcdbc:SQL_ODBC_DEMO2";
Connection con = DriverManager.getConnection (url, "username", "password"
Statement stmt = con.createStatement();

String query1 = "SELECT * FROM CC_Nums WHERE CC_No="+a;
ResultSet rs1 = stmt.executeQuery(query1);

while(rs1.next())
{
String s1 = rs1.getString("CC_No"

System.out.println(s1 + "\t"

}

stmt.close();
con.close();

}
catch (SQLException e)
{
System.err.println(e.getMessage());
}
catch(ClassNotFoundException e)
{
System.err.println(e.getMessage());
}
}




any help is much apreciated. thanks
hbutt.

 

[sedj]

either :

        int fetchSize = 0;
        while(rs1.next())
        {
           fetchSize++;
            String s1 = rs1.getString("CC_No");

            System.out.println(s1 + "\t");

        }
        System.out.println(fetchSize);

or using the ResultSet.getFetchSize() method.