》》取出放进了request的key里list,list含有对象
原:
<%@page import="com.yiki.dbutil.*"%>
<%@ page language="java" import="java.util.*,java.sql.*"
pageEncoding="gb2312"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<body>
<table align="center" border="1">
<tr>
<td>id</td>
<td>name</td>
<td>age</td>
</tr>
<%
String name = null;
int id = 0;
int age = 0;
List<Student> list=(List<Student>)request.getAttribute("list");
for (int i = 0; i < list.size(); i++) {
Student s = (Student) list.get(i);
name = s.getName();
id = s.getId();
age = s.getAge();
%>
<tr>
<td><%=id%></td>
<td><%=name%></td>
<td><%=age %></td>
</tr>
<%
}
%>
</table>
一共<%=request.getAttribute("count")%>条记录
<a href="../index.jsp">返回</a>
</body>
</html>
运用EL和JSTL标签后
<%@page import="com.yiki.dbutil.*"%>
<%@ page language="java" import="java.util.*,java.sql.*"
pageEncoding="gb2312"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<body>
<table align="center" border="1">
<tr>
<td>id</td>
<td>name</td>
<td>age</td>
<td>更新</td>
<td>删除</td>
</tr>
<c:forEach var="student" items="${requestScope.list}">
<tr>
<td>${student.id}</td>
<td>${student.name}</td>
<td>${student.age}</td>
<td>
<a href="loginServlet?action=update&success=yes&id=${student.id}&name=${student.name}&age=${student.age}">更新</a></td>
<td><a href="loginServlet?action=delete&success=yes&id=${student.id}">删除</a></td>
</tr>
</c:forEach>
</table>
<center>
一共${requestScope.count}条记录
<a href="loginServlet?action=back&success=yes">返回</a>
</center>
</body>
</html>
》》取出放在request的key里的对象
原
<%@page import="com.yiki.dbutil.*"%>
<%@ page language="java" import="java.util.*,java.sql.*"
pageEncoding="gb2312"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<body>
<h1>查询成功</h1>
<table align="center" border="1">
<tr>
<td>id</td>
<td>name</td>
<td>age</td>
</tr>
<%
Student s = (Student)request.getAttribute("quer");
String name = s.getName();
int ids = s.getId();
int age = s.getAge();
%>
<tr>
<td><%=ids%></td>
<td><%=name%></td>
<td><%=age%></td>
</tr>
</table>
<a href="../index.jsp">返回</a>
</body>
</html>
修改后
<%@page import="com.yiki.dbutil.*"%>
<%@ page language="java" import="java.util.*,java.sql.*"
pageEncoding="gb2312"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<body>
<center>
<h1>查询成功</h1>
<table align="center" border="1">
<tr>
<td>id</td>
<td>name</td>
<td>age</td>
</tr>
<tr>
<td>${requestScope.quer["id"]}</td>
<td>${requestScope.quer["name"]}</td>
<td>${requestScope.quer["age"]}</td>
</tr>
</table>
<a href="loginServlet?action=back&success=yes">返回</a>
</center>
</body>
</html>