addcommentservlet.java

学生信息管理系统 jsp + sql + javabean 实现

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() {
    }
}