📄 teachlession_update1.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" %>
<html>
<!------系统交互javascript----->
<script language="JavaScript">
<!--
function check_data() {
//按提交按钮时，检查数据是否为空
if(update_teachlession_form.teacher_id.value==0){
alert("请选择教师！");
return false;
}
if(update_teachlession_form.lession_id.value==0){
alert("请选择课程！");
return false;
}
}
-->
</script>
<body bgcolor="#DCDADA">
<!---------导航菜单------------->
<jsp:include page="navigator.txt"/>
<!-------作查询操作的SQL语句-------->
<c:set var="selectSQL"
value="select teachlession_id,teacher_id,lession_id from teachlession where teacher_id=? and lession_id=?"/>
<!------设置数据源------>
<sql:setDataSource dataSource="jdbc/sqlserver" var="sqlDS"/>
<!------作数据库操作------>
<sql:query sql="${selectSQL}" dataSource="${sqlDS}" var="teachlessionRS">
<sql:param value="${param.teacher_id}"/>
<sql:param value="${param.lession_id}"/>
</sql:query>
<c:if test="${teachlessionRS.rowCount>=1}">
<!---------数据输入------------->
<table border="1" width="100%" cellspacing="0" cellpadding="0" bordercolor="#808080" bordercolorlight="#808080" bordercolordark="#808080">
<tr>
<td width="100%">
<table border="0" width="103%">
<tr>
<td width="100%" colspan="5">修改学生信息：<br><hr></td>
</tr>
<form name="update_teachlession_form" action="teachlession_update2.jsp" method="post" onsubmit="return check_data()">
<c:forEach items="${teachlessionRS.rowsByIndex}" var="cucN">
<tr>
<td width="40%" align="right">教师授课信息序号：${cucN[0]} 授课教师：</td>
<input type="hidden" value="${cucN[0]}" name="teachlession_id">
<td width="10%">
<!-----生成教师下拉框------>
<c:set var="selectRSSQL" value="select teacher_id,teacher_name from teacher"/>
<sql:query sql="${selectRSSQL}"
var="teacherRS" dataSource="${sqlDS}"/>
<select name="teacher_id">
<c:forEach items="${teacherRS.rowsByIndex}" var="cucNteacher">
<option value="${cucNteacher[0]}"
<c:if test="${cucNteacher[0]==cucN[1]}">selected</c:if>>
${cucNteacher[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="cucNlession">
<option value="${cucNlession[0]}"
<c:if test="${cucNlession[0]==cucN[2]}">selected</c:if>>
${cucNlession[1]}</option>
</c:forEach>
</select>
</td>
<td width="20%"><input type="submit" value="提交"></td>
</tr>
</c:forEach>
</form>
</table>
</td>
</tr>
</table>
</c:if>
<br>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -