📄 adminuser.jsp

📁 JavaWeb标签应用开发（随书光盘）为方便读者阅读本书和调试程序
💻 JSP
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<fmt:requestEncoding value="gb2312"/>
<!------设置数据源------>
<sql:setDataSource dataSource="jdbc/sqlserver" var="sqlDS"/>
<html>
<!------系统交互javascript----->
<script language="JavaScript">
<!--
function delete_confirm() {
//按删除链接时，弹出确认对话框
   if(confirm("确认要删除吗？")){
  		return true;
	}else return false;	
}
-->
</script>
<body bgcolor="#DCDADA">
<!---------导航菜单------------->
<table border="0" width="100%">
  <tr>
    <td width="100%">
      <p align="left">您当前所在位置：系统管理-->用户管理</p>
    </td>
  </tr>
</table>
<!---------数据输入------------->
<table border="1" width="100%" cellspacing="0" cellpadding="0" bordercolor="#808080" bordercolorlight="#808080" bordercolordark="#808080">
  <tr>
    <td width="100%">
      <table border="0" width="100%">
        <tr>
          <td width="100%" colspan="5">输入查询条件：<br><hr></td>
        </tr>
        <form name="form1" action="adminuser.jsp" method="post">
        <tr>
          <td width="24%" align="right">用户角色：</td>
          <td width="19%">
          <select name="sysuser_role">
          	<option value="">====所有====</option>
          	<option value="2">教务管理员</option>
          	<option value="3">教师用户</option>
          	<option value="4">学生用户</option>
    	  </select>		  
          </td>
          <td width="11%" align="right">用户名：</td>
          <td width="21%">
          <input type="text" name="sysuser_name" maxlength="20" >
          </td>
          <td width="25%"><input type="submit" value="提交"></td>
        </tr>
        </form>
      </table>
    </td>
  </tr>
</table><br>
<!-------生成查询数据库的SQL语句-------->
<c:set var="selectRSSQL" 
		value="select sysuser_id,sysuser_name,sysuser_role,sysuser_status,foreign_id
			foreign_id from sysuser"/>
<c:set var="selectCountSQL" 
		value="select count(*) as sysuserCount from sysuser"/>
<!--如果sysuser_role和sysuser_name两个请求参数中有一个不为空-->
<c:if test="${not ((empty param.sysuser_role)&&(empty param.sysuser_name))}">
	<c:set var="selectRSSQL" value="${selectRSSQL} where "/>
	<c:set var="selectCountSQL" value="${selectCountSQL} where "/>
	<!--如果sysuser_role请求参数不为空-->
	<c:if test="${not empty param.sysuser_role}">
		<c:set var="selectRSSQL" 
			value="${selectRSSQL} sysuser_role=${param.sysuser_role}"/>
		<c:set var="selectCountSQL" 
			value="${selectCountSQL} sysuser_role=${param.sysuser_role}"/>
	</c:if>
	<!--如果sysuser_name请求参数不为空-->
	<c:if test="${not empty param.sysuser_name}">
	    <!--如果sysuser_role请求参数为空，故selectRSSQL以where结尾-->
		<c:if test="${fn:endsWith(selectRSSQL,\" where \")}">
			<c:set var="selectRSSQL" 
				value="${selectRSSQL} sysuser_name like '%${param.sysuser_name}%'"/>
			<c:set var="selectCountSQL" 
				value="${selectCountSQL} sysuser_name like '%${param.sysuser_name}%'"/>
		</c:if>
		<!--如果sysuser_role请求参数不为空，故selectRSSQL不以where结尾-->
		<c:if test="${not fn:endsWith(selectRSSQL,\" where \")}">
			<c:set var="selectRSSQL" 
				value="${selectRSSQL} and sysuser_name like '%${param.sysuser_name}%'"/>
			<c:set var="selectCountSQL" 
				value="${selectCountSQL} and sysuser_name like '%${param.sysuser_name}%'"/>
		</c:if>
	</c:if>
	<c:set var="selectRSSQL" 
				value="${selectRSSQL} and sysuser_role<>1"/>
	<c:set var="selectCountSQL" 
				value="${selectCountSQL} and sysuser_role<>1"/>
</c:if>
<!------如果两个参数都为空------>
<c:if test="${(empty param.sysuser_role)&&(empty param.sysuser_name)}">
	<c:set var="selectRSSQL" 
				value="${selectRSSQL} where sysuser_role<>1"/>
	<c:set var="selectCountSQL" 
				value="${selectCountSQL} where sysuser_role<>1"/>
</c:if>
<!--查询出总记录条数-->
<sql:query sql="${selectCountSQL}" 
  				var="sysuserCountRS" dataSource="${sqlDS}"/>
<!--得到当前页的页号-->
<c:if test="${not empty param.page}">
  	<c:set var="page" value="${param.page}"/>
</c:if>
<c:if test="${empty param.page}">
  	<c:set var="page" value="1"/>
</c:if>
<!--得到总记录条数-->
<c:set var="sysuserCount" value="${sysuserCountRS.rowsByIndex[0][0]}"/>
<!--设置每页显示记录条数-->
<c:set var="pageSize" value="10"/>
<!--计算总页数-->
<c:if test="${sysuserCount%pageSize==0}">
  	<c:set var="pageCount" value="${sysuserCount/pageSize}"/>
</c:if>
<c:if test="${sysuserCount%pageSize!=0}">
  	<c:set var="pageCount" value="${sysuserCount/pageSize+1-(sysuserCount%pageSize)/pageSize}"/>
</c:if>
<fmt:formatNumber value="${pageCount}" maxFractionDigits="0" var="pageCount"/>   
<!--得到当前页数据在SQL查询结果中的起始位置-->
<c:set var="startPosition" value="${(page-1)*pageSize}"/>
<!--查询出当前页的数据-->
<sql:query 
  	sql="${selectRSSQL}" 
  	var="sysuserRS" dataSource="${sqlDS}" startRow="${startPosition}" maxRows="${pageSize}"/>
<!---------数据输出------------->
<table border="1" width="100%" cellspacing="0" cellpadding="0" bordercolor="#808080" bordercolorlight="#808080" bordercolordark="#808080">
  
  <tr>
    <td colspan="6" align="center">
    	所有学生(共${sysuserCount}位)&nbsp;&nbsp;&nbsp;&nbsp;
    	<c:if test="${sysuserCount!=0}"> 
		当前第${page}页，共${pageCount}页&nbsp;&nbsp;
    	<c:if test="${page!=1}">
  			<a href="${pageContext.request.requestURL}?page=1&sysuser_role=${param.sysuser_role}&sysuser_name=${param.sysuser_name}">首页</a>&nbsp;
  			<a href="${pageContext.request.requestURL}?page=${page-1}&sysuser_role=${param.sysuser_role}&sysuser_name=${param.sysuser_name}">上一页</a>
  		</c:if>
  		<c:if test="${page!=pageCount}">
  			&nbsp;<a href="${pageContext.request.requestURL}?page=${page+1}&sysuser_role=${param.sysuser_role}&sysuser_name=${param.sysuser_name}">下一页</a>
  			&nbsp;<a href="${pageContext.request.requestURL}?page=${pageCount}&sysuser_role=${param.sysuser_role}&sysuser_name=${param.sysuser_name}">尾页</a>）
  		</c:if>
  		</c:if>
    </td>
  </tr>
  <tr>
    <td width="10%" align="center">用户序号</td>
    <td width="20%" align="center">用户名</td>
    <td width="20%" align="center">用户角色</td>
    <td width="20%" align="center">用户姓名</td>
    <td width="15%" align="center">已审核？</td>
    <td width="15%" align="center">删除？</td>
  </tr>
<c:if test="${sysuserRS.rowCount>=1}">
  <c:forEach items="${sysuserRS.rowsByIndex}" var="cucN">
  <tr>
    <td align="center">${cucN[0]}</td>
    <td align="center">${cucN[1]}</td>
    <td align="center">
    	<c:if test="${cucN[2]==1}">系统管理员</c:if> 
  		<c:if test="${cucN[2]==2}">教务管理员</c:if>
  		<c:if test="${cucN[2]==3}">教师</c:if>
  		<c:if test="${cucN[2]==4}">学生</c:if>
    </td>
    <td align="center">
    	<c:if test="${cucN[2]==1}">
  			<c:set var="usertruename" value=""/>
  		</c:if>
  		<c:if test="${cucN[2]==2 or cucN[2]==3}">
  			<c:set var="querySQL" 
  				value="select teacher_name from teacher where teacher_id=${cucN[4]}"/>
  			<sql:query sql="${querySQL}" dataSource="${sqlDS}" var="userNameRS"/>
  			<c:set var="usertruename" value="${userNameRS.rowsByIndex[0][0]}"/>
  		</c:if>
  		<c:if test="${cucN[2]==4}">
  			<c:set var="querySQL" 
  				value="select student_name from student where student_id=${cucN[4]}"/>
  			<sql:query sql="${querySQL}" dataSource="${sqlDS}" var="userNameRS"/>
  			<c:set var="usertruename" value="${userNameRS.rowsByIndex[0][0]}"/>
  		</c:if>
  		${usertruename}
    </td>
    <td align="center">
    	<c:if test="${cucN[3]==0}">未审核</c:if>
    	<c:if test="${cucN[3]==1}">已审核</c:if>
    </td>
    <td align="center">
    <a href="sysuser_delete.jsp?sysuser_id=${cucN[0]}" onclick="return delete_confirm()">×</a>
    </td>
  </tr>
  </c:forEach> 
</c:if>  
</table><br>
</body>
</html>
💿 文件大小 10976 K
👤 上传用户 feitiandy001
📂 所属分类 Java编程
🏷️ 相关标签

#JavaWeb #标签 #应用开发 #光盘
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -