tb_bookinfo_action.java

这是一个Struts网上商城(图书)的管理系统源代码.

package com.bookshop.action;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;

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.bookshop.dao.*;
import com.bookshop.dto.*;
import com.util.ParamUtils;

public class tb_bookinfo_action extends HttpServlet {

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

		request.setCharacterEncoding("gb2312");
		response.setContentType("text/html;charset=gb2312");
	doPost(request,response);
	
	}
	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
	request.setCharacterEncoding("gb2312");
	response.setContentType("text/html;charset=gb2312");
	PrintWriter out = response.getWriter();
	HttpSession session =request.getSession();
	String action=request.getParameter("action");
	
	//判断Http请求，根据不同请求进行不同的数据库操作
	
	//首页面显示的内容
	if(action!=null&&action.equals("index_page")){
		//首页显示6条记录
		ArrayList book_list=new bookinfo_dao().book_select();
		request.setAttribute("book_list",book_list);
		
		//新书上架
		ArrayList new_book=new bookinfo_dao().newbook();
		request.setAttribute("new_book",new_book);
		
		//销售排行
		
		ArrayList sort_list=new bookinfo_dao().sort();
		request.setAttribute("sort_list",sort_list);
		
		//网上调查
		ArrayList poll_list=new poll_dao().po_select();
		request.setAttribute("poll_list",poll_list);
		
		//公告信息
 		ArrayList bbs_list=new bbs_dao().bbs_select();
 		request.setAttribute("bbs_list",bbs_list);
		request.getRequestDispatcher("../index.jsp").forward(request,response);
	}
	
	
	//搜索图书页面
	if(action!=null&&action.equals("search")){
		
		System.out.println("search is running");
		 String book=request.getParameter("book");
         bookinfo_dao book_dao=new bookinfo_dao();
         
         //搜索结果
         ArrayList result=book_dao.search(book);
         request.setAttribute("result",result);
         
         // 网上调查
 		ArrayList poll_list=new poll_dao().po_select();
 		request.setAttribute("poll_list",poll_list);
         //公告信息
 		ArrayList bbs_list=new bbs_dao().bbs_select();
 		request.setAttribute("bbs_list",bbs_list);
 		
 		request.getRequestDispatcher("../search_deal.jsp").forward(request,response);
		
	}
	
	
	//新书上架
	
	if(action!=null&&action.equals("newbook")){
		
         // 网上调查
 		ArrayList poll_list=new poll_dao().po_select();
 		request.setAttribute("poll_list",poll_list);
         //公告信息
 		ArrayList bbs_list=new bbs_dao().bbs_select();
 		request.setAttribute("bbs_list",bbs_list);
 		
 		//查询新书
 		ArrayList newbook_list=new bookinfo_dao().newbook();
 		request.setAttribute("newbook_list",newbook_list);
 		
 		request.getRequestDispatcher("../newbook.jsp").forward(request,response);
		
	}
	
	
	//图书分类
	
	if(action!=null&&action.equals("booksort")){
		//图书分类列表
		
        ArrayList booksort_list=new bookinfo_dao().booksort();
 		request.setAttribute("booksort_list",booksort_list);
 		//分类详细信息
 		String type=request.getParameter("type");            
	       
	    if(type==null)
	    type="请选择类别";
	    else
	     {
		       type=new String(request.getParameter("type").getBytes("ISO-8859-1"));
		       ArrayList sortdetail_list=new bookinfo_dao().book(type);
		       request.setAttribute("sortdetail_list",sortdetail_list);
	       }
 		request.setAttribute("type",type);
 		
	    request.getRequestDispatcher("../booksort.jsp").forward(request,response);
	}
	
	//销售排行
	if(action!=null&&action.equals("ordersort")){
        // 网上调查
 		ArrayList poll_list=new poll_dao().po_select();
 		request.setAttribute("poll_list",poll_list);
         //公告信息
 		ArrayList bbs_list=new bbs_dao().bbs_select();
 		request.setAttribute("bbs_list",bbs_list);
 		
 		//排行查询
 		ArrayList sort_list=new bookinfo_dao().sort();
 		request.setAttribute("sort_list",sort_list);
 		
 		
 		
	    request.getRequestDispatcher("../sort.jsp").forward(request,response);
	}
	

	
	//图书详细信息
	if(action!=null&&action.equals("book_detail")){
        // 网上调查
 		ArrayList poll_list=new poll_dao().po_select();
 		request.setAttribute("poll_list",poll_list);
         //公告信息
 		ArrayList bbs_list=new bbs_dao().bbs_select();
 		request.setAttribute("bbs_list",bbs_list);
 		
 		//根据图书编号查询图书信息 		
 		request.setAttribute("book_detail",new bookinfo_dao().book_sel(request.getParameter("isbn")));
 		
 		
	    request.getRequestDispatcher("../book_detail.jsp").forward(request,response);
	}
	
	/*
	 * 后台图书管理
	 * 
	 */
	//后台图书管理首页
	if(action!=null&&action.equals("book_manage")){
		String next="";
	     	if(session.getAttribute("admin")!=null){
	     		System.out.print("book_manage is running");
	     		int pagesize=8;              //每页记录数
	     		int maxpage=new manager_index_dao().maxpage(pagesize);//求分页最大页
	     		int pa=ParamUtils.getIntParameter(request,"pa",1);//取当前页
	     		ArrayList list=new manager_index_dao().sel_book(pagesize,pa);//读取记录集
	     		request.setAttribute("maxpage",maxpage);
	     		request.setAttribute("pa",pa);
	     		request.setAttribute("user_list",list);
	     		
	     		next="/manager/ma_index.jsp";
	     	}
	     	else
	     	    next="/manager/login_m.jsp";
	     	
		request.getRequestDispatcher(next).forward(request,response);
	}
	
	//图书修改查询
	if(action!=null&&action.equals("book_update")){
		String next="";
		System.out.print("book_update is running");
     	if(session.getAttribute("admin")!=null){
     		
     	   String isbn=request.getParameter("isbn");
     	   bookinfo_dto dto=new manager_index_dao().isbn_select(isbn);
     	   request.setAttribute("dto",dto);
     		next="/manager/book_modify.jsp";
     	}
     	else
     	    next="/manager/login_m.jsp";
     	
	request.getRequestDispatcher(next).forward(request,response);
	}
	
	//图书修改执行
	if(action!=null&&action.equals("bookupd_excute")){
		String next="";
		System.out.print("bookupd_excute is running");
     	if(session.getAttribute("admin")!=null){
     		bookinfo_dto dto=new bookinfo_dto();
     		dto.setIsbn(request.getParameter("isbn"));
     		dto.setBookname(request.getParameter("bookname"));
     		dto.setWriter(request.getParameter("writer"));
     		dto.setType(request.getParameter("type"));
     		dto.setPublisher(request.getParameter("publisher"));
     		dto.setPdate(request.getParameter("pdate"));
     		dto.setCover(request.getParameter("cover"));
     		dto.setPrice(Float.parseFloat(request.getParameter("price")));
     		dto.setCommend(request.getParameter("commend"));
     		dto.setNewbook(request.getParameter("newbook"));
     		dto.setIntroduce(request.getParameter("introduce"));
     		
     		new manager_index_dao().book_upd(dto);
     		
     		next="tb_bookinfo_action?action=book_manage";
     	}
     	else
     	    next="/manager/login_m.jsp";
     	
	request.getRequestDispatcher(next).forward(request,response);
	}
	
	//删除图书(就是先进行查询)
	if(action!=null&&action.equals("book_del")){
		String next="";
		System.out.print("book_del is running");
     	if(session.getAttribute("admin")!=null){
     		String isbn=request.getParameter("isbn");
     		bookinfo_dto dto=new bookinfo_dao().book_sel(isbn);//此处调用的是dao包 中的manager_index_dao类
     		request.setAttribute("bookinfo",dto);
     		
     		next="../manager/book_del.jsp";
     	}
     	else
     	    next="/manager/login_m.jsp";
     	
	request.getRequestDispatcher(next).forward(request,response);
	}
	//执行删除操作
	
	if(action!=null&&action.equals("book_del_excute")){
		String next="";
		System.out.print("book_del_excute is running");
     	if(session.getAttribute("admin")!=null){
     		String isbn=request.getParameter("isbn");
     		new manager_index_dao().book_delete(isbn);
     		
     		next="tb_bookinfo_action?action=book_manage";
     	}
     	else
     	    next="/manager/login_m.jsp";
     	
	request.getRequestDispatcher(next).forward(request,response);
	}
	//添加图书
	if(action!=null&&action.equals("book_add")){
		String next="";
		System.out.print("book_add is running");
     	if(session.getAttribute("admin")!=null){
     		
     		bookinfo_dto dto=new bookinfo_dto();
     		dto.setIsbn(request.getParameter("isbn"));
     		dto.setBookname(request.getParameter("bookname"));
     		dto.setWriter(request.getParameter("writer"));
     		dto.setType(request.getParameter("type"));
     		dto.setPublisher(request.getParameter("publisher"));
     		dto.setPdate(request.getParameter("pdate"));
     		dto.setCover(request.getParameter("cover"));
     		dto.setPrice(Float.parseFloat(request.getParameter("price")));
     		dto.setCommend(request.getParameter("commend"));
     		dto.setNewbook(request.getParameter("newbook"));
     		dto.setIntroduce(request.getParameter("introduce"));
     		
     		
     		new manager_index_dao().book_insert(dto);
     		
     		next="tb_bookinfo_action?action=book_manage";
     	}
     	else
     	    next="/manager/login_m.jsp";
     	
	request.getRequestDispatcher(next).forward(request,response);
	}
	out.flush();
	out.close();
	}
}