基于javaweb+mysql的ssm+maven超市收银管理系统(java+ssm+jsp+javascript+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM+Maven超市收银管理系统(java+ssm+jsp+javascript+mysql)
系统管理员:
admin 123456
收银员:
cashier1 123456
cashier2 123456
注意:只有系统身份为1或者2才可以登录系统,注册后也需要管理员对其赋予权限后才可登录!
public class LoginController {
@Autowired
private LoginService loginService;
/*
用户登录共实现,需要验证用户名及密码的正确性;
返回int
1:管理员
2:会员
3:普通收银员
*/
@RequestMapping(value = "log",produces = "text/plain;charset=utf-8")
@ResponseBody
public String Login(String username, String password, HttpSession session){
User user = new User();
user.setUserName(username);
user.setUserPassword(password);
User login = loginService.login(user);
session.setAttribute("username",username);
session.setAttribute("userid",login.getId());
if (login!=null){
if (login.getUserRole()==2){
return "2";
}
if (login.getUserRole()==1){
return "1";
}
}
return "0";
}
/*
用户注册功能实现,需要使用User表的字段
详情可以@User JavaBean
返回
提示注册失败or成功
*/
@RequestMapping(value = "register",produces = "text/plain;charset=utf-8")
@ResponseBody
public String Register(String userName,String Password,Integer gender,String birthday,String phone,String address){
User user = new User();
user.setUserName(userName); user.setUserPassword(Password); user.setGender(gender);
user.setBirthday(birthday); user.setPhone(phone); user.setAddress(address);
int register = loginService.register(user);
if (register==-1){
return "您已有账号,请勿重复操作";
}
if (register>0){
return "注册成功";
}
if (i>0){
return "退货成功";
}
return "退货失败";
}
/**
* 1.加载修改会员界面,并传入需要修改的商品id
* 2.查询id对应的会员信息
* 3.修改会员
**/
@RequestMapping("updateMemberLoad")
public ModelAndView updateMemberLoad(Integer id){
Member memberById = updateService.getMemberById(id);
ModelAndView mv = new ModelAndView("update/updatemember");
mv.addObject("memberById",memberById);
return mv;
}
@RequestMapping(value = "updateMember",produces = "text/plain;charset=utf-8")
@ResponseBody
public String updateMember(Integer id,String name, Double discount, String phone, String address, String gender, String code, String birthday){
Member member = new Member();
member.setId(id);
member.setMemberBirthday(birthday);
member.setMemberCode(code);
member.setMemberName(name);
member.setMenberDiscount(discount);
member.setMenmberAddress(address);
member.setMenberGender(gender);
member.setMenmberPhone(phone);
int i = updateService.updateMember(member);
if (i>0){
return "修改成功,是否返回";
}
return "修改失败,是否返回";
}
}
}
@RequestMapping("shoppingcartLoad")
public ModelAndView shoppingCart(Integer userid){
List<Bill> bills = checkerService.shoppingCart(userid);
ModelAndView mv= new ModelAndView("checker/shoppingcart");
mv.addObject("bills",bills);
return mv;
}
@RequestMapping(value = "deleteShopping",produces = "text/plain;charset=utf-8")
@ResponseBody
public String deleteShopping(Integer id){
int i = checkerService.deleteShopping(id);
if (i>0){
return "删除成功";
}
return "删除失败";
}
@RequestMapping(value = "goShopping",produces = "text/plain;charset=utf-8")
@ResponseBody
public String goShopping(Integer id){
int i = checkerService.updateBill(id);
if (i>0){
return "购买成功";
}
return "购买失败";
}
}
@Controller
@RequestMapping("delete")
public class DeleteController {
@Autowired
private DeleteService deleteService;
//根据用户id删除用户
@RequestMapping(value = "deleteUser",produces = "text/plain;charset=utf-8")
@ResponseBody
public String deleteUser(Integer id){
}
return "修改失败,是否返回用户列表";
}
/**
* 1.加载修改供应商界面,并根据id查找对应的供应商
* 2.查询id对应的供应商信息
* 3.修改供应商
**/
@RequestMapping("updateProviderLoad")
public ModelAndView updateProviderLoad(Integer id){
Provider providerById = updateService.getProviderById(id);
ModelAndView mv = new ModelAndView("update/updateprovider");
mv.addObject("providerById",providerById);
return mv;
}
@RequestMapping(value = "updateProvider",produces = "text/plain;charset=utf-8")
@ResponseBody
public String updateProvider(Integer id,String proName,String proCode,String proContact,String proPhone,String proAddress,String proDesc){
Provider provider = new Provider();
provider.setId(id);
provider.setProName(proName);
provider.setProCode(proCode);
provider.setProContact(proContact);
provider.setProPhone(proPhone);
provider.setProAddress(proAddress);
provider.setProDesc(proDesc);
int i = updateService.updateProvider(provider);
if (i>0){
return "修改成功,是否返回";
}
return "修改失败,是否返回";
}
/**
* 1.加载修改商品界面,并传入需要修改的商品id
* 2.查询id对应的商品信息
* 3.修改商品
**/
@RequestMapping("updateGoodsLoad")
public ModelAndView updateGoodsLoad(Integer id){
Goods goodsById = updateService.getGoodsById(id);
List<Provider> providerToUpdateGoods = updateService.getProviderToUpdateGoods();
ModelAndView mv = new ModelAndView("update/updategoods");
Provider provider = new Provider();
provider.setProName(proName);
provider.setProCode(proCode);
provider.setProContact(proContact);
provider.setProPhone(proPhone);
provider.setProAddress(proAddress);
provider.setProDesc(proDesc);
int i = insertService.insertProvider(provider);
if (i>0){
return "新增成功,是否返回?";
}
return "新增失败,是否返回?";
}
/**
* 管理员新增商品信息
* 1.加载新增商品信息界面,并传入供应商信息(需要供应商信息以供用户新增商品时选择)
* 2.新增商品信息
**/
@RequestMapping("insertGoodsLoad")
public ModelAndView insertGoodsLoad(){
List<Provider> providerToGoods = insertService.getProviderToGoods();
ModelAndView mv = new ModelAndView("insert/insertgoods");
mv.addObject("providerToGood",providerToGoods);
return mv;
}
@RequestMapping(value = "insertGoods",produces = "text/plain;charset=utf-8")
@ResponseBody
public String insertGoods(String goodsCode,String goodsName,String goodsUnit, String goodsGenre,Integer goodsBid,Integer goodsPric,Integer provider){
Goods goods = new Goods();
goods.setGoodsCode(goodsCode);
goods.setGoodsName(goodsName);
goods.setGoodsUnit(goodsUnit);
goods.setGoodsGenre(goodsGenre);
goods.setGoodsBid(goodsBid);
goods.setGoodsPric(goodsPric);
goods.setProviderid(provider);
int i = insertService.insertGoods(goods);
if (i>0){
return "新增成功,是否返回?";
}
return "新增失败,是否返回?";
}
/**
* 管理员新增会员信息
* 1.加载新增会员信息界面
* 2.新增会员信息
**/
*/
@RequestMapping("insertUserLoad")
public ModelAndView insertUser(Integer id){
return new ModelAndView("insert/insertuser");
}
@RequestMapping(value = "insertUser",produces = "text/plain;charset=utf-8")
@ResponseBody
public String insertUser(String username,String password,String phone,String address,Integer gender,Integer role,String birthday) {
User user = new User();
user.setUserName(username);
user.setUserPassword(password);
user.setPhone(phone);
user.setAddress(address);
user.setGender(gender);
user.setUserRole(role);
user.setBirthday(birthday);
int i = insertService.insertUser(user);
if (i>0){
return "新增成功,是否返回?";
}
return "新增失败,是否返回?";
}
/*
* 管理员新增供应商
* 1.加载了添加供应商界面
* 2.新增供应商信息
*
*/
@RequestMapping("insertProviderLoad")
public ModelAndView insertProviderLoad(){
return new ModelAndView("insert/insertprovider");
}
@RequestMapping(value = "insertProvider",produces = "text/plain;charset=utf-8")
@ResponseBody
public String insertProvider(String proName,String proCode,String proContact,String proPhone,String proAddress,String proDesc) {
Provider provider = new Provider();
provider.setProName(proName);
provider.setProCode(proCode);
provider.setProContact(proContact);
provider.setProPhone(proPhone);
provider.setProAddress(proAddress);
provider.setProDesc(proDesc);
int i = insertService.insertProvider(provider);
private InsertService insertService;
/*
* 管理员新增用户
* 1.加载了增加用户界面
* 2.新增用户信息
*
*/
@RequestMapping("insertUserLoad")
public ModelAndView insertUser(Integer id){
return new ModelAndView("insert/insertuser");
}
@RequestMapping(value = "insertUser",produces = "text/plain;charset=utf-8")
@ResponseBody
public String insertUser(String username,String password,String phone,String address,Integer gender,Integer role,String birthday) {
User user = new User();
user.setUserName(username);
user.setUserPassword(password);
user.setPhone(phone);
user.setAddress(address);
user.setGender(gender);
user.setUserRole(role);
user.setBirthday(birthday);
int i = insertService.insertUser(user);
if (i>0){
return "新增成功,是否返回?";
}
return "新增失败,是否返回?";
}
/*
* 管理员新增供应商
* 1.加载了添加供应商界面
* 2.新增供应商信息
*
*/
@RequestMapping("insertProviderLoad")
public ModelAndView insertProviderLoad(){
return new ModelAndView("insert/insertprovider");
}
@RequestMapping(value = "insertProvider",produces = "text/plain;charset=utf-8")
int i = checkerService.deleteShopping(id);
if (i>0){
return "删除成功";
}
return "删除失败";
}
@RequestMapping(value = "goShopping",produces = "text/plain;charset=utf-8")
@ResponseBody
public String goShopping(Integer id){
int i = checkerService.updateBill(id);
if (i>0){
return "购买成功";
}
return "购买失败";
}
}
@Controller
@RequestMapping("delete")
public class DeleteController {
@Autowired
private DeleteService deleteService;
//根据用户id删除用户
@RequestMapping(value = "deleteUser",produces = "text/plain;charset=utf-8")
@ResponseBody
public String deleteUser(Integer id){
int i = deleteService.deleteUser(id);
if (i>0){
return "删除成功";
}
return "删除失败";
}
//根据id删除供应商
@RequestMapping(value = "deleteProvider",produces = "text/plain;charset=utf-8")
@ResponseBody
public String deleteProvider(Integer id){
int i = deleteService.deleteProvider(id);
if (i>0){
return "删除成功";
}
return "删除失败";
}
//根据id删除商品
@RequestMapping(value = "deleteGoods",produces = "text/plain;charset=utf-8")
@ResponseBody
}
/**
* 用户点击查询供应商按钮
* 实现供应商模糊查询
* 1.加载供应商查询界面
* 2.实现查询功能
**/
@RequestMapping("selectProvider")
public ModelAndView selectProvider(String providervalue){
List<Provider> providers = selectService.selectProvider(providervalue);
ModelAndView mv = new ModelAndView("table/selectprovider");
mv.addObject("provider",providers);
return mv;
}
/**
* 商品信息列表界面
* 1.加载商品信息列表界面,并查询商品信息
**/
@RequestMapping("goodsTable")
public ModelAndView goodsTable(){
List<Goods> goods = selectService.getGoods();
ModelAndView mv = new ModelAndView("table/goodstable");
mv.addObject("goods",goods);
return mv;
}
/**
* 用户点击查询商品按钮
* 实现商品模糊查询
* 1.加载商品查询界面
* 2.实现查询功能
**/
@RequestMapping("selectGoods")
public ModelAndView selectGoods(String goodsvalue){
ModelAndView mv = new ModelAndView("table/selectgoods");
List<Goods> goods = selectService.selectGoods(goodsvalue);
mv.addObject("goods",goods);
return mv;
}
/**
* 会员信息查询
* 1.加载会员信息界面
* 2.查询所有会员信息
**/
@RequestMapping("memberTable")
public ModelAndView memberTable(){
List<Member> member = selectService.getMember();
ModelAndView mv = new ModelAndView("table/membertable");
mv.addObject("member",member);
return mv;
}
/**
* 查找会员信息
* 1.加载查询界面
public ModelAndView selectUserLoad(String uservalue){
List<User> users = selectService.selectUser(uservalue);
ModelAndView mv= new ModelAndView("table/selectuser");
if (users==null){
User user = new User();
user.setUserName(uservalue);
users.set(0,user);
}else {
mv.addObject("uservalue",users);
}
return mv;
}
/**
* 加载供应商列表界面,并查询所有供应商的所有信息
* 1.加载供应商列表界面.并查询信息
**/
@RequestMapping("providerTable")
public ModelAndView selectProviderLoad(){
List<Provider> provider = selectService.getProvider();
ModelAndView mv= new ModelAndView("table/providertable");
mv.addObject("provider",provider);
return mv;
}
/**
* 用户点击查询供应商按钮
* 实现供应商模糊查询
* 1.加载供应商查询界面
* 2.实现查询功能
**/
@RequestMapping("selectProvider")
public ModelAndView selectProvider(String providervalue){
List<Provider> providers = selectService.selectProvider(providervalue);
ModelAndView mv = new ModelAndView("table/selectprovider");
mv.addObject("provider",providers);
return mv;
}
/**
* 商品信息列表界面
* 1.加载商品信息列表界面,并查询商品信息
@RequestMapping("charts")
public ModelAndView Charts(){
Integer dataAll = loginService.dataAll();
Integer data1 = loginService.data1();
Integer data2 = loginService.data2();
Integer data3 = loginService.data3();
Integer data4 = loginService.data4();
ModelAndView mv= new ModelAndView("admin/charts");
mv.addObject("dataAll",dataAll);
mv.addObject("data1",data1);
mv.addObject("data2",data2);
mv.addObject("data3",data3);
mv.addObject("data4",data4);
return mv;
}
}
@Controller
@RequestMapping("checker")
public class CheckerController {
@Autowired
private CheckerService checkerService;
@RequestMapping("index")
public ModelAndView Index(){
List<Goods> goods = checkerService.getGoods();
ModelAndView mv= new ModelAndView("checker/index");
mv.addObject("goods",goods);
return mv;
}
@RequestMapping(value = "sell",produces = "text/plain;charset=utf-8")
@ResponseBody
public String Sell( Integer goodsid,Integer goodscount, Integer isPayment, Double zj, Integer userid){
Bill bill = new Bill();
bill.setGoodsId(goodsid);
bill.setProductCount(goodscount);
bill.setIsPayment(isPayment);
bill.setTotalPrice(zj);
bill.setUserId(userid);
@RequestMapping("insertProviderLoad")
public ModelAndView insertProviderLoad(){
return new ModelAndView("insert/insertprovider");
}
@RequestMapping(value = "insertProvider",produces = "text/plain;charset=utf-8")
@ResponseBody
public String insertProvider(String proName,String proCode,String proContact,String proPhone,String proAddress,String proDesc) {
Provider provider = new Provider();
provider.setProName(proName);
provider.setProCode(proCode);
provider.setProContact(proContact);
provider.setProPhone(proPhone);
provider.setProAddress(proAddress);
provider.setProDesc(proDesc);
int i = insertService.insertProvider(provider);
if (i>0){
return "新增成功,是否返回?";
}
return "新增失败,是否返回?";
}
/**
* 管理员新增商品信息
* 1.加载新增商品信息界面,并传入供应商信息(需要供应商信息以供用户新增商品时选择)
* 2.新增商品信息
**/
@RequestMapping("insertGoodsLoad")
public ModelAndView insertGoodsLoad(){
List<Provider> providerToGoods = insertService.getProviderToGoods();
ModelAndView mv = new ModelAndView("insert/insertgoods");
mv.addObject("providerToGood",providerToGoods);
return mv;
}
@RequestMapping(value = "insertGoods",produces = "text/plain;charset=utf-8")
@ResponseBody
public String insertGoods(String goodsCode,String goodsName,String goodsUnit, String goodsGenre,Integer goodsBid,Integer goodsPric,Integer provider){
Goods goods = new Goods();
goods.setGoodsCode(goodsCode);
goods.setGoodsName(goodsName);
goods.setGoodsUnit(goodsUnit);
goods.setGoodsGenre(goodsGenre);
goods.setGoodsBid(goodsBid);
goods.setGoodsPric(goodsPric);
goods.setProviderid(provider);
int i = insertService.insertGoods(goods);
if (i>0){
return "新增成功,是否返回?";
}
return "新增失败,是否返回?";
}
/**
* 管理员新增会员信息
* 1.加载新增会员信息界面
* 2.新增会员信息
User user = new User();
user.setUserName(username);
user.setUserPassword(password);
user.setPhone(phone);
user.setAddress(address);
user.setGender(gender);
user.setUserRole(role);
user.setBirthday(birthday);
int i = insertService.insertUser(user);
if (i>0){
return "新增成功,是否返回?";
}
return "新增失败,是否返回?";
}
/*
* 管理员新增供应商
* 1.加载了添加供应商界面
* 2.新增供应商信息
*
*/
@RequestMapping("insertProviderLoad")
public ModelAndView insertProviderLoad(){
return new ModelAndView("insert/insertprovider");
}
@RequestMapping(value = "insertProvider",produces = "text/plain;charset=utf-8")
@ResponseBody
public String insertProvider(String proName,String proCode,String proContact,String proPhone,String proAddress,String proDesc) {
Provider provider = new Provider();
provider.setProName(proName);
provider.setProCode(proCode);
provider.setProContact(proContact);
provider.setProPhone(proPhone);
provider.setProAddress(proAddress);
provider.setProDesc(proDesc);
int i = insertService.insertProvider(provider);
if (i>0){
return "新增成功,是否返回?";
}
return "新增失败,是否返回?";
}
/**
* 管理员新增商品信息
* 1.加载新增商品信息界面,并传入供应商信息(需要供应商信息以供用户新增商品时选择)
mv.addObject("provider",providers);
return mv;
}
/**
* 商品信息列表界面
* 1.加载商品信息列表界面,并查询商品信息
**/
@RequestMapping("goodsTable")
public ModelAndView goodsTable(){
List<Goods> goods = selectService.getGoods();
ModelAndView mv = new ModelAndView("table/goodstable");
mv.addObject("goods",goods);
return mv;
}
/**
* 用户点击查询商品按钮
* 实现商品模糊查询
* 1.加载商品查询界面
* 2.实现查询功能
**/
@RequestMapping("selectGoods")
public ModelAndView selectGoods(String goodsvalue){
ModelAndView mv = new ModelAndView("table/selectgoods");
List<Goods> goods = selectService.selectGoods(goodsvalue);
mv.addObject("goods",goods);
return mv;
}
/**
* 会员信息查询
* 1.加载会员信息界面
* 2.查询所有会员信息
**/
@RequestMapping("memberTable")
public ModelAndView memberTable(){
List<Member> member = selectService.getMember();
ModelAndView mv = new ModelAndView("table/membertable");
mv.addObject("member",member);
return mv;
}
/**
* 查找会员信息
* 1.加载查询界面
* 2.查询信息
**/
@RequestMapping("selectMember")
public ModelAndView selectMember(String membervalue ){
List<Member> members = selectService.selectMember(membervalue);
ModelAndView mv= new ModelAndView("table/selectmember");
mv.addObject("members",members);
return mv;
int i = checkerService.updateBill(id);
if (i>0){
return "购买成功";
}
return "购买失败";
}
}
@Controller
@RequestMapping("delete")
public class DeleteController {
@Autowired
private DeleteService deleteService;
//根据用户id删除用户
@RequestMapping(value = "deleteUser",produces = "text/plain;charset=utf-8")
@ResponseBody
public String deleteUser(Integer id){
int i = deleteService.deleteUser(id);
if (i>0){
return "删除成功";
}
return "删除失败";
}
//根据id删除供应商
@RequestMapping(value = "deleteProvider",produces = "text/plain;charset=utf-8")
@ResponseBody
public String deleteProvider(Integer id){
int i = deleteService.deleteProvider(id);
if (i>0){
return "删除成功";
}
return "删除失败";
@Controller
@RequestMapping("login")
public class LoginController {
@Autowired
private LoginService loginService;
/*
用户登录共实现,需要验证用户名及密码的正确性;
返回int
1:管理员
2:会员
3:普通收银员
*/
@RequestMapping(value = "log",produces = "text/plain;charset=utf-8")
@ResponseBody
public String Login(String username, String password, HttpSession session){
User user = new User();
user.setUserName(username);
user.setUserPassword(password);
User login = loginService.login(user);
session.setAttribute("username",username);
session.setAttribute("userid",login.getId());
if (login!=null){
if (login.getUserRole()==2){
return "2";
}
if (login.getUserRole()==1){
return "1";
}
}
return "0";
}
/*
用户注册功能实现,需要使用User表的字段
详情可以@User JavaBean
返回
提示注册失败or成功
*/
@RequestMapping(value = "register",produces = "text/plain;charset=utf-8")
@ResponseBody
return "0";
}
/*
用户注册功能实现,需要使用User表的字段
详情可以@User JavaBean
返回
提示注册失败or成功
*/
@RequestMapping(value = "register",produces = "text/plain;charset=utf-8")
@ResponseBody
public String Register(String userName,String Password,Integer gender,String birthday,String phone,String address){
User user = new User();
user.setUserName(userName); user.setUserPassword(Password); user.setGender(gender);
user.setBirthday(birthday); user.setPhone(phone); user.setAddress(address);
int register = loginService.register(user);
if (register==-1){
return "您已有账号,请勿重复操作";
}
if (register>0){
return "注册成功";
}
return "注册失败";
}
/*
* 加载了用户主页
* 主要用于管理员登录后得使用,进入其他界面的操作
*/
@RequestMapping("adminIndex")
public ModelAndView AdminIndex(){
return new ModelAndView("admin/index");
}
//这里是加载了表单组件测试界面
@RequestMapping("fromtest")
public ModelAndView FromTest(){
return new ModelAndView("admin/formtest");
}
//加载了数据表页面
@RequestMapping("charts")
public ModelAndView Charts(){
Integer dataAll = loginService.dataAll();
Integer data1 = loginService.data1();
Integer data2 = loginService.data2();
Integer data3 = loginService.data3();
Integer data4 = loginService.data4();
ModelAndView mv= new ModelAndView("admin/charts");
mv.addObject("dataAll",dataAll);
mv.addObject("data1",data1);
mv.addObject("data2",data2);
mv.addObject("data3",data3);
mv.addObject("data4",data4);
return mv;