Syntax for SQL query in JSP.

[elldeegee]

Hi,

I am new with JSP so i want to know how to use SQL syntax in jsp?

I want to connect with the sql database & fetch output.

this is my query

"SELECT employee FROM email WHERE employee
like '%"+newUserID+"%'"

[Matsheet]

I hope you have put exception in your code.

Please use exception handling feature provided by JVM so you will come to know the exact problem with your code.

[Raffaele]

Syntax of JSP Declaratives is:

<%!
//java codes
%>

JSP Declaratives begins with <%! and ends with %>

try this code.

<sql:setDataSource
  var="variable"
  driver="oracle.jdbc.driver.OracleDriver"
  user="a"
  password="b"

<sql:query var="jack">
  SELECT * FROM mytable
</sql:query>

<%-- Get the column names for the header of the table --%>
<c:forEach var="columnName" items="${jack.columnNames}">
  <th><c:out value="${columnName}"/></th>
</c:forEach>

<%-- Get the value of each column while iterating over rows --%>
<c:forEach var="row" items="${jack.rows}">
  <tr>
    <c:forEach var="column" items="${row}">
      <td><c:out value="${column.value}"/></td>
    </c:forEach>
  </tr>
</c:forEach>

/>

[noscut]

You must always put your business logic in JAVA classes & call these classes from jsp.
Even if you put your SQL statements in JSP it will be hidden from the client & the client will only see the html code.