📄 show_marks.jsp
字号:
<!-----filename:show_marks.jsp------学生成绩查询系统登录后显示结果的页面------->
<%/*
--------本网页需要接收两个输入参数：request.getPrameter("radiobutton"),request.getPrameter("select"),session.getAttribute("zhanghao")--------------
*/%>
<!-------------zhg工作室------2007.6------------->
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
String zhanghao = (String)session.getAttribute("zhanghao");
if(zhanghao==null)
{
response.sendRedirect("login.html");//避免未经登录直接进入本页面
}
%>
<!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" />
<title>欢迎使用----成绩查询系统</title>
</head>
<body bgColor="#9999cc">
<%/*
<script language="javascript">
<!--
document.bgColor="#9999cc";
//-->
</script>
*/%>
<%@ include file="jdbc.jsp" %>
<%--
//这一部分通过包含公共文件jdbc.jsp 来实现
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String Host = "localhost";
String Port = "1433";
String DBName = "marks_query"; //要操作的数据库
String MssqlURL = "jdbc:microsoft:sqlserver://" + Host + ":" + Port +
";DatabaseName=" + DBName + ";SelectMethod=cursor";
String UserName = "sa"; //数据库服务器登录账号
String PassWord = ""; //登录密码
--%>
<%
//String zhanghao=null,mima=null;//记录客户端输入的账号和密码
String sql=null;
ResultSet rs = null;
%>
<%
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(MssqlURL, UserName,PassWord);
// Statement stmt = conn.createStatement(); //由于后面要用到previous()方法，所以不能使用这种形式，而下面的四种都可以。
// Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE );
// Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE );
// Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
//下面分别为从表单接收到的账号及密码
//zhanghao = new String(request.getParameter("zhanghao").getBytes("ISO8859_1"));
//mima = new String(request.getParameter("mima").getBytes("ISO8859_1"));//因以判断登录成功,故本页面不再验证密码.
String option = new String(request.getParameter("radiobutton").getBytes("ISO8859_1"));//获取用户的选择
String item = new String(request.getParameter("select").getBytes("ISO8859_1"));//获取用户的具体选项
if(option.equals("danke"))//用户选择单科查询
{
sql = "select student.姓名,student.性别,student.出生年月,student.专业,course.课程名,course.学分,course.性质,course.课时,marks.成绩 from student,course,marks where student.学号=marks.学号 and course.课程号=marks.课程号 and student.学号='"+zhanghao+"' and course.课程名='"+item+"'";
}
else
{
sql = "select student.姓名,student.性别,student.出生年月,student.专业,course.课程名,course.学分,course.性质,course.课时,marks.成绩 from student,course,marks where student.学号=marks.学号 and course.课程号=marks.课程号 and student.学号='"+zhanghao+"'";
}
//sql = "select * from login where 账号='"+zhanghao+"'";//sql查询语句
rs = stmt.executeQuery(sql);
if(rs.next())//因为数据库login表中账号为主键，所以无需使用while遍历结果集
{
//if(mima.equals(rs.getString("密码").trim())) //只需比较密码，因为结果集中只有一条记录且账号已匹配
//{
//sql = "select student.姓名,student.性别,student.出生年月,student.专业,course.课程名,course.学分,course.性质,course.课时,marks.成绩 from student,course,marks where student.学号=marks.学号 and course.课程号=marks.课程号 and student.学号='"+zhanghao+"'";
//rs = stmt.executeQuery(sql);
//if(rs.next())
//{
out.println(zhanghao+" , 你所查询的信息如下:");
%>
<br><hr>
<table border="1">
<tr>
<th>姓名</th><th>性别</th><th>出生年月</th><th>专业</th><th>课程名</th><th>学分</th><th>性质</th><th>课时</th><th>成绩</th>
</tr>
<%
rs.previous();
while(rs.next())
{
%>
<tr>
<td><%=rs.getString("姓名")%></td><td><%=rs.getString("性别")%></td><td><%=rs.getString("出生年月")%></td><td><%=rs.getString("专业")%></td><td><%=rs.getString("课程名")%></td><td><%=rs.getString("学分")%></td><td><%=rs.getString("性质")%></td><td><%=rs.getString("课时")%></td><td><%=rs.getString("成绩")%></td>
</tr>
<%
}
%>
</table>
<% //}
//else
//{
//out.println("账号为"+zhanghao+"的同学，没有你的课程及成绩信息记录！");
//}
//}
//else
//out.println("密码错误!");
}
else out.println(zhanghao+" , 没有您所要查的课程的信息！<hr>");
%>
<%
rs.close();
stmt.close();
conn.close();
}
catch(Exception e) {
out.println("出现错误!!!请检查各相关软件的设置!!!<p>下面的出错提示可供参考:<br><font color='red'>" + e+"</font></p><br><br>----ZHG工作室------2007.6 ");
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -