NewsTopStyleOperate.jsp
2.82 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
60
61
62
63
64
65
66
67
68
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<%@ page import="java.util.*" %>
<%@ page import="weaver.general.Util" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<%
String styleid = Util.null2String(request.getParameter("styleid"));
String styleids = Util.null2String(request.getParameter("styleids"));
String styleName = Util.null2String(request.getParameter("styleName"));
String type = Util.null2String(request.getParameter("type"));
String lastEditDate = Util.null2String(request.getParameter("lastEditDate"));
String titleColor = Util.null2String(request.getParameter("titleColor"));
String titleSize = Util.null2String(request.getParameter("titleSize"));
String titleFont = Util.null2String(request.getParameter("titleFont"));
String titleStyle = Util.null2String(request.getParameter("titleStyle"));
String abstractColor = Util.null2String(request.getParameter("abstractColor"));
String abstractSize = Util.null2String(request.getParameter("abstractSize"));
String abstractFont = Util.null2String(request.getParameter("abstractFont"));
String abstractStyle = Util.null2String(request.getParameter("abstractStyle"));
String operation = Util.null2String(request.getParameter("operation"));
String url = "";
if("add".equals(operation)){
String sql = "insert into hpNewsTopInfo(styleName,type,lastEditDate,titleColor,titleSize,titleFont,titleStyle,abstractColor,abstractSize,abstractFont,abstractStyle)"
+" values('"
+ styleName + "','"
+ type + "','"
+ lastEditDate + "','"
+ titleColor + "','"
+ titleSize + "','"
+ titleFont + "','"
+ titleStyle + "','"
+ abstractColor + "','"
+ abstractSize + "','"
+ abstractFont + "','"
+ abstractStyle + "'"
+")";
rs.execute(sql);
response.sendRedirect(url+"?type="+type+"&styleid="+styleid);
}else if("edit".equals(operation)){
String sql = "update hpNewsTopInfo set "
+ "styleName='" + styleName + "',"
+ "type='" + type + "',"
+ "lastEditDate='" + lastEditDate + "',"
+ "titleColor='" + titleColor + "',"
+ "titleSize='" + titleSize + "',"
+ "titleFont='" + titleFont + "',"
+ "titleStyle='" + titleStyle + "',"
+ "abstractColor='" + abstractColor + "',"
+ "abstractSize='" + abstractSize + "',"
+ "abstractFont='" + abstractFont + "',"
+ "abstractStyle='" + abstractStyle + "'"
+" where id = " + styleid;
rs.execute(sql);
response.sendRedirect(url+"?type="+type+"&styleid="+styleid);
}else if("delete".equals(operation)){
String sql ="delete from hpNewsTopInfo where id = " + styleid;
rs.execute(sql);
response.sendRedirect(url+"?type="+type+"&styleid="+styleid);
}else if ("deleteC".equals(operation)){
String sql ="delete from hpNewsTopInfo where id in ("+styleids+")";
rs.execute(sql);
response.sendRedirect(url+"?type="+type+"&styleid="+styleid);
}
%>