show.jsp

“JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。 注意： 1. 本书中的案例提供的数据库环境不同

					<td><%=str_XmlxName%></td>
					<td><%=str_Xmfzr%></td>
					<td><%=str_kssj%></td>
					<td><%=str_Jtsj%></td>
				  </tr>
			<%
			}
			%>
			<%if(sizeh==0){%>
				  <tr>
					<td colspan=6 align=center>没有横向项目!</td>
				  </tr>
			<%}%>
      </table>
	<br>
	<hr color=#C8F8BA>
	<table class="main_w" width="100%"  border="1" cellpadding="4" cellspacing="0" bordercolor="FFFFFF" bgcolor="E8FCE2">
	  <tr bgcolor="#FFFFFF" class="title_s">
		<td  colspan="6"><div align="center" title="查看本人全部纵向项目......"><a href="../user/listzx.cgi?id=<%=strThisId%>">纵向项目</a></div></td>
	  </tr>
	  <tr>
            <td height="20" class="title_s">序号</td>
            <td height="20" class="title_s">项目名称</td>
<!--             <td height="20" class="title_s">登记号</td>
            <td height="20" class="title_s">合同号</td>
 -->            <td height="20" class="title_s">项目类型</td>
            <td height="20" class="title_s">项目负责人</td>
            <td height="20" class="title_s">开始时间</td>
            <td height="20" class="title_s">结题时间</td>
	  </tr>
		<%
		int sizez = vectz.size();
		for(int i=0;i<sizez;i++){
			Hashtable hashz = (Hashtable)vectz.get(i);
			String str_id = ds.toString((String)hashz.get("id"));
			String str_Djh = ds.toString((String)hashz.get("djh"));
			String str_Hth = ds.toString((String)hashz.get("hth"));
			String str_xmmc = ds.toString((String)hashz.get("xmmc"));
			String str_Xmlx = ds.toString((String)hashz.get("xmlx"));
			String str_XmlxName = ds.toString((String)myBean.toName("kjc2_code","id","code_value",str_Xmlx));

			String str_Ktlyd = ds.toString((String)hashz.get("ktlyd"));
			String str_Xy = ds.toString((String)hashz.get("xy"));
			/*String str_Xys[] = str_Xy.split(",");
			str_Xy = "";
			for(int j=0;j<str_Xys.length;j++){
				String strtemp = ds.toString((String)myBean.toName("kjc_college","id","name",str_Xys[j]));
				if(str_Xy.equals("")) str_Xy += strtemp;
				else str_Xy += ","+strtemp;
			}*/
			String str_Xmfzr = ds.toString((String)hashz.get("xmfzr"));//逗号分割人员表id
			String str_Xmfzrs[] = str_Xmfzr.split(",");
			str_Xmfzr = "";
			for(int j=0;j<str_Xmfzrs.length;j++){
				String strtemp = ds.toString((String)myBean.toName("kjc_people","id","name",str_Xmfzrs[j]));
				if(str_Xmfzr.equals("")) str_Xmfzr += strtemp;
				else str_Xmfzr += ","+strtemp;
			}
			String str_Zywcr = ds.toString((String)hashz.get("zywcr"));//逗号分割人员表id
			String str_wcrxh = ds.toString((String)hashz.get("wcrxh"));//1,3,4
			/*String str_Zywcrs[] = str_Zywcr.split(",");
			String str_wcrxhs[] = str_wcrxh.split(",");
			str_Zywcr = "";
			for(int j=0;j<str_Zywcrs.length;j++){
				String strtemp = ds.toString((String)myBean.toName("kjc_people","id","name",str_Zywcrs[i]));
				if(str_Zywcr.equals("")) str_Zywcr += strtemp+"("+str_wcrxhs[j]+")";
				else str_Zywcr += ","+strtemp+"("+str_wcrxhs[j]+")";
			}*/
			String str_Yjscjr = ds.toString((String)hashz.get("yjscjr"));
			String str_kssj = ds.toString((String)hashz.get("kssj"));
			String str_Jtsj = ds.toString((String)hashz.get("jtsj"));
		%>
			  <tr>
				<td><%=i+1%></td>
				<td><a href="../kjc2_manage/view1.jsp?projectid=<%=str_id%>"><%=str_xmmc%></a></td>
				<td><%=str_XmlxName%></td>
				<td><%=str_Xmfzr%></td>
				<td><%=str_kssj%></td>
				<td><%=str_Jtsj%></td>
			  </tr>
		<%
		}
		%>
		<%if(sizez==0){%>
			  <tr>
				<td colspan=6 align=center>没有纵向项目!</td>
			  </tr>
		<%}%>
  </table>
	<br>
	<hr color=#C8F8BA>
	<table class="main_w" width="100%"  border="1" cellpadding="4" cellspacing="0" bordercolor="FFFFFF" bgcolor="E8FCE2">
	  <tr bgcolor="#FFFFFF" class="title_s">
		<td  colspan="8"><div align="center"  title="查看本人全部奖励项目......"><a href="../user/listprize.cgi?id=<%=strThisId%>">奖励项目</a></div></td>
	  </tr>
	  <tr>
		<td height="20" class="title_s">序号</td>
		<td height="20" class="title_s">项目名称</td>
<!-- 		<td height="20" class="title_s">编号</td>
 -->		<td height="20" class="title_s">奖励级别</td>
		<td height="20" class="title_s">奖励类型</td>
		<td height="20" class="title_s">授奖部门</td>
		<td height="20" class="title_s">奖励名称</td>
		<td height="20" class="title_s">奖种</td>
		<td height="20" class="title_s">获奖等级</td>
	  </tr>
		<%
		int sizeprize = vectprize.size();
		for(int i=0;i<sizeprize;i++){
			Hashtable hashprize = (Hashtable)vectprize.get(i);
			String str_id = ds.toString((String)hashprize.get("id"));
			String str_Bh = ds.toString((String)hashprize.get("bh"));
			String str_Xy = ds.toString((String)hashprize.get("xy"));
			String str_Xys[] = str_Xy.split(",");
			str_Xy = "";
			for(int j=0;j<str_Xys.length;j++){
				String strtemp = ds.toString((String)myBean.toName("kjc_college","id","name",str_Xys[j]));
				if(str_Xy.equals("")) str_Xy += strtemp;
				else str_Xy += ","+strtemp;
			}
			String str_Jljb = ds.toString((String)hashprize.get("jljb"));
			str_Jljb = ds.toString((String)myBean.toName("kjc2_code","id","code_value",str_Jljb));

			String str_Jllx = ds.toString((String)hashprize.get("jllx"));

			String str_Sjbm = ds.toString((String)hashprize.get("sjbm"));
			String str_jlmc = ds.toString((String)hashprize.get("jlmc"));
			str_jlmc = ds.toString((String)myBean.toName("kjc2_code","id","code_value",str_jlmc));

			String str_jz = ds.toString((String)hashprize.get("jz"));
			str_jz = ds.toString((String)myBean.toName("kjc2_code","id","code_value",str_jz));

			String str_Jldj = ds.toString((String)hashprize.get("jldj"));
			str_Jldj = ds.toString((String)myBean.toName("kjc2_code","id","code_value",str_Jldj));

			String str_Xmmc = ds.toString((String)hashprize.get("xmmc"));
		%>
			  <tr>
				<td><%=i+1%></td>
				<td><a href="../kjc2_manage/view2.jsp?projectid=<%=str_id%>"><%=str_Xmmc%></a></td>
				<td><%=str_Jljb%></td>
				<td><%=str_Jllx%></td>
				<td><%=str_Sjbm%></td>
				<td><%=str_jlmc%></td>
				<td><%=str_jz%></td>
				<td><%=str_Jldj%></td>
			  </tr>
		<%
		}
		%>
		<%if(sizeprize==0){%>
			  <tr>
				<td colspan=8 align=center>没有奖励项目!</td>
			  </tr>
		<%}%>
  </table>

	<br>
	<hr color=#C8F8BA>
	<table class="main_w" width="100%"  border="1" cellpadding="4" cellspacing="0" bordercolor="FFFFFF" bgcolor="E8FCE2">
	  <tr bgcolor="#FFFFFF" class="title_s">
		<td  colspan="7"><div align="center" title="查看本人全部鉴定项目......"><a href="../user/listcheck.cgi?id=<%=strThisId%>">鉴定项目</a></div></td>
	  </tr>
	  <tr>
		<td height="20" class="title_s">序号</td>
		<td height="20" class="title_s">项目名称</td>
		<td height="20" class="title_s">鉴定证书号</td>
		<td height="20" class="title_s">项目来源</td>
		<td height="20" class="title_s">主要完成单位</td>
		<td height="20" class="title_s">鉴定部门</td>
		<td height="20" class="title_s">鉴定时间</td>
	  </tr>
		<%
		int sizecheck = vectcheck.size();
		for(int i=0;i<sizecheck;i++){
			Hashtable hashcheck = (Hashtable)vectcheck.get(i);
			String str_id = ds.toString((String)hashcheck.get("id"));
			String str_Bh = ds.toString((String)hashcheck.get("bh"));
			String str_Jdzsh = ds.toString((String)hashcheck.get("jdzsh"));
			String str_Xy = ds.toString((String)hashcheck.get("xy"));
			String str_Xmmc = ds.toString((String)hashcheck.get("xmmc"));
			
			String str_Xmly = ds.toString((String)hashcheck.get("xmly"));
			String str_Wcr = ds.toString((String)hashcheck.get("wcr"));
			/*String str_wcrxh = ds.toString((String)hashcheck.get("wcrxh"));
			String str_Wcrs[] = str_Wcr.split(",");
			String str_wcrxhs[] = str_wcrxh.split(",");
			str_Wcr = "";
			for(int j=0;j<str_Wcrs.length;j++){
				String strtemp = ds.toString((String)myBean.toName("kjc_people","id","name",str_Wcrs[i]));
				if(str_Wcr.equals("")) str_Wcr += strtemp+"("+str_wcrxhs[j]+")";
				else str_Wcr += ","+strtemp+"("+str_wcrxhs[j]+")";
			}*/

			String str_Wcdw = ds.toString((String)hashcheck.get("wcdw"));
			String str_Jdbm = ds.toString((String)hashcheck.get("jdbm"));
			String str_Jdsj = ds.toString((String)hashcheck.get("jdsj"));
		%>
			  <tr>
				<td><%=i+1%></td>
				<td><a href="../kjc2_manage/view3.jsp?projectid=<%=str_id%>"><%=str_Xmmc%></a></td>
				<td><%=str_Jdzsh%></td>
				<td><%=str_Xmly%></td>
				<td><%=str_Wcdw%></td>
				<td><%=str_Jdbm%></td>
				<td><%=str_Jdsj%></td>
			  </tr>
		<%
		}
		%>
		<%if(sizecheck==0){%>
			  <tr>
				<td colspan=7 align=center>没有鉴定项目!</td>
			  </tr>
		<%}%>
  </table>

	<br>
	<hr color=#C8F8BA>
	<table class="main_w" width="100%"  border="1" cellpadding="4" cellspacing="0" bordercolor="FFFFFF" bgcolor="E8FCE2">
	  <tr bgcolor="#FFFFFF" class="title_s">
		<td  colspan="7"><div align="center" title="查看本人全部论文......"><a href="../user/listpaper.cgi?id=<%=strThisId%>">论文</a></div></td>
	  </tr>
	  <tr>
		<td height="20" class="title_s" width="5%">序号</td>
		<td height="20" class="title_s">论文名称</td>
		<td height="20" class="title_s">刊物名称</td>
		<td height="20" class="title_s">收录情况</td>
		<td height="20" class="title_s">影响力</td>
		<td height="20" class="title_s">引用次数</td>
		<td height="20" class="title_s">备注</td>
	  </tr>
		<%
		int sizepaper = vectpaper.size();
		for(int i=0;i<sizepaper;i++){
			Hashtable hashpaper = (Hashtable)vectpaper.get(i);
			String str_id = ds.toString((String)hashpaper.get("id"));
			String str_Bh = ds.toString((String)hashpaper.get("bh"));
			String str_Xy = ds.toString((String)hashpaper.get("xy"));
			String str_Zz = ds.toString((String)hashpaper.get("zz"));
			String str_Kwmc = ds.toString((String)hashpaper.get("kwmc"));
			String str_Lwmc = ds.toString((String)hashpaper.get("lwmc"));
			String str_Slqk = ds.toString((String)hashpaper.get("slqk"));
			str_Slqk = ds.toString((String)myBean.toName("kjc2_code","id","code_value",str_Slqk));
			String str_yxl = ds.toString((String)hashpaper.get("yxl"));
			String str_Yxyz = ds.toString((String)hashpaper.get("yxyz"));
			String str_Yycs = ds.toString((String)hashpaper.get("yycs"));
			String str_Djzz = ds.toString((String)hashpaper.get("djzz"));
			String str_bz = ds.toString((String)hashpaper.get("bz"));
		%>
			  <tr>
				<td align=center><%=i+1%></td>
				<td><a href="../kjc2_manage/view4.jsp?projectid=<%=str_id%>"><%=str_Lwmc%></a></td>
				<td><%=str_Kwmc%></td>
				<td><%=str_Slqk%></td>
				<td><%=str_yxl%></td>
				<td><%=str_Yycs%></td>
				<td><%=str_bz%></td>
			  </tr>
		<%
		}
		%>
		<%if(sizepaper==0){%>
			  <tr>
				<td colspan=7 align=center>没有论文!</td>
			  </tr>
		<%}%>
  </table>

	<br>
	<hr color=#C8F8BA>
	<table class="main_w" width="100%"  border="1" cellpadding="4" cellspacing="0" bordercolor="FFFFFF" bgcolor="E8FCE2">
	  <tr bgcolor="#FFFFFF" class="title_s">
		<td  colspan="5"><div align="center" title="查看本人全部科技专著......"><a href="../user/liststatic.cgi?id=<%=strThisId%>">科技专著</a></div></td>
	  </tr>
	  <tr>
		<td height="20" class="title_s" width="5%">序号</td>
		<td height="20" class="title_s">编号</td>
		<td height="20" class="title_s">学院</td>
		<td height="20" class="title_s">出版社名称</td>
		<td height="20" class="title_s">字数（万字）</td>
	  </tr>
		<%
		int sizestatic = vectstatic.size();
		for(int i=0;i<sizestatic;i++){
			Hashtable hashstatic = (Hashtable)vectstatic.get(i);
			String str_id = ds.toString((String)hashstatic.get("id"));
			String str_Bh = ds.toString((String)hashstatic.get("bh"));
			String str_Xy = ds.toString((String)hashstatic.get("xy"));
			String str_Zz = ds.toString((String)hashstatic.get("zz"));
			String str_cbs = ds.toString((String)hashstatic.get("cbs"));
			String str_Zs = ds.toString((String)hashstatic.get("zs"));
			String str_bz = ds.toString((String)hashstatic.get("bz"));
		%>
			  <tr>
				<td align=center><%=i+1%></td>
				<td><a href="../kjc2_manage/view5.jsp?projectid=<%=str_id%>"><%=str_Bh%></a></td>
				<td><%=str_Xy%></td>
				<td><%=str_cbs%></td>
				<td><%=str_Zs%></td>
			  </tr>
		<%
		}
		%>
		<%if(sizestatic==0){%>
			  <tr>
				<td colspan=5 align=center>没有科技专著!</td>
			  </tr>
		<%}%>
  </table>
  
  </td>
      <td width="50">&nbsp;</td>
    </tr>
  </table>
</body>
</html>
<%
myBean.closeConn ( ) ;
%>