?? alarm1info.jsp
字號:
<%--
模塊名稱：個人助理
模塊功能：提醒顯示
版 本：V1.0
著 作 人：蔡靜
著作日期：2001-11-13
使用說明：
主要技術(shù)說明：
參考文獻(xiàn)：法律事務(wù)設(shè)計(jì)書
修改歷史：= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：
修 改 人：
修改理由：
修改出處：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ page contentType= "text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<%
String alert_id = request.getParameter("alert_id");
String alert_title, alert_thing, alert_fromtime, alert_totime;
String sql = "select alert_title, alert_thing, alert_fromtime, alert_totime";
sql = sql + " from t_alert where alert_id = '" + alert_id + "'";
ResultSet rs = db.executeQuery(sql);
if (rs.next()) {
alert_title = rs.getString("alert_title");
alert_thing = rs.getString("alert_thing");
alert_fromtime = rs.getString("alert_fromtime");
alert_totime = rs.getString("alert_totime");
%>
<html>
<head>
<title>提醒顯示</title>
<%@ include file="../inc/config.jsp" %>
</head>
<body class=page>
<!--顯示工具條-->
<table width="98%" align="center" cellspacing="1">
<tr>
<td><a href="Alarm1.jsp"><img src="../images/alarm.gif" width="88" height="22" border="0"></a>
<a href="Alarm1all.jsp"><img src="../images/alarm_all.gif" height="22" border="0" width="88"></a>
<a href="AlarmAdd.jsp"><img src="../images/add.gif" alt="增加內(nèi)容" width="79" height="22" border="0"></a>
<img src="../images/delete.gif" alt="刪除選中的內(nèi)容" style="cursor:hand" width="79" height="22">
<a href="Alarmall.jsp"><img src="../images/alarm_2.gif" width="88" height="22" border="0"></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%" border="0" cellspacing="1" cellpadding="5" class="table_bg" align="center">
<tr>
<td width="21%" class="title_bg" align="right"> 提醒標(biāo)題：</td>
<td width="79%" class="tr_bg1"><%=alert_title%></td>
</tr>
<tr>
<td width="21%" class="title_bg" height="4" align="right"> 提醒開始時間：</td>
<td width="79%" class="tr_bg1" height="-2"><%=alert_fromtime.substring(0,19)%></td>
</tr>
<tr>
<td width="21%" class="title_bg" height="4" align="right"> 提醒結(jié)束時間：</td>
<td width="79%" class="tr_bg1" height="0"><%=alert_totime.substring(0,19)%></td>
</tr>
<tr>
<td width="21%" class="title_bg" height="9" align="right">被提醒人：</td>
<td width="79%" class="tr_bg1" height="9">
<%
String sql1 = "select a.alerted_person, b.employee_name from t_alerted a,";
sql1 = sql1 + "t_employee b where a.alerted_person = b.employee_id";
sql1 = sql1 + " and a.alert_id = '" + alert_id + "'";
String employee_name, alerteds = null;
ResultSet rs1 = db.executeQuery(sql1);
while (rs1.next()) {
employee_name = rs1.getString("employee_name");
if (alerteds == null)
alerteds = employee_name;
else
alerteds = alerteds + "," + employee_name;
}
out.print(alerteds);
%>
</td>
</tr>
<tr>
<td width="21%" class="title_bg" align="right"> 提醒內(nèi)容：</td>
<td class="tr_bg1"><textarea name="alert_thing" cols="75" class="input" rows="10" readOnly><%=alert_thing%></textarea></td>
</tr>
</table>
<div align="center"><br>
</div>
</body>
</html>
<%}%>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -