基于javaweb+mysql的jsp+servlet网上订餐在线点餐系统(前台、后台)(java+jsp+servlet+mysql+dbutil+tomcat)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
后台:登录、类别管理、菜品管理、会员管理、订单管理、留言管理等
前台:登录、注册、查看菜品、购买、留言
前台
后台
技术框架
JSP Servlet MySQL DBUtil Tomcat JavaScript CSS jstl
基于javaweb+mysql的JSP+Servlet网上订餐在线点餐系统(前台、后台)(java+jsp+servlet+mysql+dbutil+tomcat)
}
public String delGoodsFromCart(String goodsId)//从购物车中删除物品
{
WebContext ctx = WebContextFactory.get(); //获取WebContext上下文
HttpSession session=ctx.getSession();//获得session对象
Cart cart=(Cart)session.getAttribute("cart");
cart.delGoods(goodsId);
session.setAttribute("cart", cart);
return "yes";
}
public String clearCart()//清空购物车
{
WebContext ctx = WebContextFactory.get();
HttpSession session=ctx.getSession();
Cart cart=(Cart)session.getAttribute("cart");
cart.getItems().clear();
session.setAttribute("cart", cart);
return "yes";
}
}
public class index_servlet extends HttpServlet
//导航页面服务端小程序
{
public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
req.getSession().setAttribute("catelogList", liuService.catelogList());
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tgoods goods=new Tgoods();
goods.setId(rs.getString("id"));
goods.setCatelog_id(rs.getString("catelog_id"));
goods.setBianhao(rs.getString("bianhao"));
goods.setMingcheng(rs.getString("mingcheng"));
goods.setJieshao(rs.getString("jieshao"));
goods.setFujian(rs.getString("fujian"));
goods.setShichangjia(rs.getInt("shichangjia"));
goods.setTejia(rs.getInt("tejia"));
goods.setDel(rs.getString("del"));
goodsList.add(goods);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("goodsList", goodsList);
req.getRequestDispatcher("admin/goods/goodsMana.jsp").forward(req, res);
}
public void goodsDel(HttpServletRequest req,HttpServletResponse res)
//删除商品
{
String id=req.getParameter("id");
String sql="update t_goods set del='yes' where id="+id;
Object[] params={};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("msg", "操作成功");
String targetURL = "/common/msg.jsp";
dispatch(targetURL, req, res);
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("msg", "操作成功");
String targetURL = "/common/msg.jsp";
dispatch(targetURL, req, res);
}
public void goodsMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
//管理商品,设置商品各种属性
{
List goodsList=new ArrayList();
String sql="select * from t_goods where del='no'";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tgoods goods=new Tgoods();
goods.setId(rs.getString("id"));
goods.setCatelog_id(rs.getString("catelog_id"));
goods.setBianhao(rs.getString("bianhao"));
goods.setMingcheng(rs.getString("mingcheng"));
goods.setJieshao(rs.getString("jieshao"));
goods.setFujian(rs.getString("fujian"));
goods.setShichangjia(rs.getInt("shichangjia"));
goods.setTejia(rs.getInt("tejia"));
goods.setDel(rs.getString("del"));
goodsList.add(goods);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("goodsList", goodsList);
ResultSet rs=mydb.getRs();
while(rs.next())
{
liuyan.setId(rs.getInt("id"));
liuyan.setNeirong(rs.getString("neirong"));
liuyan.setLiuyanshi(rs.getString("liuyanshi"));
liuyan.setUser_id(rs.getString("user_id"));
liuyan.setHuifu(rs.getString("huifu"));
liuyan.setHuifushi(rs.getString("huifushi"));
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
return liuyan;
}
public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response)
{
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try
{
dispatch.forward(request, response);
return;
}
catch (ServletException e)
{
e.printStackTrace();
}
catch (IOException e)
{
e.printStackTrace();
}
}
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
{
goodsEdit(req, res);//菜品信息编辑
}
if(type.endsWith("goodsNew"))
{
goodsNew(req, res);//菜品最新信息
}
if(type.endsWith("goodsByCatelog"))
{
goodsByCatelog(req, res);//菜品类别
}
if(type.endsWith("goodsDetailQian"))
{
goodsDetailQian(req, res);//菜品前台详细信息
}
if(type.endsWith("goodsRes"))
{
goodsRes(req, res);//菜品信息更新前
}
}
public void goodsAdd(HttpServletRequest req,HttpServletResponse res)
//添加商品
{
String id=String.valueOf(new Date().getTime());
String catelog_id=req.getParameter("catelog_id");
String bianhao=req.getParameter("bianhao");
String mingcheng=req.getParameter("mingcheng");
String jieshao=req.getParameter("jieshao");
String fujian=req.getParameter("fujian");
int shichangjia=Integer.parseInt(req.getParameter("shichangjia"));
int tejia=Integer.parseInt(req.getParameter("shichangjia"));
String del="no";
String sql="insert into t_goods(id,catelog_id,bianhao,mingcheng,jieshao,fujian,shichangjia,tejia,del) " +
"values(?,?,?,?,?,?,?,?,?)";
Object[] params={id,catelog_id,bianhao,mingcheng,jieshao,fujian,shichangjia,tejia,del};//Object[]定义一个一维对象,不需要强制类型转换
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("msg", "操作成功");
String targetURL = "/common/msg.jsp";
dispatch(targetURL, req, res);
}
String id=req.getParameter("id");
String sql="delete from t_order where id=?";
Object[] params={id};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("msg", "信息删除完毕");
String targetURL = "/common/msg.jsp";
dispatch(targetURL, req, res);
}
public void orderShouli(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
String id=req.getParameter("id");
String sql="update t_order set zhuangtai='yes' where id=?";
Object[] params={id};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("msg", "订单受理完毕");
String targetURL = "/common/msg.jsp";
dispatch(targetURL, req, res);
}
public void huifuAdd(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
String id=req.getParameter("id");
String huifu=req.getParameter("huifu");
String sql="update t_order set huifu=? where id=?";
Object[] params={huifu,id};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("msg", "操作成功");
String targetURL = "/common/msg.jsp";
dispatch(targetURL, req, res);
}
public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response)
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void destroy()
{
}
}
public class xinyong_servlet extends HttpServlet
{
public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
String type=req.getParameter("type");
if(type.endsWith("xinyongAdd"))
{
xinyongAdd(req, res);//信用添加
}
if(type.endsWith("xinyongMana"))
{
{
result="no";
}
if(mark==true)
{
result="yes";
Tuser user=new Tuser();
user.setId(rs.getString("id"));
user.setLoginname(rs.getString("loginname"));
user.setLoginpw(rs.getString("loginpw"));
user.setName(rs.getString("name"));
user.setDel(rs.getString("del"));
WebContext ctx = WebContextFactory.get();
HttpSession session=ctx.getSession();
session.setAttribute("userType", 1);
session.setAttribute("user", user);
Cart cart=new Cart();
session.setAttribute("cart", cart);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
}
if(userType==2)
{
}
return result;
}
public String adminPwEdit(String userPwNew)
//管理员密码编辑
{
System.out.println("DDDD");
try
{
}
rs.close();
}
catch (SQLException e)
{
System.out.println("登录失败!");
e.printStackTrace();
}
finally
{
mydb.closed();
}
}
if(userType==1)//会员登录
{
String sql="select * from t_user where loginname=? and loginpw=? and del='no'";
Object[] params={userName,userPw};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
boolean mark=(rs==null||!rs.next()?false:true);
if(mark==false)
{
result="no";
}
if(mark==true)
{
result="yes";
Tuser user=new Tuser();
user.setId(rs.getString("id"));
user.setLoginname(rs.getString("loginname"));
user.setLoginpw(rs.getString("loginpw"));
user.setName(rs.getString("name"));
user.setDel(rs.getString("del"));
WebContext ctx = WebContextFactory.get();
HttpSession session=ctx.getSession();
req.setAttribute("userList", userList);
req.setAttribute("xinyongList", liuService.getxinyongList(id));
req.getRequestDispatcher("admin/user/userDetail.jsp").forward(req, res);
}
public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response)
{
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try
{
dispatch.forward(request, response);
return;
}
catch (ServletException e)
{
e.printStackTrace();
}
catch (IOException e)
{
e.printStackTrace();
}
}
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void destroy()
{
}
}
req.setAttribute("msg", "操作成功");
String targetURL = "/common/msg.jsp";
dispatch(targetURL, req, res);
}
public void catelogMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
//菜品类别管理
{
List catelogList=new ArrayList();
String sql="select * from t_catelog where del='no'";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())//如果存在下一条语句,循环执行
{
Tcatelog catelog=new Tcatelog();
catelog.setId(rs.getString("id"));
catelog.setName(rs.getString("name"));
catelogList.add(catelog);//添加类别到菜品类别集
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("catelogList", catelogList);
req.getRequestDispatcher("admin/catelog/catelogMana.jsp").forward(req, res);
}
public void catelogDel(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
//菜品类别删除成功
{
String sql="update t_catelog set del='yes' where id="+req.getParameter("id");
Object[] params={};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
{
result="no";
}
else
{
result="yes";
TAdmin admin=new TAdmin();
admin.setUserId(rs.getInt("userId"));
admin.setUserName(rs.getString("userName"));
admin.setUserPw(rs.getString("userPw"));
WebContext ctx = WebContextFactory.get(); //得到WebContext对象ctx
HttpSession session=ctx.getSession();
session.setAttribute("userType", 0);
session.setAttribute("admin", admin);
}
rs.close();
}
catch (SQLException e)
{
System.out.println("登录失败!");
e.printStackTrace();
}
finally
{
mydb.closed();
}
}
if(userType==1)//会员登录
{
String sql="select * from t_user where loginname=? and loginpw=? and del='no'";
Object[] params={userName,userPw};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
boolean mark=(rs==null||!rs.next()?false:true);
if(mark==false)
{
result="no";
}
if(mark==true)
{
result="yes";
public class order_servlet extends HttpServlet
{
public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
String type=req.getParameter("type");
if(type.endsWith("orderMana"))
{
orderMana(req, res);//订单管理
}
if(type.endsWith("orderDel"))
{
orderDel(req, res);//订单删除
}
if(type.endsWith("orderShouli"))
{
orderShouli(req, res);//受理订单
}
if(type.endsWith("huifuAdd"))
{
huifuAdd(req, res);//添加回复
}
}
public void orderMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
List orderList=new ArrayList();
String sql="select * from t_order order by zhuangtai desc";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Torder order=new Torder();
order.setId(rs.getString("id"));
order.setBianhao(rs.getString("bianhao"));
order.setShijian(rs.getString("shijian"));
order.setZhuangtai(rs.getString("zhuangtai"));
order.setHuifu(rs.getString("huifu"));
order.setSonghuodizhi(rs.getString("songhuodizhi"));
order.setFukuanfangshi(rs.getString("fukuanfangshi"));
order.setJine(rs.getInt("jine"));
order.setUser_id(rs.getString("user_id"));
orderList.add(order);
}
req.setAttribute("message", "成功退出系统");
req.setAttribute("path", "site/default.jsp");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void userMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
List userList=new ArrayList();
String sql="select * from t_user where del='no'";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tuser user=new Tuser();
user.setId(rs.getString("id"));
user.setLoginname(rs.getString("loginname"));
user.setLoginpw(rs.getString("loginpw"));
user.setLoginpw(rs.getString("loginpw"));
user.setName(rs.getString("name"));
userList.add(user);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("userList", userList);
req.getRequestDispatcher("admin/user/userMana.jsp").forward(req, res);
}
public void goodsDetailHou(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
//商品的具体描述信息
{
String id=req.getParameter("id");
req.setAttribute("goods", liuService.getGoods(id));
req.getRequestDispatcher("admin/goods/goodsDetailHou.jsp").forward(req, res);
}
public void goodsPre(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
//菜品信息添加函数
{
Tgoods goods=new Tgoods();
String sql="select * from t_goods where id=?";
Object[] params={req.getParameter("id")};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
goods.setId(rs.getString("id"));
goods.setCatelog_id(rs.getString("catelog_id"));
goods.setBianhao(rs.getString("bianhao"));
goods.setMingcheng(rs.getString("mingcheng"));
goods.setJieshao(rs.getString("jieshao"));
goods.setFujian(rs.getString("fujian"));
goods.setShichangjia(rs.getInt("shichangjia"));
goods.setTejia(rs.getInt("tejia"));
goods.setDel(rs.getString("del"));
}
rs.close();
}
catch(Exception e)
{
public class user_servlet extends HttpServlet
{
public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
String type=req.getParameter("type");
if(type.endsWith("userReg"))
{
userReg(req, res);//会员注册
}
if(type.endsWith("userLogout"))
{
userLogout(req, res);//会员退出
}
if(type.endsWith("userMana"))
{
userMana(req, res);//会员管理
}
if(type.endsWith("userDel"))
{
userDel(req, res);//会员删除
}
if(type.endsWith("userDetail"))
{
userDetail(req, res);//会员详细信息
}
}
public void userReg(HttpServletRequest req,HttpServletResponse res)
//会员注册
{
String id=String.valueOf(new Date().getTime());
String loginname=req.getParameter("loginname");
String loginpw=req.getParameter("loginpw");
String name=req.getParameter("name");
String del="no";
String s=liuService.panduan_zhanghao(loginname);
if(s.equals("yizhan"))
{
req.setAttribute("message", "账号已被占用,请输入其他账号");
req.setAttribute("path", "site/userreg/userreg.jsp");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
String fujian=req.getParameter("fujian");
int shichangjia=Integer.parseInt(req.getParameter("shichangjia"));
int tejia=Integer.parseInt(req.getParameter("shichangjia"));
String del="no";
String sql="insert into t_goods(id,catelog_id,bianhao,mingcheng,jieshao,fujian,shichangjia,tejia,del) " +
"values(?,?,?,?,?,?,?,?,?)";
Object[] params={id,catelog_id,bianhao,mingcheng,jieshao,fujian,shichangjia,tejia,del};//Object[]定义一个一维对象,不需要强制类型转换
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("msg", "操作成功");
String targetURL = "/common/msg.jsp";
dispatch(targetURL, req, res);
}
public void goodsMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
//管理商品,设置商品各种属性
{
List goodsList=new ArrayList();
String sql="select * from t_goods where del='no'";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tgoods goods=new Tgoods();
goods.setId(rs.getString("id"));
goods.setCatelog_id(rs.getString("catelog_id"));
goods.setBianhao(rs.getString("bianhao"));
goods.setMingcheng(rs.getString("mingcheng"));
goods.setJieshao(rs.getString("jieshao"));
goods.setFujian(rs.getString("fujian"));
public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response)
{
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try
{
dispatch.forward(request, response);
return;
}
catch (ServletException e)
{
e.printStackTrace();
}
catch (IOException e)
{
e.printStackTrace();
}
}
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void destroy()
{
}
}
public class buy_servlet extends HttpServlet
{