第4章 JavaBean在JSP程序中的应用【首页】杜老师

JavaBean知识点备忘录

1. JavaBean定义、使用、移除

1.1 定义JavaBean

创建项目01JavaWeb04, 01学号 java EE 5.0, src下创建包com.duzhaojiang.bean，包下创建Teacher01.java

1.2 调用JavaBean

创建页面WebRoot\UseBeanDemo01.jsp, gb2312 -- gbk

1.3 创建[添加教师信息]、[显示教师信息]页面

[添加教师信息]页面TeacherForm01.jsp gb2312 -- gbk

[显示教师信息]页面AddTeacher01.jsp gb2312 -- gbk

1.4 创建移除JavaBean演示页面

创建[移除JavaBean演示页面]RemoveJavaBean01.jsp gb2312 -- gbk

<%@page language="java" pageEncoding="gbk"%>
<%@page import="com.duzhaojiang.bean.Teacher01"%>
<html>
<head>
	<title>移除JavaBean演示</title>  
</head>
<body>
	<jsp:useBean id="page_Teacher" scope="page" class="Teacher01" />
	<jsp:useBean id="request_Teacher" scope="request" class="Teacher01" />
	<jsp:useBean id="session_Teacher" scope="session" class="Teacher01" />
	<jsp:useBean id="application_Teacher" scope="application" 
		class="com.duzhaojiang.bean.Teacher01" />

<h3>JavaBean实例对象能访问，移除前</h3>
	page范围：${!empty page_Teacher}<br>
	request范围：${!empty request_Teacher}<br>
	session范围：${!empty session_Teacher}<br>
	application范围：${!empty application_Teacher}
	<%
		pageContext.removeAttribute("page_Teacher");   //移除page范围实例对象
		request.removeAttribute("request_Teacher");   //移除request范围实例对象
		session.removeAttribute("session_Teacher");   //移除session范围实例对象
		application.removeAttribute("application_Teacher"); //移除application范围实例对象
	%>
	<h3>JavaBean实例对象能访问，移除后</h3>
	page范围：${!empty page_Teacher}<br>
	request范围：${!empty request_Teacher}<br>
	session范围：${!empty session_Teacher}<br>
	application范围：${!empty application_Teacher}
</body>
</html>

1.5 创建【首页】、修改配置文件

创建【首页】WebRoot\index.jsp并测试

<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE html>
<html>
<head>
	<base href="<%=basePath%>">
	<title>第4章 JavaBean在JSP程序中的应用(杜老师)</title>
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">	
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	
</head>
<body>
	<h1>第4章 JavaBean在JSP程序中的应用(杜老师)</h1>
	<hr/>
	<span >1. JavaBean定义、使用、移除(教师)</span><br/>
	<span>  1.1 定义JavaBean(教师: Teacher01.java)</span><br>
	<a href="UseBeanDemo01.jsp">  1.2 调用JavaBean(教师)</a><br>
	<a href="TeacherForm01.jsp">  1.3 获取JavaBean属性(教师)</a><br>
	<a href="RemoveJavaBean01.jsp">  1.4 移除JavaBean</a><br>
	<a href="ShowCommodityList01.jsp">2. 用JSP+JavaBean开发购物车模块</a><br>
	<a href="ShowStudentList01.jsp">3. 学生信息管理(上机题：学生增删改查)</a><br>
	<hr/>
	<a href="/html/01JavaWeb.html">返回</a><br>
</body>
</html>

修改配置文件WebRoot\WEB-INF\web\xml, 部署并调试

2. 用JSP+JavaBean开发购物车模块

2.1 创建商品JavaBean、数据库表和数据库连接公用模块

在com.duzhaojiang.bean包，创建Commodity01.java

在MySql中，创建Commodity数据表：commodity01.sql

创建com.duzhaojiang.util包，并在包下创建数据库连接公用模块：DBConnection.java

package com.duzhaojiang.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DBConnection {
	private static final String DBDRIVER = "com.mysql.jdbc.Driver" ;			//驱动类类名
	private static final String DBURL = "jdbc:mysql://localhost:3306/javaweb04";	//连接URL
	private static final String DBUSER = "root" ;								//数据库用户名
	private static final String DBPASSWORD = "6337925";							//数据库密码

public static Connection getConnection(){
		Connection conn = null;													//声明一个连接对象
		try {
			Class.forName(DBDRIVER);											//注册驱动
			conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);		//获得连接对象
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}

public static void close(Connection conn) {
		if(conn != null) {				//如果conn连接对象不为空
			try {
				conn.close();			//关闭conn连接对象对象
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	public static void close(PreparedStatement pstmt) {
		if(pstmt != null) {				//如果pstmt预处理对象不为空
			try {
				pstmt.close();			//关闭pstmt预处理对象
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	public static void close(ResultSet rs) {
		if(rs != null) {				//如果rs结果集对象不为null
			try {
				rs.close();				//关闭rs结果集对象
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}

2.2 创建数据库操作接口、工厂类、实现

创建com.duzhaojiang.dao包，并在包下创建工厂类：CommodityDAO01.java

创建com.duzhaojiang.factory包，并在包下创建工厂类：CommodityDAOFactory01.java

创建com.duzhaojiang.impl包，并在包下创建实现上述接口的操作类：CommodityDAOImpl01.java

package com.duzhaojiang.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.duzhaojiang.bean.Commodity01;
import com.duzhaojiang.dao.CommodityDAO01;
import com.duzhaojiang.util.DBConnection;

public class CommodityDAOImpl implements CommodityDAO01 {
	//实现添加商品的方法
	public void addCommodity(Commodity01 commodity) {
		Connection conn = DBConnection.getConnection();	//获得连接对象
		String addSQL = "insert into commodity" +
				"(commodityName,price,agio) values(?,?,?)";
		PreparedStatement pstmt = null;					//声明预处理对象
		try {
			pstmt = conn.prepareStatement(addSQL);		//获得预处理对象并赋值
			pstmt.setString(1, commodity.getCommodityName());	//设置第一个参数
			pstmt.setDouble(2, commodity.getPrice());			//设置第二个参数
			pstmt.setDouble(3, commodity.getAgio());			//设置第三个参数
			pstmt.executeUpdate();								//执行更新
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			DBConnection.close(pstmt);							//关闭预处理对象
			DBConnection.close(conn);							//关闭连接对象
		}
	}
	
	//实现删除商品的方法
	public void deleteCommodity(int commodityId) {
		Connection conn = DBConnection.getConnection();	//获得连接对象
		String updateSQL = "delete from commodity where commodityId=?";
		PreparedStatement pstmt = null;					//声明预处理对象
		try {
			pstmt = conn.prepareStatement(updateSQL);		//获得预处理对象并赋值
			pstmt.setInt(1, commodityId);			//设置第一个个参数
			pstmt.executeUpdate();								//执行更新
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			DBConnection.close(pstmt);							//关闭预处理对象
			DBConnection.close(conn);							//关闭连接对象
		}
	}
	
	//实现查询商品的方法
	public List<Commodity01> findAllCommodity() {
		Connection conn = DBConnection.getConnection();	//获得连接对象
		String updateSQL = "select * from commodity";
		PreparedStatement pstmt = null;					//声明预处理对象
		
		List<Commodity01> commodityList = new ArrayList<Commodity01>();
		
		updateSQL = "select * from commodity";
		try {
			pstmt = conn.prepareStatement(updateSQL);		//获得预处理对象并赋值
			ResultSet rs = pstmt.executeQuery();			//执行查询
			while(rs.next()) {
				Commodity01 commodity = new Commodity01();		//实例化
				commodity.setCommodityId(rs.getInt(1)); 	//获得商品ID
				commodity.setCommodityName(rs.getString(2));//获得商品名称
				commodity.setPrice(rs.getDouble(3)); 		//获得商品价格
				commodity.setAgio(rs.getDouble(4));			//获得商品折扣
				commodityList.add(commodity);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			DBConnection.close(pstmt);							//关闭预处理对象
			DBConnection.close(conn);							//关闭连接对象
		}
		return commodityList;									//返回查询到的所有商品
	}
	
	//实现更新商品的方法
	public void updateCommodity(Commodity01 commodity) {
		Connection conn = DBConnection.getConnection();	//获得连接对象
		String updateSQL = "update commodity set commodityName=?," +
		"price=?,agio=? where commodityId=?";
		PreparedStatement pstmt = null;					//声明预处理对象
		try {
			pstmt = conn.prepareStatement(updateSQL);		//获得预处理对象并赋值
			pstmt.setString(1, commodity.getCommodityName());	//设置第一个参数
			pstmt.setDouble(2, commodity.getPrice());			//设置第二个参数
			pstmt.setDouble(3, commodity.getAgio());			//设置第三个参数
			pstmt.setInt(4, commodity.getCommodityId());			//设置第四个参数
			pstmt.executeUpdate();								//执行更新
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			DBConnection.close(pstmt);							//关闭预处理对象
			DBConnection.close(conn);							//关闭连接对象
		}
	}
	
	public Commodity01 findCommodityById(int commodityId) {
		Connection conn = DBConnection.getConnection();	//获得连接对象
		String updateSQL = "select * from commodity where commodityId = ?";
		PreparedStatement pstmt = null;					//声明预处理对象
		Commodity01 commodity = new Commodity01();
		try {
			pstmt = conn.prepareStatement(updateSQL);		//获得预处理对象并赋值
			pstmt.setInt(1, commodityId);	//设置参数
			ResultSet rs = pstmt.executeQuery();			//执行查询
			if(rs.next()) {
				commodity.setCommodityId(rs.getInt(1)); 	//获得商品ID
				commodity.setCommodityName(rs.getString(2));//获得商品名称
				commodity.setPrice(rs.getDouble(3)); 		//获得商品价格
				commodity.setAgio(rs.getDouble(4));			//获得商品折扣
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			DBConnection.close(pstmt);							//关闭预处理对象
			DBConnection.close(conn);							//关闭连接对象
		}
		return commodity;
	}
}

2.3 创建jsp页面

创建[添加商品信息]页面：WebRoot\AddToCart01.jsp

<%@page language="java" pageEncoding="gbk" import="java.util.*"%>
<%@page import="com.duzhaojiang.bean.Commodity01"%>
<%@page import="com.duzhaojiang.dao.CommodityDAO01"%>
<%@page import="com.duzhaojiang.factory.CommodityDAOFactory01"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib	prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<html>
<head>
	<title>购物车列表</title>	
</head>
<body>
	<%
		if(request.getParameter("commodityId") != null) {	//如果commodityId参数为空
			List<Commodity01> cart = null;					//声明一个购物车					
			if(session.getAttribute("cart") == null) {		//如果session中不存在购物车
				cart = new ArrayList<Commodity01>();		//新建一个ArrayList实例
			}else {
				cart = (List<Commodity01>)session.getAttribute("cart");//从session中得到购物车
			}
			//通过DAO工厂类获得DAO实例
			CommodityDAO01 commodityDAO = CommodityDAOFactory01.getCommodityDAOInstance();
			//获得commodityId参数，并进行类型转换
			int commodityId = Integer.parseInt(request.getParameter("commodityId"));
			cart.add(commodityDAO.findCommodityById(commodityId));//将商品添加到购物车中
			session.setAttribute("cart",cart);//将购物车保存在session中
		}
		if(request.getParameter("listId") != null) {	//判断listId是否为空
			//取得session中购物车
			List<Commodity01> cart = (List<Commodity01>)session.getAttribute("cart");
			int listId = Integer.parseInt(request.getParameter("listId"));
			cart.remove(listId);//移除listId对应的商品信息
			session.setAttribute("cart",cart);//将重新购物车保存到session中
		}
	%>
	你已经购买了如下商品:
	<table width="500" border="1">
		<tr>
			<td>商品ID</td>
			<td>商品名称</td>
			<td>商品价格</td>
			<td>删除</td>
		</tr>
		<%-- 输出购物车中商品信息 --%>	
		<c:forEach var="commodity" items="${sessionScope.cart}" varStatus="stat">
			<tr>
				<td>${commodity.commodityId }</td>
				<td>${commodity.commodityName }</td>
				<td><fmt:formatNumber type="currency" value="${commodity.price * commodity.agio}"/></td>
				<td><a href="AddToCart01.jsp?listId=${stat.index}">删除</a></td>
			</tr>
		</c:forEach>
		<tr><td><a href="ShowCommodityList01.jsp"><<继续购物</a></td></tr>
	</table>
</body>
</html>

创建[显示商品信息]页面：WebRoot\ShowCommodityList01.jsp，复制数据库驱动程序mysql-connector-java-5.1.6-bin.jar到WEB-INF\lib，部署项目并调试

<%@page language="java" pageEncoding="gbk" import="java.util.List"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<%@page import="com.duzhaojiang.bean.Commodity01"%>
<%@page import="com.duzhaojiang.dao.CommodityDAO01"%>
<%@page import="com.duzhaojiang.factory.CommodityDAOFactory01"%>
<html>
  <head>
    <title>商品列表</title>
  </head>
  <body>
    <%
    	//通过DAO工厂类获得DAO实现类实例
    	CommodityDAO01 commodityDAO = CommodityDAOFactory01
    			.getCommodityDAOInstance();
    	//查找所有商品记录  
    	List<Commodity01> commodityList = commodityDAO.findAllCommodity();
    	//将所有记录保存到page范围  
    	pageContext.setAttribute("commodityList", commodityList);
    %>
    <table width="700" border="1">
      <tr>
        <td>商品ID</td>
        <td>商品名称</td>
        <td>商品价格</td>
        <td>商品折扣</td>
        <td>优惠价格</td>
        <td>购买</td>
      </tr>
      <c:forEach var="commodity" items="${pageScope.commodityList}">
        <%-- 循环输出商品信息 --%>
        <tr>
          <td>${commodity.commodityId}</td>
          <td>${commodity.commodityName}</td>
          <td><fmt:formatNumber type="currency" value="${commodity.price}" /></td>
          <td>${commodity.agio}</td>
          <td><fmt:formatNumber type="currency"value="${commodity.price * commodity.agio}" /></td>
          <td><a href="AddToCart01.jsp?commodityId=${commodity.commodityId }">购买</a></td>
        </tr>
      </c:forEach>
      <tr>
        <td><a href="AddToCart01.jsp">查看购物车>></a></td>
      </tr>
    </table>
    <hr />
    <a href="/01JavaWeb04">返回本章目录</a>
  </body>
</html>

3. 学生信息管理(上机题：学生增删改查)

3.1 创建学生JavaBean、数据库表和数据库连接公用模块

在com.duzhaojiang.bean包，创建Student01.java

在MySql中，创建student数据表：student01.sql

3.2 创建数据库操作接口、工厂类、实现

创建com.duzhaojiang.dao包，并在包下创建工厂类：StudentDAO01.java

创建com.duzhaojiang.factory包，并在包下创建工厂类：StudenDAOFactory01.java

创建com.duzhaojiang.dao.impl包，并在包下创建实现上述接口的操作类：StudenDAOImpl01.java

package com.duzhaojiang.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.duzhaojiang.bean.Student01;
import com.duzhaojiang.dao.StudentDAO01;
import com.duzhaojiang.util.DBConnection;

public class StudentDAOImpl01 implements StudentDAO01 {
	//实现添加学生的方法
	public void addStudent(Student01 student) {
		Connection conn = DBConnection.getConnection();	//获得连接对象
		String addSQL = "insert into student(stuNO,stuName,age,sex) values(?,?,?,?)";
		PreparedStatement pstmt = null;					//声明预处理对象
		try {
			pstmt = conn.prepareStatement(addSQL);		//获得预处理对象并赋值
			pstmt.setString(1, student.getStuNO());		//设置第一个参数
			pstmt.setString(2, student.getStuName());	//设置第二个参数
			pstmt.setInt(3, student.getAge());			//设置第三个参数
			pstmt.setString(4, student.getSex());	//设置第四个参数
			pstmt.executeUpdate();								//执行更新
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			DBConnection.close(pstmt);							//关闭预处理对象
			DBConnection.close(conn);							//关闭连接对象
		}
	}
	
	//实现更新学生的方法
	public void updateStudent(Student01 student) {
		Connection conn = DBConnection.getConnection();	//获得连接对象
		String updateSQL = "update student set stuName = ?,age = ?,sex = ? where stuNo = ?";
		PreparedStatement pstmt = null;					//声明预处理对象
		try {
			pstmt = conn.prepareStatement(updateSQL);	//获得预处理对象并赋值
			pstmt.setString(1, student.getStuName());	//设置第一个参数
			pstmt.setInt(2, student.getAge());			//设置第二个参数
			pstmt.setString(3, student.getSex());		//设置第三个参数
			pstmt.setString(4, student.getStuNO());		//设置第四个参数
			pstmt.executeUpdate();						//执行更新
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			DBConnection.close(pstmt);						//关闭预处理对象
			DBConnection.close(conn);						//关闭连接对象
		}
	}
	
	//实现删除学生的方法
	public void deleteStudent(String stuNO) {
		Connection conn = DBConnection.getConnection();	//获得连接对象
		String deleteSQL = "delete from student where stuNO=?";
		PreparedStatement pstmt = null;					//声明预处理对象
		try {
			pstmt = conn.prepareStatement(deleteSQL);	//获得预处理对象并赋值
			pstmt.setString(1, stuNO);					//设置第一个个参数
			pstmt.executeUpdate();						//执行更新
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			DBConnection.close(pstmt);					//关闭预处理对象
			DBConnection.close(conn);					//关闭连接对象
		}
	}
	
	//实现查询学生的方法
	public List<Student01> findAllStudent() {
		Connection conn = DBConnection.getConnection();	//获得连接对象
		String selectSQL = "select * from student";
		PreparedStatement pstmt = null;					//声明预处理对象
		List<Student01> studentList = new  ArrayList<Student01>();
		try {
			pstmt = conn.prepareStatement(selectSQL);	//获得预处理对象并赋值
			ResultSet rs = pstmt.executeQuery();		//执行查询
			while(rs.next()) {
				Student01 student = new Student01();		//实例化
				student.setStuNO(rs.getString(1));
				student.setStuName(rs.getString(2));
				student.setAge(rs.getInt(3));
				student.setSex(rs.getString(4));
				studentList.add(student);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			DBConnection.close(pstmt);						//关闭预处理对象
			DBConnection.close(conn);						//关闭连接对象
		}
		return studentList;									//返回查询到的所有学生
	}
	
	public Student01 findStudentByNo(String stuNO) {
		Connection conn = DBConnection.getConnection();	//获得连接对象
		String selectSQL = "select * from student where stuNO = ?";
		PreparedStatement pstmt = null;					//声明预处理对象
		Student01 student = new Student01();				//实例化
		try {
			pstmt = conn.prepareStatement(selectSQL);	//获得预处理对象并赋值
			pstmt.setString(1, stuNO);					//设置参数
			ResultSet rs = pstmt.executeQuery();		//执行查询
			if(rs.next()) {
				student.setStuNO(rs.getString(1));
				student.setStuName(rs.getString(2));
				student.setAge(rs.getInt(3));
				student.setSex(rs.getString(4));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			DBConnection.close(pstmt);							//关闭预处理对象
			DBConnection.close(conn);							//关闭连接对象
		}
		return student;
	}
}

3.3 创建jsp页面

创建[添加学生信息]页面：WebRoot\StudentForm01.jsp

创建[添加学生信息]后台处理页面：WebRoot\AddStudent01.jsp

创建[修改学生信息]页面：WebRoot\StudentUpdateForm01.jsp

<%@page language="java" pageEncoding="gbk"%>
<!DOCTYPE html >
<html>
<head>
	<title>更新学生信息</title>
</head>
<body>
	<form action="UpdateStudent01.jsp" method="post">
		<table>
			<tr>
				<td>学生学号：</td>
				<td><input type="text" name="stuNO" value="${param.stuNO}" readonly="readonly"/></td>
			</tr>
			<tr>
				<td>学生姓名：</td>
				<td><input type="text" name="stuName" value="${param.stuName}"/></td>
			</tr>
			<tr>
				<td>学生年龄：</td>
				<td><input type="text" name="age" value="${param.age}"/></td>
			</tr>
			<tr>
				<td>学生性别：</td>
				<td>
					<%
					String str=request.getParameter("sex"); 
					if( str.equals("男")){%>
						<input type="radio" name="sex" value="男" checked="checked"/>男
						<input type="radio" name="sex" value="女"/>女
					<%}else{ %>
						<input type="radio" name="sex" value="男"/>男
						<input type="radio" name="sex" value="女" checked="checked"/>女
					<%} %>
				</td>
			</tr>
			<tr>
				<td><input type="submit" value="更新"></td>
				<td><input type="reset" value="重置"></td>
			</tr>
		</table>
	</form>
</body>
</html>

创建[修改学生信息]后台处理页面：WebRoot\UpdateStudent01.jsp

创建[删除学生信息]后台处理页面：WebRoot\DeleteStudent01.jsp

创建[显示学生信息]页面：WebRoot\ShowStudentList01.jsp

<%@page language="java" pageEncoding="gbk"%>
<%@page import="java.util.List"%>
<%@page import="com.duzhaojiang.dao.StudentDAO01"%>
<%@page import="com.duzhaojiang.factory.StudentDAOFactory01"%>
<%@page import="com.duzhaojiang.bean.Student01"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<html>
<head>
	<title>学生列表</title>  
</head>
<body>
	<%
		//通过DAO工厂类获得DAO实现类实例
		StudentDAO01 studentDAO = StudentDAOFactory01.getStudentDAOInstance();
		//查找所有学生记录  
		List<Student01> studentList = studentDAO.findAllStudent();
		//将所有记录保存到page范围  
		pageContext.setAttribute("studentList",studentList);
	%>
	<h1>学生列表(杜兆将老师整理)</h1>
	<hr />
	<table width="700" border="1">
		<tr>
			<td>学生学号</td>
			<td>学生姓名</td>
			<td>学生年龄</td>
			<td>学生性别</td>
			<td>删除</td>
			<td>更新</td>
		</tr>
		<c:forEach var="student" items="${pageScope.studentList}"><%-- 循环输出学生信息 --%>
			<tr>
				<td>${student.stuNO }</td>
				<td>${student.stuName }</td>
				<td>${student.age }</td>
				<td>${student.sex }</td>
				<td><a href="DeleteStudent01.jsp?stuNO=${student.stuNO }">删除</a></td>
				<td><a href="StudentUpdateForm01.jsp?stuNO=${student.stuNO}&stuName=${student.stuName}&age=${student.age}&sex=${student.sex}">更新</a></td>
			</tr>
		</c:forEach>
		<tr><td colspan="6" align="right"><a href="StudentForm01.jsp">新增学生</a></td></tr>
	</table>
	<hr/>
	<a href="/01JavaWeb04">返回本章目录</a>
</body>
</html>

返回章节目录