sellbookservlet.java

网上书店 源代码和数据库网上书店 源代码和数据库

package com.shop.controller;

import java.io.IOException;
import java.util.List;

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

import com.shop.model.dao.BookInfoDAO;
import com.shop.model.dao.SellBookDAO;
import com.shop.vo.BookInfoVo;
import com.shop.vo.MultipSellVO;

public class SellBookServlet extends HttpServlet {

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

		String method=request.getParameter("method");
		if("showlist".equals(method)){
			SellBookDAO selldao=new SellBookDAO();
			BookInfoVo book=new BookInfoVo();
			List<BookInfoVo> bookList=null;
			bookList=selldao.findBookVO("1=1");
			request.setAttribute("booklist", bookList);
			request.getRequestDispatcher("/sellbookinfo/showSelllist.jsp").forward(request, response);
			return;
		}
		
		if("show".equals(method)){
			
			String iisbn=request.getParameter("iisbn");
			System.out.println(iisbn);
			SellBookDAO selldao=new SellBookDAO();
			MultipSellVO mulsell=new MultipSellVO();
			mulsell=selldao.SellBookList(iisbn);
			request.setAttribute("mulsell", mulsell);
			request.getRequestDispatcher("/sellbookinfo/showSellBook.jsp").forward(request, response);
			return;
		}	
		
	}

	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String method=request.getParameter("method");
	if("find".equals(method)){
		BookInfoVo book=new BookInfoVo();
		String isbnStr,nameStr,userStr,dateStr;
		String isbn=request.getParameter("isbn");
		int counter=0;
		if(!isbn.equals("")){
			isbnStr=" bf.ISBN='"+isbn+"' and ";
			counter++;
		}else{
			isbnStr="";
		}
		String bookname=request.getParameter("bookname");
		if(!bookname.equals("")){
			nameStr=" bf.BOOKNUM='"+bookname+"' and ";
			counter++;
		}else{
			nameStr="";
		}
		String buyuser=request.getParameter("buyuser");
		if(!buyuser.equals("")){
			userStr=" uf.USERNAME='"+buyuser+"' and ";
			counter++;
		}else{
			userStr="";
		}
		String adddate=request.getParameter("adddate");
		if(!adddate.equals("")){
			dateStr=" uf.ADDDATE='"+adddate+"' and ";
			counter++;
		}else{
			dateStr="";
		}
		if(counter==0){
			request.getRequestDispatcher("/booksearch/searchBook.jsp?select=faile").forward(request, response);
			return;
		}
		String sql=isbnStr+nameStr+userStr+dateStr+" 1=1";
		SellBookDAO bookdao=new SellBookDAO();
		List<BookInfoVo> bookList=null;
		bookList=bookdao.findBookVO(sql);
		request.setAttribute("query","Y");
		request.setAttribute("isbn", isbn);
		request.setAttribute("buyuser", buyuser);
		request.setAttribute("printNum", bookname);
		request.setAttribute("adddate", adddate);
		request.setAttribute("booklist", bookList);
		request.getRequestDispatcher("/sellbookinfo/showSelllist.jsp").forward(request, response);
	  }
	
	  if("updatePost".equals(method) ){
		  SellBookDAO selldao=new SellBookDAO();
			MultipSellVO mulsell=new MultipSellVO();
    	  String[] posted=request.getParameterValues("posted");
    	  selldao.updatePosted(posted);
    	 // request.setAttribute("method","showlist");
    	  request.getRequestDispatcher("/sellbookinfo/updateSucess.jsp").forward(request, response);
    	  
      }  
	}
        
	
	
	
}