📄 addmark.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" errorPage="errorpage.jsp" %>
<%@ page import="java.sql.*,myBeans.SQLBean"%>
<html>
<head>
<link href="Inc/student_com.css" type="text/css" rel="stylesheet">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>公布成绩</title>
</head>
<jsp:useBean id="stu" scope="page" class="myBean.Student" />
<body>
<p>
<%
String tea_id=(String)session.getAttribute("id");
if(tea_id ==null){response.sendRedirect("login.jsp");}
String class_id = request.getParameter("classid");
String cour_id = request.getParameter("course");
ResultSet rs = stu.getStu_id(class_id);
%>
</p>
<p align="center"><font color="#00FF00" size="+3" face="华文行楷">新增学生成绩</font></p>
<p> </p>
<div align="center">
<form name="myform" method="post" action="StudentLoginSvlt">
<input name="action" type="hidden" value="add">
<input name="cour_id" type="hidden" value="<%=cour_id%>">
<table border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#DEDFDE">
<tr>
<td width="200" height="25" align="center" bgcolor="#EEEEEE">学号</td>
<td width="150" align="center" bgcolor="#EEEEEE">姓名</td>
<td width="100" align="center" bgcolor="#EEEEEE">成绩</td>
</tr>
<%SQLBean db = new SQLBean();String stu_id = "";
while(rs.next()){
stu_id = rs.getString("ID");
String name = rs.getString("NAME");
String sql = "select * from stu_course where STUID='"+stu_id+"' and COURSEID='"+cour_id+"'";
ResultSet rs1 = db.executeQuery(sql);
if(!rs1.next()){
%>
<tr>
<td align="center" bgcolor="#FFFFFF"><font size="5"><%=stu_id%></font></td>
<td align="center" bgcolor="#FFFFFF"><%=name%></td><td align="center" bgcolor="#FFFFFF"><input name="<%=stu_id%>" type="text" value="0"></td>
</tr>
<%}rs1.close();}rs.close();%>
</table>
<p> </p>
<p align="center">
<input type="submit" name="Submit" value="确定">
</p>
</form>
</div>
<div align="center"><a href="teacher.jsp" target="_parent">返回 </a>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -