【Java开源代码栏目提醒】:网学会员鉴于大家对Java开源代码十分关注,论文会员在此为大家搜集整理了“AddCommentServlet.java”一文,供大家参考学习
package sms.servlet;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import sms.db.*;
import java.sql.*;
import sms.bean.*;
public class AddCommentServlet extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=gb2312";
//Initialize global variables
public void init() throws ServletException {
}
public void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
doGet(request,response);
}
public void doGet(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
response.setContentType(CONTENT_TYPE);
request.setCharacterEncoding("gb2312");
String addCommentCommit = request.getParameter("addComment");
String scoreCommit = request.getParameter("scoreButton");
String score = request.getParameter("RadioGroup1");
String messegeId = request.getParameter("messegeId");
DBAccess dba = new DBAccess();
if(addCommentCommit != null){
System.out.println("test in AddCommentServlet 000");///////////
String comment = request.getParameter("comment");
String author = request.getParameter("author");
System.out.println("test in AddCommentServlet comment/author:"+comment+"/"+author);/////////////
if(comment != null && !comment.equals("")){
System.out.println("test in AddCommentServlet 000");/////////////
String sql = "insert into comment_info (messege_id,content,add_time,author) values('"+messegeId+"','"+comment+"',sysdate(),'"+author+"')";
try {
dba.getConnection();
int flag = dba.executeSql(sql);
} catch (Exception ex1) {
System.out.println("产生异常 AddCommentServlet.doGet()");///////////
ex1.printStackTrace();
}finally{
dba.closeConnection();
}
}
}
if(scoreCommit != null){
try {
if (score != null && score.length() > 0 && Integer.parseInt(score) > 0) {
dba.getConnection();
String sql2 = "update messege_info set score_num=score_num+1,total_score=total_score+"+score+" where id='"+messegeId+"'";
int flag = dba.executeSql(sql2);
}
} catch (Exception ex) {
}finally{
dba.closeConnection();
}
}
String dispatchURL = "messegedetailservlet?messegeId="+messegeId;
RequestDispatcher dispatcher = request.getRequestDispatcher(dispatchURL);
dispatcher.forward(request,response);
}
public void destroy() {
}
}