svltbsbook.java

一个网上购书系统

package com.bookstore.book;


import java.io.IOException;

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


import com.bookstore.BookStoreConst;
import com.bookstore.svlt.ParamServlet;
import com.bookstore.util.UploadDownFile;

/**
* @author zhangh
* Date 2006-5-15
* Window - Preferences - Java - Code Style - Code Templates
*/
public class SvltBsBook extends ParamServlet
{
	/**
	 * 
	 */
	private static final long serialVersionUID = 43989944804182585L;
	BsBookInfo	bookinfo	= null;
	
	public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
	{
		try
		{
			super.byHttpService(request, response, BookStoreConst.ENCODING);
			bookinfo = new BsBookInfo(BookStoreConst.BOOKSTORESPOOL);
			HttpSession s = createGetSession(request);
			if (action.equals("addClassifyBig"))//添加图书大类
			{
				String classifyName = request.getParameter("classifyName");
				String sort = request.getParameter("sort");	
				bookinfo.addBookClassifyBig(classifyName,sort);
				url = BookStoreConst.JSPBookClassifyBig +"?info=1";
			} 
			else if(action.equals("editClassifyBig"))	//修改图书大类
			{
				String id = request.getParameter("id");
				String classifyName = request.getParameter("classifyName");
				String sort = request.getParameter("sort");	
				bookinfo.modifyBookClassifyBig(id,classifyName,sort);
				String info = "2";
				url = BookStoreConst.JSPBookClassifyBig +"?info="+info;
			}
			else if(action.equals("delClassifyBig")) //删除图书大类
			{
				String id = request.getParameter("id");
				bookinfo.deleteBookClassifyBig(id);
				String info = "3";
				url = BookStoreConst.JSPBookClassifyBig +"?info="+info;
			}
			else if(action.equals("addClassifyMid")){//添加图书分类（中类）
				String classifyBigId = request.getParameter("classifyBigId");
				String classifyName = request.getParameter("classifyName");
				String sort = request.getParameter("sort");	
				bookinfo.addBookClassifyMid(classifyBigId,classifyName,sort);
				url = BookStoreConst.JSPBookClassifyMid +"?info=1&classifyBigId="+classifyBigId;
				
			}
			else if(action.equals("changeSelect"))
			{
				String classifyBigId = request.getParameter("classifyBigId");
				url = BookStoreConst.JSPBookClassifyMid +"?classifyBigId="+classifyBigId;
			}
			else if(action.equals("editClassifyMid"))//修改图书分类（中类）
			{
				String id = request.getParameter("id");
				String classifyBigId = request.getParameter("classifyBigId");
				String classifyName = request.getParameter("classifyName");
				String sort = request.getParameter("sort");	
				bookinfo.modifyBookClassifyMid(id,classifyName,sort);
				
				url = BookStoreConst.JSPBookClassifyMid +"?info=2&classifyBigId="+classifyBigId;
			}
			else if(action.equals("delClassifyMid"))//删除图书分类（中类）
			{
				String id = request.getParameter("id");
				String classifyBigId = request.getParameter("classifyBigId");
				bookinfo.deleteBookClassifyMid(id);
				
				url = BookStoreConst.JSPBookClassifyMid +"?info=3&classifyBigId="+classifyBigId;
			}
			else if(action.equals("changeMidSelect"))
			{
				String classifyBigId = request.getParameter("classifyBigId");
				String classifyMidId = request.getParameter("classifyMidId");
				url = BookStoreConst.JSPBookClassifySmall +"?classifyMidId="+classifyMidId+"&classifyBigId="+classifyBigId;
			}
			else if(action.equals("addClassifySmall"))//添加图书细类
			{
				String classifyBigId = request.getParameter("classifyBigId");
				String classifyMidId = request.getParameter("classifyMidId");
				String classifyName = request.getParameter("classifyName");
				String sort = request.getParameter("sort");	
				bookinfo.addBookClassifySmall(classifyMidId,classifyName,sort);
				
				url = BookStoreConst.JSPBookClassifySmall +"?classifyMidId="+classifyMidId+"&classifyBigId="+classifyBigId;
			}
			else if(action.equals("editClassifySmall"))//修改图书细类
			{
				String id = request.getParameter("id");
				String classifyBigId = request.getParameter("classifyBigId");
				String classifyMidId = request.getParameter("classifyMidId");
				String classifyName = request.getParameter("classifyName");
				String sort = request.getParameter("sort");	
				bookinfo.modifyBookClassifySmall(id,classifyName,sort);
				
				url = BookStoreConst.JSPBookClassifySmall +"?classifyMidId="+classifyMidId+"&classifyBigId="+classifyBigId;
			}
			else if(action.equals("delClassifySmall")) //删除图书细类
			{
				String id = request.getParameter("id");
				String classifyBigId = request.getParameter("classifyBigId");
				String classifyMidId = request.getParameter("classifyMidId");
				bookinfo.deleteBookClassifySmall(id);
				
				url = BookStoreConst.JSPBookClassifySmall +"?classifyMidId="+classifyMidId+"&classifyBigId="+classifyBigId;
			}
			else if(action.equals("addPublish"))//添加出版社
			{
				String publishName = request.getParameter("publishName");
				String sort = request.getParameter("sort");
				bookinfo.addPublish(publishName,sort);
				
				url = BookStoreConst.JSPPublishManager+"?info=1";
				
			}
			else if(action.equals("editPublish"))//修改出版社信息
			{
				String id = request.getParameter("id");
				String publishName = request.getParameter("publishName");
				String sort = request.getParameter("sort");
				bookinfo.modifyPublish(id,publishName,sort);
				url = BookStoreConst.JSPPublishManager+"?info=2";
			}
			else if(action.equals("delPublish"))//删除出版社信息
			{
				String id = request.getParameter("id");
				bookinfo.deletePublish(id);
				url = BookStoreConst.JSPPublishManager+"?info=3";
			}
			else if(action.equals("addNation"))//添加国别信息
			{
				String sort=request.getParameter("sort");
				String nationName = request.getParameter("nationName");
				bookinfo.addNation(nationName,sort);
				url = BookStoreConst.JSPNationManager+"?info=1";
			}
			else if(action.equals("editNation"))//修改国别信息
			{
				String id = request.getParameter("id");
				String nationName = request.getParameter("nationName");
				String sort = request.getParameter("sort");
				bookinfo.modifyNation(id,nationName,sort);
				url = BookStoreConst.JSPNationManager+"?info=2";
			}
			else if(action.equals("delNation"))//删除国别信息
			{
				String id = request.getParameter("id");
				bookinfo.deleteNation(id);
				url = BookStoreConst.JSPNationManager+"?info=3";
			}
			else if(action.equals("addLibrary"))//添加馆区信息
			{
				String sort=request.getParameter("sort");
				String libraryName = request.getParameter("libraryName");
				bookinfo.addLibrary(libraryName,sort);
				url = BookStoreConst.JSPLibraryManager+"?info=1";		
			}
			else if(action.equals("editLibrary"))//修改馆区信息
			{
				String id = request.getParameter("id");
				String libraryName = request.getParameter("libraryName");
				String sort = request.getParameter("sort");
				bookinfo.modifyLibrary(id,libraryName,sort);
				url = BookStoreConst.JSPLibraryManager+"?info=2";
			}
			else if(action.equals("delLibrary"))//删除馆区信息
			{
				String id = request.getParameter("id");
				bookinfo.deleteLibrary(id);
				url = BookStoreConst.JSPLibraryManager+"?info=3";
			}
			else if(action.equals("addPackage"))//添加包装信息
			{
				String packageName = request.getParameter("packageName");
				String sort = request.getParameter("sort");
				bookinfo.addPackageing(packageName,sort);
				url = BookStoreConst.JSPPackageManager + "?info=1";
			}
			else if(action.equals("editPackage"))//修改包装信息
			{
				String id = request.getParameter("id");
				String packageName = request.getParameter("packageName");
				String sort = request.getParameter("sort");
				bookinfo.modifyPackage(id,packageName,sort);
				url = BookStoreConst.JSPPackageManager + "?info=2";
			}
			else if(action.equals("delPackage"))//删除包装信息
			{
				String id = request.getParameter("id");
				bookinfo.deletePackage(id);
				url = BookStoreConst.JSPPackageManager + "?info=3";
			}
			else if(action.equals("addFormat"))//添加开本信息
			{
				String formatName = request.getParameter("formatName");
				String sort = request.getParameter("sort");
				bookinfo.addFormat(formatName,sort);
				url = BookStoreConst.JSPFormatManager + "?info=1";
			}
			else if(action.equals("editFormat"))//修改开本信息
			{
				String id = request.getParameter("id");
				String formatName = request.getParameter("formatName");
				String sort = request.getParameter("sort");
				bookinfo.modifyFormat(id,formatName,sort);
				url = BookStoreConst.JSPFormatManager + "?info=2";
			}
			else if(action.equals("delFormat"))//删除开本信息
			{
				String id = request.getParameter("id");
				bookinfo.deleteFormat(id);
				url = BookStoreConst.JSPFormatManager + "?info=3";
			}
			else if(action.equals("changeClassifySelect"))
			{
				String libraryId = request.getParameter("libraryId");
				System.out.println("libraryId = "+libraryId);
				String classifyBigId = request.getParameter("classifyBigId");
				String classifyMidId = request.getParameter("classifyMidId");
				String classifySmallId = request.getParameter("classifySmallId");
				url = BookStoreConst.JSPAddBook +"?classifyBigId=" + classifyBigId +
					"&classifyMidId="+classifyMidId+"&classifySmallId="+classifySmallId +
					"&libraryId="+libraryId;
			}
			else if(action.equals("addBook"))//添加新图书信息
			{
				String userId = (String)s.getAttribute("userId");
				String bookName = request.getParameter("bookname");
				String publishId = request.getParameter("publish");
				String classifyBigId = request.getParameter("bookClassifyBig");
				String classifyMidId = request.getParameter("bookClassifyMid");
				if(classifyMidId.length()==0)
					classifyMidId = "0";
				String classifySmallId = request.getParameter("bookClassifySmall");
				if(classifySmallId.length()==0)
					classifySmallId = "0";
				String author = request.getParameter("author");
				String translater = request.getParameter("translater");
				String complier = request.getParameter("complier");
				String bookNumber = request.getParameter("bookNumber");
				String pressDate = request.getParameter("pressDate");
				String pageNumber = request.getParameter("pageNumber");
				String publishTime = request.getParameter("publishTime");
				String packagingId = request.getParameter("package");
				String formatId = request.getParameter("format");
				String nationId = request.getParameter("nation");
				String libraryId = request.getParameter("library");
				String marketPrice = request.getParameter("marketPrice");
				String seaPrice = request.getParameter("bookStorePrice");
				String stockNumber = request.getParameter("stockNumber");
				String saleNumber = request.getParameter("saleNumber");
				String smallPicPath = request.getParameter("smallPicPath");
				
				String bigPicPath = request.getParameter("bigPicPath");
				String recommend = request.getParameter("recommend");
				String summary = request.getParameter("summary");
				String catalogue = request.getParameter("catalogue");
				String comment = request.getParameter("comment");
				String[] type  = request.getParameterValues("type");
				String bookType = "";
				if(type.length>0)
				{
					if(type.length==1)bookType = type[0];
					else
					{
						for(int i=0;i<type.length;i++)
						{
							bookType = bookType + type[i] + ",";
						}
						bookType = bookType.substring(0,bookType.length()-1);
					}
				}else
					bookType = "";
				bookinfo.addBook(userId,bookName,
									publishId,
									classifyBigId,
									classifyMidId,
									classifySmallId,
									author,
									translater,
									complier,
									bookNumber,
									pressDate,
									pageNumber,
									publishTime,
									packagingId,
									formatId,
									nationId,
									libraryId,
									marketPrice,
									seaPrice,
									stockNumber,
									saleNumber,
									smallPicPath,
									bigPicPath,
									recommend,
									summary,
									catalogue,
									comment,
									bookType);
				s.removeAttribute("smallpicpath");
				s.removeAttribute("bigpicpath");
				
				url = BookStoreConst.JSPAddBook + "?info=1";
			}
			else if(action.equals("uploadSmallPic"))//上传小图片
			{
				UploadDownFile upfile = new UploadDownFile();
				upfile.setCharset(BookStoreConst.ENCODING);
				upfile.init(request);
				upfile.setMaxFileSize(5 * 1024 * 1024);
				String image_path =  "C:/temp/book/upload/images_small/";
				upfile.setSaveDir(image_path);
				upfile.uploadFile();
				String picPath = image_path + upfile.getFileName()[0];
				
				url = request.getContextPath()+"/admin/bookmanager/addbook.files/upload1.jsp?smallpicpath="+picPath;
			}
			else if(action.equals("uploadBigPic"))//上传大图片
			{
				UploadDownFile upfile = new UploadDownFile();
				upfile.setCharset(BookStoreConst.ENCODING);
				upfile.init(request);
				upfile.setMaxFileSize(5 * 1024 * 1024);
				String image_path = "C:/temp/book/upload/images_big/";
				upfile.setSaveDir(image_path);
				upfile.uploadFile();
				String picPath = image_path + upfile.getFileName()[0];
				url = request.getContextPath()+"/admin/bookmanager/addbook.files/upload2.jsp?bigpicpath="+picPath;
			}
			else if(action.equals("delBook"))//删除图书
			{
				String[] id = request.getParameterValues("selectbookid");
				for(int i=0;i<id.length;i++)
				{
					bookinfo.deleteBook(id[i]);
				}
				url = BookStoreConst.JSPManaBook;
			}
			else if(action.equals("searchBook"))//按不同条件查询图书
			{
				String selectkey = request.getParameter("selectkey");
				String selectm = request.getParameter("selectm");
				
				url = BookStoreConst.JSPManaBook + "?selectkey="+selectkey+"&selectm="+selectm;
			}
			else if(action.equals("addBookComment"))//添加书评
			{ 
				String libraryId = request.getParameter("libraryId");
				String midId  = request.getParameter("midId");
				String bookId = request.getParameter("bookId");
				String title = request.getParameter("title");
				String commentContent = request.getParameter("commentContent");
				
				bookinfo.addBookComment(bookId,title,commentContent);
				url = BookStoreConst.JSPBookComment +"?midId="+midId+"&libraryId="+libraryId+
					"&bookId="+bookId;
			}
			else if(action.equals("delBookCommon"))//删除评论（后台）
			{
				String[] id = request.getParameterValues("selectid");
				for(int i=0;i<id.length;i++)
				{
					bookinfo.deleteBookCommon(id[i]);
				}
				url = BookStoreConst.JSPBookCommon;
			}
			url = response.encodeRedirectURL(url);
			response.sendRedirect(url);
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
	}
}