⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 category_search.jsp

📁 数据库系统教材中附录的课程设计accomodation宿舍管理系统源码
💻 JSP
字号:
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="cn.kmp.accommodation.domain.*" %>
<%@ page import="cn.kmp.accommodation.service.*" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'category_search.jsp' starting page</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<link rel="stylesheet" type="text/css" href="<%=basePath %>styles/list.css">

  </head>
  
  <body>
   
   	<%
   		StudentService studentService=ServiceFactory.getStudentService();
   		int status,category;
   		if(request.getParameter("status")==null||request.getParameter("status").equals("")){
   			status=-1;
   		}
   		else{
   			status=Integer.parseInt(request.getParameter("status"));
   		}
   		if(request.getParameter("category")==null||request.getParameter("category").equals("")){
   			category=-1;
   		}
   		else{
   			category=Integer.parseInt(request.getParameter("category"));
   		}
   		int studentCategoryNum=studentService.getStudentNumberByCategory(category);
   		int studentNum=studentService.getAllStudentNumber();
   		List<Student> studentList=studentService.categorySearch(category,status);
   	 %>
   <div id="container">
   	<div id="search">
   		<form action="<%=basePath %>jsp/studentManage/category_search.jsp" method="post">
   			<table>
   				<tr>
   					<td><h2>类别搜索</h2></td>
   				</tr>
   				<tr>
   					<td>学生类型
   						<select name="category">
   							<option value=""<%if(category<0){ %>selected<%} %>>所有</option>
							<option value="1"<%if(category==1){ %>selected<%} %>>大一</option>
							<option value="2"<%if(category==2){ %>selected<%} %>>大二</option>
							<option value="3"<%if(category==3){ %>selected<%} %>>大三</option>
							<option value="4"<%if(category==4){ %>selected<%} %>>大四</option>
							<option value="5"<%if(category==5){ %>selected<%} %>>研一</option>
							<option value="6"<%if(category==6){ %>selected<%} %>>研二</option>
							<option value="7"<%if(category==7){ %>selected<%} %>>研三</option>
						</select>
   					</td>
   					<td>住宿情况</td>
   					<td>
   						<select name="status">
   							<option value=""<%if(status<0){ %>selected<%} %>>所有</option>
   							<option value="0"<%if(status==0){ %>selected<%} %>>未安排住宿</option>
   							<option value="1"<%if(status==1){ %>selected<%} %>>已经安排住宿</option>
   						</select>
   					</td>
   					<td>
   						<input type="submit" name="submit" value="Go"/>
   					</td>
   				</tr>
   			</table>
   		</form>
   	</div>
   	<div id="list">
   		<table border>
    				<tr>
    					<th colspan="8">
    						<%
    							if(category<0){
    						 %>
    						 	学生信息(<%=studentNum %> 人)
    						 <%} %>
    						 <%if(category>0){ %>
    						 	学生信息(<%=studentCategoryNum %>人)
    						 <%} %>
    					</th>
    				</tr>
    				<tr>
    					<th>学号</th>
    					<th>名字</th>
    					<th>状态</th>
    					<th>性别</th>
    					<th>国籍</th>
    					<th>住址</th>
    					<th>查看详细信息</th>
    					<th>操作</th>
    				</tr>
    			<%for(Student student:studentList){ %>
    				<tr>
    					<td>
    						<%=student.getStudentNum() %>
    					</td>
    					<td>
    						<%=student.getLname() %><%=student.getFname()%>
    					</td>
    					<td>
    						<%if(student.getStatus()==0){ %>
    						未安排住宿
    					<%} %>
    					<%if(student.getStatus()==1){%>
    						已安排住宿
    					<%} %>
    					</td>
    					<td>
    						<%=student.getSex() %>
						</td>
    					<td>
    						<%=student.getNationality() %>
    					</td>
    					<td>
    						<%=student.getCity() %><%=student.getStreet() %>
    					</td>
    					<td>
    						<a href="<%=basePath %>jsp/studentManage/detail_information.jsp?studentNum=<%=student.getStudentNum() %>">查看详细信息</a>
    					</td>
    					<td>
    						<a href="<%=basePath %>/jsp/deleteStudent.do?studentNum=<%=student.getStudentNum() %>" onclick="{if(confirm('确定要删除吗?')){return true;}return false;}">[删除]</a>
    						<a href="<%=basePath %>jsp/studentManage/edit_student.jsp?studentNum=<%=student.getStudentNum() %>">[修改]</a>
    					</td>
    				</tr>
    			<%
    			}
    			%>
    		</table>
   	</div>
   </div>
  </body>
</html>

⌨️ 快捷键说明

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