http://www.jexp.ru/index.php?action=history&feed=atom&title=Java%2FJSTL%2FDatabase
Java/JSTL/Database - История изменений
2026-04-24T12:01:01Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.jexp.ru/index.php?title=Java/JSTL/Database&diff=6693&oldid=prev
Admin: 1 версия
2010-06-01T06:17:18Z
<p>1 версия</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 06:17, 1 июня 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
Admin
http://www.jexp.ru/index.php?title=Java/JSTL/Database&diff=6692&oldid=prev
в 18:01, 31 мая 2010
2010-05-31T18:01:44Z
<p></p>
<p><b>Новая страница</b></p><div>== JSTL SQL Query ==<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<br />
<%@ taglib uri="http://java.sun.ru/jstl/core" prefix="c" %><br />
<%@ taglib uri="http://java.sun.ru/jstl/sql" prefix="sql" %><br />
<sql:setDataSource var="dataSource" driver="org.gjt.mm.mysql.Driver"<br />
url="jdbc:mysql://localhost/forum?user=forumuser"<br />
scope="session" /><br />
<html><br />
<head><br />
<title>Query Example</title><br />
</head><br />
<body><br />
<sql:query var = "users" dataSource="${dataSource}"><br />
select column_uid,column_pwd,column_accesses,column_first,column_last,column_bad,column_posted,column_type from t_users<br />
</sql:query><br />
<table border=1><br />
<c:forEach var="row" items="${users.rows}"><br />
<tr><br />
<td><c:out value="${row.column_uid}"/></td><br />
<td><c:out value="${row.column_pwd}"/></td><br />
<td><c:out value="${row.column_accesses}"/></td><br />
<td><c:out value="${row.column_first}"/></td><br />
<td><c:out value="${row.column_last}"/></td><br />
<td><c:out value="${row.column_bad}"/></td><br />
<td><c:out value="${row.column_posted}"/></td><br />
<td><c:out value="${row.column_type}"/></td><br />
</tr><br />
</c:forEach><br />
</table><br />
<br />
</body><br />
</html><br />
<br />
<br />
</source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
<br />
== JSTL SQL Update ==<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<%@ taglib uri="http://java.sun.ru/jstl/core" prefix="c" %><br />
<%@ taglib uri="http://java.sun.ru/jstl/core-rt" prefix="c-rt" %><br />
<%@ taglib uri="http://java.sun.ru/jstl/sql" prefix="sql" %><br />
<sql:setDataSource var="dataSource" driver="org.gjt.mm.mysql.Driver"<br />
url="jdbc:mysql://localhost/forum?user=forumuser"<br />
scope="session" /><br />
<html><br />
<head><br />
<title>General Query</title><br />
</head><br />
<body><br />
<c:choose><br />
<c:when test="${param.cmd!=null}"><br />
<c:set var="str" value="${param.cmd}" /><br />
</c:when><br />
<c:otherwise><br />
<c:set var="str"<br />
value="select * from tableName" /><br />
</c:otherwise><br />
</c:choose><br />
Please enter a query:<br />
<br /><br />
<form method="post"><br />
<textarea name="cmd" cols="40" rows="5"><br />
<c:out value="${str}" /><br />
</textarea><br />
<br /><br />
<input type="submit" /><br />
</form><br />
<c:if test="${pageContext.request.method=="POST"}"><br />
<c:catch var="e"><br />
<sql:query var="users" dataSource="${dataSource}"<br />
sql="${param.cmd}" /><br />
<table border="1"><br />
<c:forEach var="row" items="${users.rows}"<br />
varStatus="status"><br />
<jsp:useBean id="status"<br />
type="javax.servlet.jsp.jstl.core.LoopTagStatus" /><br />
<c-rt:if test="<%=status.getCount()==1%>"><br />
<tr><br />
<c:forEach var="col" items="${row}"><br />
<th><br />
<c:out value="${col.key}" /><br />
</th><br />
</c:forEach><br />
</tr><br />
</c-rt:if><br />
<tr><br />
<c:forEach var="col" items="${row}"><br />
<td><br />
<c:out value="${col.value}" /><br />
</td><br />
</c:forEach><br />
</tr><br />
</c:forEach><br />
</table><br />
</c:catch><br />
<c:if test="${e!=null}"><br />
<h3>Error</h3><br />
<c:out value="${e}" /><br />
</c:if><br />
</c:if><br />
</body><br />
</html><br />
<br />
<br />
</source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
<br />
== JSTL: Transaction with a JSP ==<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<%@ taglib uri="http://java.sun.ru/jstl/core" prefix="c" %><br />
<%@ taglib uri="http://java.sun.ru/jstl/sql" prefix="sql" %><br />
<html><br />
<HEAD><br />
<TITLE>Using a Transaction with a JSP</TITLE><br />
</HEAD><br />
<body bgcolor="white"><br />
<h2>View table Data</h2><br />
<br />
<sql:transaction> <br />
<br />
<sql:update><br />
insert into atable values(2, "Joe","Id","Feb-24-1996","F")<br />
</sql:update><br />
<br />
<sql:query var="resultObj"><br />
select * from atable<br />
</sql:query><br />
</sql:transaction> <br />
<table><br />
<c:forEach items="${resultObj.rows}" var="row"><br />
<c:forEach items="${row}" var="column"><br />
<tr><br />
<td align="right"><br />
<b><c:out value="${column.key}" /></b><br />
</td><br />
<td><br />
<c:out value="${column.value}" /><br />
</td></tr><br />
</c:forEach><br />
</c:forEach><br />
</table><br />
</body><br />
</html><br />
<br />
<br />
</source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
== Presenting database content using tags ==<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<br />
//web.xml<br />
<?xml version="1.0" encoding="UTF-8"?><br />
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"<br />
"http://java.sun.ru/dtd/web-app_2_3.dtd"><br />
<web-app><br />
<resource-ref><br />
<res-ref-name>jdbc/address</res-ref-name><br />
<res-type>javax.sql.DataSource</res-type><br />
<res-auth>Container</res-auth><br />
</resource-ref><br />
</web-app><br />
<br />
<br />
<%@ taglib prefix="sql" uri="http://java.sun.ru/jstl/sql" %><br />
<%@ taglib prefix="c" uri="http://java.sun.ru/jstl/core" %><br />
<html><br />
<head><br />
<title>Presenting database content using tags</title><br />
<sql:setDataSource<br />
dataSource="jdbc/address"<br />
var="conn"<br />
/><br />
</head><br />
<body><br />
<h1>Address List</h1><br />
<sql:query dataSource="${conn}" var="addresses"><br />
SELECT * FROM AddressList<br />
</sql:query><br />
<table width="90%" border="1"><br />
<tr><br />
<!-- add the table column headings --><br />
<c:forEach var="columnName" items="${addresses.columnNames}"><br />
<th> <c:out value="${columnName}"/> </th><br />
</c:forEach><br />
</tr><br />
<!-- add the table rows from the result set --><br />
<c:forEach var="row" items="${addresses.rowsByIndex}"><br />
<tr><br />
<c:forEach var="column" items="${row}"><br />
<td><c:out value="${column}"/></td><br />
</c:forEach><br />
</tr><br />
</c:forEach><br />
</table><br />
</body><br />
</html><br />
<br />
<br />
</source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
== SQL Tag Out Examples ==<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<%@ taglib uri="http://java.sun.ru/jstl/core" prefix="c" %><br />
<%@ taglib uri="http://java.sun.ru/jstl/sql" prefix="sql" %><br />
<sql:setDataSource var="dataSource" driver="sun.jdbc.odbc.JdbcOdbcDriver" url="jdbc:odbc:forum"/><br />
<html><br />
<head><br />
<title>SQL Tag Out Examples</title><br />
</head><br />
<body><br />
<sql:query var = "users" dataSource="${dataSource}"><br />
select column_uid,column_pwd,column_accesses,column_first,column_last,column_bad,column_posted,column_type from t_users<br />
</sql:query><br />
<table border=1><br />
<c:forEach var="row" items="${users.rows}"><br />
<tr><br />
<td><c:out value="${row.column_uid}"/></td><br />
<td><c:out value="${row.column_pwd}"/></td><br />
<td><c:out value="${row.column_accesses}"/></td><br />
<td><c:out value="${row.column_first}"/></td><br />
<td><c:out value="${row.column_last}"/></td><br />
<td><c:out value="${row.column_bad}"/></td><br />
<td><c:out value="${row.column_posted}"/></td><br />
<td><c:out value="${row.column_type}"/></td><br />
</tr><br />
</c:forEach><br />
</table><br />
<br />
</body><br />
</html><br />
<br />
<br />
</source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
<br />
== Updating a database using the sql:update tag ==<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<br />
//web.xml<br />
<?xml version="1.0" encoding="UTF-8"?><br />
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"<br />
"http://java.sun.ru/dtd/web-app_2_3.dtd"><br />
<web-app><br />
<resource-ref><br />
<res-ref-name>jdbc/address</res-ref-name><br />
<res-type>javax.sql.DataSource</res-type><br />
<res-auth>Container</res-auth><br />
</resource-ref><br />
</web-app><br />
<br />
<%@ taglib prefix="sql" uri="http://java.sun.ru/jstl/sql" %><br />
<%@ taglib prefix="c" uri="http://java.sun.ru/jstl/core" %><br />
<html><br />
<head><br />
<title>Updating a database using the sql:update tag</title><br />
<sql:setDataSource<br />
var="conn"<br />
dataSource="jdbc/address"<br />
/><br />
</head><br />
<body><br />
<h1>Modify Address List</h1><br />
<sql:update dataSource="${conn}" var="addresses"><br />
INSERT INTO AddressList (name, street, city, country, telephone) VALUES (?, ?, ?, ?, ?)<br />
<sql:param value="${param["name"]}"/><br />
<sql:param value="${param["street"]}"/><br />
<sql:param value="${param["city"]}"/><br />
<sql:param value="${param["country"]}"/><br />
<sql:param value="${param["tel"]}"/><br />
</sql:update><br />
</body><br />
</html><br />
<br />
<br />
</source><br />
<br />
<br />
<!-- end source code --></div>