?? s_showitem.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_showitem" scope="page" class="firm.firm"/>
<%
String itemID=request.getParameter("itemID");
String sql="select * from I_s_item where itemID='"+itemID+"'";
ResultSet rs=s_showitem.executeQuery(sql);
//定義數據類型并初始化
String item_name1=""; //項目名稱
String sort1=""; //類 別
String sort2="";
String begin_date1=""; //起止年限
String finish_date1=""; //起止年限
String applicant1=""; //申 請 者
String grade1=""; //職 稱
String education=""; //學 歷
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=""; //推薦單位意見
String expert_mind1=""; //專家評審委員會意見
String leading_mind1=""; //審批意見
String pass1=""; //是否通過審批
String sum="";
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");
education=rs.getString("education");
unit_name1=rs.getString("unit_name");
fill_date1=rs.getString("fill_date");
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");
expert_mind1=rs.getString("expert_mind");
leading_mind1=rs.getString("leading_mind");
pass1=rs.getString("pass");
rs.close();
s_showitem.closeStmt();
s_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 fill_year=fill_date1.substring(0,4);
String fill_month=fill_date1.substring(5,7);
String fill_day=fill_date1.substring(8,10);
String sql2="select * from I_s_money where itemID='"+itemID+"'";
ResultSet rs2=s_showitem.executeQuery(sql2);
String sql3="select sum(sMoney) as ssum from I_s_money where itemID='"+itemID+"'";
ResultSet rs3=s_showitem.executeQuery(sql3);
if(rs3.next()){ sum=rs3.getString("ssum");}
String pSql="select * from I_distribute where itemID='"+itemID+"'";
ResultSet pRs=s_showitem.executeQuery(pSql);
String expert[]={"專家一","專家二","專家三","專家四","專家五"};
%>
<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"> </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" 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="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>
<tr>
<td bgcolor="#d9d8dc" align="center"><font color="#000099">申
請 者</font></td>
<td bgcolor="#f2f2f2"> <font color="#000099"><%=applicant1%>（<%=grade1%>）（<%=education%>）</font>
</td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center"><font color="#000099">所在單位</font></td>
<td><font color="#000099"><%=unit_name1%></font></td>
</tr>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -