JSTL(SQL)

SQL
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>
1.<sql:setDataSource>
ÉèÖÃÊý¾ÝÔ´
<sql:setDataSource dataSource=""|url="jdbcUrl" driver="" user="" password=""
 var="varName" scope=""/>
var:String DataSource
dataSourceµÄÖµÓÐÁ½ÖÖÐÎʽ£º1.Ö¸¶¨Êý¾ÝÔ´µÄJNDIÃûµÄÏà¶Ô·¾¶£¬ÀýÈçjava:comp/env/jdbc/bookstore,Ö»ÐèÉèÖÃΪ"jdbc/bookstore"¼´¿É¡£
 2¡£Ö¸¶¨DriverManagerÀàÐèÒªµÄ²ÎÊý£¬¸ñʽ url£¬driver£¬user,password
ûÓÐÉèÖÃvarµÄ»°£¬Êý¾ÝÔ´½«±»±£´æµ½javax.servlet.jsp.jstl.sql.dataSource
<sql:setDataSource
  var="example"
  driver="RmiJdbc.RJDriver"
  url="jdbc:rmi://localhost:1099/jdbc:cloudscape:CloudscapeDB;create=true"
/>
2.<sql:query>
¶ÔÊý¾Ý¿â²éѯ
<sql:query sql="sqlQuery" var="" scope="" dataSource="" maxRows="" startRow=""/>
<sql:query sql="sqlQuery" var="" scope="" dataSource="" maxRows="" startRow="">
 <sql:param>
</sql:query>
<sql:query  var="" scope="" dataSource="" maxRows="" startRow="">
 <sql:param>
 sqlQuery
</sql:query>
var:javax.servlet.jsp.jstl.sql.Result
ResultµÄÎå¸ö·½·¨£º
String[]getColumnNames();·µ»Ø½á¹û¼¯ÖÐÁеÄÃû³Æ
SortedMap[]getRows ÿ¸ösortedMap´ï±êÒ»ÐУ¬ÁÐÃû×÷Ϊkey£¬¶ÔÓ¦ÁеÄÊý¾Ý×÷Ϊvalue
int getRowCount()
Object [][]getRowsByIndex()µÚһλ±íʾ²éѯ½á¹ûµÄÐУ¬µÚ¶þÁвéѯ½á¹ûµÄÁÐ
boolean isLimitedByMaxRows()ԭʼ¼Ç¼ÐÐÊýÊÇÐдóÓÚmaxRows
Îå¸öÊôÐÔ£ºcolumnNames,rowCount,rows,rowsByIndex,limitedByMaxRows
<sql:query sql="select * from bookinfo" var="books"/>
<table>
 <c:forEach var="book" items="${books.rows}">
  <tr>
   <td><c:out value="${book.title(ÁÐÃû)}"/></td>
   <td><c:out value="${book.author}"></td>
  </tr>
 </c:forEach>
</table>
<sql:query sql="select * from bookinfo" var="books"/>
<table>
 <c:forEach var="book" items="${books.rowsBy