<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

    blogjava's web log

    blogjava's web log
    ...

    Jstl 操作數據庫相關

    工作要找。。東西還是要學的。。。

    Code:
    JSTL SQL Query


    <%@?taglib?uri="http://java.sun.com/jstl/core"?prefix="c"?%>
    <%@?taglib?uri="http://java.sun.com/jstl/sql"?prefix="sql"?%>

    <sql:setDataSource?var="dataSource"?driver="org.gjt.mm.mysql.Driver"
    url="jdbc:mysql://localhost/forum?user=forumuser"
    scope="session"?/>

    <html>
    ??<head>
    ????<title>Query?Example</title>
    ??</head>

    ??<body>

    <sql:query?var?=?"users"?dataSource="${dataSource}">
    select?column_uid,column_pwd,column_accesses,column_first,column_last,column_bad,column_posted,column_type?from?t_users
    </sql:query>

    <table?border=1>
    <c:forEach?var="row"?items="${users.rows}">
    <tr>
    <td><c:out?value="${row.column_uid}"/></td>
    <td><c:out?value="${row.column_pwd}"/></td>
    <td><c:out?value="${row.column_accesses}"/></td>
    <td><c:out?value="${row.column_first}"/></td>
    <td><c:out?value="${row.column_last}"/></td>
    <td><c:out?value="${row.column_bad}"/></td>
    <td><c:out?value="${row.column_posted}"/></td>
    <td><c:out?value="${row.column_type}"/></td>
    </tr>
    </c:forEach>
    </table>


    ??</body>
    </html>

    JSTL SQL Update

    <%@?taglib?uri="http://java.sun.com/jstl/core"?prefix="c"?%>
    <%@?taglib?uri="http://java.sun.com/jstl/core-rt"?prefix="c-rt"?%>
    <%@?taglib?uri="http://java.sun.com/jstl/sql"?prefix="sql"?%>

    <sql:setDataSource?var="dataSource"?driver="org.gjt.mm.mysql.Driver"
    url="jdbc:mysql://localhost/forum?user=forumuser"
    scope="session"?/>

    <html>
    ??<head>
    ????<title>General?Query</title>
    ??</head>

    ??<body>
    ??<c:choose>
    ????<c:when?test="${param.cmd!=null}">
    ??????<c:set?var="str"?value="${param.cmd}"?/>
    ????</c:when>

    ????<c:otherwise>
    ??????<c:set?var="str"
    ??????value="select?*?from?tableName"?/>
    ????</c:otherwise>
    ??</c:choose>

    ??Please?enter?a?query:
    ??<br?/>

    ??<form?method="post">
    ????<textarea?name="cmd"?cols="40"?rows="5">
    <c:out?value="${str}"?/>
    ????</textarea>

    ????<br?/>

    ????<input?type="submit"?/>
    ??</form>

    ??<c:if?test="${pageContext.request.method=='POST'}">
    ????<c:catch?var="e">
    ??????<sql:query?var="users"?dataSource="${dataSource}"
    ??????sql="${param.cmd}"?/>

    ??????<table?border="1">
    ????????<c:forEach?var="row"?items="${users.rows}"
    ????????varStatus="status">
    ??????????<jsp:useBean?id="status"
    ??????????type="javax.servlet.jsp.jstl.core.LoopTagStatus"?/>

    ??????????<c-rt:if?test="<%=status.getCount()==1%>">
    ????????????<tr>
    ??????????????<c:forEach?var="col"?items="${row}">
    ????????????????<th>
    ??????????????????<c:out?value="${col.key}"?/>
    ????????????????</th>
    ??????????????</c:forEach>
    ????????????</tr>
    ??????????</c-rt:if>

    ??????????<tr>
    ????????????<c:forEach?var="col"?items="${row}">
    ??????????????<td>
    ????????????????<c:out?value="${col.value}"?/>
    ??????????????</td>
    ????????????</c:forEach>
    ??????????</tr>
    ????????</c:forEach>
    ??????</table>
    ????</c:catch>

    ????<c:if?test="${e!=null}">
    ??????<h3>Error</h3>

    ??????<c:out?value="${e}"?/>
    ????</c:if>
    ??</c:if>
    ??</body>
    </html>

    Updating a database using the sql:update tag

    //web.xml

    <?xml?version="1.0"?encoding="UTF-8"?>
    <!DOCTYPE?web-app?PUBLIC?"-//Sun?Microsystems,?Inc.//DTD?Web?Application?2.3//EN"
    ??"http://java.sun.com/dtd/web-app_2_3.dtd">
    <web-app>
    ??<resource-ref>
    ????<res-ref-name>jdbc/address</res-ref-name>
    ????<res-type>javax.sql.DataSource</res-type>
    ????<res-auth>Container</res-auth>
    ??</resource-ref>
    </web-app>


    <%@?taglib?prefix="sql"?uri="http://java.sun.com/jstl/sql"?%>
    <%@?taglib?prefix="c"?uri="http://java.sun.com/jstl/core"?%>
    <html>
    <head>
    <title>Updating?a?database?using?the?sql:update?tag</title>
    <sql:setDataSource
    ??var="conn"
    ??dataSource="jdbc/address"
    />
    </head>
    <body>
    <h1>Modify?Address?List</h1>
    <sql:update?dataSource="${conn}"?var="addresses">
    ????INSERT?INTO?AddressList?(name,?street,?city,?country,?telephone)?VALUES?(?,??,??,??,??)
    ????<sql:param?value='${param["name"]}'/>
    ????<sql:param?value='${param["street"]}'/>
    ????<sql:param?value='${param["city"]}'/>
    ????<sql:param?value='${param["country"]}'/>
    ????<sql:param?value='${param["tel"]}'/>
    </sql:update>
    </body>
    </html>

    Presenting database content using tags

    //web.xml
    <?xml?version="1.0"?encoding="UTF-8"?>
    <!DOCTYPE?web-app?PUBLIC?"-//Sun?Microsystems,?Inc.//DTD?Web?Application?2.3//EN"
    ??"http://java.sun.com/dtd/web-app_2_3.dtd">
    <web-app>
    ??<resource-ref>
    ????<res-ref-name>jdbc/address</res-ref-name>
    ????<res-type>javax.sql.DataSource</res-type>
    ????<res-auth>Container</res-auth>
    ??</resource-ref>
    </web-app>




    <%@?taglib?prefix="sql"?uri="http://java.sun.com/jstl/sql"?%>
    <%@?taglib?prefix="c"?uri="http://java.sun.com/jstl/core"?%>
    <html>
    <head>
    <title>Presenting?database?content?using?tags</title>
    <sql:setDataSource
    ??dataSource="jdbc/address"
    ??var="conn"
    />
    </head>
    <body>

    <h1>Address?List</h1>
    <sql:query?dataSource="${conn}"?var="addresses">
    ????SELECT?*?FROM?AddressList
    </sql:query>
    <table?width="90%"?border="1">
    <tr>
    <!--?add?the?table?column?headings?-->
    <c:forEach?var="columnName"?items="${addresses.columnNames}">
    ??<th>?<c:out?value="${columnName}"/>?</th>
    </c:forEach>
    </tr>
    <!--?add?the?table?rows?from?the?result?set?-->
    <c:forEach?var="row"?items="${addresses.rowsByIndex}">
    ??<tr>
    ????<c:forEach?var="column"?items="${row}">
    ??????<td><c:out?value="${column}"/></td>
    ????</c:forEach>
    ??</tr>
    </c:forEach>
    </table>
    </body>
    </html>

    JSTL: Transaction with a JSP

    <%@?taglib?uri="http://java.sun.com/jstl/core"?prefix="c"?%>
    <%@?taglib?uri="http://java.sun.com/jstl/sql"?prefix="sql"?%>
    <html>
    <HEAD>
    ??????<TITLE>Using?a?Transaction?with?a?JSP</TITLE>
    ?????</HEAD>
    <body?bgcolor="white">
    ??????????<h2>View?table?Data</h2>
    <sql:transaction>??
    ??<sql:update>
    ??insert?into?atable?values(2,?'Joe','Id','Feb-24-1996','F')
    ??</sql:update>
    ????<sql:query?var="resultObj">
    ????select?*?from?atable
    ????</sql:query>

    </sql:transaction>??
    <table>
    <c:forEach?items="${resultObj.rows}"?var="row">
    ??<c:forEach?items="${row}"?var="column">
    ????<tr>
    ???<td?align="right">
    ?????<b><c:out?value="${column.key}"?/></b>
    ?????</td>
    ?????<td>
    ???????<c:out?value="${column.value}"?/>
    ?????</td></tr>
    ?????</c:forEach>
    ???????</c:forEach>
    ?????</table>
    </body>
    </html>



    SQL Tag Out Examples

    <%@?taglib?uri="http://java.sun.com/jstl/core"?prefix="c"?%>
    <%@?taglib?uri="http://java.sun.com/jstl/sql"?prefix="sql"?%>

    <sql:setDataSource?var="dataSource"?driver="sun.jdbc.odbc.JdbcOdbcDriver"?url="jdbc:odbc:forum"/>

    <html>
    ??<head>
    ????<title>SQL?Tag?Out?Examples</title>
    ??</head>

    ??<body>

    <sql:query?var?=?"users"?dataSource="${dataSource}">
    select?column_uid,column_pwd,column_accesses,column_first,column_last,column_bad,column_posted,column_type?from?t_users
    </sql:query>

    <table?border=1>
    <c:forEach?var="row"?items="${users.rows}">
    <tr>
    <td><c:out?value="${row.column_uid}"/></td>
    <td><c:out?value="${row.column_pwd}"/></td>
    <td><c:out?value="${row.column_accesses}"/></td>
    <td><c:out?value="${row.column_first}"/></td>
    <td><c:out?value="${row.column_last}"/></td>
    <td><c:out?value="${row.column_bad}"/></td>
    <td><c:out?value="${row.column_posted}"/></td>
    <td><c:out?value="${row.column_type}"/></td>
    </tr>
    </c:forEach>
    </table>


    ??</body>
    </html>

    詳細請看:http://www.java2s.com

    posted on 2006-06-15 19:27 record java and net 閱讀(1342) 評論(0)  編輯  收藏 所屬分類: Jsp&&Web

    導航

    常用鏈接

    留言簿(44)

    新聞檔案

    2.動態語言

    3.工具箱

    9.文檔教程

    友情鏈接

    搜索

    最新評論

    主站蜘蛛池模板: 成人久久久观看免费毛片| 久久久久亚洲AV无码永不| 亚洲Av永久无码精品一区二区| 无码国产精品一区二区免费16| 亚洲熟妇无码另类久久久| 一区二区三区免费视频网站| 亚洲国产成人精品无码久久久久久综合 | 免费黄网在线观看| 亚洲精品无码专区在线播放| 成年女人免费视频播放体验区| 亚洲最大av资源站无码av网址| 免费精品人在线二线三线区别| 亚洲国产精品无码久久| 无码国模国产在线观看免费| 国产青草亚洲香蕉精品久久 | 精品久久久久久久免费人妻 | 国产无遮挡吃胸膜奶免费看视频| 亚洲色大成网站www久久九| 国产中文字幕免费观看| 久久av免费天堂小草播放| 久久精品国产亚洲AV网站| 亚洲日本va中文字幕久久| a级毛片免费完整视频| 亚洲色欲www综合网| 麻豆最新国产剧情AV原创免费 | 成人av免费电影| 色多多免费视频观看区一区| 伊伊人成亚洲综合人网7777| 午夜精品一区二区三区免费视频| 亚洲成综合人影院在院播放| 国内一级一级毛片a免费| 国产精品青草视频免费播放| 亚洲高清日韩精品第一区| 免费无码又爽又高潮视频| 国产久爱免费精品视频 | 伊人久久亚洲综合影院| 亚洲日韩在线视频| 国产午夜免费秋霞影院| 一个人免费视频观看在线www| 亚洲影视自拍揄拍愉拍| 亚洲黄片手机免费观看|