所用到的jar包和类:
一、 主界面
代码如下:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<style type="text/css">
table,tr{
border-collapse: collapse;
}
td{
text-align: center;
}
</style>
</head>
<body>
<h2 align="center"><a href="Add.jsp">新增</a></h2>
<table border="" width="1000px" height="400px" align="center">
<tr>
<td colspan="6">
<form action="key.do">
教员:
<select name="jy">
<option value="null">--请选择教员--</option>
<c:forEach var="y" items="${ list2 }">
<option value="${ y.yname }" ${ y.yname==jy?"selected":"" }>${y.yname }</option>
</c:forEach>
</select>
班级:
<select name="bj">
<option value="null">--请选择班级--</option>
<c:forEach var="b" items="${ list1 }">
<option value="${ b.bname }" ${ b.bname==bj?"selected":"" }>${b.bname }</option>
</c:forEach>
</select>
爱好:
<input type="checkbox" name="sah" value="乒乓球" <c:forEach var="i" items="${ ah }">
<c:if test="${ i=='乒乓球' }"> checked
</c:if>
</c:forEach>>乒乓球
<input type="checkbox" name="sah" value="足球" <c:forEach var="i" items="${ ah }">
<c:if test="${ i=='足球' }"> checked
</c:if>
</c:forEach>>足球
<input type="checkbox" name="sah" value="篮球" <c:forEach var="i" items="${ ah }">
<c:if test="${ i=='篮球' }"> checked
</c:if>
</c:forEach>>篮球
<input type="checkbox" name="sah" value="排球" <c:forEach var="i" items="${ ah }">
<c:if test="${ i=='排球' }"> checked
</c:if>
</c:forEach>>排球
<button>查询</button>
</form>
</td>
</tr>
<tr>
<td>学生的id</td>
<td>学生姓名</td>
<td>学生的教员</td>
<td>学生的班级</td>
<td>学生爱好</td>
<td>操作</td>
</tr>
<c:forEach var="i" items="${list }">
<tr>
<td>${i.sid }</td>
<td>${i.sname }</td>
<td>${i.yname }</td>
<td>${i.bname }</td>
<td>${i.sah }</td>
<td><a href="get.do?sid=${i.sid }">修改</a>
<a onclick="return confirm(' 确认是否删除!!! ')" href="del.do?sid=${i.sid }">删除</a></td>
</tr>
</c:forEach>
</table>
</body>
</html>
查询:
根据教员、班级、爱好进行模糊查询;
删除:
根据id删除
二、增加界面
学生ID有标识列,会自增长
代码如下:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<style type="text/css">
table,tr{
border-collapse: collapse;
}
td{
text-align: center;
}
</style>
</head>
<body>
<h3 align="center">新增页面</h3>
<form action="add.do">
<table border="" width="500px" height="400px" align="center">
<tr>
<td>名字 </td>
<td><input type="text" name="sname"></td>
</tr>
<tr>
<td>教员:</td>
<td>
<select name="yname">
<option value="null">--请选择教员--</option>
<option value="老吴">老吴</option>
<option value="小李">老李</option>
<option value="老胡">老胡</option>
<option value="老胡">老王</option>
</select>
</td>
</tr>
<tr>
<td>班级:</td>
<td>
<select name="bname">
<option value="null">--请选择班级--</option>
<option value="一班">一班</option>
<option value="二班">二班</option>
<option value="三班">三班</option>
<option value="四班">四班</option>
</select>
</td>
</tr>
<tr>
<td>
爱好:</td>
<td>
<input type="checkbox" name="sah" value="乒乓球" >乒乓球
<input type="checkbox" name="sah" value="足球" >足球
<input type="checkbox" name="sah" value="篮球" >篮球
<input type="checkbox" name="sah" value="排球" >排球
</td>
</tr>
<tr>
<td>按键</td>
<td><button>确认</button> <input type="reset"/></td>
</tr>
</table>
</form>
<h3 align="center"><a href="index.do">返回首页</a></h3>
</body>
</html>
三、修改
先根据id获得学生所有信息并添加到修改界面中,再调用修改方法
代码如下:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<style type="text/css">
table,tr{
border-collapse: collapse;
}
td{
text-align: center;
}
</style>
</head>
<body>
<h3 align="center">修改页面</h3>
<form action="upd.do">
<table border="" width="500px" height="400px" align="center">
<input type="hidden" name="sid" value="${s.sid}">
<td>名字</td>
<td> <input type="text" name="sname" value="${s.sname }"></td>
</tr>
<tr>
<td>教员:</td>
<td>
<select name="yname">
<option value="张老师" ${s.yname=="老吴"?"selected":"" }>老吴</option>
<option value="李老师" ${s.yname=="老李"?"selected":"" }>老李</option>
<option value="胡老师" ${s.yname=="老胡"?"selected":"" }>老胡</option>
<option value="胡老师" ${s.yname=="老王"?"selected":"" }>老王</option>
</select>
</td>
</tr>
<tr>
<td>班级:</td>
<td>
<select name="bname">
<option value="一班" ${s.bname=="一班"?"selected":"" }>一班</option>
<option value="二班" ${s.bname=="二班"?"selected":"" }>二班</option>
<option value="三班" ${s.bname=="三班"?"selected":"" }>三班</option>
<option value="四班" ${s.bname=="四班"?"selected":"" }>四班</option>
</select>
</td>
</tr>
<tr>
<td>
爱好:</td>
<td>
<input type="checkbox" name="sah" value="乒乓球" <c:forEach var="i" items="${ ah }">
<c:if test="${ i=='乒乓球' }"> checked
</c:if>
</c:forEach>>乒乓球
<input type="checkbox" name="sah" value="足球" <c:forEach var="i" items="${ ah }">
<c:if test="${ i=='足球' }"> checked
</c:if>
</c:forEach>>足球
<input type="checkbox" name="sah" value="篮球" <c:forEach var="i" items="${ ah }">
<c:if test="${ i=='篮球' }"> checked
</c:if>
</c:forEach>>篮球
<input type="checkbox" name="sah" value="排球" <c:forEach var="i" items="${ ah }">
<c:if test="${ i=='排球' }"> checked
</c:if>
</c:forEach>>排球
</td>
</tr>
<tr>
<td>按键</td>
<td><button>确认修改</button></td>
</tr>
</table>
</form>
<h3 align="center"><a href="index.do">返回首页</a></h3>
</body>
</html>