基于javaweb的SSH餐厅点餐管理系统(java+ssh+mysql+jsp)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb的SSH餐厅点餐管理系统(java+ssh+mysql+jsp)

登录：
http://localhost:8080/login.jsp

管理员（后台管理）：
admin 123456
manager 123456

员工（前台管理、餐桌点餐、订单结算等）：
emp 123456

		query.setInteger(0, tabId);
		return query.executeUpdate();
	}

	@Override
	public int updateTableIsOff(Integer tabId) {
		Session session = sessionFactory.getCurrentSession();
		Query query = session.createQuery("update DiningTable set isno=0 where id=?");
		query.setInteger(0, tabId);
		return query.executeUpdate();
	}

	@Override
	public DiningTable getOneTableBytabNum(String tabNum) {
		Session session = sessionFactory.getCurrentSession();
		Query query = session.createQuery("from DiningTable where tableNum=?");
		query.setString(0, tabNum);
		return (DiningTable) query.list().get(0);
	}

	@Override
	public List<DiningTable> getdiningTable() {
		Session session = sessionFactory.getCurrentSession();
		Query query = session.createQuery("from DiningTable where isno=1 order by id");
		return query.list();
	}

}




public class MemberDaoImpl implements MemberDao {
	@Autowired
	private SessionFactory sessionFactory;

public int UpdateMember(Member member) {
	Session session = sessionFactory.getCurrentSession();
	try {
		session.update(member);
		return 1;
	} catch (Exception e) {
		return -1;
	}
}

@Override
public int delMember(Integer id) {
	Session session = sessionFactory.getCurrentSession();
	Query query = session.createQuery("delete from Member where id=?");
	query.setInteger(0, id);
	return query.executeUpdate();
}

@Override
public List<Member> getAllByMemberTypeId(Integer id) {
	Session session = sessionFactory.getCurrentSession();
	Query query = session.createQuery("from Member where memberType.id=?");
	query.setInteger(0, id);
	return query.list();
}

@Override
public int AddMember(Member member) {
	Session session = sessionFactory.getCurrentSession();
	return (Integer) session.save(member);
}

@Override
public int flagMemberByphone(String phone) {
	Session session = sessionFactory.getCurrentSession();
	String hql = "select count(*) from Member where phone=?";
	Query query = session.createQuery(hql);
	query.setString(0, phone);
	return ((Long)query.uniqueResult()).intValue();
}

@Override
public int UpdateMemberByphone(String phone, Integer code) {
	Session session = sessionFactory.getCurrentSession();
	String hql = "update Member set mcode=mcode+? where phone=?";
	Query query = session.createQuery(hql);
	query.setInteger(0, code);
	query.setString(1, phone);
	return query.executeUpdate();
}

	public Integer getToddayorderNum() {
		return toddayorderNum;
	}
	public void setToddayorderNum(Integer toddayorderNum) {
		this.toddayorderNum = toddayorderNum;
	}
	public Integer getRll1() {
		return rll1;
	}
	public void setRll1(Integer rll1) {
		this.rll1 = rll1;
	}
	public Integer getRll2() {
		return rll2;
	}
	public void setRll2(Integer rll2) {
		this.rll2 = rll2;
	}
	public Integer getRll3() {
		return rll3;
	}
	public void setRll3(Integer rll3) {
		this.rll3 = rll3;
	}
	public Integer getRll4() {
		return rll4;
	}
	public void setRll4(Integer rll4) {
		this.rll4 = rll4;
	}
	
}




public class MenuDaoImpl implements MenuDao {

	@Autowired
	private SessionFactory sessionFactory;
	
	public SessionFactory getSessionFactory() {

/**
 * 添加会员类型
 * @return
 * @throws IOException 
 */
public void addMemberType() throws IOException{
	PrintWriter out = ServletActionContext.getResponse().getWriter();
	int res = memberTypeservice.flagMemberType(typename);
	if(res==0){
		MemberType mt = new MemberType(typename);
		int result = memberTypeservice.addMemberType(mt);
		out.print(result);
	}else{
		out.print(-1);
	}
}
//删除条件
private Memberservice memberservice;
private Integer delID;
/**
 * 删除会员类型
 * @return
 * @throws IOException 
 */
public void delMemberType() throws IOException{
	PrintWriter out = ServletActionContext.getResponse().getWriter();
	List<Member> memberList = memberservice.getAllByMemberTypeId(delID);
	if(memberList.size()==0){
		int res = memberTypeservice.delMemberType(delID);
		out.print(res);
	}else{
		out.print(-1);
	}
	
}

//封装
public MemberTypeservice getMemberTypeservice() {
	return memberTypeservice;
}

public void setMemberTypeservice(MemberTypeservice memberTypeservice) {
	this.memberTypeservice = memberTypeservice;
}

public List<MemberType> getMembertypelist() {
	return membertypelist;
}

public void setMembertypelist(List<MemberType> membertypelist) {
	this.membertypelist = membertypelist;
}

	}else{
	}
}
/**
 * 添加餐桌
 * @return
 * @throws IOException 
 */
public void addTable() throws IOException{
	PrintWriter out = ServletActionContext.getResponse().getWriter();
	int flag = diningTableservice.flagTableNum(tablenum);
	if(flag==0){
		DiningTable dt = new DiningTable(tablenum,tablePernum,0);
		int res = diningTableservice.addDiningTable(dt);
		out.print(res);
	}else{
		out.print(-1);
	}
}
//封装
public DiningTableservice getDiningTableservice() {
	return diningTableservice;
}

public void setDiningTableservice(DiningTableservice diningTableservice) {
	this.diningTableservice = diningTableservice;
}

public Page getPageUtil() {
	return pageUtil;
}

public void setPageUtil(Page pageUtil) {
	this.pageUtil = pageUtil;
}

public Integer getPage() {
	return page;
}

public DiningTable getDiningTable() {
	return diningTable;
}
public void setDiningTable(DiningTable diningTable) {

---

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