⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 changepassword.jsp

📁 jsp+access简易选课系统
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.util.*" %>
<%@ page import="java.text.*" %>
<%@ page import="java.net.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
body {
	background-image: url(images/surface.jpg);
}
-->
</style></head>

<body>
<br>
<br><br><br><br>
<form>
<table align="center">
  <tr>
   <td width="50"></td>
   <td width="200" align="right">旧密码:</td>  
   <td><input type="password" name="oldPassword" height="25"></td>
  </tr>
 <tr>
   <td width="50"></td>
   <td width="200" align="right">新密码:</td>  
   <td><input type="password" name="newPassword1" height="25"></td>
  </tr>
  <tr>
   <td width="50"></td>
   <td width="200" align="right">再次输入新密码:</td>
   <td><input type="password" name="newPassword2" height="25"></td>
  </tr>
  <tr>
    <td></td>
	<td align="right"><input type="submit" name="submit" height="25" value="确定"></td>
    <td><input type="reset" name="reset" value="重设"></td>
  </tr>
</table>
</form>
<%
	
	if(request.getParameter("newPassword1") != null && request.getParameter("newPassword2") != null &&request.getParameter("oldPassword") != null)
	{
		if(request.getParameter("newPassword1").equals(request.getParameter("newPassword2")))
		{
			if(session.isNew())		response.sendRedirect("index.jsp");
			String accountID,typeString,sql,newPW;
			String oldPassword=request.getParameter("oldPassword");
			newPW = request.getParameter("newPassword1");
			Object id = session.getAttribute("id");
			Object type = session.getAttribute("type");
			accountID = id.toString();
			typeString = type.toString();
			
%>
<jsp:useBean id="statement" class="student.Connect" />
<%
			Connection con = statement.getCon();
			Statement smt = con.createStatement();
			if(!type.equals("s")) 
			  sql = "UPDATE Administrator SET  Password = '"+newPW+"' WHERE A_ID = '"+accountID+"' and Password='"+oldPassword+"'";
			else 
			  sql = "update student set Password= '"+newPW+"' where S_ID = '"+accountID+"' and Password='"+oldPassword+"'";
			smt.executeUpdate(sql);
			out.println("<script>alert('修改成功!');</script>");
			con.close();
		}		
		else	
		  out.println("<script>alert('两次输入的密码不一致!');</script>");
	}
	
%>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -