📄 teacherlist.jsp
字号:
<%@page language="java" contentType="text/html; charset=GBK"%>
<%@page import="java.sql.*"%>
<html>
<head>
<title>教师列表</title>
<style type="text/css">
<!--
.STYLE2 {
font-size: 12px;
}
.STYLE5 {font-size: 12px}
-->
</style>
<link rel="stylesheet" href="style.css" type="text/css">
<style type="text/css">
<!--
.STYLE6 {color: #FF0000}
-->
</style>
</head>
<jsp:useBean id="grades" scope="page" class="edu.GradeBean" />
<jsp:useBean id="classs" scope="page" class="edu.ClassBean" />
<jsp:useBean id="subjects" scope="page" class="edu.SubjectBean" />
<jsp:useBean id="uteacher" scope="page" class="edu.UteacherBean" />
<jsp:useBean id="teacher" scope="page" class="edu.TeacherBean" />
<body>
<div align="center">
<table height="160" width="770" border="0" cellspacing="1"
align="center">
<tr>
<td><iframe name="top" height="160" width="770" scrolling="no"
src="top.jsp" frameborder="0"></iframe></td>
</tr>
</table>
</div>
<%
int id,ut_id=0,grade_id=0,class_id=0,subject_id=0;
int allrow=0,pagesize=4, intpage=1;
String name=null,psw="",address="",age="",sex="",email="",idcard="",mobile="",allow="";
String grade="",classname="",subject="",about="",photo="";
try{
intpage=Integer.valueOf(request.getParameter("intpage")).intValue();
}catch(NumberFormatException e){}
ResultSet rs=uteacher.getCount();
if(rs.next())
allrow=rs.getInt(1);
int allpage = (allrow+pagesize-1) / pagesize;
// 调整待显示的页码
if(intpage>allpage) intpage = allpage;
if(intpage<1) intpage = 1;
int startrow=(intpage-1)*pagesize;
uteacher.setStartpage(startrow);
uteacher.setPagesize(pagesize);
%>
<center><font size="+2" face="华文行楷">教师列表</font></center>
<div align="center">
<table width="750" border="0" cellspacing="1">
<%
rs = uteacher.getTeacher();
int i=0;
while(rs.next()){
ut_id=rs.getInt("t_id");
about=rs.getString("t_about");
ResultSet rss = teacher.getTeachers(ut_id);
if(rss.next())
{
id=rss.getInt("t_id");
name=rss.getString("t_teacher");
photo=rss.getString("t_photo");
address=rss.getString("t_address");
age=rss.getString("t_age");
sex=rss.getString("t_sex");
idcard=rss.getString("t_idcard");
mobile=rss.getString("t_mobile");
email=rss.getString("t_email");
grade_id=rss.getInt("grade_id");
class_id=rss.getInt("class_id");
subject_id=rss.getInt("subject_id");
if(email==null || email.equals(""))
email="没有";
allow=rss.getString("t_allow");
}
%>
<%if(i%2==0){ %>
<tr>
<%}
%>
<td nowrap>
<table width="360" border="0" cellspacing="1" bgcolor="#EBEBEB">
<tr>
<td width="121" rowspan="6" align="left" valign="top"
bgcolor="#FFFFFF"><img name="photo"
src="<%if(photo!=""&&photo!=null){ %>uploadfile/images/<%=photo%><%}else{ %>images/dlbj173149.gif<%} %>"
width="120" height="120" alt="照片"></td>
<td width="51" bgcolor="#FFFFFF"><span class="STYLE2">教师名：</span></td>
<td width="174" bgcolor="#FFFFFF"><span class="STYLE2"><%=name %></span></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><span class="STYLE2">年 龄：</span></td>
<td bgcolor="#FFFFFF"><span class="STYLE2"><%=age %></span></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><span class="STYLE2">性 别：</span></td>
<td bgcolor="#FFFFFF"><span class="STYLE2"><%=sex %></span></td>
</tr>
<tr>
<%
ResultSet rs_class=classs.getClasss(class_id);
rs_class.next();
classname=rs_class.getString("class");
ResultSet rs_subject=subjects.getSubjects(subject_id);
rs_subject.next();
subject=rs_subject.getString("subject");
ResultSet rs_grade=grades.getGrades(grade_id);
rs_grade.next();
grade=rs_grade.getString("grade");
%>
<td bgcolor="#FFFFFF"><span class="STYLE2">专 辅：</span></td>
<td bgcolor="#FFFFFF"><span class="STYLE2"><%=grade %> <%=classname %>
<%=subject %></span></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><span class="STYLE2">E-mail：</span></td>
<td bgcolor="#FFFFFF"><span class="STYLE2"><%=email %></span></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><span class="STYLE2">地 址：</span></td>
<td bgcolor="#FFFFFF"><span class="STYLE2"><%=address %></span></td>
</tr>
<tr>
<td colspan="3" bgcolor="#FFFFFF"><span class="STYLE5"><span
class="STYLE2">简 介：</span><%=about %></span></td>
</tr>
</table>
</td>
<%if(i%2!=0){ %>
</tr>
<%}i++;
} %>
</table>
</div>
<div align="center">
<table width="750" border="0">
<tr>
<td width="30%" height="30">
<div align="center">共<span class="STYLE6"><%=allrow %></span>条记录 当前第<span class="STYLE6"><%=intpage %></span>页/共<span class="STYLE6"><%=allpage %></span>页</div></td>
<td width="70%"><div align="center"><a href="teacherlist.jsp">首页</a>
<%int tenpage=((int)(intpage/10))*10;
if(intpage-10>0) {%>
<a href="teacherlist.jsp?intpage=<%=intpage-10%>">上十页</a>
<%} %>
<a href="teacherlist.jsp?intpage=<%=intpage-1%>">上一页</a>
<%if(tenpage+10<=allpage){
for(int ii=1;ii<=10;ii++){%>
<a href="teacherlist.jsp?intpage=<%=tenpage+ii %>"><%=tenpage+ii %></a>
<%}}if(tenpage+10>allpage){
for(int ii=1;ii+tenpage<=allpage;ii++){%>
<a href="teacherlist.jsp?intpage=<%=tenpage+ii %>"><%=tenpage+ii %></a>
<%}} %>
<a href="teacherlist.jsp?intpage=<%=intpage+1%>">下一页</a>
<%if(intpage+10<=allpage) {%>
<a href="teacherlist.jsp?intpage=<%=intpage+10%>">下十页</a>
<%} %>
<a href="teacherlist.jsp?intpage=<%=allpage%>">尾页</a></div></td>
</tr>
</table></div>
<div align="center">
<table height="155" width="750" border="0" cellspacing="1"
align="center">
<tr>
<td><iframe name="bottom" height="155" width="750" scrolling="no"
src="bottom.jsp" frameborder="0"></iframe></td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -