Simple SQL Query Problem?

[Vaastav]

Hi how do I embed a variable in a sql statement in a Java bean. I am trying reference a vaule from my jsp which is stored in the variable argshowcourse in my java bean. Is this the right way to do it?

String sqlQuery = "SELECT * from modules WHERE 'argShowCourse' = 'O';

 

[gdiffor]

If the variable - argShowCourse contains the name of a column in your table, you would code the following:

String sqlQuery = "SELECT * from modules WHERE " + argShowCourse + " = 'O'";

If the variable - argShowCource contains the value you want to search for, you would code the following:

String sqlQuery = "SELECT * from modules WHERE COLUMNNAME = '" + argShowCourse + "'";

If the query is going to be used multiple times (with different values in the argShowCourse variable, you may be better off using a PreparedStatement to handle your query.