基于javaweb+mysql的jsp+servlet早餐外卖店管理系统(java+jsp+javascript+servlet+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb的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
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中src/com/hr/dao/Basedao.java配置文件中的数据库配置改为自己的配置; 4. 运行项目,输入http://localhost:8080/ 登录 管理员账号/密码:admin/admin 用户账号/密码:user/123456
public class SelectProductViewServlet extends HttpServlet {
@SuppressWarnings("unchecked")
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
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);
String id = req.getParameter("id");
HttpSession session = req.getSession();
//查询最近浏览的商品
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 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);
}
}
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);
}
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);
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();
}
}
}
}
}
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();
}
}
}
public class LoginServlet extends HttpServlet {
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
req.setCharacterEncoding("UTF-8");
String username=req.getParameter("userName");
String passWord=req.getParameter("passWord");
String veryCode=req.getParameter("veryCode");
resp.setContentType("text/html;charset=utf-8");
HttpSession session = req.getSession();
//获得系统生成的验证码
String sysCode = (String)session.getAttribute("syscode");
int count=EASYBUY_USERDao.selectByNM(username, passWord);
EASYBUY_USER user=EASYBUY_USERDao.selectAdmin(username, passWord);
if(sysCode.equals(veryCode)){
if(count>0){
session.setAttribute("name", user);
if(user.getEU_STATUS()==2){
//System.out.println(user.getEU_STATUS());
//resp.sendRedirect("manage/index.jsp");
resp.sendRedirect("manage/index.jsp");
}else{
resp.sendRedirect("indexSelect");
}
}else{
PrintWriter out = resp.getWriter();
out.print("<script>");
out.print("alert('用户名或密码错误');");
out.print("location.href='login.jsp';");
out.print("</script>");
out.close();
}
}else{
PrintWriter out = resp.getWriter();
out.print("<script>");
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)
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");//保存图片到指定位置
} catch (SmartUploadException e) {
e.printStackTrace();
}
Request req1 = su.getRequest();
String id = req1.getParameter("id");
String pname = req1.getParameter("productName");
String pid = req1.getParameter("parentId");
String price = req1.getParameter("productPrice");
String desc = req1.getParameter("productDesc");
String stock = req1.getParameter("productStock");
EASYBUY_PRODUCT p = new EASYBUY_PRODUCT(Integer.parseInt(id),
pname,
desc,
Integer.parseInt(price),
Integer.parseInt(stock),
Integer.parseInt(pid.split("-")[0]),
Integer.parseInt(pid.split("-")[1]),
fname);
int count = 0;
if(p!=null){
count = EASYBUY_PRODUCTDao.update(p);
}
req.getRequestDispatcher("productSelect").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");//保存图片到指定位置
} catch (SmartUploadException e) {
e.printStackTrace();
}
Request req1 = su.getRequest();
String id = req1.getParameter("id");
String pname = req1.getParameter("productName");
String pid = req1.getParameter("parentId");
String price = req1.getParameter("productPrice");
String desc = req1.getParameter("productDesc");
String stock = req1.getParameter("productStock");
EASYBUY_PRODUCT p = new EASYBUY_PRODUCT(Integer.parseInt(id),
pname,
desc,
Integer.parseInt(price),
Integer.parseInt(stock),
Integer.parseInt(pid.split("-")[0]),
Integer.parseInt(pid.split("-")[1]),
fname);
int count = 0;
if(p!=null){
count = EASYBUY_PRODUCTDao.update(p);
}
req.getRequestDispatcher("productSelect").forward(req, 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();
}
}
}
out.close();
}else{
out.print("<script>");
out.print("alert('购物失败,请重新选择商品');");
out.print("location.href='ShopSelect';");
out.print("</script>");
out.close();
}
}
}
public class ShopAdd2Servlet 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");
}
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();
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);
}
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();
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);
}
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();
@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);
}
}
} 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 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);
}
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;
//获得系统生成的验证码
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();
}
}
}
}
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");