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

📄 lease_list.jsp

📁 数据库系统教材中附录的课程设计accomodation宿舍管理系统源码
💻 JSP
字号:
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="cn.kmp.accommodation.service.*"%>
<%@ page import="cn.kmp.accommodation.domain.*" %>
<%@ page import="com.littleQworks.commons.util.*" %>
<%
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 'lease_list.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>&nbsp; 
<% 
	LeaseService leaseService=ServiceFactory.getLeaseService();
	StudentService ss=ServiceFactory.getStudentService();
	List<Lease> all=leaseService.getAllLeases();
	List<Lease> ll=leaseService.getLeasesByDuration();
	
	DateTimeUtils dtime=UtilsFactory.getInstance().getDateTimeUtils();
	String date=dtime.getDate();
%>
<div id="container">
	<div id="all">
	<h3>所有租约</h3>
		<table border="1">
			<tr>
				<td>床位号</td>
				<td>房间号</td>
				<td>学生号</td>
				<td>学生名</td>
				<td>租期</td>
				<td>入住日期</td>
				<td>退房日期</td>
				<td>学年</td>
				<td>状态</td>
				<td colspan="3">操作</td>
			</tr>
		<%for(Lease l:all){
			Student st=ss.getStudentByStudentNum(l.getStudentNum());
			String name=st.getLname()+st.getFname();
			String status=null;
			if(date.compareTo(l.getLeaveTime())<=0)status="有效";
			else status="过期";
		%>
			<tr>
				<td><%=l.getPlaceNum() %></td>
				<td><%=l.getRoomNum() %></td>
				<td><%=st.getStudentNum() %></td>
				<td><%=name %></td>
				<td><%=l.getDuration() %></td>
				<td><%=l.getEnterTime() %></td>
				<td><%=l.getLeaveTime() %></td>
				<td><%=l.getSchoolYear() %></td>
				<td><%=status %></td>
				<td><a href="<%=basePath %>jsp/edit_lease.jsp?leaseNum=<%=l.getLeaseNum() %>"/>编辑</a></td>
				<td><a href="<%=basePath %>deleteLease.do?leaseNum=<%=l.getLeaseNum() %>" onclick="{if(confirm('确定要删除吗?')){return true;}return false;}">删除</a></td>
				<td><a href="<%=basePath %>jsp/insert_invoice.jsp?leaseNum=<%=l.getLeaseNum() %>">账单</a></td>
			</tr>
		<%} %>
		</table>
	</div>
	<div id="vocation">
	<h3>暑假租约</h3>
		<table border="1">
			<tr>
				<td>床位号</td>
				<td>房间号</td>
				<td>学生号</td>
				<td>学生名</td>
				<td>租期</td>
				<td>入住日期</td>
				<td>退房日期</td>
				<td>学年</td>
				<td>状态</td>
				<td colspan="3">操作</td>
			</tr>
		<%for(Lease l:ll){
			Student st=ss.getStudentByStudentNum(l.getStudentNum());
			String name=st.getLname()+st.getFname();
			String status=null;
			if(date.compareTo(l.getLeaveTime())<=0)status="有效";
			else status="过期";
		%>
			<tr>
				<td><%=l.getPlaceNum() %></td>
				<td><%=l.getRoomNum() %></td>
				<td><%=st.getStudentNum() %></td>
				<td><%=name %></td>
				<td><%=l.getDuration() %></td>
				<td><%=l.getEnterTime() %></td>
				<td><%=l.getLeaveTime() %></td>
				<td><%=l.getSchoolYear() %></td>
				<td><%=status %></td>
				<td><a href="<%=basePath %>jsp/edit_lease.jsp?leaseNum=<%=l.getLeaseNum() %>"/>编辑</a></td>
				<td><a href="<%=basePath %>jsp/deleteLease.do?leaseNum=<%=l.getLeaseNum() %>" onclick="{if(confirm('确定要删除吗?')){return true;}return false;}">删除</a></td>
				<td><a href="<%=basePath %>jsp/insert_invoice.jsp?leaseNum=<%=l.getLeaseNum() %>">账单</a></td>
			</tr>
		<%} %>
		</table>
	</div>
</div>
</body>
</html>

⌨️ 快捷键说明

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