基于javaweb的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的JSP+Servlet网上订餐在线点餐系统(前台、后台)(java+jsp+servlet+mysql+dbutil+tomcat)

			}
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
	}
	if(userType==2)
	{
		
	}
	return result;
}


   public String adminPwEdit(String userPwNew)
   //管理员密码编辑
   {
	System.out.println("DDDD");
   	try 
	{
		Thread.sleep(700);//确保线程运行顺序
	} 
	catch (InterruptedException e)
	{
		e.printStackTrace();
	}
	WebContext ctx = WebContextFactory.get(); 
	HttpSession session=ctx.getSession(); 
	TAdmin admin=(TAdmin)session.getAttribute("admin");
	
	String sql="update t_admin set userPw=? where userId=?";
	Object[] params={userPwNew,admin.getUserId()};
	DB mydb=new DB();
	mydb.doPstm(sql, params);
	
	return "yes";
   }
   
   
   public List catelogAll()
   //得到菜品类别结果集
   {
   	try
	{
		Thread.sleep(700);
	} catch (InterruptedException e)
	{
		// TODO Auto-generated catch block
		e.printStackTrace();

	if(type.endsWith("catelogMana"))
	{
		catelogMana(req, res);//菜品类别管理
	}
	if(type.endsWith("catelogDel"))
	{
		catelogDel(req, res);//菜品类别删除
	}
}

public void catelogAdd(HttpServletRequest req,HttpServletResponse res)
//菜品类别添加函数
{
	String id=String.valueOf(new Date().getTime());
	String name=req.getParameter("name").trim();//trim()去掉前后的空白
	String del="no";
	
	String sql="insert into t_catelog(id,name,del) values(?,?,?)";
	Object[] params={id,name,del};
	DB mydb=new DB();
	mydb.doPstm(sql, params);//执行sql语句，对数据库进行增删改查，结果赋值给结果集params中
	mydb.closed();
	
	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();

//添加商品
{
	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);
}


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"));

		
		req.setAttribute("message", "注册成功，请登录");
		req.setAttribute("path", "site/default.jsp");
		
        String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}
	
	
}



public void userLogout(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
	HttpSession session=req.getSession();
	session.setAttribute("userType", null);
	session.setAttribute("user", null);
	
		
	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"));

public class goods_servlet extends HttpServlet
{
	public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException 
	{
        String type=req.getParameter("type");
		
		if(type.endsWith("goodsAdd"))
		{
			goodsAdd(req, res);//添加菜品
		}
		if(type.endsWith("goodsMana"))
		{
			goodsMana(req, res);//菜品管理
		}
		if(type.endsWith("goodsDel"))
		{
			goodsDel(req, res);//菜品删除
		}
		if(type.endsWith("goodsDetailHou"))
		{
			goodsDetailHou(req, res);//菜品后台详细信息
		}
		if(type.endsWith("goodsPre"))
		{
			goodsPre(req, res);//菜品信息添加
		}
		if(type.endsWith("goodsEdit"))
		{
			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"))

---

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