Java源码社

基于javaweb的JSP+Servlet在线书店购书系统(java+jsp+servlet+mysql+tomcat)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

Jdk1.8 + Tomcat8.5 + mysql + Eclispe（IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持）

061623450306

520023332402

530023332402

550023332402

560023332402

560023332403

560023332404

基于javaweb的JSP+Servlet在线书店购书系统(java+jsp+servlet+mysql+tomcat)

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
	if(bd.bookBatDelById(ids)) {
		request.setAttribute("bookMessage", "图书已批量删除");
		if(uid.imgBatDelById(imgIds)) {
			for(UpLoadImg uli:list) {
				//批量删除本地文件
				File f=new File(contextPath,uli.getImgSrc());
				if(f.exists()) {
					//f.delete();
				}
			}
		}
	}else {
		request.setAttribute("bookMessage", "图书批量删除失败");
	}
	//用户删除成功失败都跳转到用户列表页面
	bookList(request, response);//通过servlet中listUser跳到用户列表
}

//图书删除
private void bookDel(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	int id=Integer.parseInt(request.getParameter("id"));
	File contextPath=new File(request.getServletContext().getRealPath("/"));
	BookDao bd=new BookDaoImpl();
	UpLoadImgDao uid=new UpLoadImgDaoImpl();
	Book book=bd.findBookById(id);
	//这里先删除数据库图书信息，再删除图书图片及本地硬盘图片信息
	if(bd.bookDelById(id)) {
		request.setAttribute("bookMessage", "图书已删除");
		if(uid.imgDelById(book.getImgId())) {
			//删除本地文件
			File f=new File(contextPath,book.getUpLoadImg().getImgSrc());
			if(f.exists()) {
				//f.delete();
			}
		}
	}else {
		request.setAttribute("bookMessage", "图书删除失败");
	}
	
	//用户删除成功失败都跳转到用户列表页面
	bookList(request, response);//通过servlet中listUser跳到用户列表
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
47
48
49
50
51
/**
 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
 */
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	doPost(request, response);
}

/**
 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
 */
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	
	String action=request.getParameter("action");
	switch(action){
	case "login":
		login(request,response);
		break;
	case "off":
		offlogin(request,response);
		break;
	case "ajlogin":
		ajlogin(request,response);
		break;
	case "reg":
		reg(request,response);
		break;
	case "landstatus":
		landstatus(request,response);
		break;

	}
}



//判断登陆状态
private void landstatus(HttpServletRequest request, HttpServletResponse response) throws IOException {
	
	User user=  (User) request.getSession().getAttribute(LANDING);
	
	PrintWriter pw = response.getWriter();
	JSONObject json=new JSONObject();
	
	if(user!=null) {
		json.put("status", "y");
	}else {
		json.put("status", "n");
	}
	pw.print(json.toString());
	pw.flush();
	
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
47
48
49
50
@WebServlet("/CartServlet")
public class CartServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doPost(request, response);
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String action=request.getParameter("action");
		switch(action) {
		case "add":
			addTOCart(request,response);
			break;
		case "changeIn":
			changeIn(request,response);//更改购物车商品数量
			break;
		case "delItem":
			delItem(request,response);
			break;
		case "delAll":
			delAll(request,response);
		}
	}


	private void delAll(HttpServletRequest request, HttpServletResponse response) throws IOException {
		request.getSession().removeAttribute("shopCart");
		response.sendRedirect("jsp/book/cart.jsp");
		
	}

	//购物项删除
	private void delItem(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
		int bookId=Integer.parseInt(request.getParameter("id"));
		Cart shopCart = (Cart) request.getSession().getAttribute("shopCart");
		if(shopCart.getMap().containsKey(bookId)) {
			shopCart.getMap().remove(bookId);
		}
		response.sendRedirect("jsp/book/cart.jsp");
	}

	//更改购物项数量
	private void changeIn(HttpServletRequest request, HttpServletResponse response) throws IOException {
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
				if(f.exists()) {
					//f.delete();
				}
			}
		}
	}else {
		request.setAttribute("bookMessage", "图书批量删除失败");
	}
	//用户删除成功失败都跳转到用户列表页面
	bookList(request, response);//通过servlet中listUser跳到用户列表
}

//图书删除
private void bookDel(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	int id=Integer.parseInt(request.getParameter("id"));
	File contextPath=new File(request.getServletContext().getRealPath("/"));
	BookDao bd=new BookDaoImpl();
	UpLoadImgDao uid=new UpLoadImgDaoImpl();
	Book book=bd.findBookById(id);
	//这里先删除数据库图书信息，再删除图书图片及本地硬盘图片信息
	if(bd.bookDelById(id)) {
		request.setAttribute("bookMessage", "图书已删除");
		if(uid.imgDelById(book.getImgId())) {
			//删除本地文件
			File f=new File(contextPath,book.getUpLoadImg().getImgSrc());
			if(f.exists()) {
				//f.delete();
			}
		}
	}else {
		request.setAttribute("bookMessage", "图书删除失败");
	}
	
	//用户删除成功失败都跳转到用户列表页面
	bookList(request, response);//通过servlet中listUser跳到用户列表
	
}

//图书更新
private void bookUpdate(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	BookDao bookDao=new BookDaoImpl();
	Book book=new Book();
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
47
48
49
50
51
52
53
54
	}
	
}

private void deleteOrder(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException  {
	String orderid=request.getParameter("id");
	OrderDao orderDao = new OrderDaoImpl();
	if(orderid != null && orderid != "") {
		orderDao.deleteOrderItem(Integer.valueOf(orderid));
		orderDao.deleteOrder(Integer.valueOf(orderid));
	}
	orderList(request, response);
}

private void seachOrder(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	int curPage = 1;
	String page = request.getParameter("page");
	if (page != null) {
		curPage = Integer.parseInt(page);
	}
	int maxSize = Integer.parseInt(request.getServletContext().getInitParameter("maxPageSize"));
	String ordername = request.getParameter("ordername");
	OrderDao orderDao = new OrderDaoImpl();
	PageBean pb = null;
	if(ordername != null && ordername != "") {
		pb = new PageBean(curPage, maxSize, orderDao.orderReadCount(ordername));
		request.setAttribute("orderList", orderDao.orderList(pb,ordername));
	}else {
		pb = new PageBean(curPage, maxSize, orderDao.orderReadCount());
		request.setAttribute("orderList", orderDao.orderList(pb));
	}
	
	request.setAttribute("pageBean", pb);
	request.getRequestDispatcher(ORDERLIST_PATH).forward(request, response);
}

private void seachOrder1(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	int curPage = 1;
	String page = request.getParameter("page");
	if (page != null) {
		curPage = Integer.parseInt(page);
	}
	int maxSize = Integer.parseInt(request.getServletContext().getInitParameter("maxPageSize"));
	String ordername = request.getParameter("ordername");
	OrderDao orderDao = new OrderDaoImpl();
	PageBean pb = null;
	if(ordername != null && ordername != "") {
		pb = new PageBean(curPage, maxSize, orderDao.orderReadCountByStatus(1,ordername));
		request.setAttribute("orderList", orderDao.orderListByStatus(pb,1,ordername));
	}else {
		pb = new PageBean(curPage, maxSize, orderDao.orderReadCountByStatus(1));
		request.setAttribute("orderList", orderDao.orderListByStatus(pb,1));
	}
	
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
        
    }
	
}
package com.shine.bookshop.servlet.book;




/**
 * Servlet implementation class BookList
 */
@WebServlet("/BookList")
public class BookList extends HttpServlet {
	private static final long serialVersionUID = 1L;
	private static final int MAX_LIST_SIZE = 12;
	private static final String BOOKLIST_PATH="jsp/book/booklist.jsp";
   

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		
		String action=request.getParameter("action");
		if(action==null) {
			action="list";
		}
		switch(action) {
		case "d":
			break;
			
		case "list"://默认全部图书列表
			bookList(request,response);
			break;

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