今天做了修改密码的功能
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8" import="java.sql.*"%> <!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=utf-8"> <title>修改密码</title> </head> <body> <jsp:useBean id="db" class="DBBean.Bean" scope="page" /> <%!String a, b;%> <%-- 将ab设为全局变量。 --%> <% request.setCharacterEncoding("utf-8"); String Iname = (String) session.getAttribute("Iname"); System.out.println(" "); System.out.println("resetpass.jsp 界面信息："); System.out.println("resetpass界面的Iname:" + Iname); String str = "select Iadd,Ifrdb,Iemail,Iyzbm,Iweb,Iclient,Igh,Iphone,Ifax from baseInfo where Iname=" + "'" + Iname + "'"; ResultSet rs2 = db.executeQuery(str); %> <form action="updatepass.jsp" method="post"> <p>当前登录的用户为: <%=Iname%></p> <p>请输入修改后的密码： <input type="password" name="repass1"></p> <p>请确认修改后的密码： <input type="password" name="repass2"></p> <input type="submit" value="确认修改"> </form> </body> <% rs2.close(); db.close(); %> </html>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" import="java.sql.*"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> </head> <body> <jsp:useBean id="db" class="DBBean.Bean" scope="page" /> <% request.setCharacterEncoding("utf-8"); String Iname = (String) session.getAttribute("Iname"); System.out.println(" "); System.out.println("updatepass.jsp 界面信息："); System.out.println("updatepass界面的Iname:" + Iname); String repassword1 = request.getParameter("repass1"); String repassword2 = request.getParameter("repass2"); //判断密码 System.out.print(repassword1); System.out.print(repassword2); if(repassword1.equals(repassword2)) { Class.forName("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8", "root", "123456"); Statement stmt = con.createStatement(); String sql = "update baseInfo set Ipassword='" + repassword1 + "' where Iname=" + "'" + Iname + "'"; int i = stmt.executeUpdate(sql); if (i == 1) { out.println("<h2>修改成功！</h2><br/>"); } else { out.println("<h2>修改不符合条件，失败！</h2><br/>"); } stmt.close(); con.close(); } else { out.println("<h2>修改不符合条件，失败！</h2><br/>");} %> </body> </html>