📄 change_pass.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.http.*"%>
<HTML><HEAD><TITLE>修改到数据库</TITLE>
</HEAD>
<BODY >
<%
String success="";
String db_password="";
String username=request.getParameter("username");
String oldpassword=request.getParameter("oldpassword");
String newpassword=request.getParameter("newpassword");
String newpassword_check=request.getParameter("newpassword_check");
boolean dbcheck1,dbcheck2,dbcheck3;
dbcheck1=dbcheck2=dbcheck3=true;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dengfen";
String user="sa";
String password="123";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
Statement stmt1=conn.createStatement();
String db_check_sql="select password from ad where username='"+username+"'";
ResultSet rs=stmt.executeQuery(db_check_sql);
while(rs.next())
{
dbcheck1=true;
db_password=rs.getString(1);
}
if(!(oldpassword.equals(db_password)))
{
response.sendRedirect("change_password.jsp?success=0");
}
else
{
String sql_modify="update ad set password='"+newpassword+"' where username='"+username+"'";
stmt1.executeUpdate(sql_modify);
rs.close();
stmt.close();
stmt1.close();
conn.close();
response.sendRedirect("change_password.jsp?success=1");
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -