基于servlet+jsp的网上书店系统

基于servlet+jsp的网上书店系统，数据库采用mysql。基本功能：登录、注册、浏览书店、加入购物车、查看购物车等，后台管理对用户、书籍进行增删改查管理。

系统使用mysql数据库，后端采购servlet model service三层结构 

package dlufl.servlet;

import java.io.IOException;

import java.io.PrintWriter;

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

import dlufl.dao.AdveristingDao;
import dlufl.model.Adveristing;
@WebServlet("/AdminServlet")
public class AdminServlet extends HttpServlet {
	public AdminServlet() {
		super();
	}
	public void destroy() {
		super.destroy(); 
	}
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		//转换编码
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		//设置内容类型
		response.setContentType("text/html;charset=UTF-8");
		//创建out对象
		PrintWriter out=response.getWriter();
		//获取action的值
		String action=request.getParameter("action");		
		if("insert".equals(action)){			
			insert(request, response);			
		}else if("deleteadver".equals(action)){
			deleteadver(request, response);
		}else if("updateadver".equals(action)){
			updateadver(request,response);
		}
		else{
			out.print("<script>alert('非法操作！');location.href='login.jsp'</script>");
			return;
		}	
	}
	private void updateadver(HttpServletRequest request,
			HttpServletResponse response) throws IOException {
		String name=request.getParameter("name");
		String designer=request.getParameter("designer");
		String price=request.getParameter("price");
		String company=request.getParameter("company");
		String id=request.getParameter("id");
		
		PrintWriter out=response.getWriter();
		
		Adveristing bm=new Adveristing();
		//设置名称
		bm.setName(name);
		bm.setDesigner(designer);
		//设置价格
		bm.setPrice(Double.valueOf(price));
		bm.setCompany(company);
		bm.setId(Integer.parseInt(id));
		AdveristingDao bd=new AdveristingDao();
		if(bd.updateAdver(bm)){
			out.print("<script>alert('修改成功');location.href='admin.jsp'</script>");
		}else{
			out.print("<script>alert('修改失败');history.go(-1)</script>");
		}
	}
	private void deleteadver(HttpServletRequest request,
			HttpServletResponse response) throws IOException {
		PrintWriter out=response.getWriter();
		String id=request.getParameter("id");
		AdveristingDao bd=new AdveristingDao();
		if(bd.delAdver(Integer.valueOf(id))){
			//删除成功就跳到管理员页面admin.jsp
			out.print("<script>alert('删除成功');location.href='admin.jsp'</script>");
		}else{
			//history.go(-1)往后退一个页面
			out.print("<script>alert('删除失败');history.go(-1)</script>");
		}
	}

	private void insert(HttpServletRequest request, HttpServletResponse response) throws IOException {
		PrintWriter out=response.getWriter();
		String name=request.getParameter("name");
		String designer=request.getParameter("designer");
		String price=request.getParameter("price");
		String company=request.getParameter("company");
		
		Adveristing bm=new Adveristing();
		//设置书名
		bm.setName(name);
		
		bm.setDesigner(designer);
		//设置书价格
		bm.setPrice(Double.valueOf(price));
		//设置书图片
		bm.setCompany(company);
		AdveristingDao bd=new AdveristingDao();
		//判断是否成功添加一本新的书籍
		if(bd.insertAdver(bm)){
			//同上
			out.print("<script>alert('增加成功');location.href='admin.jsp'</script>");
			
		}else{
			//同上
			out.print("<script>alert('增加失败');location.href='history.go(-1)'</script>");
		}
	}
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doGet(request, response);
	}
	public void init() throws ServletException {
	}

}