?? p_showitem.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_showitem" scope="page" class="firm.firm"/>
<%
String itemID=request.getParameter("itemID");
String sql="select * from I_s_item where itemID='"+itemID+"'";
ResultSet rs=p_showitem.executeQuery(sql);
//定義數據類型并初始化
String item_name1=""; //項目名稱
String sort1=""; //類 別
String sort2="";
String begin_date1=""; //起止年限
String finish_date1=""; //起止年限
String applicant1=""; //申 請 者
String grade1=""; //職 稱
String education1=""; //學 歷
String unit_name1=""; //所在單位
String fill_date1=""; //填報日期
String purport1=""; //本課題的研究意義
String status1=""; //國內外研究現狀述評
String future1=""; //預期應用前景
String point1=""; //主要思想、觀點
String analysis1=""; //主要內容、重點和難點分析
String way1=""; //研究方法
String moment1=""; //階段及最終預期研究成果
String result1=""; //預期研究成果
String reference1=""; //本課題前期研究成果，主要的外文參考文獻和參考資料
String market1=""; //應用推廣或市場分析
String commend_mind1=""; //推薦單位意見
if(rs.next())
{
item_name1=rs.getString("item_name");
sort1=rs.getString("sort1");
sort2=rs.getString("sort2");
begin_date1=rs.getString("begin_date");
finish_date1=rs.getString("finish_date");
applicant1=rs.getString("applicant");
grade1=rs.getString("grade");
education1=rs.getString("education");
purport1=rs.getString("purport");
status1=rs.getString("status");
future1=rs.getString("future");
point1=rs.getString("point");
analysis1=rs.getString("analysis");
way1=rs.getString("way");
moment1=rs.getString("moment");
result1=rs.getString("result");
reference1=rs.getString("reference");
market1=rs.getString("market");
commend_mind1=rs.getString("commend_mind");
rs.close();
p_showitem.closeStmt();
p_showitem.closeConn();
}
String begin_year=begin_date1.substring(0,4);
String begin_month=begin_date1.substring(5,7);
String finish_year=finish_date1.substring(0,4);
String finish_month=finish_date1.substring(5,7);
String sql2="select * from I_s_money where itemID='"+itemID+"'";
ResultSet rs2=p_showitem.executeQuery(sql2);
%>
<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" width="650">
<tr>
<td bgcolor="#000099">
<table width="650" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#FFFFFF">
<td colspan="3" height="20"> </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/s_item1.gif" width="112" height="22"></div>
</td>
<td width="33%"> </td>
</tr>
</table>
<table width="650" border="0" cellspacing="1" cellpadding="0">
<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">
<tr>
<td>
<table width="95%" border="0" cellspacing="1" cellpadding="1" align="center">
<tr>
<td colspan="2" bgcolor="#d9d8dc"> </td>
</tr>
<tr>
<td width="25%" bgcolor="#d9d8dc" align="center"><font color="#000099">項目名稱</font></td>
<td><font color="#000099"><%=item_name1%></font></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center"><font color="#000099">類 別</font></td>
<td bgcolor="#f2f2f2"><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">起止年限</font></td>
<td> <font color="#000099"><%=begin_year%>年<%=begin_month%>月——<%=finish_year%>年<%=finish_month%>月</font>
</td>
</tr>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -