CommentOperation.jsp
2.24 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 import="java.sql.Timestamp" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" %> <%@ include file="/web/inc/init1.jsp" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="Util" class="weaver.general.Util" scope="page" />
<%
Date newdate = new Date() ;
long datetime = newdate.getTime() ;
Timestamp timestamp = new Timestamp(datetime) ;
String CurrentDate = (timestamp.toString()).substring(0,4) + "-" + (timestamp.toString()).substring(5,7) + "-" +(timestamp.toString()).substring(8,10);
String CurrentTime = (timestamp.toString()).substring(11,13) + ":" + (timestamp.toString()).substring(14,16) + ":" +(timestamp.toString()).substring(17,19);
String sqlStr = "" ;
String method = Util.null2String(request.getParameter("method"));
if(method.equals("add"))
{
String newsid = Util.null2String(request.getParameter("newsid"));
String docid = Util.null2String(request.getParameter("docid"));
String languageid = Util.null2String(request.getParameter("languageid"));
String isTime = Util.null2String(request.getParameter("isTime"));
String simple = Util.null2String(request.getParameter("simple"));
String name=Util.null2String(request.getParameter("name"));
String mail=Util.null2String(request.getParameter("mail"));
String comment=Util.null2String(request.getParameter("comment"));
name=name.trim();
mail=mail.trim();
comment=comment.trim();
sqlStr = "insert into DocWebComment(docId,name,mail_1,comment_1,createDate,createTime) values(" + docid ;
sqlStr +=",'"+name+"'" ;
sqlStr +=",'"+mail+"'" ;
sqlStr +=",'"+comment+"'" ;
sqlStr +=",'"+CurrentDate+"'" ;
sqlStr +=",'"+CurrentTime+"'" ;
sqlStr +=")";
RecordSet.executeSql(sqlStr); response.sendRedirect("/web/WebDetailDsp.jsp?newsid="+newsid+"&id="+docid+"&languageid="+languageid+"&isTime="+isTime+"&simple="+simple+"&fromComment=1");
return;
}
String commentIDs[]=request.getParameterValues("commentIDs");
if(method.equals("delete"))
{
if(commentIDs != null)
{
for(int i=0;i<commentIDs.length;i++)
{
sqlStr = "DELETE FROM DocWebComment where id=" + commentIDs[i];
RecordSet.executeSql(sqlStr);
}
}
response.sendRedirect("/web/comment/CommentList.jsp?isSearch=1");
return;
}
%>