?? s_expertinfo.jsp
字號:
<%@ page language="java" import="java.sql.*" contentType="text/html;charset=GB2312"%>
<%
String getLoginmessage=(String)session.getValue("loginSign");
String unit_ID=(String)session.getValue("unitID");
if(getLoginmessage!="OK")
{
response.sendRedirect("index2.jsp");
}
%>
<jsp:useBean id="s_expertInfo" scope="page" class="firm.firm"/>
<%
String identityID=request.getParameter("identityID");
String sql="select * from I_p_info where identityID='"+identityID+"'";
ResultSet rs=s_expertInfo.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();
s_expertInfo.closeStmt();
s_expertInfo.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","外國語言文學",
"0503","新聞傳播學",
"0504","藝術學",
"0600","歷史學",
"0601","歷史學",
"0700","理學",
"0701","數學",
"0702","物理學",
"0703","化學",
"0704","天文學",
"0705","地理學",
"0706","大氣科學",
"0707","海洋科學",
"0708","地球物理學",
"0709","地質學",
"0710","生物學",
"0711","系統科學",
"0712","科學技術史",
"0800","工學",
"0801","力學",
"0802","機械工程",
"0803","光學工程",
"0804","儀器科學與技術",
"0805","材料科學與工程",
"0806","冶金工程",
"0807","動力工程及工程熱物理",
"0808","電氣工程",
"0809","電子科學與技術",
"0810","信息與通信工程",
"0811","控制科學與工程",
"0812","計算機科學與技術",
"0813","建筑學",
"0814","土木工程",
"0815","水利工程",
"0816","測繪科學與技術",
"0817","化學工程與技術",
"0818","地質資源與地質工程",
"0819","礦業工程",
"0820","石油與天然氣工程",
"0900","農學",
"0901","作物學",
"0902","園藝學",
"0903","農業資源利用",
"0904","植物保護",
"0905","畜牧學",
"0906","獸醫學",
"0907","林學",
"0908","水產",
"1000","醫學",
"1001","基礎醫學",
"1002","臨床醫學",
"1003","口腔醫學",
"1004","公共衛生與預防醫學",
"1005","中醫學",
"1006","中西醫結合",
"1007","藥學",
"1008","中藥學",
"1100","軍事學",
"1101","軍事",
"1200","管理學",
"1201","管理科學與工程",
"1202","工商管理");
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" width="50%"><font color="#000099"><%=expert_name1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center"><font color="#000099">身份證號</font></td>
<td bgcolor="#f2f2f2" colspan="2" width="50%"><font color="#000099"><%=identityID1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center"><font color="#000099">性 別</font></td>
<td colspan="2" width="50%"><font color="#000099"><%=sex1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center"><font color="#000099">民 族</font></td>
<td bgcolor="#f2f2f2" colspan="2" width="50%"><font color="#000099"><%=nation1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center"> <font color="#000099">出生日期</font></td>
<td colspan="2" width="50%"><font color="#000099"><%=bir_year%>年<%=bir_month%>月<%=bir_day%>日</font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center"><font color="#000099">單位代碼</font></td>
<td colspan="2" width="50%"><font color="#000099"><%=unit_ID1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center"><font color="#000099">所在單位</font></td>
<td bgcolor="#f2f2f2" colspan="2" width="50%"><font color="#000099"><%=unit_name1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center"><font color="#000099">職 稱</font></td>
<td colspan="2" width="50%"><font color="#000099"><%=grade1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center"><font color="#000099">研究領域</font></td>
<td bgcolor="#f2f2f2" colspan="2" width="50%"> <font color="#000099"><%=domain1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center"><font color="#000099">適評專業</font></td>
<td colspan="2" width="50%"> <font color="#000099">
<script language="javascript">showSort(OptSort,"<%=sort1%>");showbank();showSort(OptSort,"<%=sort2%>");</script>
</font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center"><font color="#000099">E
- mail</font></td>
<td bgcolor="#f2f2f2" colspan="2" width="50%"><font color="#000099"><%=email1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center"><font color="#000099">聯系地址</font></td>
<td colspan="2" width="50%"><font color="#000099"><%=address1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center"><font color="#000099">郵政編碼</font></td>
<td bgcolor="#f2f2f2" colspan="2" width="50%"><font color="#000099"><%=zipcode1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center"><font color="#000099">電 話</font></td>
<td colspan="2" width="50%"><font color="#000099"><%=tel1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center"><font color="#000099">簡 介</font></td>
<td bgcolor="#f2f2f2" colspan="2" width="50%"><font color="#000099"><%=introduction1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center" colspan="3"> </td>
</tr>
<tr>
<tr>
<td bgcolor="#d9d8dc" align="center" colspan="3"> <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 + -