📄 edituser.jsp
字号:
<%@ page contentType="text/html; charset=gb2312"%>
<%@ include file="verify.jsp" %>
<%@ include file="../share/connection.jsp" %>
<%
String name = (String)session.getAttribute("adminname");
if(!name.equals("admin"))
{
out.println("您没有此权限");
return;
}
%>
<SCRIPT language=javascript src="verifyuser.js">
</SCRIPT>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../jscss/styles.css" rel="stylesheet" type="text/css">
</head>
<body>
<%
int flag=0;
String userid;
String userloginname;
String usertruename;
String userpassword;
String useremail;
String userphone;
int userdepartid;
int usercanview;
int usercanadd;
int usercanedit;
int usercandel;
int usercanaudit;
String sqlList;
String sqlDepart;
String sqlUser;
String sqlSaveEdit;
ResultSet rsUser;
ResultSet rsList;
ResultSet rsDepart;
String action=request.getParameter("action");
String actionArray[]={"list","edit","save"};
for(int i=0;i<actionArray.length;i++)
{
if (action.equalsIgnoreCase(actionArray[i]))
{
flag=i;
break;
}
}
switch(flag)
{
case 0:
%>
<TABLE width="80%" height=20
border=0 align="center" cellPadding=0 cellSpacing=0 background="../images/adminbg.gif" bgColor=#587dbc>
<TBODY>
<TR>
<TD><font color="#ffffff">
<div align="center"><strong><font color="#000000">编辑用户</font></strong></div>
</font></TD>
</TR>
</TBODY>
</TABLE>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0" style="border:1px solid #003366">
<tr>
<td> <p> </p>
<table width="80%" border="0" align="center">
<tr>
<td><strong>用户名</strong></td>
<td width="100" align="center"><strong>操作</strong></td>
</tr>
</table>
<%
out.print("<br>");
sqlList="select * from cs_user where user_active=1";
rsList=stm.executeQuery(sqlList);
while(rsList.next())
{%>
<table width="80%" border="0" align="center">
<tr>
<td>
<%
out.print(rsList.getString("user_truename"));
%>
</td>
<td width="100"><a href="edituser.jsp?action=edit&userid=<%=rsList.getInt("user_id")%>">修改</a>
|||<a href="abandon.jsp?userid=<%=rsList.getInt("user_id")%>">删除</a>
</td>
</tr>
</table><hr style="height:1px;color:#003366">
<%
out.print("<br>");
}
break;
case 1:
userid=request.getParameter("userid");
sqlUser="select * from cs_user where user_id="+userid;
rsUser=stm.executeQuery(sqlUser);
rsUser.next();
%>
<p> </p></td>
</tr>
</table>
<FORM name=frmUserInfo action=edituser.jsp?action=save method=post onsubmit="return VerifyInput();">
<TABLE width="80%" height=20
border=0 align="center" cellPadding=0 cellSpacing=0 background="../images/adminbg.gif" bgColor=#587dbc>
<TBODY>
<TR>
<TD><font color="#ffffff">
<div align="center"><strong><font color="#000000">编辑用户</font></strong></div>
</font></TD>
</TR>
</TBODY>
</TABLE>
<table width="80%" align=center cellpadding=3 cellspacing=1 style="border:1px solid #003366">
<TBODY>
<TR align=middle>
<Th colSpan=2 height=24> </TR>
<TR>
<TD width=40% ><b>账号</b>：<BR>
账号长度限制为0－10字节，只可使用字母或数字</TD>
<TD width=60% > <INPUT maxLength="10" size=30 name=loginname value='<%=rsUser.getString("user_loginname")%>'></TD>
</TR>
<TR>
<TD width=40% ><B>密码(6-10位)</B> ：<BR>
请输入密码，区分大小写 <BR>
请不要使用任何类似 '*'、' ' 或 HTML 字符 </TD>
<TD width=60% > <INPUT type=password maxLength=16 size=30 name=passwd value='<%=rsUser.getString("user_password")%>'>
</TD>
</TR>
<TR>
<TD ><B>密码(6-10位)</B>：<BR>
请再输一遍确认</TD>
<TD ><INPUT type=password maxLength=16 size=30 name=repasswd value='<%=rsUser.getString("user_password")%>'></TD>
</TR>
<TR>
<TD ><B>姓名</B>：<BR>
请输入您的真实姓名</TD>
<TD ><INPUT name=truename id="truename" size=30 maxLength=16 value='<%=rsUser.getString("user_truename")%>'></TD>
</TR>
<TR>
<TD width=40% ><strong>所在部门：</strong><br>
请选择您所在的部门 </TD>
<TD ><select name="depart">
<%
useremail=rsUser.getString("user_email");
userphone=rsUser.getString("user_phone");
userdepartid=rsUser.getInt("user_departid");
usercanview=rsUser.getInt("user_canview");
usercanadd=rsUser.getInt("user_canadd");
usercanedit=rsUser.getInt("user_canedit");
usercandel=rsUser.getInt("user_candel");
usercanaudit=rsUser.getInt("user_canaudit");
sqlDepart="select * from cs_depart";
rsDepart=stm.executeQuery(sqlDepart);
while(rsDepart.next())
{
String label=rsDepart.getString("depart_name");
int value=rsDepart.getInt("depart_id");
if (value==userdepartid)
{
out.print("<option value='"+value+"'selected>"+label+"</option>");
}
else
{
out.print("<option value='"+value+"'>"+label+"</option>");
}
}
%>
</select> </TD>
</TR>
<TR>
<TD ><B>Email地址</B>：<BR>
请输入您在山大邮件服务器的email，以此确认的身份</TD>
<TD><INPUT maxLength=50 size=30 name= "email" value='<%=useremail%>'></TD>
</TR>
<TR>
<TD><B>内线电话</B>：<BR>
请输入您的内线电话，以方便我们与您联系</TD>
<TD> <input name=phone value='<%=userphone %>'>
</TD>
</TR>
<TR>
<TD colspan="2" >权限设置 <br> <input name="view" type="checkbox" value="1" <%=((usercanview >0)?"checked":"")%>>
阅读
<input type="checkbox" name="add" value="1" <%=((usercanadd>0)?"checked":"")%>>
添加
<input type="checkbox" name="edit" value="1" <%=((usercanedit>0)?"checked":"")%>>
修改
<input type="checkbox" name="del" value="1" <%=((usercandel>0)?"checked":"")%>>
删除
<input type="checkbox" name="audit" value="1" <%=((usercanaudit>0)?"checked":"")%>>
审核</TD>
</TR>
<TR align="center">
<TD colspan="2" ><br> <input name="userid" type="hidden" value="<%=userid%>">
<input type=submit value= "提 交" name=Submit>
<input type="button" name="Cancel" value="返 回" onClick="history.back()"> </TD>
</TR>
</table>
</form>
<%
break;
case 2:
userid=request.getParameter("userid");
userloginname=request.getParameter("loginname");
usertruename=request.getParameter("truename");
userpassword=request.getParameter("passwd");
useremail=request.getParameter("email");
userphone=request.getParameter("phone");
userdepartid=Integer.parseInt(request.getParameter("depart"));
usercanview=(request.getParameter("view")==null)?0:1;
usercanadd=(request.getParameter("add")==null)?0:1;
usercanedit=(request.getParameter("edit")==null)?0:1;
usercandel=(request.getParameter("del")==null)?0:1;
usercanaudit=(request.getParameter("audit")==null)?0:1;
sqlSaveEdit="UPDATE cs_user "+"SET user_loginname='"+userloginname+"',"
+"user_password='"+userpassword+"',"
+"user_truename='"+usertruename+"',"
+"user_email='"+useremail+"',"
+"user_phone='"+userphone+"',"
+"user_departid="+userdepartid+","
+"user_canview="+usercanview+","
+"user_canadd="+usercanadd+","
+"user_canedit="+usercanedit+","
+"user_candel="+usercandel+","
+"user_canaudit="+usercanaudit+" "
+"WHERE user_id="+userid;
if(stm.executeUpdate(sqlSaveEdit)==1)
out.print("修改成功");
break;
}// end of switch
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -