📄 xiugai.jsp
字号:
<%@page info="database handler" language="java" import="java.sql.*" import="java.util.*" import="java.io.*"%>
<%@page import="javax.servlet.*"%>
<%@page import="javax.servlet.http.*"%>
<%@page contentType="text/html;charset=gb2312"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改密码</title>
<style type="text/css">
<!--
.style8 {font-family: "幼圆"; font-size: 18px; }
body {
background-color: #CC9966;
}
.style3 {color: #6633CC}
-->
</style>
</head>
<body background="image/Back057.gif">
<p align="center">
<%
String name=request.getParameter("name");
String password1=request.getParameter("mima");
String newpassword=request.getParameter("newpassword");
String newpassword2=request.getParameter("newpassword2");
String password=request.getParameter("password");
if(name.equals("")||password.equals("")||newpassword2.equals("")||newpassword.equals(""))
{ out.print("资料不完整，请重新填写！");%>
</p>
<p align="center"><a href="xiugai.htm">返回修改页面</a></p>
<p align="center">
<%return;
}
else if(!newpassword.equals(newpassword2))
{out.print("新密码不正确，请重新输入密码！");%>
</p>
<p align="center"><a href="xiugai.htm">返回修改页面</a></p>
<p align="center">
<%return;}
else
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:b";
Connection con=DriverManager.getConnection(url,"","");
Statement st=con.createStatement();
String strSql="select * from zhuce where name='"+name+"'and password='"+password+"'";
ResultSet rs=st.executeQuery(strSql);
if(!rs.next())
{out.print("用户名或密码不正确，请重新填写!<p align='center'><a href=xiugai.htm>返回</a></p>");
return;
}%>
<%
Statement aa=con.createStatement();
String sql="update zhuce set password='"+newpassword+"'where name='"+name+"'";//更新语句，使库里的信息更改为输入的信息
aa.executeUpdate(sql);
%>
</p>
<table width="611" border="0" align="center" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="40" height="20"> </td>
<td width="362"> </td>
<td width="173"> </td>
</tr>
<tr>
<td height="136" colspan="3"><table width="55%" height="136" border="0" align="center" cellspacing="0">
<!--DWLayoutTable-->
<tr align="center">
<td height="43" colspan="2" valign="top"><strong><font size="5">用户密码修改成功！</font></strong></td>
</tr>
<tr>
<td width="211" height="43" align="right" valign="middle">用户密码已经更改为</td>
<td width="95" valign="middle"> <%out.print(rs.getString("password"));%> </td>
</tr>
<tr>
<td height="50" colspan="2"><div align="center"><span class="style3"><a href="denglu.htm">返回登录页</a></span></div></td>
</tr>
</table></td>
</tr>
<tr>
<td height="32" colspan="3"><div align="center"><span class="style8"> </span></div></td>
</tr>
</table>
<%rs.close();
st.close();
aa.close();
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -