?? useredit.jsp
字號:
<%@ page contentType="text/html;charset=gb2312" %><%@ include file="check.jsp" %>
<%
if(String.valueOf(session.getAttribute("Urule")).compareTo("a")!=0){
response.sendRedirect ("error.jsp?id=admin");
}
%>
<script language=javascript src="mouse.js"></script>
<%
String sql = "";
String op = "9";
if( request.getParameter("op")!=null){
op = request.getParameter("op");
}
String sid = request.getParameter("id");
if( op.compareTo("3")==0){ //刪除用戶
sql = "delete from myuser where ID="+sid;
sqlbean.executeUpdate(sql);
sql = "delete from allmail where userid="+sid;
sqlbean.executeUpdate(sql);
sql ="delete from userinfo where userid=" + sid;
sqlbean.executeUpdate(sql);
sql="DELETE FROM card where userid="+sid;
sqlbean.executeUpdate(sql);
sql="DELETE FROM calendar where userid="+sid;
sqlbean.executeUpdate(sql);
sqlbean.close();
response.sendRedirect("userchk.jsp");
}else if( op.compareTo("1")==0){ //添加用戶？
}else if( op.compareTo("2")==0){ //修改用戶
%>
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="oa.css">
<title>修改用戶資料</title>
</head>
<body>
<script Language="javaScript">
function validate()
{
if (document.myform.name.value=="")
{
alert("姓名不能為空");
document.myform.name.focus();
return false ;
}
if (document.myform.username.value=="")
{
alert("登錄帳號不能為空");
document.myform.username.focus();
return false ;
}
if (document.myform.company.value=="")
{
alert("部門名稱不能為空");
document.myform.company.focus();
return false ;
}
if (document.myform.tel.value=="")
{
alert("電話號碼不能為空");
document.myform.tel.focus();
return false ;
}
if (document.myform.email.value=="")
{
alert("電子郵件不能為空");
document.myform.email.focus();
return false ;
}
if (document.myform.password.value=="")
{
alert("密碼不能為空");
document.myform.password.focus();
return false ;
}
if (document.myform.ilevel.value=="")
{
alert("郵箱級別不能為空");
document.myform.ilevel.focus();
return false ;
}
return true;
}
</script> <link rel="stylesheet" href="eintrdemo.css"> </head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form method="post" action="useredit.jsp" name="myform" onsubmit="return validate()">
<input type=hidden name=id value='<%=sid%>'>
<input type=hidden name=op value=6>
<table width="100%" border="0" cellspacing="1" cellpadding="2"> <tr > <td class="heading">
<div align="center"> <center> <table width="81%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000" bordercolorlight="#000000" style="font-size:9pt">
<tr> <td width="2%" align="right"></td><td align="left" height="25"> <p align="center"><font color="#FFFFFF"><b>修
改 資 料</b></font></p></td><td width="3%"></td></tr> </table></center></div></td></tr>
</table><div align="center">
<table width="80%" border="1" cellspacing="0" cellpadding="0" bordercolordark="#FFFFFF" bordercolor="#FFFFFF" bordercolorlight="#000000" style="font-size:9pt">
<tr>
<td width="17%" valign="top">
<p align="right">部門名稱:</td>
<td width="83%">
<select NAME="part">
<%
sql = "select * from bumen";
sqlbean.executeQuery(sql);
String tmp;
while(sqlbean.next()){
tmp = sqlbean.getString("type");
out.println("<option value='"+tmp+"'>"+tmp+"</option>");
}
sql="select * from myuser where ID="+sid;
sqlbean.executeQuery(sql);
if(sqlbean.next()){
%>
</select> </td></tr>
<tr> <td width="17%" valign="top"> <p align="right">你的姓名:</p></td><td width="83%">
<input type="text" name="name" class="form" value="<%=sqlbean.getString("name")%>" >
</td></tr>
<tr> <td width="17%" valign="top" height="6"> <p align="right">登錄帳號:</p></td><td width="83%" height="6">
<input type="text" name="username" class="form" value="<%=sqlbean.getString("username")%>" size="24" disabled>
</td></tr> <tr> <td width="17%" valign="top" height="16"> <p align="right">登錄密碼:</p></td><td width="83%" height="16">
<input type="password" name="pwd" class="form" size="24" value="<%=sqlbean.getString("pwd")%>">
</td></tr> <tr> <td width="17%" valign="top" height="16"> <p align="right">密碼問題:</p></td><td width="83%" height="16">
<input type="text" name="wenti" class="form" size="24" value="<%=sqlbean.getString("wenti")%>">
</td></tr> <tr> <td width="17%" valign="top" height="16"> <p align="right">密碼答案:</p></td><td width="83%" height="16">
<input type="text" name="daang" class="form" size="24" value="<%=sqlbean.getString("daang")%>">
</td></tr>
<tr><td width="17%" valign="top"><p align="right">電話號碼:</p></td><td width="83%">
<input type="text" name="phone" class="form" value="<%=sqlbean.getString("phone")%>" size="24"> </td></tr>
<tr><td width="17%" valign="top"><p align="right">手機號碼:</p></td><td width="83%">
<input type="text" name="mobile" class="form" value="<%=sqlbean.getString("mobile")%>" size="24"> </td></tr>
<tr> <td width="17%" valign="top"> <p align="right">電子郵件:</p></td><td width="83%">
<input type="text" name="email" class="form" value="<%=sqlbean.getString("email")%>" size="24">
</td></tr> <tr> <td width="17%" valign="top"> <p align="right">管理權限:</p></td><td width="83%">
<select NAME="admin">
<%
tmp = sqlbean.getString("urule");
%>
<option value="a" <%if(tmp.compareTo("a")==0){%>selected<%}%>>超級用戶</option>
<option value="b" <%if(tmp.compareTo("b")==0){%>selected<%}%>>管理員</option>
<option value="c" <%if(tmp.compareTo("c")==0){%>selected<%}%>>貴賓用戶</option>
<option value="d" <%if(tmp.compareTo("d")==0){%>selected<%}%>>普通用戶</option>
</select> </td></tr>
</table>
</div><div align="center"><input type=image src="images/modify_off.gif">
<a href="javaScript:window.close()"><img border="0" src="images/close_1.gif"></a>
</div></form>
</body>
</html>
<%
}
}else if( op.compareTo("9")==0){ //用戶
sql = "update myuser set shenhe=0 where ID="+sid;
sqlbean.executeUpdate(sql);
sqlbean.close();
response.sendRedirect("userchk.jsp");
}else if( op.compareTo("5")==0){ //用戶
}else if( op.compareTo("6")==0){
Calendar now = Calendar.getInstance();
String sj = now.get(Calendar.YEAR)+"-"+(now.get(Calendar.MONTH)+1)+"-"+now.get(Calendar.DAY_OF_MONTH)+" "+now.get(Calendar.HOUR_OF_DAY)+":"+now.get(Calendar.MINUTE)+":"+now.get(Calendar.SECOND);
sql = "update myuser set "
+"pwd='"+ sqlbean.to_8859_1(request.getParameter("pwd"))
+"',email='"+sqlbean.to_8859_1(request.getParameter("email"))
+"',name='"+sqlbean.to_8859_1(request.getParameter("name"))
+"',part='"+sqlbean.to_8859_1(request.getParameter("part"))
+"',wenti='"+sqlbean.to_8859_1(request.getParameter("wenti"))
+"',daang='"+sqlbean.to_8859_1(request.getParameter("daang"))
+"',phone='"+sqlbean.to_8859_1(request.getParameter("phone"))
+"',mobile='"+sqlbean.to_8859_1(request.getParameter("mobile"))
+"',IP='"+request.getRemoteAddr()
+"',time='"+sj+"' where ID="+sid;
sqlbean.executeUpdate(sql);
sqlbean.close();
//out.println(sql);
out.println("<script>");
out.println("window.close();");
out.println("</script>");
//out.println(sqlbean.showMsg("javascript:window.close()","您的資料已經(jīng)成功修改","修 改 資 料"));
}else if( op.compareTo("8")==0){//保存數(shù)據(jù)
sql = "update myuser set shenhe=1 where ID="+sid;
sqlbean.executeUpdate(sql);
sqlbean.close();
response.sendRedirect("userchk.jsp");
}else if( op.compareTo("7")==0){ //允許用戶修改檔案
sql = "update userinfo set ischeck = 0,havephoto=0 where userid = "+sid;
sqlbean.executeUpdate(sql);
//out.println(sql);
sqlbean.close();
response.sendRedirect("userchk.jsp");
}
%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -