sql query

[bhaskar behera]

i have used long sql query in jsp.how i write this sql query line by line in jsp ?

[r035198x]

SQL should not be found in JSP pages at all.
I'm really not sure what it is that you are trying to ask here.

[itsraghz]

If your *real* concern is to have the sql query to be splitted across several lines you can append the portion of queries on each line with the "+" symbol which acts as a concatenation operator.

String mySql = "SELECT * FROM <<tableName>>" +
                      "where tableName.colName in (Select matchingColName FROM " +
                      " <<anotherTableName>> ";

But as the administrator said, its NOT a good practice to have the SQL inside the JSP and executing it directly as well. Try to read about MVC and follow it.