equalizing a variable in an sql statement

[Keshini Weerasuriya]

Hi...

I'm trying to equal an ID which is taken as user input in an sql staement as below..

int answer = Integer.parseInt(mainMenu.client);
ResultSet rs = st.executeQuery("select * from Client where CliId = answer ");

Give the error, java.sql.SQLException: ORA-00904: invalid column name
Pls help.. Tnx..

[Keith Lynn]

It looks like the column name you listed was not found in the table. I'm not sure, but it may be case sensitive.

[Mani Ram]

Also note that you have included the 'answer' variable with in the quotes. So the query that will be executed in the database will be

select * from Client where CliId = answer;

The proper way to build the query is

ResultSet rs = st.executeQuery("select * from Client where CliId = " + answer);

Another way is to use a PreparedStatement

String QUERY = "select * from Client where CliId = ?";
preparedStatement = connection.prepareStatement ( QUERY );
preparedStatement.setInt ( answer );
preparedStatement.executeQuery ( );

[Keshini Weerasuriya]

Tnx Mani Ram.. Your method works.........