📄 m_modify_password2.jsp

📁 留学生信息管理系统我的工程实习的项目
💻 JSP
字号:
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<jsp:directive.page import="java.sql.ResultSet"/>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'M_add.jsp' starting page</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
<link rel="stylesheet" href="m_style.css" type="text/css">
  </head>
    <jsp:useBean id="db" scope="session" class="news.sql_data"/> 
  <body>
    <%
    	//String dataid=(String)session.getAttribute("dataid"); //用于用户的密码修改
    	String id=(String)session.getAttribute("id");   //用于管理员的密码修改	
    	String psw1=request.getParameter("psw1");
    	String psw2=request.getParameter("psw2");
    	String psw3=request.getParameter("psw3");
    	if(psw2.equals(psw3)){
    try{
    	
    	//String sql="select * from news_table where dataid="+dataid+" and password='"+psw1+"'";
    	String sql="select * from manager_table where id="+id+" and password='"+psw1+"'";
    	//out.print(sql+"<p>");
    	ResultSet rs=db.executeQuery(sql);
    	if(rs.next()){
    //	String mysql="update news_table set password='"+psw2+"'where dataid="+id;
    	String mysql="update manager_table set password='"+psw2+"'where id="+id;
    	//out.println(mysql+"<p>");
    	 db.executeUpdate(mysql);   
    	 rs.close();
    	 out.println("&nbsp;"+"<p>");
    	 out.println("&nbsp;"+"<p>");
    	 out.println("&nbsp;"+"<p>");
    	 out.println("<center>修改密码成功！<a href='/qxgl/incoming/Welcome.jsp'>返回首页</a></center>");
    	 mysql="select password from manager_table where id="+id;
    	 rs=db.executeQuery(mysql);
    	 rs.next();
    	 String password=rs.getString("password");
    	 if(password.equals(""))
    	 	out.println("<p><center>你的新密码为空");
    	 else
    		 out.println("<p><center>你的新密码是："+password+"</center>");
    	 }
    	 else{
    	  out.println("&nbsp;"+"<p>");
    	  out.println("&nbsp;"+"<p>");
    	  out.println("&nbsp;"+"<p>");
    	  out.print("<center>原密码输入错误 ");
    	  out.println("<input type='button' name='ret' value='返回' onclick='history.go(-1)'></center>");
    	 }
    	 }catch(Exception e){
    	    out.println("&nbsp;"+"<p>");
    	 	out.println("&nbsp;"+"<p>");
    	 	out.println("&nbsp;"+"<p>");
    	 	out.println("<center>修改密码失败！"+e.getMessage()+"</center>");
    	 }
    	 }
    	 else{
    	     out.println("&nbsp;"+"<p>");
    		 out.println("&nbsp;"+"<p>");
    		 out.println("&nbsp;"+"<p>");
    	     out.println("<center>新密码和新密码确认不一致");
    	     out.println("<input type='button' name='ret' value='返回' onclick='history.go(-1)'></center>");
    	 	}
     %>
  </body>
</html>
⌨️ 快捷键说明

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