📄 core_add.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<!------设置数据源------>
<sql:setDataSource dataSource="jdbc/sqlserver" var="sqlDS"/>
<html>
<!------系统交互javascript----->
<script language="JavaScript">
<!--
function check_data() {
//按提交按钮时，检查输入数据
if(add_core_form.class_id.value==0){
alert("请选择班级！");
return false;
}
if(add_core_form.lession_id.value==0){
alert("请选择课程！");
return false;
}
}
-->
</script>
<body bgcolor="#DCDADA">
<!---------导航菜单------------->
<table border="0" width="100%">
<tr>
<td width="100%">
<p align="left">您当前所在位置：学生成绩录入-->查询和录入学生成绩信息</p>
</td>
</tr>
</table>
<!---------数据输入------------->
<table border="1" width="100%" cellspacing="0" cellpadding="0" bordercolor="#808080" bordercolorlight="#808080" bordercolordark="#808080">
<tr>
<td width="100%">
<table border="0" width="100%">
<tr>
<td width="100%" colspan="5">查询和录入学生成绩信息：<br><hr></td>
</tr>
<form name="add_core_form" action="core_add.jsp" method="post" onsubmit="return check_data()">
<tr>
<td width="25%" align="right">班级：</td>
<td width="10%">
<!-----生成班级下拉框------>
<c:set var="selectRSSQL" value="select class_id,class_name from class"/>
<sql:query sql="${selectRSSQL}"
var="classRS" dataSource="${sqlDS}"/>
<select name="class_id">
<c:forEach items="${classRS.rowsByIndex}" var="cucN">
<c:if test="${cucN[0]==param.class_id}"> selected</c:if>>
<option value="${cucN[0]}"
<c:if test="${cucN[0]==param.class_id}"> selected</c:if>>
${cucN[1]}</option>
</c:forEach>
</select>
</td>
<td width="15%" align="right">课程名：</td>
<td width="20%">
<!-----生成课程下拉框------>
<c:set var="selectRSSQL" value="select lession_id,lession_name from lession"/>
<sql:query sql="${selectRSSQL}"
var="lessionRS" dataSource="${sqlDS}"/>
<select name="lession_id">
<c:forEach items="${lessionRS.rowsByIndex}" var="cucN">
<option value="${cucN[0]}"
<c:if test="${cucN[0]==param.lession_id}"> selected</c:if>>
${cucN[1]}</option>
</c:forEach>
</select>
</td>
<td width="30%"><input type="submit" value="提交"></td>
</tr>
</form>
</table>
</td>
</tr>
</table><br>
<!---------数据输出------------->
<c:if test="${(not empty param.class_id) and (not empty param.lession_id)}">
<table border="1" width="100%" cellspacing="0" cellpadding="0" bordercolor="#808080" bordercolorlight="#808080" bordercolordark="#808080">
<!--得到当前班级的当前课程的封存状态-->
<c:set var="selectRSSQL" value="select distinct core.lession_id as lession_id,student.class_id as class_id,
core.close_status as close_status from core,student
where core.student_id=student.student_id and student.class_id=${param.class_id}
and core.lession_id=${param.lession_id}"/>
<sql:query sql="${selectRSSQL}"
var="closeStatusRS" dataSource="${sqlDS}"/>
<c:if test="${closeStatusRS.rowCount==1}">
<c:forEach items="${closeStatusRS.rowsByIndex}" var="cucNclose">
<c:if test="${cucNclose[2]==1}">
<tr>
<td colspan="3" align="center">
此班级的此门课程成绩已被封存！
</td>
</tr>
</c:if>
<c:if test="${cucNclose[2]!=1}">
<c:set var="closeStat" value="1"/>
</c:if>
</c:forEach>
</c:if>
<c:if test="${closeStatusRS.rowCount!=1}">
<c:set var="closeStat" value="1"/>
</c:if>
<c:if test="${closeStat==1}">
<!--查询出此班级的此门课程的所有成绩-->
<c:set var="selectRSSQL" value="select distinct student.student_id as student_id,
student.student_name as student_name,class.class_id as class_id
from student,class where student.class_id=class.class_id"/>
<c:if test="${not empty param.class_id}">
<c:set var="selectRSSQL" value="${selectRSSQL} and student.class_id=${param.class_id}
and class.class_id=${param.class_id}"/>
</c:if>
<sql:query sql="${selectRSSQL}"
var="classStudentRS" dataSource="${sqlDS}"/>
<form name="student_core" action="core_save.jsp" method="post" onsubmit="return check_core_data()">
<tr>
<td colspan="3" align="center">
学生课程成绩(共${classStudentRS.rowCount}条)
</td>
</tr>
<tr>
<td colspan="3" align="right">
<input type="submit" value="保存成绩">
</td>
</tr>
<tr>
<td width="20%" align="center">学生序号</td>
<td width="40%" align="center">学生姓名</td>
<td width="40%" align="center">课程成绩</td>
</tr>
<input type="hidden" value="${param.lession_id}" name="lession_id">
<input type="hidden" value="${param.class_id}" name="class_id">
<c:if test="${classStudentRS.rowCount>=1}">
<c:forEach items="${classStudentRS.rowsByIndex}" var="cucN">
<tr>
<td align="center" >${cucN[0]}</td>
<td align="center" >${cucN[1]}</td>
<td align="center" >
<!--查询出此学生的成绩-->
<c:set var="selectSQL"
value="select core from core where lession_id=${param.lession_id}
and student_id=${cucN[0]}"/>
<sql:query sql="${selectSQL}"
var="coreRS" dataSource="${sqlDS}"/>
<c:if test="${coreRS.rowCount<1}">
<input type="text" maxlength="10" name="stu${cucN[0]}">
</c:if>
<c:if test="${coreRS.rowCount==1}">
<c:forEach items="${coreRS.rowsByIndex}" var="cucNcore">
<input type="text" maxlength="10" name="stu${cucN[0]}" value="${cucNcore[0]}">
</c:forEach>
</c:if>
</td>
</tr>
</c:forEach>
</c:if>
</form>
</c:if>
</table><br>
</c:if>
<!----------操作提示信息--------------->
<table border="1" width="100%" cellspacing="0" cellpadding="0" bordercolor="#808080" bordercolorlight="#808080" bordercolordark="#808080">
<tr>
<td width="100%">
<table border="0" width="100%">
<tr>
<td width="100%">注意：单击保存按钮会保存当前屏幕上的所有学生的此课程的成绩。</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -