📄 managerscore.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<!-- TemplateBeginEditable name="doctitle" -->
<title>无标题文档</title>
<!-- TemplateEndEditable -->
<!-- TemplateBeginEditable name="head" -->
<!-- TemplateEndEditable -->
<style type="text/css">
<!--
body {
background-image: url(images/0866.jpg);
}
-->
</style></head>
<body>
<form>
<table width="336" align="center">
<tr>
<th width="156" scope="col"><input name="choose" type="radio" value="m" checked />录入成绩及修改</th>
<th width="164" scope="col"><input name="choose" type="radio" value="s" />显示成绩</th>
</tr>
<tr>
<td align="right">请输入课程号</td>
<td><input name="CID" type="text" size="20" /></td>
</tr>
<tr>
<td align="right">请输入年度</td>
<td><input name="semester" type="text" size="20" /></td>
</tr>
<tr>
<td align="center"><input name="submit" type="submit" value="确定" /></td>
<td align="center"><input name="" type="reset" value="取消" /></td>
</tr>
</table>
</form>
<%
if(request.getParameter("submit")!=null)
{
String choice=request.getParameter("choose");
if(request.getParameter("CID")!=null && request.getParameter("semester")!=null)
{
String CID=request.getParameter("CID");
String semester=request.getParameter("semester");
byte b[]=semester.getBytes("ISO-8859-1");
semester=new String(b);
session.setAttribute("CID",CID);
session.setAttribute("semester",semester);
%>
<jsp:useBean id="show" class="student.ReadScore" />
<jsp:setProperty name="show" property="CID" value="<%=CID %>"/>
<jsp:setProperty name="show" property="semester" value="<%=semester %>"/>
<%
ResultSet result=show.getResult();
if(choice.equals("m"))
{
out.println("<table align=\"center\">");
out.println("<tr>"+"<th>学号</th><th>姓名</th><th>课程名</th><th>是否考核</th><th>成绩</th><th></th>");
while(result.next())
{
out.println("<form action=\"ManagerScore1.jsp\" method=\"post\" >");
String SID=result.getString(1);
out.println("<tr><td>"+SID+"</td><td>"+result.getString(2)+"</td><td>"+result.getString(3)+"</td><td>"+result.getObject(4)+"</td><td><input type=\"text\" name=\"score\" value=\""+result.getInt(5) +"\" /></td><td><input name=\"modify\" type=\"submit\" value=\"修改\" /></td></tr>");
out.println("<input type='hidden' name='test' value='"+SID+"'/></form>");
}
out.println("</table>");
}
else
{
out.println("<table align=\"center\">");
out.println("<tr>"+"<th>学号</th><th>姓名</th><th>课程名</th><th>是否考核</th><th>成绩</th>");
while(result.next())
{
out.println("<tr><td>"+result.getString(1)+"</td><td>"+result.getString(2)+"</td><td>"+result.getString(3)+"</td><td>"+result.getObject(4)+"</td><td>"+result.getInt(5)+"</td></tr>");
}
out.println("</table>");
}
}
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -