赞
踩
基于javaweb+mysql的jsp+servlet在线奶茶店系统(java+jsp+javascript+servlet+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的JSP+Servlet在线奶茶店系统(java+jsp+javascript+servlet+mysql)
项目介绍
本系统分为前后台,分为普通用户和管理员两种角色;
管理员角色包含以下功能:
管理员登录,用户管理,分类管理,奶茶信息管理,订单管理,新闻管理等功能。
用户角色包含以下功能: 用户登录,按分类查看,查看商品详情,加入购物车,修改个人信息,查看订单,提交留言,留言管理等功能。
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 5.数据库:MySql 5.7版本; 6.是否Maven项目:否;
技术栈
JSP+CSS+JavaScript+java+servlet+mysql
使用说明
su.upload(); } catch (SmartUploadException e) { e.printStackTrace(); } Files fs = su.getFiles();//获得所有文件 File f = fs.getFile(0);//获得上传的文件 String fname = f.getFileName();//获得文件名 try { su.save("images/product");//保存图片到指定位置 } catch (SmartUploadException e) { e.printStackTrace(); } Request req1 = su.getRequest(); String pname = req1.getParameter("productName"); String id = req1.getParameter("parentId"); String price = req1.getParameter("productPrice"); String desc = req1.getParameter("productDesc"); String stock = req1.getParameter("productStock"); EASYBUY_PRODUCT p = null; if(price!=null && stock!=null && id!=null){ p = new EASYBUY_PRODUCT(0, pname, desc, Integer.parseInt(price), Integer.parseInt(stock), Integer.parseInt(id.split("-")[0]), Integer.parseInt(id.split("-")[1]), fname); } int count = 0; if(p!=null){ count = EASYBUY_PRODUCTDao.insert(p); } req.getRequestDispatcher("productSelect").forward(req, resp); } }
public class UserDoupdate extends HttpServlet { @Override protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { EncodeUtil.encode(req); resp.setContentType("text/html;charset=utf-8"); String username=req.getParameter("userName"); String name=req.getParameter("name"); String pwd=req.getParameter("passWord"); String sex=req.getParameter("sex"); String birthday=req.getParameter("birthday"); String email=req.getParameter("email"); String mobile=req.getParameter("mobile"); String address=req.getParameter("address"); String userStatus=req.getParameter("userStatus"); int status = 1; if(userStatus != null && !"".equals(userStatus)){ status = Integer.parseInt(userStatus); } EASYBUY_USER user=new EASYBUY_USER(username, name, pwd, sex, birthday, null, email, mobile, address, status); int count=EASYBUY_USERDao.update(user); if(count>0){ resp.sendRedirect("manage-result.jsp"); }else{ PrintWriter out=resp.getWriter(); out.print("<script>"); out.print("alert('修改失败');"); out.print("location.href='user'"); out.print("</script>"); out.close(); } }
EASYBUY_USER user=new EASYBUY_USER(username, name, pwd, sex, birthday, null, email, mobile, address, status); int count=EASYBUY_USERDao.update(user); if(count>0){ resp.sendRedirect("manage-result.jsp"); }else{ PrintWriter out=resp.getWriter(); out.print("<script>"); out.print("alert('修改失败');"); out.print("location.href='user'"); out.print("</script>"); out.close(); } } } public class UpManage extends HttpServlet { @Override protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); response.setContentType("text/html;charset=utf-8"); int id=Integer.parseInt(request.getParameter("orderId")); String name=request.getParameter("name"); String replyContent=request.getParameter("replyContent"); String Content=request.getParameter("Content"); Date date=new Date(); System.out.println(Content); SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String replyTime=sdf.format(date); EASYBUY_COMMENT comment=new EASYBUY_COMMENT(id,Content,replyTime,replyContent,replyTime,name); //System.out.println(id+"--"+content+"--"+replyTime+"--"+replyContent+"--"+name); comment.setEC_ID(id); int num=EASYBUY_COMMENTDao.update(comment); if(num>0){ response.sendRedirect("manage-result.jsp"); }else{
public class SelectDD extends HttpServlet { @Override protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("UTF-8"); //查询分类数据 ArrayList<EASYBUY_PRODUCT_CATEGORY> flist = EASYBUY_PRODUCT_CATEGORYDao.selectFather(); req.setAttribute("flist", flist); ArrayList<EASYBUY_PRODUCT_CATEGORY> clist = EASYBUY_PRODUCT_CATEGORYDao.selectChild(); req.setAttribute("clist", clist); ArrayList<EASYBUY_PRODUCT> tlist = EASYBUY_PRODUCTDao.selectAllByT(); req.setAttribute("tlist", tlist); ArrayList<EASYBUY_PRODUCT> hlist = EASYBUY_PRODUCTDao.selectAllByHot(); req.setAttribute("hlist", hlist); ArrayList<EASYBUY_NEWS> nlist = EASYBUY_NEWSDao.selectAll(); req.setAttribute("nlist", nlist); HttpSession session = req.getSession(); //查询最近浏览的商品 ArrayList<Integer> ids = (ArrayList<Integer>)session.getAttribute("ids"); if(ids!=null){ ArrayList<EASYBUY_PRODUCT> lastlylist = EASYBUY_PRODUCTDao.selectById(ids); req.setAttribute("lastlylist", lastlylist); } EncodeUtil.encode(req); String dd=req.getParameter("dd"); ArrayList<EASYBUY_Ddan> dan=EASYBUY_DdanDao.selectById(dd); req.setAttribute("dan", dan); req.getRequestDispatcher("Dan.jsp").forward(req, resp); } }
out.print("alert('修改失败');"); out.print("location.href='user'"); out.print("</script>"); out.close(); } } } public class UpManage extends HttpServlet { @Override protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); response.setContentType("text/html;charset=utf-8"); int id=Integer.parseInt(request.getParameter("orderId")); String name=request.getParameter("name"); String replyContent=request.getParameter("replyContent"); String Content=request.getParameter("Content"); Date date=new Date(); System.out.println(Content); SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String replyTime=sdf.format(date); EASYBUY_COMMENT comment=new EASYBUY_COMMENT(id,Content,replyTime,replyContent,replyTime,name); //System.out.println(id+"--"+content+"--"+replyTime+"--"+replyContent+"--"+name); comment.setEC_ID(id); int num=EASYBUY_COMMENTDao.update(comment); if(num>0){ response.sendRedirect("manage-result.jsp"); }else{
ArrayList<Integer> ids = (ArrayList<Integer>)session.getAttribute("ids"); if(ids==null){ ids = new ArrayList<Integer>(); } if(ids.size()>=5){ ids.remove(0); } //System.out.println(!ids.contains(Integer.parseInt(id))); if(id!=null&&(!ids.contains(Integer.parseInt(id)))){ ids.add(Integer.parseInt(id)); } session.setAttribute("ids", ids); ids = (ArrayList<Integer>) session.getAttribute("ids"); if(ids!=null){ ArrayList<EASYBUY_PRODUCT> lastlylist = EASYBUY_PRODUCTDao.selectById(ids); req.setAttribute("lastlylist", lastlylist); } //查询商品 EASYBUY_PRODUCT p = null; if(id!=null){ p = EASYBUY_PRODUCTDao.selectById(Integer.parseInt(id)); } req.setAttribute("p", p); req.getRequestDispatcher("product-view.jsp").forward(req, resp); } } public class LoginServlet extends HttpServlet { @Override protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
Font f=new Font("Times New Roman",Font.BOLD,50); g.setFont(f); int red=0,green=0,blue=0; String code=""; for (int i = 0; i < 4; i++) { red=rand.nextInt(255); green=rand.nextInt(255); blue=rand.nextInt(255); Color c=new Color(red,green,blue); g.setColor(c); int num=rand.nextInt(10); code+=num; g.drawString(num+"", i*20+20, 49); } HttpSession session=req.getSession(); session.setAttribute("syscode", code); ServletOutputStream out=resp.getOutputStream(); ImageIO.write(img, "jpg", out); } } public class UseraddServlet extends HttpServlet { @Override
HttpSession session = req.getSession(); //查询最近浏览的商品 ArrayList<Integer> ids = (ArrayList<Integer>)session.getAttribute("ids"); if(ids!=null){ ArrayList<EASYBUY_PRODUCT> lastlylist = EASYBUY_PRODUCTDao.selectById(ids); req.setAttribute("lastlylist", lastlylist); } EncodeUtil.encode(req); String dd=req.getParameter("dd"); ArrayList<EASYBUY_Ddan> dan=EASYBUY_DdanDao.selectById(dd); req.setAttribute("dan", dan); req.getRequestDispatcher("Dan.jsp").forward(req, resp); } } public class DoProductUpdateServlet extends HttpServlet { @Override protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { SmartUpload su = new SmartUpload(); su.initialize(this.getServletConfig(), req, resp); try { su.upload(); } catch (SmartUploadException e) { e.printStackTrace(); } Files fs = su.getFiles();//获得所有文件 File f = fs.getFile(0);//获得上传的文件 String fname = f.getFileName();//获得文件名 try { su.save("images/product");//保存图片到指定位置
// es_eod_quantity NUMBER,--购买数量 // es_ep_stock NUMBER,--商品库存 // es_ep_id NUMBER,--商品id // es_EU_USER_ID NVARCHAR2(30),--用户id // es_valid NUMBER --是否结账,1未结账,2已结账 EASYBUY_PRODUCT p = null; String pid = req.getParameter("id"); String count = req.getParameter("count"); if(pid!=null){ p = EASYBUY_PRODUCTDao.selectById(Integer.parseInt(pid)); } resp.setContentType("text/html;charset=utf-8"); PrintWriter out = resp.getWriter(); HttpSession session = req.getSession(); EASYBUY_USER user=(EASYBUY_USER)session.getAttribute("name"); if(user!=null){ // System.out.println("登录好了"); EASYBUY_USER eu=(EASYBUY_USER)session.getAttribute("name"); String id=(String)eu.getEU_USER_ID(); ArrayList<eb_shop> list=ESDao.getShop(id); req.setAttribute("shoplist",list); //req.getRequestDispatcher("shopping.jsp").forward(req, resp); }else{ out.print("<script>"); out.print("alert('请先登录');"); out.print("location.href='login.jsp';"); out.print("</script>"); out.close(); return; } String uid = user.getEU_USER_ID(); int valid = 1; eb_shop sp = new eb_shop(0, p.getEP_FILE_NAME(), p.getEP_NAME(), p.getEP_PRICE(), Integer.parseInt(count), p.getEP_STOCK(), p.getEP_ID(), uid, valid); ESDao.insert(sp); resp.sendRedirect("ShopSelect"); //req.getRequestDispatcher("ShopSelect").forward(req, resp); } }
int y1=rand.nextInt(width); int x2=rand.nextInt(width); int y2=rand.nextInt(width); g.drawLine(x1, y1, x2, y2); } Font f=new Font("Times New Roman",Font.BOLD,50); g.setFont(f); int red=0,green=0,blue=0; String code=""; for (int i = 0; i < 4; i++) { red=rand.nextInt(255); green=rand.nextInt(255); blue=rand.nextInt(255); Color c=new Color(red,green,blue); g.setColor(c); int num=rand.nextInt(10); code+=num; g.drawString(num+"", i*20+20, 49); } HttpSession session=req.getSession(); session.setAttribute("syscode", code); ServletOutputStream out=resp.getOutputStream(); ImageIO.write(img, "jpg", out); } }
public class SelectDD extends HttpServlet { @Override protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("UTF-8"); //查询分类数据 ArrayList<EASYBUY_PRODUCT_CATEGORY> flist = EASYBUY_PRODUCT_CATEGORYDao.selectFather(); req.setAttribute("flist", flist); ArrayList<EASYBUY_PRODUCT_CATEGORY> clist = EASYBUY_PRODUCT_CATEGORYDao.selectChild(); req.setAttribute("clist", clist); ArrayList<EASYBUY_PRODUCT> tlist = EASYBUY_PRODUCTDao.selectAllByT(); req.setAttribute("tlist", tlist); ArrayList<EASYBUY_PRODUCT> hlist = EASYBUY_PRODUCTDao.selectAllByHot(); req.setAttribute("hlist", hlist); ArrayList<EASYBUY_NEWS> nlist = EASYBUY_NEWSDao.selectAll(); req.setAttribute("nlist", nlist); HttpSession session = req.getSession(); //查询最近浏览的商品 ArrayList<Integer> ids = (ArrayList<Integer>)session.getAttribute("ids"); if(ids!=null){ ArrayList<EASYBUY_PRODUCT> lastlylist = EASYBUY_PRODUCTDao.selectById(ids); req.setAttribute("lastlylist", lastlylist); } EncodeUtil.encode(req); String dd=req.getParameter("dd"); ArrayList<EASYBUY_Ddan> dan=EASYBUY_DdanDao.selectById(dd); req.setAttribute("dan", dan); req.getRequestDispatcher("Dan.jsp").forward(req, resp); } }
public class ShopAddServlet extends HttpServlet { @Override protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { // es_id NUMBER primary key not null,--id // es_ep_file_name NVARCHAR2(30),--图片名称 // es_ep_name NVARCHAR2(30),--商品名 // es_ep_price NUMBER,--商品单价 // es_eod_quantity NUMBER,--购买数量 // es_ep_stock NUMBER,--商品库存 // es_ep_id NUMBER,--商品id // es_EU_USER_ID NVARCHAR2(30),--用户id // es_valid NUMBER --是否结账,1未结账,2已结账 EASYBUY_PRODUCT p = null; String pid = req.getParameter("id"); String count = req.getParameter("count"); if(pid!=null){ p = EASYBUY_PRODUCTDao.selectById(Integer.parseInt(pid)); } resp.setContentType("text/html;charset=utf-8"); PrintWriter out = resp.getWriter(); HttpSession session = req.getSession(); EASYBUY_USER user=(EASYBUY_USER)session.getAttribute("name"); if(user!=null){ // System.out.println("登录好了"); EASYBUY_USER eu=(EASYBUY_USER)session.getAttribute("name"); String id=(String)eu.getEU_USER_ID(); ArrayList<eb_shop> list=ESDao.getShop(id);
out.print("location.href='login.jsp';"); out.print("</script>"); out.close(); return; } String uid = user.getEU_USER_ID(); int valid = 1; eb_shop sp = new eb_shop(0, p.getEP_FILE_NAME(), p.getEP_NAME(), p.getEP_PRICE(), Integer.parseInt(count), p.getEP_STOCK(), p.getEP_ID(), uid, valid); ESDao.insert(sp); resp.sendRedirect("ShopSelect"); //req.getRequestDispatcher("ShopSelect").forward(req, resp); } } public class SelallServlet extends HttpServlet { @Override protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); resp.setContentType("text/html;charset=utf-8"); int page=1; //当前页数 int pagesize=6;//每页行数 String spage=req.getParameter("page"); ArrayList<EASYBUY_PRODUCT_CATEGORY> flist = EASYBUY_PRODUCT_CATEGORYDao.selectFather(); req.setAttribute("flist", flist); ArrayList<EASYBUY_PRODUCT_CATEGORY> clist = EASYBUY_PRODUCT_CATEGORYDao.selectChild(); req.setAttribute("clist", clist); if(spage!=null){ //如果页面上传递了页数,将当前页数改变掉 page=Integer.parseInt(spage); }
public class RegisterInServlet extends HttpServlet { @Override protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("UTF-8"); String username=req.getParameter("userName"); String name=req.getParameter("name"); String rePassWord=req.getParameter("rePassWord"); String sex=req.getParameter("sex"); String year=req.getParameter("birthday"); String email=req.getParameter("email"); String mobile=req.getParameter("mobile"); String address=req.getParameter("address"); String veryCode=req.getParameter("veryCode"); HttpSession session = req.getSession(); //获得系统生成的验证码 String sysCode = (String)session.getAttribute("syscode"); EASYBUY_USER u=new EASYBUY_USER(username, name, rePassWord, sex, year, null, email, mobile, address, 1); int count=EASYBUY_USERDao.insert(u); PrintWriter out=resp.getWriter(); if(sysCode.equals(veryCode)){ if(count>0){ resp.sendRedirect("reg-result.jsp"); }else{ out.write("<script>"); out.write("alert('register error');"); out.write("location.href='register.jsp'"); out.write("</script>"); out.close(); } } } }
req.setAttribute("cpage", cpage); //总页数 req.setAttribute("tpage", tpage); //搜索关键字 req.setAttribute("search_words", name); //父分类 req.setAttribute("selected_fid", fid); req.getRequestDispatcher("product-list.jsp").forward(req, resp); } } public class gmServlet extends HttpServlet { @Override protected void service(HttpServletRequest arg0, HttpServletResponse arg1) throws ServletException, IOException { arg1.setContentType("text/html;charset=utf-8"); PrintWriter out=arg1.getWriter(); EncodeUtil.encode(arg0); HttpSession session=arg0.getSession(); EASYBUY_USER list=(EASYBUY_USER)session.getAttribute("name"); //用户id String id=list.getEU_USER_ID(); //用户姓名 String name=list.getEU_USER_NAME(); //用户地址 String address=list.getEU_ADDRESS();
//查出总页数 ArrayList<EASYBUY_COMMENT> list=EASYBUY_COMMENTDao.selPage(page, pagesize); int max_page=EASYBUY_COMMENTDao.getMax(pagesize); if(list.size()>0&&max_page>0){ req.setAttribute("list", list); //把总页数传递给guestbook.jsp 使用 req.setAttribute("max_page", max_page); //把当前页数传递给guestbook.jsp使用 req.setAttribute("page", page); // 跳 req.getRequestDispatcher("guestbook.jsp").forward(req,resp); }else{ req.setAttribute("list", list); //把总页数传递给guestbook.jsp 使用 req.setAttribute("max_page", max_page); //把当前页数传递给guestbook.jsp使用 req.setAttribute("page", page); // 跳 req.getRequestDispatcher("guestbook.jsp").forward(req,resp); } } }
public class UpManage extends HttpServlet { @Override protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); response.setContentType("text/html;charset=utf-8"); int id=Integer.parseInt(request.getParameter("orderId")); String name=request.getParameter("name"); String replyContent=request.getParameter("replyContent"); String Content=request.getParameter("Content"); Date date=new Date(); System.out.println(Content); SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String replyTime=sdf.format(date); EASYBUY_COMMENT comment=new EASYBUY_COMMENT(id,Content,replyTime,replyContent,replyTime,name); //System.out.println(id+"--"+content+"--"+replyTime+"--"+replyContent+"--"+name); comment.setEC_ID(id); int num=EASYBUY_COMMENTDao.update(comment); if(num>0){ response.sendRedirect("manage-result.jsp"); }else{ } } }
HttpSession session = req.getSession(); //查询最近浏览的商品 ArrayList<Integer> ids = (ArrayList<Integer>)session.getAttribute("ids"); if(ids!=null){ ArrayList<EASYBUY_PRODUCT> lastlylist = EASYBUY_PRODUCTDao.selectById(ids); req.setAttribute("lastlylist", lastlylist); } req.getRequestDispatcher("index.jsp").forward(req, resp); } } public class UserNumServlet extends HttpServlet { @Override protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { int width=120; int height=60; BufferedImage img=new BufferedImage(width, height,BufferedImage.TYPE_INT_RGB); Graphics2D g=img.createGraphics(); g.setColor(Color.LIGHT_GRAY); g.fillRect(0, 0, width, height); g.setColor(Color.YELLOW); Random rand=new Random(); for (int i = 0; i < 15; i++) { int x1=rand.nextInt(width); int y1=rand.nextInt(width); int x2=rand.nextInt(width); int y2=rand.nextInt(width); g.drawLine(x1, y1, x2, y2);
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。