📄 user_info.jsp
字号:
<%
/*---------------------------------------------
功能描述:用户信息
编写时间:2003-08-20
编写人:侯雄飞
email:houxf@whaty.com
修改情况记录
修改时间： 修改内容： 修改人：
-----------------------------------------------*/
%>
<%@ page language="java" %>
<%@ page contentType="text/html;charset=gb2312" %>
<%
//////////////////////////////////////////////////////////////
// Privilege Guarding
String PrivXP="浏览学生";
String PrivME="00104";
%>
<%@ include file="../pub/privGuarding.jsp" %>
<%
// Privilege Guarding
//////////////////////////////////////////////////////////////
%>
<jsp:useBean id="work" scope="application" class="com.dbConnection.dbpool"/>
<%!
//判断字符串为空的话，赋值为"不详"
String fixnull(String str)
{
if(str == null || str.equals("null") || str.equals("null"))
str = "不详";
return str;
}
String fixnull2(String str)
{
if(str == null || str.equals("null") || str.equals("null"))
str = "0";
return str;
}
%>
<%
String id = request.getParameter("id");
String sql = "";
int count = 0;
com.dbConnection.MyResultSet rs;
sql = "select u.id as id,u.name as name,u.password as password,u.id_card as id_card,u.email as email,u.phone as phone,u.address as address,u.zip_address as zip_address,u.gender as gender,u.work_place as work_place,u.position as position,u.title as title,u.edu as edu,u.red_date as red_date,u.comfirm_date as comfirm_date,u.user_type as user_type,u.status as status,u.birthday as birthday,u.note as note,u.graduated_time as graduated_time,u.graduated_sch as graduated_sch,u.graduated_major as graduated_major,u.folk as folk,u.zzmm as zzmm,u.hometown as hometown,u.degree_flag as degree_flag,u.nickname as nickname,u.reg_no as reg_no,u.entrance_date as entrance_date,u.begin_date as begin_date,u.alteration as alteration,u.remark as remark,u.email_flag as email_flag,m.name as m_name,g.name as g_name,s.name as s_name,e.name as e_name,u.photo_link as photo_link,u.oldsite as oldsite,v.name as oldsitename from (select id,name,password,id_card,email,phone,address,zip_address,gender,work_place,position,title,edu,red_date,to_char(comfirm_date,'yyyy-mm-dd') as comfirm_date,user_type,status,login_num,to_char(last_login_time,'yyyy-mm-dd') as last_login_time,last_login_ip,birthday,site,note,to_char(graduated_time,'yyyy-mm-dd') as graduated_time,graduated_sch,graduated_major,folk,zzmm,hometown,degree_flag,nickname,isdelete,isgraduated,reg_no,grade_id,to_char(entrance_date,'yyyy-mm-dd') as entrance_date,to_char(begin_date,'yyyy-mm-dd') as begin_date,alteration,remark,email_flag,edu_type_id,major_id,photo_link,oldsite from lrn_user_info where id = '" + id + "') u,(select id,name from lrn_major_info where id<>'0') m,(select id,name from lrn_edu_type) e,(select id,name from lrn_grade_info) g,(select id,name from lrn_site_info) s ,(select id,name from lrn_site_info) v where u.major_id = m.id and u.edu_type_id = e.id and u.grade_id = g.id and u.site = s.id and u.oldsite = v.id(+)";
//out.print(sql);
count = work.countselect(sql);
if(count < 1)
{
out.print("没有符合条件的查询结果");
return;
}
%>
<html>
<head>
<title>学生学籍卡</title>
<link href="../css/style.css" rel=stylesheet type=text/css>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="javascript">
function cfmdel(url)
{
if(confirm("您确定要删除么？"))
window.navigate(url);
}
</script>
</head>
<body bgcolor=FFFFFF leftmargin="0" topmargin="0">
<center>
<%
String name = "";
String password = "";
String id_card = "";
String email = "";
String phone = "";
String address = "";
String zip_address = "";
String gender = "";
String work_place = "";
String position = "";
String title = "";
String edu = "";
String red_date = "";
String comfirm_date = "";
String user_type = "";
String birthday = "";
String note = "";
String graduated_time = "";
String graduated_sch = "";
String graduated_major = "";
String folk = "";
String zzmm = "";
String hometown = "";
String nickname = "";
String entrance_date = "";
String begin_date = "";
String alteration = "";
String remark = "";
String e_name = "";
String m_name = "";
String s_name = "";
String g_name = "";
String photo_link = "";
String oldsite = "";
String oldsitename = "";
String reg_no = "";
rs = work.executeQuery(sql);
while(rs.next())
{
name = rs.getString("name");
password = fixnull(rs.getString("password"));
id_card = fixnull(rs.getString("id_card"));
email = fixnull(rs.getString("email"));
phone = fixnull(rs.getString("phone"));
address = fixnull(rs.getString("address"));
zip_address = fixnull(rs.getString("zip_address"));
gender = fixnull(rs.getString("gender"));
work_place = fixnull(rs.getString("work_place"));
position = fixnull(rs.getString("position"));
title = fixnull(rs.getString("title"));
edu = fixnull(rs.getString("edu"));
red_date = fixnull(rs.getString("red_date"));
comfirm_date = fixnull(rs.getString("comfirm_date"));
user_type = fixnull(rs.getString("user_type"));
birthday = fixnull(rs.getString("birthday"));
note = fixnull(rs.getString("note"));
graduated_time = fixnull(rs.getString("graduated_time"));
graduated_sch = fixnull(rs.getString("graduated_sch"));
graduated_major = fixnull(rs.getString("graduated_major"));
folk = fixnull(rs.getString("folk"));
zzmm = fixnull(rs.getString("zzmm"));
hometown = fixnull(rs.getString("hometown"));
nickname = fixnull(rs.getString("nickname"));
entrance_date = fixnull(rs.getString("entrance_date"));
begin_date = fixnull(rs.getString("begin_date"));
alteration = fixnull(rs.getString("alteration"));
remark = fixnull(rs.getString("remark"));
e_name = rs.getString("e_name");
m_name = rs.getString("m_name");
s_name = rs.getString("s_name");
g_name = rs.getString("g_name");
photo_link = fixnull(rs.getString("photo_link"));
oldsite = fixnull(rs.getString("oldsite"));
oldsitename = fixnull(rs.getString("oldsitename"));
reg_no = rs.getString("reg_no");
%>
<br>
学生注册信息表 <br>
照片：<%=photo_link%>
<table width="722" border=0 align=center cellPadding=2 cellSpacing=1 bgColor=3F6C61>
<tr>
<td width=16 class="t12_14_bgE3EAE9">学号</td>
<td width="128" class="t08_bgwhite_p2"> <%=reg_no%></td>
<td width=32 class="t12_14_bgE3EAE9">姓名</td>
<td width="16" class="t08_bgwhite_p2"><%=name%></td>
<td width=32 class="t12_14_bgE3EAE9"> 密码</td>
<td width="48" class="t08_bgwhite_p2"><%=password%> </td>
<td width=16 class="t12_14_bgE3EAE9">身份证号码</td>
<td width="176" class="t08_bgwhite_p2"><%=id_card%></td>
<td width=16 class="t12_14_bgE3EAE9">性别</td>
<td width="72" class="t08_bgwhite_p2"> <%=gender%></td>
<td width=16 class="t12_14_bgE3EAE9">出生日期</td>
<td width="56" class="t08_bgwhite_p2"> <%=birthday%></td>
</tr>
<tr>
<td width=16 class="t12_14_bgE3EAE9">所在站点</td>
<td width="128" class="t08_bgwhite_p2"><br>
<%=s_name%></td>
<td width=32 class="t12_14_bgE3EAE9">专业</td>
<td width="16" class="t08_bgwhite_p2"> <%=m_name%></td>
<td width=32 class="t12_14_bgE3EAE9">层次</td>
<td width="48" class="t08_bgwhite_p2"> <%=e_name%></td>
<td width=16 class="t12_14_bgE3EAE9">年级</td>
<td width="176" class="t08_bgwhite_p2"> <%=g_name%></td>
<td width=16 class="t12_14_bgE3EAE9">电子邮件</td>
<td width="72" class="t08_bgwhite_p2"> <%=email%></td>
<td width=16 class="t12_14_bgE3EAE9">入学时间</td>
<td width="56" class="t08_bgwhite_p2"> <%=entrance_date%></td>
</tr>
<tr>
<td width="712" colspan=12 class="t08_bgwhite_p2"> <p align="center"><b>其他信息</b></td>
</tr>
<tr>
<td width=16 class="t12_14_bgE3EAE9">政治面貌</td>
<td width="128" class="t08_bgwhite_p2"> <%=zzmm%></td>
<td width=32 class="t12_14_bgE3EAE9">民族</td>
<td width="16" class="t08_bgwhite_p2"> <%=folk%></td>
<td width=32 class="t12_14_bgE3EAE9">籍贯</td>
<td width="48" class="t08_bgwhite_p2"> <%=hometown%></td>
<td width=16 class="t12_14_bgE3EAE9">通信地址</td>
<td width="176" class="t08_bgwhite_p2"> <%=address%></td>
<td width=16 class="t12_14_bgE3EAE9">邮政编码</td>
<td width="72" class="t08_bgwhite_p2"> <%=zip_address%></td>
<td width=16 class="t12_14_bgE3EAE9">联系电话</td>
<td width="56" class="t08_bgwhite_p2"> <%=phone%></td>
</tr>
<tr>
<td width=16 class="t12_14_bgE3EAE9">入学前学历</td>
<td width="128" class="t08_bgwhite_p2"> <%=edu%></td>
<td width=32 class="t12_14_bgE3EAE9">原毕业学校</td>
<td width="16" class="t08_bgwhite_p2"> <%=graduated_sch%></td>
<td width=32 class="t12_14_bgE3EAE9">原毕业专业</td>
<td width="48" class="t08_bgwhite_p2"> <%=graduated_major%></td>
<td width=16 class="t12_14_bgE3EAE9">工作单位</td>
<td width="176" class="t08_bgwhite_p2"> <%=work_place%></td>
<td width=16 class="t12_14_bgE3EAE9">职务或职称</td>
<td width="72" class="t08_bgwhite_p2">职务:<%=position%><br>
职称:<%=title%></td>
<td width=16 class="t12_14_bgE3EAE9">从事本专业开始时间</td>
<td width="56" class="t08_bgwhite_p2"> <%=begin_date%></td>
</tr>
<tr>
<td width=16 class="t12_14_bgE3EAE9">毕业时间</td>
<td width="128" class="t08_bgwhite_p2"> <%=graduated_time%></td>
<td width=32 class="t12_14_bgE3EAE9">学籍异动（留级、休学）</td>
<td width="16" class="t08_bgwhite_p2"> <%=alteration%></td>
<td width=32 class="t12_14_bgE3EAE9">个人简历（从高中或中专开始填写）</td>
<td width="256" colspan=3 class="t08_bgwhite_p2">
<pre><%=note%></pre></td>
<td width=16 class="t12_14_bgE3EAE9">备注</td>
<td width="160" colspan=3 class="t08_bgwhite_p2">
<pre><%=remark%></pre></td>
</tr>
<tr>
<td class="t12_14_bgE3EAE9">原所属教学点</td>
<td class="t08_bgwhite_p2"><%=oldsitename%></td>
<td class="t12_14_bgE3EAE9"> </td>
<td class="t08_bgwhite_p2"> </td>
<td class="t12_14_bgE3EAE9"> </td>
<td colspan=3 class="t08_bgwhite_p2"> </td>
<td class="t12_14_bgE3EAE9"> </td>
<td colspan=3 class="t08_bgwhite_p2"> </td>
</tr>
<%
}
work.close(rs);
%>
</table>
<p>
<a href="javascript:cfmdel('user_delexe.jsp?id=<%=id%>')">删除 </a>
<a href="user_edit.jsp?id=<%=id%>">修改 </a><a href="../../../mail/mail_register.jsp?id=s<%=reg_no%>&password=<%=password%>&domain=whaty.edu.cn&type=1" target=_blank> 注册email</a> <a href="../../../mail/mail_del.jsp?id=s<%=reg_no%>&password=<%=password%>&domain=whaty.edu.cn&type=1" target=_blank> 删除email</a>
<a href="javascript:window.close()">关闭 </a>
<br>
</center>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -