📄 student_change_password.jsp
字号:
<%------filename:student_change_password.jsp-------学生更改密码的页面--------%>
<%/*-------该网页需要接收三个参数：session中的zhanghao，表单中的mima0,mima1，mima2--------
*/%><!---------------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">
<%@ 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 mima0=null,mima1=null,mima2=null;
String sql=null;
ResultSet rs=null;
%>
<%
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(MssqlURL, UserName,PassWord);
Statement stmt = conn.createStatement();
// Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE );
//Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
//下面分别为从表单接受到的原来的密码,新密码及新密码确认
mima0 = new String(request.getParameter("mima0").getBytes("ISO8859_1"));
mima1 = new String(request.getParameter("mima1").getBytes("ISO8859_1"));
mima2 = new String(request.getParameter("mima2").getBytes("ISO8859_1"));
sql = "select * from studentlogin where 账号='"+zhanghao+"'";
rs = stmt.executeQuery(sql);
rs.next();
if(!(rs.getString("密码").trim().equals(mima0)))
{
out.println("原密码不正确! 请重新输入。");
}
else if(mima1==null||mima1.trim().length()==0)
{
out.println("密码不能为空，请重新输入！");
}
else if(! mima1.equals(mima2))
{
out.println("请确保两次输入的密码一致！");
}
else
{
sql = "update studentlogin set 密码='"+mima1+"' where 账号='"+zhanghao+"'";// sql修改密码语句
stmt.executeUpdate(sql);
out.println("账号为 "+zhanghao+" 的用户,您已成功修改密码，请记住您的新密码！");
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e) {/*
out.println("<hr>出现错误!!!请检查各相关软件的设置!!!<p>下面的出错提示可供参考:<br><font color='red'>" + e+"</font></p><br><br>----ZHG工作室------2007.6 <hr>");
*/ }
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -