managetopic.java

来自「采用j2ee架构做的bbs」· Java 代码 · 共 178 行

/*
 * 创建日期 2006-6-10
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package net.icefish.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;

import net.icefish.bean.Conn;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * @author Administrator
 * 
 * TODO 要更改此生成的类型注释的模板，请转至 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class ManageTopic extends HttpServlet {
	private Connection conn;

	public ManageTopic() {
		this.conn = Conn.connection();
	}

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

		
		response.setContentType("text/html;charset=GB2312");
		request.setCharacterEncoding("GB2312");
		int topic_id = Integer.parseInt(request.getParameter("topic_id"));
		if (request.getParameter("submit").equals("置顶")) {

			PreparedStatement pstmt1 = null;
			try {

				pstmt1 = conn
						.prepareStatement("update icefish_topic set topic_top='true' where topic_id="
								+ topic_id);
				int result1 = pstmt1.executeUpdate();

				pstmt1.close();
				
			}

			catch (SQLException e) {

				System.out.println(e.toString());
			}

		} else if (request.getParameter("submit").equals("取消置顶")) {

			PreparedStatement pstmt1 = null;
			try {

				pstmt1 = conn
						.prepareStatement("update icefish_topic set topic_top='false' where topic_id="
								+ topic_id);
				int result1 = pstmt1.executeUpdate();

				pstmt1.close();
				
			}

			catch (SQLException e) {

				System.out.println(e.toString());
			}

		} else if (request.getParameter("submit").equals("热门")) {

			PreparedStatement pstmt1 = null;
			try {

				pstmt1 = conn
						.prepareStatement("update icefish_topic set topic_hot='true' where topic_id="
								+ topic_id);
				int result1 = pstmt1.executeUpdate();

				pstmt1.close();
				
			}

			catch (SQLException e) {

				System.out.println(e.toString());
			}

		} else if (request.getParameter("submit").equals("取消热门")) {

			PreparedStatement pstmt1 = null;
			try {

				pstmt1 = conn
						.prepareStatement("update icefish_topic set topic_hot='false' where topic_id="
								+ topic_id);
				int result1 = pstmt1.executeUpdate();

				pstmt1.close();
				
			}

			catch (SQLException e) {

				System.out.println(e.toString());
			}

		} else if (request.getParameter("submit").equals("精华")) {

			PreparedStatement pstmt1 = null;
			try {

				pstmt1 = conn
						.prepareStatement("update icefish_topic set topic_best='true' where topic_id="
								+ topic_id);
				int result1 = pstmt1.executeUpdate();

				pstmt1.close();
				
			}

			catch (SQLException e) {

				System.out.println(e.toString());
			}

		} else if (request.getParameter("submit").equals("取消精华")) {

			PreparedStatement pstmt1 = null;
			try {

				pstmt1 = conn
						.prepareStatement("update icefish_topic set topic_best='false' where topic_id="
								+ topic_id);
				int result1 = pstmt1.executeUpdate();

				pstmt1.close();
				
			}

			catch (SQLException e) {

				System.out.println(e.toString());
			}

		} else if (request.getParameter("submit").equals("删除")) {

			PreparedStatement pstmt1 = null;
			try {

				pstmt1 = conn
						.prepareStatement("update icefish_topic set topic_del='true' where topic_id="
								+ topic_id);
				int result1 = pstmt1.executeUpdate();

				pstmt1.close();
				
			}

			catch (SQLException e) {

				System.out.println(e.toString());
			}

		}

		PrintWriter out=response.getWriter();
		out.println("<script>alert('操作成功！');history.back();</script>");
	}
}