📄 ok_student.jsp
字号:
<%/*-----filename:ok_student.jsp------学生成绩查询系统学生登录成功的页面-------*/%>
<%/*
--------本网页需要接收session.getAttribute("zhanghao")--------------
*/%>
<!-------------zhg工作室------2007.6------------->
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<%
String zhanghao = (String)session.getAttribute("zhanghao");
if(zhanghao==null)
{
response.sendRedirect("login.html");//避免未经登录直接进入本页面
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
body {
background-color: #9999cc;
}
-->
</style></head>
<%@ 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"));//因以判断登录成功,故本页面不再验证密码.
%>
<body>
<table width="326" border="1">
<tr>
<td><p><font size="5" color="#FF00CC">欢迎你 <%=session.getAttribute("zhanghao")%> !</font>
</p></td>
</tr>
<tr>
<td>
<form name="form1" method="post" action="show_marks.jsp" target="win2">
<fieldset>
<legend>成绩查询</legend>
<p> </p>
<table width="240" border="0">
<tr>
<td width="102"><label for="radio1">单科查询</label>
<input type="radio" name="radiobutton" value="danke" id="radio1" checked></td>
<td width="128">
<select name="select" id="select">
<%
sql = "select * from course";
rs = stmt.executeQuery(sql);
if(rs.next())//因为数据库login表中账号为主键，所以无需使用while遍历结果集
{
rs.previous();
while(rs.next())
{
%>
<option value="<%=rs.getString("课程名")%>"><%=rs.getString("课程名")%></option>
<%
}
}
else
{
%>
<option value="无课程信息">无课程信息</option>
<%
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e) {
out.println("出现错误!!!请检查各相关软件的设置!!!<p>下面的出错提示可供参考:<br><font color='red'>" + e+"</font></p><br><br>----ZHG工作室------2007.6 ");
}
%>
</select>
</td>
</tr>
<tr>
<td height="23"><label for="radio2">多科查询</label>
<input type="radio" name="radiobutton" value="duoke" id="radio2">
</td>
<td> </td>
</tr>
</table>
<label for="radiobutton"></label>
<label for="select"></label>
<p>
<input type="submit" name="Submit2" value="查询" id="Submit2">
</p>
</fieldset>
</form>
</td>
</tr>
<tr>
<td><form name="form2" method="post" action="student_change_password.jsp" target="win2">
<fieldset>
<legend >修改密码</legend>
<p> <label for="mima0">原密码:</label>
<input name="mima0" type="password" size="25" maxlength="25" id="mima0">
<br>
<p> <label for="mima1">新密码:</label>
<input name="mima1" type="password" size="25" maxlength="25" id="mima1">
<br>
<label for="mima2">确认:</label>
<input name="mima2" type="password" size="25" maxlength="25" id="mima2">
</p>
<p>
<input type="submit" name="Submit" value="确定" id="Submit">
<input type="reset" name="reset" value="取消" id="reset">
</p>
</fieldset>
</form></td>
</tr>
<tr>
<td><form name="form3" method="post" action="quit.jsp">
<div align="center">
<p> </p>
<p>
<input type="submit" name="quit" value="退出登录" onClick="javascript:window.opener=null;top.window.close();">
</p>
</div>
</form> </td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -