shot.java

在学校做的第一个jsp专周论坛,用了些ajax技术.

package com.service;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.db.DataProcess;

public class shot extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public shot() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		response.setContentType("text/xml;charset=utf-8");
		response.setHeader("Cache-Control","no-cache"); 
		PrintWriter out = response.getWriter();
		request.setCharacterEncoding("UTF-8"); 
		StringBuffer backInf=new StringBuffer();
		HttpSession sess=request.getSession(true);
		String shot=request.getParameter("shot");
		String sql;
		//获取bbs_id
		int bbs_id=Integer.parseInt(request.getParameter("bbs_id"));
		//String username=request.getParameter("username");//获取用户名
		String username=(String)sess.getAttribute("username");
		if(shot.equals("shot")){//加精
			//更新bbs表
		   sql="update bbs set bbshot=1 where bbs_id="+bbs_id;	
		   DataProcess.ExeQuery(sql);
		   //加用户积分20
		   String sqla="update user set userclass=userclass+20 where username="+"'"+username+"'";
	        System.out.println(sqla);
	        DataProcess.ExeQuery(sqla);
		}else{//去精
		   //更新bbs表
		   sql="update bbs set bbshot=0 where bbs_id="+bbs_id;
		   DataProcess.ExeQuery(sql);
		   //减用户积分-3
		   String sqla="update user set userclass=userclass-3 where username="+"'"+username+"'";
	        System.out.println(sqla);
	        DataProcess.ExeQuery(sqla);
		}
		
		out.print(backInf.toString());
		out.flush();
		out.close();
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}