editadmin.jsp

该源码为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;
}
%>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../jscss/styles.css" rel="stylesheet" type="text/css">

<%
int flag=0;
String adminid;
String adminname;
String adminpassword;
String adminrepassword;


String sqlList;
String sqlAdmin;
String sqlSaveEdit;
String sqlDelete;
ResultSet rsAdmin;
ResultSet rsList;
String action=request.getParameter("action");
String actionArray[]={"list","edit","save","delete"};
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>&nbsp;</p>
      <p>&nbsp; </p>
        <%
	sqlList="select * from cs_admin where admin_name <> 'admin'";
	rsList=stm.executeQuery(sqlList);
	while(rsList.next())
	{%> 
      <table width="80%" border="0" align="center">
        <tr>
          <td>
         <%
		  out.print(rsList.getString("admin_name")+"----");
		  %>
          </td>
          <td width="100"><a href="editadmin.jsp?action=edit&adminid=<%=rsList.getInt("admin_id")%>">修改</a> 
            |||<a href="editadmin.jsp?action=delete&adminid=<%=rsList.getInt("admin_id")%>">删除</a></td>
        </tr>
      </table>
      <p> 
        <%
		  out.print("<br>");
	}
	break;
case 1:
	adminid=request.getParameter("adminid");
	sqlAdmin="select * from cs_admin where admin_id="+adminid;
	rsAdmin=stm.executeQuery(sqlAdmin);
	rsAdmin.next();

	%>
      </p></td>
  </tr>
</table>
<FORM name=frmUserInfo action=editadmin.jsp?action=save method=post>
  <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>&nbsp;</TR>
	  <TR> 
		<TD width=40% ><b>账号</b>：<BR></TD>
		<TD width=60%  > <%=rsAdmin.getString("admin_name")%></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> 
		</TD>
	  </TR>
	  <TR> 
		<TD ><B>密码(6-10位)</B>：<BR>
		  请再输一遍确认</TD>
		<TD ><INPUT type=password maxLength=16 size=30 name=repasswd></TD>
	  </TR>
	  <TR align="center"> 
		<TD colspan="2" ><br> 
		<input name="adminid" type="hidden" value="<%=adminid%>"> 
		  <input type=submit value= "提 交" name=Submit>
		  　 
		  <input type=reset value= "清 空" name=reset>
          　
<input type="button" name="Cancel" value="返 回" onClick="history.back()"> </TD>
	  </TR>
  </table>

	</form>

<%
break;
case 2:
adminid=request.getParameter("adminid");
adminpassword=request.getParameter("passwd");
adminrepassword=request.getParameter("repasswd");
if(adminpassword == null || adminpassword.length() == 0)
{
	out.print("密码不能为空");
	return;
}
if(!adminpassword.equals(adminrepassword))
{
	out.print("两遍密码不一致");
	return;
}
sqlSaveEdit="UPDATE cs_admin "+"SET "
	+"admin_password='"+adminpassword+"' "

	+"WHERE admin_id="+adminid;
if(stm.executeUpdate(sqlSaveEdit)==1)
  out.print("修改成功");
break;
case 3:
	adminid=request.getParameter("adminid");
	sqlDelete="Delete from cs_admin where admin_id="+adminid;
if(stm.executeUpdate(sqlDelete)==1)
  out.print("删除成功");
break;
}// end of switch
%>
</body>
</html>