MailListOperation.jsp
1.78 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
<%@ page import="weaver.general.Util" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" %> <%@ include file="/systeminfo/init_wev8.jsp" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="Util" class="weaver.general.Util" scope="page" />
<%
String sqlStr = "" ;
String method = Util.null2String(request.getParameter("method"));
if(method.equals("add"))
{
String name=Util.null2String(request.getParameter("name"));
String mailDesc=Util.null2String(request.getParameter("mailDesc"));
name=name.trim();
mailDesc=mailDesc.trim();
sqlStr = "insert into webMailList(name,mailDesc) values(";
sqlStr +="'"+Util.fromScreen2(name,user.getLanguage())+"'," ;
sqlStr +="'"+Util.fromScreen2(mailDesc,user.getLanguage())+"'" ;
sqlStr +=")";
RecordSet.executeSql(sqlStr);
response.sendRedirect("/web/mailList/MailList.jsp");
return;
}
String webIDs[]=request.getParameterValues("webIDs");
if(method.equals("delete"))
{
if(webIDs != null)
{
for(int i=0;i<webIDs.length;i++)
{
sqlStr = "DELETE FROM webMailList where id=" + webIDs[i];
RecordSet.executeSql(sqlStr);
}
}
response.sendRedirect("/web/mailList/MailList.jsp");
return;
}
if(method.equals("edit"))
{
String id=Util.null2String(request.getParameter("id"));
String name=Util.null2String(request.getParameter("name"));
String mailDesc=Util.null2String(request.getParameter("mailDesc"));
name=name.trim();
mailDesc=mailDesc.trim();
sqlStr = "UPDATE webMailList set " ;
sqlStr += " name = '" + Util.fromScreen2(name,user.getLanguage()) + "' , " ;
sqlStr += " mailDesc = '" + Util.fromScreen2(mailDesc,user.getLanguage()) + "' " ;
sqlStr += " where id = " + id ;
RecordSet.executeSql(sqlStr);
response.sendRedirect("/web/mailList/MailList.jsp");
return;
}
%>