📄 preview.jsp

📁 jsp+oracle书记的源代码
💻 JSP
字号:
<%
/**********************************************************
Copyright (C),2003-11-2, Beijing  USTB.
All rights reserved.
Filename: view.jsp
Author: 
Version 1.0
Date:2003-11-2
Description:显示文章
Other:
Variable List:

Function List:

History:
***********************************************************/
%>
<%@page language="java" contentType="text/html;charset=GBK"%>
<%@page import="java.util.*,java.text.*,java.io.*,oa.main.DealString"%>
<jsp:useBean id="myArtBean" class="oa.bean.InfoArticleBean" scope="page"/>
<jsp:useBean id="pb" class="oa.main.ParentBean" scope="page"/>
<html>
<head>
<!--	<link href="../css/person.css" type=text/css rel=stylesheet>-->
<title>
	会议浏览
</title>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<div align=center>
<%
oa.bean.PersonBean	personBean = null;
try{
	if(pb.getConn()==null)
	{
		%>		
		数据库无法响应,请<a href="javascript:window.history.back(-1);">返回</a>重试
		<%out.close();
	}
	if(myArtBean.getConn()==null)
	{
		%>		
		数据库无法响应,请<a href="javascript:window.history.back(-1);">返回</a>重试
		<%out.close();
	}


	DealString ds = new DealString();
	int errcode = -1;
	//通知编号
	String noticeid = ds.toString(request.getParameter("noticeid"));
	//接受人编号
	String person_ID = ds.toString((String)session.getAttribute("zgbh"));
	String sql = "";

	//查询数据
	String []str = new String[12];
	// 设置查询的 SQL 语句
	sql = "select * from HG2_MEET_NOTICE where id='"+noticeid+"'";
	Vector vect = pb.getDataBySql(sql);
	str[0] = (String)((Hashtable)vect.get(0)).get("TITLE");
	str[1] = (String)((Hashtable)vect.get(0)).get("KEYWORD");
	str[2] = (String)((Hashtable)vect.get(0)).get("LEVEL1");
	if(str[2].equals("1"))str[2]="一级";
	if(str[2].equals("2"))str[2]="二级";
	if(str[2].equals("3"))str[2]="三级";
	str[3] = (String)((Hashtable)vect.get(0)).get("TIME");
	str[4] = (String)((Hashtable)vect.get(0)).get("TIMESTART");
	str[5] = (String)((Hashtable)vect.get(0)).get("TIMEEND");
	str[6] = "";
	str[7] = "";
	str[8] = (String)((Hashtable)vect.get(0)).get("WORD");
	String sender=(String)((Hashtable)vect.get(0)).get("SENDER");
	str[9] = (String)((Hashtable)vect.get(0)).get("OLDORGID");
	str[10] = (String)((Hashtable)vect.get(0)).get("ORGID");
	str[11] = (String)((Hashtable)vect.get(0)).get("TIME");

	String sendername = pb.toName("ZZ_ZGB","ZGBH","XM",sender);
	personBean =new oa.bean.PersonBean();
	String bmbh=personBean.toName("ZZ_ZGB","ZGBH","BMBH",sender);
	String bm=ds.toString(personBean.getFatherName(bmbh))+ds.toString(personBean.getApartName(bmbh));

	//分割改过名的文件名串
	String[] newname=str[10].split(",");
	//分割未改过名的文件名串
	String[] newfile=str[9].split(",");
	int k=0;
	if(newname!=null)k=newname.length;
	int m=0;
	if(newfile!=null)m=newfile.length;
	
	int ifhave = 0;
	String strhave = "";
	//if(m<k) ifhave=m;
	//out.println("ifhave========="+ifhave);
	for (int i=0;i<k&&i<m;i++){
		strhave +=newfile[i];
	}
	strhave = ds.toString(strhave);
	if(!strhave.equals("")) ifhave = 1; 
%>


<table width="90%" border="0">
	<tr>
		<td align="left"><font color=#0000FF style="font-size:13px;">&nbsp;&nbsp;</font></td>
		<td align="right"><font color="#0000FF" style="font-size:13px;">发布人：<%=sendername%>&nbsp;&nbsp;发布时间：<%=str[11]%></font>
	</tr>
	<%if(ifhave==1){%>
		<tr>
			<td >
			<font color=red style="font-size:13px;">附件：</font>
				<%
					for (int i=0;i<k&&i<m;i++){
				%>
				<a href="../../../../articledownloadservlet?cominfo=meet&newname=<%=newname[i]%>&newfile=<%=newfile[i]%>"><font style="font-size:13px;"><%=newfile[i]%></font></a>
				<%
					}
				%>
			</td>
		</tr>
	<%}%>
</table>

<jsp:include page="EditDoc.jsp"/>

<hr align=center width="90%" size=2 color="#cccccc">
<%if(ifhave==1){%>
	<table width="90%" border="0" bgcolor=#eeeeee>
		<tr>
			<td >
				<font color=red style="font-size:13px;">附件：</font>
	<%
		for (int i=0;i<k&&i<m;i++){
	%>
				<a href="../../../../articledownloadservlet?cominfo=meet&newname=<%=newname[i]%>&newfile=<%=newfile[i]%>"><font style="font-size:13px;"><%=newfile[i]%></font></a>
	<%
		}
	%>
			</td>
		</tr>
	</table>
<%}%>
<table width="90%" border="0" bgcolor=#eeeeee>
	<tr>
		<td ><font style="font-size:13px;"><font color=#0000FF>关键字：<%=str[1]%></font>&nbsp;&nbsp;</font></td>
	</tr>
	<!-- <tr>
		<td ><font style="font-size:13px;"><font color=#FF00CC>会议级别：<%//=str[2]%></font>&nbsp;&nbsp;
</font></td>
	</tr> -->
	<tr>
		<td ><font style="font-size:13px;"><font color=#0000FF>会议来源：<%=bm%></font>&nbsp;&nbsp;<font color=#0000FF>发布者：<%=sendername%></font>
</font></td>
	</tr>
</table>

<hr align=center width="90%" size=2 color="#cccccc">
<table width="90%" border="0" >
	<tr ><td align=center>
&nbsp&nbsp<input type=button value="取消" onclick="javascript:window.close();window.opener.focus();">
</td>	</tr>	
</table></div>
</body>
</html>
<%}
finally{
	if(pb!=null)pb.closeConn();
	if(personBean!=null)personBean.closeConn();
}
%>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -