adminservlet.java

用J2EE开发的网站,可以应用到图书馆,图书超市

package ksnb;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;

public class AdminServlet extends HttpServlet {
    private static final String CONTENT_TYPE = "text/html; charset=GB2312";
    private ToConn toconn=null;
    private News news=null;
    private String page=null;
    private Affiche affiche=null;
    //Initialize global variables
    public void init() throws ServletException
    {
        toconn = new ToConn();
        news=new News();
        affiche=new Affiche();
    }

    //Process the HTTP Get request
    public void service(HttpServletRequest request, HttpServletResponse response) throws
            ServletException, IOException {
        HttpSession session=request.getSession();
        String cmd=(String)request.getParameter("cmd");
        //HttpSession session=request.getSession(true);
        System.out.println("cmd"+cmd);
        if(cmd.equals("selectopinion"))
        {
            toconn.SelectOpinion(request);
            //session.setAttribute("sql",request);
            //System.out.println("select ok");
            page="Back_Opinion.jsp";
        }
        else if(cmd.equals("modifyopinion"))//未完成，无法返回
        {
             toconn.Update(request);
             session.setAttribute("info","更新成功");
            // toconn.SelectOpinion(request);
             //toconn.SelectOpinion((HttpServletRequest)session.getAttribute("sql"));
             page="ok.jsp";
        }
        else if(cmd.equals("deleteopinion"))//未完成，无法返回
        {
            toconn.Delete(request);
            session.setAttribute("info","删除成功");
            //toconn.SelectOpinion((HttpServletRequest)session.getAttribute("sql"));
            page="ok.jsp";
        }
        else if(cmd.equals("insertopinion"))
        {
            toconn.insert(request);
            session.setAttribute("info","插入成功");
            page="ok.jsp";
        }
        else if(cmd.equals("selectnews"))
        {

            news.SelectNews(request);
            page="Back_News.jsp";
        }
        else if(cmd.equals("addnews"))
        {

            news.insert(request);
            page="Back_index.html";
        }
        /*else if(cmd.equals("newsmodify1"))
        {

        }
        else if(cmd.equals("newsmodify"))
        {

        }*/
        else if(cmd.equals("newsdelete"))
        {
            news.delete(request);
            session.setAttribute("info","删除成功");
            page="ok.jsp";
        }
        else if(cmd.equals("affichedelete"))
        {
            affiche.delete(request);
            System.out.println("delete affiche ok!");
            session.setAttribute("info","删除成功");
            page="ok.jsp";
        }
        else if(cmd.equals("insertaffiche"))
        {
            affiche.insert(request);
            session.setAttribute("info","插入成功");
            page="ok.jsp";
        }
        System.out.println(page);
        RequestDispatcher rd = request.getRequestDispatcher(page);
        rd.forward(request, response);
    }

    //Process the HTTP Post request
    /*public void doPost(HttpServletRequest request, HttpServletResponse response) throws
            ServletException, IOException {
        doGet(request, response);
    }*/

    //Clean up resources
    public void destroy()
    {
    }
}