?? 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 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 + -