notice_show.jsp
来自「oa 源代码」· JSP 代码 · 共 104 行
JSP
104 行
<%@ page language="java" contentType="text/html;charset=gb2312" %>
<%@ page import = "java.net.URLEncoder"%>
<%@ page import = "java.sql.ResultSet"%>
<%@ page import = "java.sql.SQLException"%>
<%@ page import = "java.util.Properties"%>
<HTML><HEAD><TITLE>查看通知</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<link rel="stylesheet" href="../common.css" type="text/css">
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff >
<table width="494" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="23" valign="bottom" background="../images/tab-b-top.gif"> <span class="right-title">查
看 通 知</span></td>
</tr>
<tr>
<td height="255" align="center" valign="top" background="../images/tab-b-back.gif">
<jsp:useBean id="cfgparser" scope="page" class="fan.util.CFGParser"/>
<jsp:useBean id="fchar" scope="page" class="cn.js.fan.util.StrUtil"/>
<jsp:useBean id="privilege" scope="page" class="com.redmoon.oa.pvg.Privilege"/>
<%
String priv="admin";
String priv1="notice_public";
if (!privilege.isUserPrivValid(request,priv) && !privilege.isUserDepartmentPrivValid(request,priv1))
{
out.println(cn.js.fan.web.SkinUtil.makeErrMsg(request, cn.js.fan.web.SkinUtil.LoadString(request, "pvg_invalid")));
return;
}
String id = fchar.getNullString(request.getParameter("id"));
if (id.equals(""))
{
out.print(fchar.makeErrMsg("缺少需求信息标识符!"));
return;
}
%>
<jsp:useBean id="conn" scope="page" class="com.redmoon.oa.db.Conn"/>
<jsp:setProperty name="conn" property="POOLNAME" value="ttoa"/>
<%
String title="",content="",mydate="",filename="",extname="",author="";
int isdel = 0;
String sql = "select title,content,mydate,filename,extname,author from notice where id="+id;
ResultSet rs = null;
try {
rs = conn.executeQuery(sql);
if (rs!=null && rs.next())
{
title = rs.getString("title");
content = rs.getString("content");
mydate = rs.getString("mydate").substring(0,10);
filename = fchar.getNullStr(rs.getString("filename"));
extname = rs.getString("extname");
author = rs.getString("author");
}
}
catch (SQLException e) {
out.println(e.getMessage());
}
finally {
if (rs!=null) {
rs.close();
rs = null;
}
if (conn!=null) {
conn.close();
conn = null;
}
}
%>
<br>
<table width="90%" border="0" align="center" cellpadding="2" cellspacing="0">
<tr bgcolor="#C4DAFF">
<td width="19%" class="stable">发送者:</td>
<td width="81%" class="stable"><%=author%> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#eeeeee" class="stable">日 期:</td>
<td class="stable"><%=mydate%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td valign="top" bgcolor="#eeeeee" class="stable">附 件:</td>
<td class="stable">
<%
if (!filename.equals(""))
{
%> <a href="../getnoticefile.jsp?id=<%=id%>&filename=<%=filename%>&extname=<%=extname%>">附件(.<%=extname%>)</a> <%
}
else
out.print(" ");
%> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td valign="top" bgcolor="#eeeeee" class="stable">内 容:</td>
<td class="stable"><%=content%> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="9"><img src="../images/tab-b-bot.gif" width="494" height="9"></td>
</tr>
</table>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?