COUNT+PSTMT error?

[sahar sa]

Dear,
Im trying to find the count of rows who has Pmax . and I need to use PSTMT. but it throws me an error:
here is the code snippet:

          Connection con = getConnection();
            StringBuilder query = new StringBuilder() ;
            query.append("select count(Pmax) as rowcount from tseller").append(" where manfac=?").append(" and name=?");
            String update = query.toString();
            pstmt = con.prepareStatement(update);
             pstmt.setString(1,Name);
             pstmt.setString(2,Manfac);
             ResultSet row=pstmt.executeQuery();
             row.next();// Get the rowcount column value.
             int ResultCount = row.getInt(rowcount) ;
             System.out.println("Good is counted in DB: Name: "+Name +", "+Manfac+", "+"Count:"+ResultCount);
             row.close() ;    

here is the error:

Compiling 1 source file to C:\Documents and Settings\student\Desktop\project  incomplete\1-work On\BookTrading\build\classes
C:\Documents and Settings\student\Desktop\project  incomplete\1-work On\BookTrading\src\DB\DB.java:77: cannot find symbol
symbol  : variable rowcount
location: class DB.DB
             int ResultCount = row.getInt(rowcount) ;
1 error
BUILD FAILED (total time: 2 seconds)

do you know how can I declare this rowcount ?
thanks,
Sahar.

[Paul Sturrock]

No, but you do have to pass a String or int to the getInt() method. Stick some quotes round rowcount.

[sahar sa]

wooow! thank you friend!
now it works!