📄 p_showinfo.jsp
字号:
<%@ page language="java" import="java.sql.*"contentType="text/html;charset=GB2312"%>
<%
String getLoginmessage=(String)session.getValue("p_loginSign");
String identityID=(String)session.getValue("identityID");
if(getLoginmessage!="OK")
{
response.sendRedirect("index3.jsp");
}
%>
<jsp:useBean id="p_showinfo" scope="page" class="firm.firm"/>
<%
String itemID=request.getParameter("itemID");
String sql="select * from I_p_info where identityID='"+identityID+"'";
ResultSet rs=p_showinfo.executeQuery(sql);
//定义数据类型并初始化
String expert_name1=""; //专家姓名
String identityID1=""; //身份证号
String sex1=""; //性别
String nation1=""; //民族
String bir_date1=""; //生日
String unit_ID1=""; //单位代码
String unit_name1=""; //所在单位
String grade1=""; //职称
String domain1=""; //研究领域
String sort1=""; //适评专业
String sort2=""; //适评专业
String email1=""; //E-mail
String address1=""; //住址
String zipcode1=""; //邮编
String tel1=""; //电话
String introduction1=""; //介绍
if(rs.next())
{
identityID1=rs.getString("identityID");
expert_name1=rs.getString("expert_name");
sex1=rs.getString("sex");
nation1=rs.getString("nation");
bir_date1=rs.getString("bir_date");
unit_ID1=rs.getString("unit_ID");
unit_name1=rs.getString("unit_name");
grade1=rs.getString("grade");
domain1=rs.getString("domain");
sort1=rs.getString("sort1");
sort2=rs.getString("sort2");
email1=rs.getString("email");
address1=rs.getString("address");
zipcode1=rs.getString("zipcode");
tel1=rs.getString("tel");
introduction1=rs.getString("introduction");
rs.close();
p_showinfo.closeStmt();
p_showinfo.closeConn();
}
String bir_year=bir_date1.substring(0,4);
String bir_month=bir_date1.substring(5,7);
String bir_day=bir_date1.substring(8,10);
%>
<html>
<head>
<title>专家信息</title>
<SCRIPT language=javascript>
<!--
OptSort = new Array(
"0100","网络",
"0101","软件外包",
"0200","经营管理",
"0201","公司硬件设施",
"0202","员工交通",
"0300","员工住宿",
"0301","员工工资",
"0302","节假日补助",
"0303","公司发展战略",
"0304","软件系统",
"0400","招聘新员工",
"0401","成立新部门",
"0402","公司管理制度",
"0403","公司财务管理",
"0500","公司人事管理",
"0501","公司销售部门",
"0502","公司质检部门" );
function showSort()
{
var i,len,start,step,s1,a,args=showSort.arguments;
var name;
a=args[0];
s1=args[1];
start=0;
step=2;
len=a.length;
for(i=0;i<len;i+=step)
{
if(a[i]==s1)
{
name=a[i+1];
break;
}
else name="";
}
document.writeln(name);
}
function showbank()
{
document.writeln("");
}
//-->
</SCRIPT>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div align="center">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#000099">
<table width="650" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#FFFFFF">
<td colspan="3"> </td>
</tr>
<tr>
<td colspan="3"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="3"> </td>
</tr>
<tr>
<td width="33%"> </td>
<td bgcolor="#FFFFFF">
<div align="center"><img src="../images/p_expertinfo.gif" width="112" height="22"></div>
</td>
<td width="33%"> </td>
</tr>
</table>
<table width="650" border="0" cellspacing="1" cellpadding="0" height="120">
<tr>
<td height="179" bgcolor="#FFFFFF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5"> </td>
</tr>
</table>
<table width="95%" border="0" cellspacing="0" cellpadding="0" align="center" height="151">
<tr>
<td>
<table width="95%" border="0" cellspacing="1" cellpadding="1" align="center">
<tr>
<td colspan="3" bgcolor="#d9d8dc"> </td>
</tr>
<tr>
<td bgcolor="#d9d8dc" width="21%" align="center"> <font color="#000099">专家姓名</font></td>
<td colspan="2"><font color="#000099"><%=expert_name1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center" width="21%"><font color="#000099">身份证号</font></td>
<td bgcolor="#f2f2f2" colspan="2"><font color="#000099"><%=identityID1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center" width="21%"><font color="#000099">性 别</font></td>
<td colspan="2"><font color="#000099"><%=sex1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center" width="21%"><font color="#000099">民 族</font></td>
<td bgcolor="#f2f2f2" colspan="2"><font color="#000099"><%=nation1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center" width="21%"> <font color="#000099">出生日期</font></td>
<td colspan="2"><font color="#000099"><%=bir_year%>年<%=bir_month%>月<%=bir_day%>日</font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center" width="21%"><font color="#000099">单位代码</font></td>
<td colspan="2"><font color="#000099"><%=unit_ID1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center" width="21%"><font color="#000099">所在单位</font></td>
<td bgcolor="#f2f2f2" colspan="2"><font color="#000099"><%=unit_name1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center" width="21%"><font color="#000099">职 称</font></td>
<td colspan="2"><font color="#000099"><%=grade1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center" width="21%"><font color="#000099">研究领域</font></td>
<td bgcolor="#f2f2f2" colspan="2"> <font color="#000099"><%=domain1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center" width="21%"><font color="#000099">适评专业</font></td>
<td colspan="2"> <font color="#000099">
<script language="javascript">showSort(OptSort,"<%=sort1%>");showbank();showSort(OptSort,"<%=sort2%>");</script>
</font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center" width="21%"><font color="#000099">E
- mail</font></td>
<td bgcolor="#f2f2f2" colspan="2"><font color="#000099"><%=email1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center" width="21%"><font color="#000099">联系地址</font></td>
<td colspan="2"><font color="#000099"><%=address1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center" width="21%"><font color="#000099">邮政编码</font></td>
<td bgcolor="#f2f2f2" colspan="2"><font color="#000099"><%=zipcode1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center" width="21%"><font color="#000099">电 话</font></td>
<td colspan="2"><font color="#000099"><%=tel1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center" width="21%"><font color="#000099">简 介</font></td>
<td bgcolor="#f2f2f2" colspan="2"><font color="#000099"><%=introduction1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center" colspan="3"> </td>
</tr>
<tr>
<td bgcolor="#d9d8dc" colspan="2" align="right"><a href="p_changeInfo.jsp"><img src="../images/change.gif" width="62" height="22" border="0"></a> </td>
<td bgcolor="#d9d8dc" width="50%">
<INPUT onclick=javascript:window.close(); type=image src="../images/close.gif" width="62" height="22">
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -