?? modipass.jsp
字號:
<%@ page contentType="text/html;charset=gb2312" errorPage="errpage.jsp" language="java" import="java.sql.*"%>
<%@include file="connect_odbc.jsp"%>
<html>
<head>
<title>
密碼修改
</title>
</head>
<body bgcolor="#009999">
<BR><BR><BR><BR>
<CENTER>
<form name="thisform" method="post">
<p>用戶代碼:
<input type="text" name="user" valign="left" size=17 style="border-style: solid; border-width: 1" tabindex="1" >
</p>
老密碼:
<input type="password" name="old" valign="left" size=17 style="border-style: solid; border-width: 1" tabindex="2" maxlength="10">
<p>
新密碼:
<input type="password" name="new" valign="left" size=17 style="border-style: solid; border-width: 1" tabindex="3" maxlength="10">
<p>
<input type="submit" name="Submit" value="提交" style="font-family: 宋體; width: 80px; font-size: 10pt; border-style: ridge; border-color: #000080" tabindex="4">
<input type="reset" name="Reset" value="取消" style="font-family: 宋體; width: 80px; font-size: 10pt; border-style: ridge; border-color: #000080" tabindex="5">
<input type="button" name="zx" value="重新登錄" style="font-family: 宋體; width: 80px; font-size: 10pt; border-style: ridge; border-color: #000080" tabindex="5" onClick="zx1()">
</p>
</form>
<BR>
</CENTER>
<SCRIPT LANGUAGE="JavaScript">
document.thisform.user.focus();
</SCRIPT>
<%
String userid="",oldpass="",newpass="",temp1="",err="";
int n=0;
String ksmc="";
userid=request.getParameter("user");
if(userid==null||userid.trim().equals(""))
{
// pool.releaseConnection(con);
}
else
{
oldpass=request.getParameter("old");
newpass=request.getParameter("new");
if(oldpass==null)
{
oldpass="";
}
sql="SELECT YHKL FROM YY_KSDM WHERE KSDM="+userid+"";
rs=stmt.executeQuery(sql);
while(rs.next())
{
temp1=rs.getString(1);
n++;
}
if(n<=0)
{
err="對不起,沒有此用戶!";
}
else
{
if(temp1.trim().equals(oldpass))
{
try{
if(newpass!=null)
{
sql="UPDATE YY_KSDM SET YHKL='"+newpass+"' WHERE KSDM="+userid+"";
}
else
{
sql="UPDATE YY_KSDM SET YHKL=NULL WHERE KSDM="+userid+"";
}
stmt.executeUpdate(sql);
err="修改成功,請返回后重新登錄!";
}
catch(SQLException ss)
{
err="提交失敗,"+ss.getMessage();
}
}
else
{
err="對不起,密碼不正確!";
}
}
}
pool.releaseConnection(con);
%>
<SCRIPT LANGUAGE="JavaScript">
function zx1()
{
var mm="index.jsp";
window.open(mm,"_self");
}
</SCRIPT>
<BR>
<FONT face="宋體" SIZE="5" COLOR=""><CENTER><%=err%></CENTER></FONT>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -