?? bulletininfo.jsp
字號(hào):
<%--
模塊名稱(chēng):律所公告
模塊功能:公告信息
版 本:V1.0
著 作 人:蔡靜
著作日期:2001-11-12
使用說(shuō)明:
主要技術(shù)說(shuō)明:
參考文獻(xiàn):法律事務(wù)設(shè)計(jì)書(shū)
修改歷史:= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期:2001-12-28
修 改 人:Celts
修改理由:內(nèi)容無(wú)原格式輸出
修改出處:
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ page contentType= "text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<jsp:useBean id="stringset" class="system.ExtendString" scope="page" />
<%
String bulletin_id = request.getParameter("bulletin_id");
String bulletin_title, bulletin_content, input_time, input_person;
String sql = "select a.bulletin_title, a.bulletin_content, a.input_time,";
sql = sql + "b.employee_name as input_person from t_bulletin a, t_employee b";
sql = sql + " where a.input_person = b.employee_id and a.bulletin_id = '" + bulletin_id + "'";
ResultSet rs = db.executeQuery(sql);
if (rs.next()) {
bulletin_title = rs.getString("bulletin_title");
bulletin_content = rs.getString("bulletin_content");
bulletin_title=stringset.toHtml(bulletin_title);
bulletin_content=stringset.toHtml(bulletin_content);
input_time = rs.getString("input_time");
input_person = rs.getString("input_person");
%>
<html>
<head>
<title>公告信息</title>
<%@ include file="../inc/config.jsp" %>
</head>
<body class=page>
<!--顯示工具條-->
<table width="98%" align="center" cellspacing="1">
<tr>
<td><a href="Bulletin.jsp"><img src="../images/all.gif" height="22" border="0"></a>
<a href="BulletinSearch.jsp"><img src="../images/query.gif" alt="查詢內(nèi)容" border="0" width="79" height="22"></a></td>
<td align="right"><img src="../images/back.gif" width="50" height="22" onClick="window.history.back()" style="cursor:hand" alt="返回"></td>
</tr>
</table>
<table width="98%" background="../images/line.gif" border="0" cellspacing="0" cellpadding="0" height="12" align="center">
<tr>
<td> </td>
</tr>
</table>
<!--顯示工具條結(jié)束-->
<!--<table width="98%" align="center">
<tr>
<td>
<div align="right"><a href="#"><img src="../images/prethread.gif" width="48" height="12" border="0"></a>
<a href="#"><img src="../images/nextthread.gif" width="48" height="12" border="0"></a>
</div>
</td>
</tr>
</table>
-->
<table border="0" cellspacing="1" cellpadding="5" class="table_bg" align="center" width="98%">
<tr>
<td width="13%" class="title_bg" align="right"> 公告編號(hào):</td>
<td width="22%" class="tr_bg1"><%=bulletin_id%></td>
<td width="13%" class="title_bg">錄入時(shí)間:</td>
<td width="22%" class="tr_bg1"><%=input_time.substring(0,10)%></td>
<td width="9%" class="title_bg">錄入人:</td>
<td width="21%" class="tr_bg1"><%=input_person%></td>
</tr>
<tr>
<td width="13%" class="title_bg" height="9" align="right"> 公告標(biāo)題:</td>
<td class="tr_bg1" height="9" colspan="5"><%=bulletin_title%></td>
</tr>
<tr>
<td width="13%" class="title_bg" align="right"> 公告內(nèi)容:</td>
<td height="250" class="tr_bg1" colspan="5"><pre><%=bulletin_content%></pre></td>
</tr>
</table>
</body>
</html>
<%}%>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -