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