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

📄 show.jsp

📁 在线教育平台： 从小学
💻 JSP
字号:
🔍 
<%@ page contentType="text/html; charset=gb2312" language="java"
	import="java.sql.*" errorPage=""%>

<jsp:useBean id="user" scope="page" class="edu.UserBean" />
<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="teacher" scope="page" class="edu.TeacherBean" />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>资料</title>
<style type="text/css">
<!--
.STYLE1 {
	font-size: 14px;
	font-weight: bold;
	color: #FFFFFF;
}
.STYLE2 {font-size: 12px}
.STYLE3 {color: #FF0000}
-->
</style>
</head>

<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 userid=0,grade_id=0,class_id=0,subject_id=0;
String name="",age="",email="",address="",sex="",day="",mobile="",idcard="",sort="",gradename="",classname="",subjectname="";
sort=request.getParameter("sort");
try{
userid =Integer.valueOf(request.getParameter("userid")).intValue();
}catch(NumberFormatException e){}
if(userid==0){
	response.sendRedirect("error.jsp");
}
%>
<%if(sort.equals("user")){ %>

<div align="center">
<table width="500" height="20">
	<tr>
		<td></td>
	</tr>
</table>
<table width="500" border="0" cellspacing="1" bgcolor="#DCDCDC">
	<tr>
		<td height="25" colspan="2" bgcolor="#6666CC">
		<div align="center" class="STYLE1">学生资料</div>
		</td>
	</tr>
	<% 
      
      ResultSet rs=user.getUser(userid);
      if(rs.next()){
      name=rs.getString("u_name");
      age=rs.getString("u_age");
      email=rs.getString("u_email");
      address=rs.getString("u_address");
	  sex=rs.getString("u_sex");
	  day=rs.getString("u_day");
      }%>
	<tr>
		<td width="36%" height="22" bgcolor="#FFFFFF">
		<div align="right" class="STYLE2">
		<div align="center">用户名：</div>
		</div>
		</td>
		<td width="64%" height="22" bgcolor="#FFFFFF" class="STYLE2"><label>
		<div align="left"><%=name%></div>
		</label></td>
	</tr>
	<tr>
		<td height="22" bgcolor="#FFFFFF">
		<div align="right" class="STYLE2">
		<div align="center">年龄：</div>
		</div>
		</td>
		<td height="22" bgcolor="#FFFFFF" class="STYLE2"><label>
		<div align="left"><%=age%></div>
		</label></td>
	</tr>
	<tr>
		<td height="22" bgcolor="#FFFFFF">
		<div align="right" class="STYLE2">
		<div align="center">性别：</div>
		</div>
		</td>
		<td height="22" bgcolor="#FFFFFF" class="STYLE2"><label>
		<div align="left"><%=sex%></div>
		</label></td>
	</tr>
	<tr>
		<td height="22" bgcolor="#FFFFFF">
		<div align="right" class="STYLE2">
		<div align="center">注册时间：</div>
		</div>
		</td>
		<td height="22" bgcolor="#FFFFFF" class="STYLE2"><label>
		<div align="left"><%=day%></div>
		</label></td>
	</tr>
	<tr>
		<td height="22" bgcolor="#FFFFFF">
		<div align="right" class="STYLE2">
		<div align="center">E-mail:</div>
		</div>
		</td>
		<td height="22" bgcolor="#FFFFFF" class="STYLE2"><label>
		<div align="left"><%=email%></div>
		</label></td>
	</tr>
	<tr>
		<td height="22" bgcolor="#FFFFFF">
		<div align="right" class="STYLE2">
		<div align="center">详细地址：</div>
		</div>
		</td>
		<td height="22" bgcolor="#FFFFFF" class="STYLE2"><label>
		<div align="left"><%=address%></div>
		</label></td>
	</tr>
</table>
</div>
<%}if(sort.equalsIgnoreCase("teacher")){ %>
<table width="500" height="20" align="center">
	<tr>
		<td></td>
	</tr>
</table>
<table width="500" border="0" align="center" cellspacing="1"
	bgcolor="#DCDCDC">
	<tr>
		<td height="25" colspan="2" bgcolor="#CCCC00">
		<div align="center" class="STYLE1">教师资料</div>
		</td>
	</tr>
	<%

    
ResultSet rs = teacher.getTeachers(userid);
while(rs.next())
{
	//id=rs.getInt("t_id");
	name=rs.getString("t_teacher");
	grade_id=rs.getInt("grade_id");
	class_id=rs.getInt("class_id");
	subject_id=rs.getInt("subject_id");
	address=rs.getString("t_address");
	age=rs.getString("t_age");
	sex=rs.getString("t_sex");
	idcard=rs.getString("t_idcard");
	mobile=rs.getString("t_mobile");
	email=rs.getString("t_email");
	day=rs.getString("t_day");}
%>
	<tr>
		<td width="36%" height="22" bgcolor="#FFFFFF">
		<div align="right" class="STYLE2">
		<div align="center">用户名：</div>
		</div>
		</td>
		<td width="64%" height="22" bgcolor="#FFFFFF" class="STYLE2"><label>
		<div align="left"><%=name %></div>
		</label></td>
	</tr>

	<tr>
		<td height="22" bgcolor="#FFFFFF">
		<div align="right" class="STYLE2">
		<div align="center">主要辅导：</div>
		</div>
		</td>
		<td height="22" bgcolor="#FFFFFF" class="STYLE2">
		<div align="left">
		<%
      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();
      subjectname=rs_subject.getString("subject");
      ResultSet rs_grade=grades.getGrades(grade_id);
      rs_grade.next();
      gradename=rs_grade.getString("grade");
      %>
		<table>
			<tr>
				<td><%=gradename %></td>
				<td><%=classname %></td>
				<td><%=subjectname %></td>
			</tr>
		</table>
		</div>
		</td>
	</tr>
	<tr>
		<td height="22" bgcolor="#FFFFFF">
		<div align="right" class="STYLE2">
		<div align="center">年龄：</div>
		</div>
		</td>
		<td height="22" bgcolor="#FFFFFF" class="STYLE2"><label>
		<div align="left"><%=age %></div>
		</label></td>
	</tr>
	<tr>
		<td height="22" bgcolor="#FFFFFF">
		<div align="right" class="STYLE2">
		<div align="center">性别：</div>
		</div>
		</td>
		<td height="22" bgcolor="#FFFFFF" class="STYLE2"><label>
		<div align="left"><%=sex %></div>
		</label></td>
	</tr>
	<tr>
		<td height="22" bgcolor="#FFFFFF">
		<div align="right" class="STYLE2">
		<div align="center">注册时间：</div>
		</div>
		</td>
		<td height="22" bgcolor="#FFFFFF" class="STYLE2"><label>
		<div align="left"><%=day %></div>
		</label></td>
	</tr>
	<tr>
		<td height="22" bgcolor="#FFFFFF">
		<div align="right" class="STYLE2">
		<div align="center">证件号：</div>
		</div>
		</td>
		<td height="22" bgcolor="#FFFFFF" class="STYLE2"><label>
		<div align="left"><%=idcard %></div>
		</label></td>
	</tr>
	<tr>
		<td height="22" bgcolor="#FFFFFF">
		<div align="right" class="STYLE2">
		<div align="center">联系电话：</div>
		</div>
		</td>
		<td height="22" bgcolor="#FFFFFF" class="STYLE2"><label>
		<div align="left"><%=mobile %></div>
		</label></td>
	</tr>
	<tr>
		<td height="22" bgcolor="#FFFFFF">
		<div align="right" class="STYLE2">
		<div align="center">E-mail:</div>
		</div>
		</td>
		<td height="22" bgcolor="#FFFFFF" class="STYLE2"><label>
		<div align="left"><%=email %></div>
		</label></td>
	</tr>
	<tr>
		<td height="22" bgcolor="#FFFFFF">
		<div align="right" class="STYLE2">
		<div align="center">详细地址：</div>
		</div>
		</td>
		<td height="22" bgcolor="#FFFFFF" class="STYLE2"><label>
		<div align="left"><%=address %></div>
		</label></td>
	</tr>
</table>
<%} %><%if(sort.equals("admin")){ %>
<table width="500" align="center">
<tr><td height="25">&nbsp;</td>
</tr>
<tr>
  <td><div align="center" class="STYLE3">您无权查看管理员资料!</div></td>
</tr>
</table>
<%} %>
<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 + -