11. Learning Java: JSTL, part 2 – a rant

In the 11th hours, I continued with JSTL. In this, I learned about delimits, Connections to the database. Here is another blah blah post continued. You can continue reading my blah blah post for many days to come.

Here are the hand written fragments.

Token:

<core:set value="Satya|Prakash:Karan" var="Names" />

<core:forTokens items="${names}" var="name" delims=":|" />

<core:out value="${names}" /> <br/>

</core:forToken>

Datebase Connection:

Add library: jstl/sql-rt. Prefix given : sql

<sql:setDataSource Driver="com.mysql.jdbc.Driver" var="conn" Database="jdbc:mysql://127.0.0.1:3306/java" />

<sql:query DataSource="${conn}" query="select * from tableName where eno=1" var="table" />

${table.columnNames}

${table.rows}

${table..rowsByIndex}

----

<core:forEach items="${table.columnNames}"  var="columns" >

<td> <core:out value="${columns}" /></td>

</core:forEach>

---

<core:forEach items="${table.rows}" var="Row">
<td> <core:out value ="${Row.Eno}"/> </td>
<td> <core:out value ="${Row.Ename}"/> </td>
<td> <core:out value ="${Row.Salary}"/> </td>
<td> <core:out value ="${Row.Email}"/> </td>
<td> <core:out value ="${Row.Address}"/> </td>
</core:forEach>