📄 alarmamendrun.jsp
字号:
<%--
模块名称：个人助理
模块功能：提醒修改
版 本：V1.0
著 作 人：蔡静
著作日期：2001-11-13
使用说明：
主要技术说明：
参考文献：法律事务设计书
修改历史：= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：
修 改 人：
修改理由：
修改出处：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ page contentType= "text/html; charset=gb2312" %>
<%@ page language="java" import="system.*" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<%
ExtendString es = new ExtendString();
String alert_id, alert_title, alert_thing, alert_fromtime, alert_totime;
alert_id = request.getParameter("alert_id");
alert_title = es.getStr(request.getParameter("alert_title"));
alert_thing = es.getStr(request.getParameter("alert_thing"));
alert_fromtime = request.getParameter("alert_fromtime") + " ";
alert_fromtime = alert_fromtime + request.getParameter("fromhour") + ":";
alert_fromtime = alert_fromtime + request.getParameter("fromminute");
alert_totime = request.getParameter("alert_totime") + " ";
alert_totime = alert_totime + request.getParameter("tohour") + ":";
alert_totime = alert_totime + request.getParameter("tominute");
String sql = "update t_alert set alert_title = '" + alert_title + "'";
sql = sql + ", alert_thing = '" + alert_thing + "', alert_fromtime = '";
sql = sql + alert_fromtime + "', alert_totime = '" + alert_totime + "'";
sql = sql + " where alert_id = '" + alert_id + "'";
int num = db.executeUpdate(sql);
if (num <= 0) {
out.print(sql);
}
String alerteds = request.getParameter("alertedlist");
String alerted[] = new String[20];
alerted = es.Split(";",alerteds);
sql = "delete from t_alerted where alert_id = '" + alert_id + "'";
db.executeUpdate(sql);
for (int i=0; i<es.length; i++) {
sql = "insert into t_alerted(alert_id, alerted_person) values('";
sql = sql + alert_id + "','" + alerted[i] + "')";
db.executeUpdate(sql);
}
%>
<html>
<head>
<title>修改成功</title>
</head>
<body>
<%
String flag = request.getParameter("flag");
String location = "";
if (flag.equals("1"))
location = "Alarm1.jsp";
else
location = "Alarm1all.jsp";
%>
<script language="javascript">
alert("修改成功！");
</script>
<%
response.sendRedirect(location);
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -