<%@ page contentType="text/html;charset=UTF-8" %>
<%@ taglib prefix="c" uri="http://java.sun.com/
jsp/jstl/core" %>
<html>
<head>
<title>班级列表</title>
</head>
<body>
<h3>班级列表</h3>
<a
href="addClass.
jsp">添加班级</a>
<table border="1">
<tr>
<th>班级名称</th>
<th>操作</th>
</tr>
<c:forEach var="cls" items="${classist}">
<tr>
<td>${cls.cname} (ID: ${cls.cid})</td>
<td>
<a
href="chooseTerm.
jsp?cid=${cls.cid}">查看成绩</a>
<a
href="Student?cid=${cls.cid}">查看学生</a>
</td>
</tr>
</c:forEach>
</table>
</body>
</html>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<c:forEach var="gls" items="${gradeList}">
<tr>
<td>${gls.term} (${gls.gid})</td>
<td>
<a
href="ShowGrade?cid=${gls.gid}&term=第一学期">查看第一学期成绩</a><br>
<a
href="ShowGrade?cid=${gls.gid}&term=第二学期">查看第二学期成绩</a><br>
<a
href="ShowGrade?cid=${gls.gid}&term=第三学期">查看第三学期成绩</a><br>
<a
href="ShowGrade?cid=${gls.gid}&term=第四学期">查看第四学期成绩</a>
</td>
</tr>
</c:forEach>
</body>
</html>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/
jsp/jstl/core" %>
<html>
<head>
<title>成绩列表</title>
</head>
<body>
<h3>班级ID：${cid} | 学期：${term}</h3>
<table border="1">
<tr>
<th>学生姓名</th>
<th>数学</th>
<th>语文</th>
<th>英语</th>
</tr>
<c:forEach var="grade" items="${gradeList}">
<tr>
<td>${grade.studentName}</td>
<td>${grade.math}</td>
<td>${grade.chinese}</td>
<td>${grade.english}</td>
</tr>
</c:forEach>
</table>
<br>
<a
href="javascript:history.back()">返回</a>
</body>
</html>
@RequestMapping("/ShowGrade")
public ModelAndView showGrade(HttpSession session, String term, ModelAndView mv) {
Integer cid = (Integer) session.getAttribute("cid");
List<Map<String, Object>> gradeList = gradeService.getGradeByTerm(cid, term);
mv.addObject("gradeList", gradeList);
mv.addObject("term", term);
mv.addObject("cid", cid);
mv.setViewName("ShowGrade.
jsp");
return mv;
}<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.buka.dao.GradeDao">
<resultMap id="grade" type="com.buka.po.Grade">
<result property="name" column="name"></result>
<result property="term" column="term"></result>
<result property="math" column="math"></result>
<result property="chinese" column="chinese"></result>
<result property="English" column="English"></result>
<result property="sid" column="sid"></result>
<association property="cid" javaType="com.buka.po.Student">
<id property="cid" column="cid"></id>
</association>
</resultMap>
<insert id="addGrade" parameterType="com.buka.po.Grade">
INSERT INTO grade (gid, term, sid, math, chinese, English)
VALUES (#{gid}, #{term}, #{sid}, #{math}, #{chinese}, #{English})
</insert>
<select id="getGradeByTerm" resultMap="grade">
SELECT
s.name AS studentName,
g.math AS math,
g.chinese AS chinese,
g.English AS english,
g.term AS term,
s.cid AS cid
FROM
grade g
INNER JOIN student s ON g.sid = s.sid
WHERE
s.cid = #{cid}
AND g.term = #{term}
ORDER BY
s.name
</select>
</mapper>我该如何解决cid无法在页面中传值的问题
本文详细探讨了如何在JSP页面中通过URL参数获取用户输入，并展示了一个简单的示例，包括如何接收并打印请求参数userid。了解如何在服务器端处理HTTP请求对于Web开发人员至关重要。
扫一扫
3004
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
