Having problem on retriving results from a query

[mike_ledis]

Hello suppose that i have the following sql table

name clients
field 1 c_id varchar(8)
field 2 remaining_amount smallint(6)
i need to execute the following statement from a java program and take the results
SELECT remaining_amount FROM clients WHERE c_id='something'
i tried the following code but i keep having an exception

    public static boolean checkAmountAndWithdraw (String id,int amount) throws SQLException
    {
    	 

        String chId = null;
    	Statement stmt ; 
        ResultSet rs ; 
        PreparedStatement pstmt = dbConnection.prepareStatement("SELECT remaining_amount FROM clients WHERE c_id='"+id+"'");
     
        rs=pstmt.executeQuery();
        Boolean exists=false;
            if(rs.getInt(2)==0){
        	System.out.println ("is") ;
        	exists=true;
            
        }
        System.out.println (exists) ;
      rs.close () ;
        return exists;
    }
}

[

[Petr]

You have mistake in prepared statement.
see Using Prepared Statements (The Java™ Tutorials > JDBC(TM) Database Access > JDBC Basics)

[Tolls]

Do you not think it might be an idea to actually tell us what the exception is (full stack trace and all)?

Your statement isn't actually incorrect...but it is a waste of a PreparedStatement (even an abuse). Reading the link Petr supplied will show you how to use it properly. The way you have it it may as well be a Statement.

However, the error is probably:

            if(rs.getInt([B]2[/B])==0){

You are only selecting one column in your query, whereas that line above is trying to find the third column you've requested...which doesn't exist.

[razmyasdfg]

Yeah Petr is right. you have a problem in Prepared Statement
put it in this way

PreparedStatement pstmt = dbConnection.prepareStatement("SELECT remaining_amount FROM clients WHERE c_id= ? id = ?);

pstmt.setString (1,"pass the c_id");
pstmt.setInt (2,pass the id)

while (rs.next()){ write the condition witch you want to check

}

[Tolls]

Which doesn't actually fix what is likely to have been the problem.
Which is that they were trying to get data from column 2, and only had one column in their query.

Of course they didn't give the exception or where it came from...

And this was over 2 weeks ago.