useraction.java

java开发购物车+网上书城

package com.xaccp.aj3q8073.action;

import java.util.List;

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

import com.xaccp.aj3q8073.controller.Action;
import com.xaccp.aj3q8073.controller.ActionForward;
import com.xaccp.aj3q8073.dao.BookInfoDao;
import com.xaccp.aj3q8073.dao.BulletinDao;
import com.xaccp.aj3q8073.dao.ContentsManagerDao;
import com.xaccp.aj3q8073.dao.OrderCar;
import com.xaccp.aj3q8073.dao.UserDao;
import com.xaccp.aj3q8073.vo.BookInfoVo;
import com.xaccp.aj3q8073.vo.BookReviewVo;
import com.xaccp.aj3q8073.vo.MyFavoriteVo;
import com.xaccp.aj3q8073.vo.NewsInfoVo;
import com.xaccp.aj3q8073.vo.OrderInfoVo;
import com.xaccp.aj3q8073.vo.OrderListVo;
import com.xaccp.aj3q8073.vo.PageBean;
import com.xaccp.aj3q8073.vo.UserInfoVo;

public class UserAction implements Action{
	ContentsManagerDao dao=new ContentsManagerDao();
	BookInfoDao bd=new BookInfoDao();
	UserDao ud=new UserDao();
	BulletinDao bb=new BulletinDao();
	
	public ActionForward execute(HttpServletRequest request, HttpServletResponse response) throws Exception {
		//公告信息
		List lsit= bb.findTopBulletin();
		request.getSession().setAttribute("bull_lsit", lsit);
		
		//一级目录
		List list= dao.findOneBookshelf();
		request.getSession().setAttribute("oneBookContent", list);
		//二级目录
		List listt= bd.findTwoContent();
		request.getSession().setAttribute("twoContent", listt);
		//最新推荐
		List st= ud.findNewBook();
		request.getSession().setAttribute("book_st", st);
		//查找点击率最高的前6本书
		List ct= ud.findBookByClick();
		request.getSession().setAttribute("book_ct", ct);
		//从订单信息表中查处销量最多的四本书的Id
		List li= ud.findBookBySale();
		int[] arg=new int[li.size()];
		for (int i = 0; i < li.size(); i++) {
			arg[i]= ((OrderListVo)li.get(i)).getBookId();
		}
		List tk= ud.findBookByarg(arg);
		request.getSession().setAttribute("book_tk", tk);
		
		List tsk= ud.findBookBycom();
		request.getSession().setAttribute("book_tsk", tsk);
		//查找行家推荐的前两本书
		return new ActionForward("/proscenium/qybook_main.jsp",true);
	}
	
	/**
	 * 会员登陆验证
	 * @param request
	 * @param response
	 * @return
	 * @throws Exception
	 */
	public ActionForward findMemberInfo(HttpServletRequest request, HttpServletResponse response) throws Exception {
		String member= request.getParameter("member");
		String pass=request.getParameter("pass");
		
		UserInfoVo vo=new UserInfoVo();
		vo.setUserName(member);
		vo.setUserPwd(pass);
		
		UserInfoVo uv= (UserInfoVo) ud.findMemberInfo(vo);
		if(uv!=null){
			request.getSession().setAttribute("memberInfo", uv);
			return new ActionForward("/userLogin.do");
		}else{
			return new ActionForward("/proscenium/memberError.jsp");
		}
	}
	/**
	 * 根据作者和图书名称名称查询图书
	 * 
	 * @param id
	 * @param pageSize
	 * @param author
	 * @return
	 */
	private static String bookName;
	private static String author;
	public ActionForward findBookInfo(HttpServletRequest request, HttpServletResponse response) throws Exception {
		String id= request.getParameter("id");//得到分页的Id
		if(id==null){
			id="1";
		}
		String _bookName=request.getParameter("bookName");
		String _author=request.getParameter("author");
		
		if(_bookName!=null){
			bookName=_bookName;
		}
		if(_author!=null){
			author=_author;
		}
		PageBean pb= ud.findBookInfoByAuthorAnd(Integer.parseInt(id), 3, author,bookName);
		request.getSession().setAttribute("pb", pb);
		return new ActionForward("/proscenium/StallStyleOne.jsp",true);
	}
	/**
	 * 根据shelfId对图书进行分页
	 */
	private static String shelfId;
	public ActionForward findBookByshelfId(HttpServletRequest request, HttpServletResponse response) throws Exception {
		String twoId= request.getParameter("twoId");//图书信息中的shelfId
		shelfId=twoId;
		String id= request.getParameter("id");//得到分页的Id
		if(id==null){
			id="1";
		} 
		PageBean pb= ud.findBookById(Integer.parseInt(shelfId), Integer.parseInt(id), 3);
		request.getSession().setAttribute("pb", pb);
		return new ActionForward("/proscenium/StallStyleOne.jsp",true);
	}
	/**
	 * 界面上根据id查询图书信息
	 * @param request
	 * @param response
	 * @return
	 * @throws Exception
	 */
	public ActionForward findBookById(HttpServletRequest request, HttpServletResponse response) throws Exception {
		String bookId=request.getParameter("bookId");
		//查询出图书信息
		BookInfoVo vo= (BookInfoVo) ud.findBookByBookId(Integer.parseInt(bookId));
		request.getSession().setAttribute("book_vo", vo);
		//查询出图书评论信息
		List list=ud.findReviewByBookId(Integer.parseInt(bookId));
		request.getSession().setAttribute("book_kv", list);
		return new ActionForward("/proscenium/BookInfomation.jsp",true);
	}
	
	/**
	 * 添加用户信息
	 * @param request
	 * @param response
	 * @return
	 * @throws Exception
	 */
	public ActionForward addUser(HttpServletRequest request, HttpServletResponse response) throws Exception {
		String user= request.getParameter("user");
		String pass= request.getParameter("pass");
		String rname= request.getParameter("rname");
		String age= request.getParameter("age");
		String ques= request.getParameter("ques");
		String ans= request.getParameter("ans");
		String tel= request.getParameter("tel");
		String add= request.getParameter("add");
		String post= request.getParameter("post");
		String sex= request.getParameter("sex");
		
		UserInfoVo vo=new UserInfoVo();
		vo.setUserName(user);
		vo.setUserPost(pass);
		vo.setUserRname(rname);
		vo.setUserAge(Integer.parseInt(age));
		vo.setUserQuestion(ques);
		vo.setUserAnswer(ans);
		vo.setUserTel(tel);
		vo.setUserAddress(add);
		vo.setUserPost(post);
		vo.setUserSex(Integer.parseInt(sex));
		
		int i= ud.saveUser(vo);
		if(i>0){
			vo.setUserId(i);
			request.getSession().setAttribute("memberInfo", vo);
			return new ActionForward("/userLogin.do");
		}
		return null;
		
	}
	/**
	 * 用户退出登陆
	 * @param request
	 * @param response
	 * @return
	 * @throws Exception
	 */
	public ActionForward userExit(HttpServletRequest request, HttpServletResponse response) throws Exception {
		request.getSession().invalidate();
		return new ActionForward("/proscenium/qybook_main.jsp",true);
	}
	/**
	 * 收藏图书
	 * @param request
	 * @param response
	 * @return
	 * @throws Exception
	 */
	public ActionForward saveFavorite(HttpServletRequest request, HttpServletResponse response) throws Exception {
		String fav= request.getParameter("fav");
		String userId=request.getParameter("userId");
		MyFavoriteVo vo=new MyFavoriteVo();
		vo.setBookId(Integer.parseInt(fav));
		vo.setUserId(Integer.parseInt(userId));
		int i= ud.saveFavorite(vo);
		if(i>0){
			return new ActionForward("/proscenium/fav.jsp");
		}
		return  null;
	}
	
	/**
	 * 根据id查找用户收藏的图书
	 * @param request
	 * @param response
	 * @return
	 * @throws Exception
	 */
	public ActionForward findFavByUserId(HttpServletRequest request, HttpServletResponse response) throws Exception {
		String userId=request.getParameter("userId");
		List list= ud.findFavByUserId(Integer.parseInt(userId));
		int k= list.size();
		request.getSession().setAttribute("fav_count", k);
		request.getSession().setAttribute("fav_list", list);
		return new ActionForward("/proscenium/userFavorite.jsp",true);
		
	}
	/**
	 * 根据id删除收藏夹中的图书
	 * @param request
	 * @param response
	 * @return
	 * @throws Exception
	 */
	public ActionForward delFavByBookId(HttpServletRequest request, HttpServletResponse response) throws Exception {
		String bookId= request.getParameter("bookId");
		String id=request.getParameter("userId");
		int userId= Integer.parseInt(id);
		int i= ud.delFavByBookId(Integer.parseInt(bookId));
		if(i>0){
			return new ActionForward("/space.do?userId="+userId);
		}
		return null;
	}
	/**
	 * 给购物车中添加图书
	 * @param request
	 * @param response
	 * @return
	 * @throws Exception
	 */
	public ActionForward saveBook(HttpServletRequest request, HttpServletResponse response) throws Exception {
		String bookId=request.getParameter("bookId");
		OrderCar car= (OrderCar) request.getSession().getAttribute("orderCar");
		if(car==null){
			car=new OrderCar();
			request.getSession().setAttribute("orderCar", car);
		}
		int i= car.findById(Integer.parseInt(bookId));
		if(i!=-1){
			car.addCount(i);
			return new ActionForward("/proscenium/ShopingCarinformation.jsp",true);
		}else{
			BookInfoVo vo= (BookInfoVo) ud.findBookByBookId(Integer.parseInt(bookId));
			car.putOrderCar(vo);
		}
		return new ActionForward("/proscenium/ShopingCarinformation.jsp",true);
	}
	
	/**
	 * 将购物车中的商品移除
	 * @param request
	 * @param response
	 * @return
	 * @throws Exception
	 */
	public ActionForward removeBookById(HttpServletRequest request, HttpServletResponse response) throws Exception {
		String bookId= request.getParameter("bookId");
		OrderCar car= (OrderCar) request.getSession().getAttribute("orderCar");
		car.removeById(Integer.parseInt(bookId));
		return new ActionForward("/proscenium/ShopingCarinformation.jsp",true);
	}
	
	/**
	 * 改变购物车中的商品数量
	 * @param request
	 * @param response
	 * @return
	 * @throws Exception
	 */
	public ActionForward editNumById(HttpServletRequest request, HttpServletResponse response) throws Exception {
		String bookId=request.getParameter("bookId");
		String bookNum=request.getParameter("bookNum");
		
		OrderCar car= (OrderCar) request.getSession().getAttribute("orderCar");
		car.setCount(Integer.parseInt(bookId), Integer.parseInt(bookNum));
		return new ActionForward("/proscenium/ShopingCarinformation.jsp",true);
	}
	/**
	 * 添加评论信息
	 * @param request
	 * @param response
	 * @return
	 * @throws Exception
	 */
	public ActionForward saveReview(HttpServletRequest request, HttpServletResponse response) throws Exception {
		String bookId=request.getParameter("bookId");
		String userId=request.getParameter("userId");
		String text=request.getParameter("text");
		String content=request.getParameter("content");
		BookReviewVo vo=new BookReviewVo();
		vo.setBookId(Integer.parseInt(bookId));
		vo.setUserId(Integer.parseInt(userId));
		vo.setReviewText(text);
		vo.setReviewContent(content);
		int i= ud.saveReview(vo);
		if(i>0){
			return new ActionForward("/proscenium/fav.jsp");
		}
		return null;
	}
	
	/**
	 * 添加订单信息
	 * @param request
	 * @param response
	 * @return
	 * @throws Exception
	 */
	public ActionForward saveOrderInfo(HttpServletRequest request, HttpServletResponse response) throws Exception {
		String userId=request.getParameter("userId");
		String name=request.getParameter("name");
		String sex=request.getParameter("sex");
		String post=request.getParameter("post");
		String mail=request.getParameter("mail");
		String tel=request.getParameter("tel");
		String address=request.getParameter("address");
		String send=request.getParameter("send");
		String pay=request.getParameter("pay");
		
		OrderInfoVo vo=new OrderInfoVo();
		vo.setUserId(Integer.parseInt(userId));
		vo.setCustmorName(name);
		vo.setCustmorTel(tel);
		vo.setCustmorSex(sex);
		vo.setCustmorPostman(post);
		vo.setCustmorAddress(address);
		vo.setCustmorEmail(mail);
		vo.setSendStyle(send);
		vo.setPayStyle(pay);
		
		int i= ud.saveOrderInfo(vo);
		
		OrderCar car= (OrderCar) request.getSession().getAttribute("orderCar");
		for (int j = 0; j < car.getList().size(); j++) {
			BookInfoVo bv= car.getList().get(j);
			OrderListVo dv=new OrderListVo();
			dv.setOrderId(i);
			dv.setBookId(bv.getBookId());
			dv.setBookCount(bv.getCount());
			dv.setFinalPrice(car.getAllPrice());
			ud.saveOrderList(dv);
		}
		
//		PageBean pus =ud.findOrderByMemberId(Integer.parseInt(userId), 1, 3);
//		request.getSession().setAttribute("pus", pus);
		return new ActionForward("/proscenium/fav.jsp",true);
	}
	/**
	 * 订单分页
	 * @param request
	 * @param response
	 * @return
	 * @throws Exception
	 */
	public ActionForward findNextOrder(HttpServletRequest request, HttpServletResponse response) throws Exception {
		String id=request.getParameter("id");
		if(id==null){
			id="1";
		}
		String userId=request.getParameter("userId");
		PageBean pb =ud.findOrderByMemberId(Integer.parseInt(userId), Integer.parseInt(id), 3);
		request.getSession().setAttribute("pb", pb);
		return new ActionForward("/proscenium/userSpace.jsp",true);
	}
	
	/**
	 * 往购物车中添加时先删除收藏表
	 * @param request
	 * @param response
	 * @return
	 * @throws Exception
	 */
	public ActionForward addOrderCar(HttpServletRequest request, HttpServletResponse response) throws Exception {
		String bookId=request.getParameter("bookId");
		ud.removeFayByBookId(Integer.parseInt(bookId));
		return  new ActionForward("buy.do?bookId="+bookId);
	}
	/**
	 * 修改密码
	 * @param request
	 * @param response
	 * @return
	 * @throws Exception
	 */
	public ActionForward editPwd(HttpServletRequest request, HttpServletResponse response) throws Exception {
		UserInfoVo vo= (UserInfoVo) request.getSession().getAttribute("memberInfo");
		int id=vo.getUserId();
		String pass=request.getParameter("newPwd");
		ud.editPwd(pass, id);
		return new ActionForward("/proscenium/fav.jsp");
	}
	public ActionForward showBull(HttpServletRequest request, HttpServletResponse response) throws Exception {
		String newsId=request.getParameter("newsId");
		NewsInfoVo vo= (NewsInfoVo) bb.findTopBull(Integer.parseInt(newsId));
		request.getSession().setAttribute("news_vo", vo);
		return new ActionForward("/proscenium/showBull.jsp");
	}
	
	
	
}