<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>用户重置密码</title>
</head>
<body>
用户重置密码
<form action="LoginUp/changePassWd" method="post">
输入账号<input type="text" name="username"/><br>
输入新密码<input type="password" name="passwd"/><br>
<%-- 再输一次密码<input type="password" name="passWd"/><br>--%>
<input type="submit" name="get"/>
</form>
</body>
</html>
package LoginUp;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
/**
* 重置用户密码
*/
public class changePassWd extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//设置服务器端以UTF-8编码进行输出
resp.setCharacterEncoding("UTF-8");
//设置浏览器以UTF-8编码进行接收,解决中文乱码问题
resp.setContentType("text/html;charset=UTF-8");
PrintWriter out = resp.getWriter();
String user = req.getParameter("username");
String passwd = req.getParameter("passwd");
try {
try {
System.out.println("here");
String url = "jdbc:sqlserver://localhost:1433;DataBaseName=Login;integratedSecurity=true;";
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection comm = DriverManager.getConnection(url);
// String sql = "INSERT into [user] (username,password) VALUES ('"+username+"','"+passwd+"')";
String sql = "update [user] set password='"+passwd+"' where username='"+user+"'";
Statement st = comm.createStatement();
int temp = st.executeUpdate(sql);
System.out.println(temp);
st.close();
comm.close();
out.println("更改成功,请重新登陆");
resp.setHeader("refresh","3,http://localhost:8080/javaWeb_war_exploded/tijiao.jsp");
System.out.println("b"); resp.setHeader("refresh","3,http://localhost:8080/javaWeb_war_exploded/tijiao.jsp");
//
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
更改完成: