Java源码社

基于javaweb的JSP+Servlet在线购书商城系统(java+jsp+mysql+servlert+ajax)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

420023072402

430023072402

440023072402

450023072402

基于javaweb的JSP+Servlet在线购书商城系统(java+jsp+mysql+servlert+ajax)

一、项目简述

功能：一个基于JavaWeb的网上书店的设计与实现，归纳 出了几个模块，首先是登录注册模块，图书查找模块，购 物车模块，订单模块，个人中心模块，用户管理模块，图 书管理模块等。 该项目是javaJeb技术的实战操作，采用了MVC设计模 式，包括基本的entity, jscript, servlet,以及ajax异步请 求，查询分页，持久化层方法的封装等等，对javaweb技 术的巩固很有帮助，为J2EE的学习打下基础，适用于课程 设计，毕业设计。

二、项目运行

环境配置： Jdk1.8 + Tomcat8.5 + mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持)。

项目技术： JSP + Entity+ Servlert + html+ css + JavaScript + JQuery + Ajax + Fileupload 等等。

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
}

/**
 * 显示购物车
 * @param request
 * @param response
 * @throws ServletException
 * @throws IOException
 */
protected void showCart(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	ShoppingCart cart = (ShoppingCart) request.getSession().getAttribute("cart");
	if(cart!=null){
		Collection<ShoppingItem> silist = cart.getItems();
		request.getSession().setAttribute("silist", silist);
		//计算商品总价
		cart.getTotalReal();
	}else{
		cart = new ShoppingCart();
	}
	request.getSession().setAttribute("cart", cart);
	
	Users user = (Users) request.getSession().getAttribute("user");
	if(user!=null){
		//页面跳转
		response.sendRedirect("user/usercart.jsp");
	}else{
		//页面跳转
		response.sendRedirect("showcart.jsp");
	}
}


/**
 * 增加购物车商品数量
 * @param request
 * @param response
 * @throws ServletException
 * @throws IOException
 */
protected void inAmount(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	//从session中获取ShoppingCart
	ShoppingCart cart = (ShoppingCart) request.getSession().getAttribute("cart");
	if(cart!=null){
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
   }

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	doPost(request, response);
}

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {	
	String opt = request.getParameter("opt");
	String role = request.getParameter("role");
	//判断是否为管理员操作
	if(role!=null && role.equals("3")){
		optByAdmin(request, response);
		return;
	}
	//操作判断
	if(opt.equals("byTitle")){
		queryByTitle(request, response);
	}else if(opt.equals("byIsbn")){
		queryByIsbn(request, response);
	}else if(opt.equals("byCategory")){
		queryByCategory(request, response);
	}else if(opt.equals("buyBook")){
		buyBook(request, response);
	}else if(opt.equals("search")){
		search(request, response);
	}else if(opt.equals("byPublish")){
		queryByPublish(request, response);
	}else if(opt.equals("byCategoryName")){
		queryByCategoryName(request, response);
	}
	
	else{
		response.sendRedirect("index.jsp");
	}

}
/**
 * 管理员操作
 * @param request
 * @param response
 * @throws ServletException
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
	}else if(opt.equals("buyBook")){
		buyBook(request, response);
	}else if(opt.equals("search")){
		search(request, response);
	}else if(opt.equals("byPublish")){
		queryByPublish(request, response);
	}else if(opt.equals("byCategoryName")){
		queryByCategoryName(request, response);
	}
	
	else{
		response.sendRedirect("index.jsp");
	}

}
/**
 * 管理员操作
 * @param request
 * @param response
 * @throws ServletException
 * @throws IOException
 */
protected void optByAdmin(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	String opt = request.getParameter("opt");
	//判断是否登录
	Users user = (Users) request.getSession().getAttribute("user");
	if(user==null || user.getUserRoleId()!=3){
		response.sendRedirect("admin/login.jsp");
		return;
	}
	if(opt.equals("booklist")){
		bookListByAdmin(request, response);
	}
	else if(opt.equals("del")){
		delBookByAdmin(request, response);
	}
	else if(opt.equals("show")){
		showBookByAdmin(request, response);
	}
	else if(opt.equals("edit")){
		editBookByAdmin(request, response);
	}
	else if(opt.equals("add")){
		addBookByAdmin(request, response);
	}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
		//获取session中的user对象
		Users user = (Users) request.getSession().getAttribute("user");
		//调用dao层的获取订单方法
		OrderDaoImpl dao = new OrderDaoImpl();
		List<OrderBookCustom> olist = dao.getOrder(user.getId());
		//添加到session中
		request.getSession().setAttribute("olist",olist);
		//页面跳转
		response.sendRedirect("user/userorder.jsp");
	}
	

}
package cn.svtcc.edu.mybookshop.controller;



@WebServlet(name="InitServlet",urlPatterns={"/initServlet"},loadOnStartup=0)
public class InitServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    public InitServlet() {
        super();
    }

	@Override
	public void init(ServletConfig config) throws ServletException {
		//获取图书分类
		CategoriesDaoImpl dao = new CategoriesDaoImpl();
		List<Categories> clist = dao.getCategories();
		config.getServletContext().setAttribute("clist", clist);
		//获取出版社
		PublisherDaoImpl pdao = new PublisherDaoImpl();
		List<Publishers> plist = pdao.getPublisher();
		config.getServletContext().setAttribute("plist", plist);
		
		//获取热门图书
		BookDaoImpl bDao = new BookDaoImpl();
		List<Books> hotBList = bDao.getHotBooksByClicks();
		config.getServletContext().setAttribute("hotBList", hotBList);
		String ctxPath = config.getServletContext().getContextPath();
		config.getServletContext().setAttribute("ctxPath", ctxPath);
		System.out.println("InitServlet初始化完毕！");
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	doPost(request, response);
}

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {	
	String opt = request.getParameter("opt");
	String role = request.getParameter("role");
	//判断是否为管理员操作
	if(role!=null && role.equals("3")){
		optByAdmin(request, response);
		return;
	}
	//操作判断
	if(opt.equals("byTitle")){
		queryByTitle(request, response);
	}else if(opt.equals("byIsbn")){
		queryByIsbn(request, response);
	}else if(opt.equals("byCategory")){
		queryByCategory(request, response);
	}else if(opt.equals("buyBook")){
		buyBook(request, response);
	}else if(opt.equals("search")){
		search(request, response);
	}else if(opt.equals("byPublish")){
		queryByPublish(request, response);
	}else if(opt.equals("byCategoryName")){
		queryByCategoryName(request, response);
	}
	
	else{
		response.sendRedirect("index.jsp");
	}

}
/**
 * 管理员操作
 * @param request
 * @param response
 * @throws ServletException
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
 * @throws ServletException
 * @throws IOException
 */
protected void loginByAdmin(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	ShoppingCart cart = (ShoppingCart) request.getSession().getAttribute("cart");
	if(cart==null){
		cart = new ShoppingCart();
	}
	//获取参数
	String name = request.getParameter("loginId");
	String pwd = request.getParameter("loginPwd");
	//调用登录验证
	UserDaoImpl dao = new UserDaoImpl();
	Users user = dao.doLoginByAdmin(name, pwd);
	 if(user!=null){
		 //将user对象存入session中,便于前台使用
		 request.getSession().setAttribute("user", user);
		 response.sendRedirect("admin/index.jsp");
		 return;
	 }else{
		 response.sendRedirect("admin/login.jsp");
		 return;
	 }	
	
}
/**
 * 用户注销退出
 * @param request
 * @param response
 * @throws ServletException
 * @throws IOException
 */
protected void logout(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	//从session中获取用户信息
	Users user = (Users) request.getSession().getAttribute("user");
	if(user!=null){
		request.getSession().removeAttribute("user");
	}
	response.sendRedirect("login.jsp");
}

protected void show(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	response.sendRedirect("user/user.jsp");
}

/**

项目链接：
https://javayms.github.io?id=151422282105200cp
https://javayms.pages.dev?id=151422282105200cp