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

📄 detail_information.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 'detail_information.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="<%=path %>/styles/studentinformation.css">

  </head>
  
  <body>
  <div id="container">
  	<div id="instruction1">
  		<table align="left">
  			<tr>
  				<td>学生信息管理导航--&gt;</td>
  				<td>学生顾问信息</td>
  			</tr>
  		</table>
  	</div>
  	<div id="list1">
  		<table border>
  			<tr>
  				<th colspan="5">学生顾问信息</th>
  			</tr>
  			<tr>
  				<th>学号</th>
  				<th>学生名</th>
  				<th>学生顾问名</th>
  				<th>顾问联系方式</th>
  				<th>操作</th>
  			</tr>
  			<%
  				StudentService studentService=ServiceFactory.getStudentService();
  				AdvisorService advisorService=ServiceFactory.getAdvisorService();
  				int studentNum=Integer.parseInt(request.getParameter("studentNum"));
  				Advisor advisor=advisorService.getAdvisorByStudentNum(studentNum);
  				Student student=studentService.getStudentByStudentNum(studentNum);
  			%>
  			<tr>
  				<td><%=student.getStudentNum() %></td>
  				<td><%=student.getLname() %><%=student.getFname() %></td>
  				<td><%=advisor.getAdvisorName() %></td>
  				<td><%=advisor.getPhoneNumber() %></td>
  				<td>
  					<a href="<%=basePath %>jsp/studentManage/edit_advisor.jsp?advisorNum=<%=advisor.getAdvisorNum() %>">[修改]</a>
  					<a href="<%=basePath %>jsp/deleteAdvisor.do?advisorNum=<%=advisor.getAdvisorNum() %>" onclick="{if(confirm('确定要删除吗?')){return true;}return false;}" >
  						[删除]
  					</a>
  				</td>
  			</tr>
  		</table>
  	</div>
  	<div id="instruction2">
  		<table align="left">
  			<tr>
  				<td>学生信息管理导航</td>
  				<td>--></td>
  				<td>家长信息</td>
  			</tr>
  		</table>
  	</div>
  	<div id="list2">
  		<table border>
  			<tr>
  				<th colspan="6">家长信息管理</th>
  			</tr>
  			<tr>
  				<th>学号</th>
  				<th>学生名</th>
  				<th>关系</th>
  				<th>家长名</th>
  				<th>联系方式</th>
  				<th>操作</th>
  			</tr>
  			<%
  				FamilyService familyService=ServiceFactory.getFamilyService();
  				List<Family> familyList=familyService.getFamilyByStudentNum(studentNum);
  			 %>
  			<%
				for(Family family: familyList){  			
  			 %>
  			 <tr>
  			 	<td><%=student.getStudentNum() %></td>
  			 	<td><%=student.getLname() %><%=student.getFname() %></td>
  			 	<td><%=family.getRelationship() %></td>
  			 	<td><%=family.getName() %></td>
  			 	<td><%=family.getPhoneNumber() %></td>
  			 	<td>
  			 		<a href="<%=basePath %>/jsp/studentManage/edit_family.jsp?familyNum=<%=family.getFamilyNum() %>">[修改]</a>
  			 		<a href="<%=basePath %>/jsp/deleteFamily.do?familyNum=<%=family.getFamilyNum() %>" onclick="{if(confirm('确定要删除吗?')){return true;}return false;}">[删除]</a></td>
  			 </tr>
  			 <%
  			 }
  			 %>
  		</table>
  	</div>
  	<div id="instruction3">
  			<table align="left">
  				<tr>
  					<td>学生信息管理导航</td>
  					<td>--></td>
  					<td>课程信息</td>
  				</tr>
  			</table>
  		</div>
  		<div id="list3">
  			<table border>
  				<tr>
  					<th colspan="7">学生课程信息</th>
  				</tr>
  				<tr>
  					<th>学号</th>
  					<th>学名</th>
  					<th>学年</th>
  					<th>课程名</th>
  					<th>课程负责人</th>
  					<th>负责人联系方式</th>
  					<th>操作</th>
  				</tr>
  				<%
  				 	CourseLeaderService courseLeaderService=ServiceFactory.getCourseLeaderService();
  				 	TakeCourseService takeCourseService=ServiceFactory.getTakeCourseService();
  				 	CourseService courseService=ServiceFactory.getCourseService();
  				 	List<TakeCourse> takeCourseList=takeCourseService.getTakeCourseByStudentNum(studentNum);
  				 %>
  				 <%
  				  for(TakeCourse takeCourse:takeCourseList){
  				  	Course course=courseService.getCourseByCourseNum(takeCourse.getCourseNum());
  				  	CourseLeader courseLeader=courseLeaderService.getCourseLeaderByCourseNum(course.getCourseNum());
  				 %>
  				 <tr>
  				 	<td><%=student.getStudentNum() %></td>
  				 	<td><%=student.getLname() %><%=student.getFname() %></td>
  				 	<td><%=takeCourse.getSchoolYear() %>年<%=takeCourse.getSemester() %>学期</td>
  				 	<td><%=course.getCourseTitle() %></td>
  				 	<td><%=courseLeader.getLname() %><%=courseLeader.getFname() %></td>
  				 	<td><%=courseLeader.getPhoneNumber() %></td>
  				 	<td>
  				 		<a href="<%=path %>/jsp/studentManage/edit_takeCourse.jsp?studentNum=<%=student.getStudentNum() %>&courseNum=<%=course.getCourseNum() %>&schoolYear=<%=takeCourse.getSchoolYear() %>&semester=<%=takeCourse.getSemester() %>">
  				 			[修改]
  				 		</a>
  				 		<a href="<%=path %>/jsp/deleteTakeCourse.do?studentNum=<%=student.getStudentNum() %>&courseNum=<%=course.getCourseNum() %>&schoolYear=<%=takeCourse.getSchoolYear() %>&semester=<%=takeCourse.getSemester() %>" onclick="{if(confirm('确定要删除吗?')){return true;}return false;}">
  				 			[删除]
  				 		</a>
  				 	</td>
  				 </tr>
  				 <%
  				  	}
  				  %>
  			</table>
  			<h4 align="left"><a href="javascript:history.back(-1)">返回</a></h4>
  		</div> 
  </div>
  </body>
</html>

⌨️ 快捷键说明

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