基于javaweb+mysql的ssm零食商城系统(java+ssm+jsp+mysql+easyui)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM零食商城系统(java+ssm+jsp+mysql+easyui)
系统主要实现的功能有:用户浏览商品、加入商品到购物车、登录注册、提交订单,会员中心修改个人信息、查看订单等。
后台管理员登录后可以分角色添加管理员,不同角色有不同权限,可以管理用户信息、商品信息、订单信息,订单信息可以导出到excel。其中支付是模拟在线支付,从账户余额中扣费的,用户注册后自动设置余额为指定值。
//退出登录
@RequestMapping("userlogout")
public String showlogin(HttpServletRequest request){
HttpSession session = request.getSession();
session.removeAttribute("frontuser");
session.removeAttribute("frontuserId");
return "redirect:userLoginGet";
}
//商品详情
@RequestMapping("proDatail")
public String gotoProDatail(HttpServletRequest request,Snackinfo snack){
Snackinfo sck = shopService.selectById(snack);
request.setAttribute("sck", sck);
return "product/proDetail";
}
//查询订单
@RequestMapping("selectOrderSnack")
@ResponseBody
public DataTables selectOrderSnack(String oId,int start,int length){
Map<Object,Object> map=new HashMap<Object, Object>();
map.put("oId", oId);
map.put("pageStart",start);
map.put("pageSize",length);
PageHelp<DoSnack> pageHelp = shopService.selectOrderSnack(map);
DataTables datatable=new DataTables();
datatable.setData(pageHelp.getList());
datatable.setRecordsFiltered(pageHelp.getRecord());
datatable.setRecordsTotal(pageHelp.getRecord());
return datatable;
}
//type页面
@RequestMapping("puffingType")
public String puffing(HttpServletRequest request,DoSnackType doSnackType){
List<Snackinfo> TypeSnackList=shopService.selectPuffing(doSnackType.getType(),doSnackType.getSnackName());
Map<Integer, String> allType = TypeUtil.getAllType();
String typeString = allType.get(doSnackType.getType());
if(typeString == null || "".equals(typeString)){
typeString = "搜索结果";
}
if(doSnackType.getType() == 666){
typeString = "进口类";
}
request.setAttribute("TypeSnackTitle",typeString);
PageHelp<Account> pageHelp= userService.selectAccountLimit(map);
DataTables datatable=new DataTables();
datatable.setData(pageHelp.getList());
datatable.setRecordsFiltered(pageHelp.getRecord());
datatable.setRecordsTotal(pageHelp.getRecord());
return datatable;
}
//获得金额
@RequestMapping("getMoneyAcount")
@ResponseBody
public Object getMoneyAcount(HttpServletRequest request){
return request.getSession().getAttribute("money");
}
//查看当前订单
@RequestMapping("userOrderLimit")
@ResponseBody
public DataTables userOrderLimit(HttpServletRequest request,int start,int length){
Map<Object,Object> map=new HashMap<Object, Object>();
map.put("uId",request.getSession().getAttribute("frontuserId"));
map.put("pageStart",start);
map.put("pageSize",length);
PageHelp<DoMyOrder> pageHelp= userService.selectOrderLimit(map);
DataTables datatable=new DataTables();
datatable.setData(pageHelp.getList());
datatable.setRecordsFiltered(pageHelp.getRecord());
datatable.setRecordsTotal(pageHelp.getRecord());
return datatable;
}
//跳转订单页面
@RequestMapping("userGoOrder")
public String userGoOrder(HttpSession session){
return "user/myOrder";
}
//跳转历史订单
@RequestMapping("userGoSuccessOrder")
public String userGoSuccessOrder(){
return "user/myOrderSuccess";
}
//查看当前订单
@RequestMapping("userSucOrderLimit")
@ResponseBody
PageHelp<Account> pageHelp= userService.selectAccountLimit(map);
DataTables datatable=new DataTables();
datatable.setData(pageHelp.getList());
datatable.setRecordsFiltered(pageHelp.getRecord());
datatable.setRecordsTotal(pageHelp.getRecord());
return datatable;
}
//获得金额
@RequestMapping("getMoneyAcount")
@ResponseBody
public Object getMoneyAcount(HttpServletRequest request){
return request.getSession().getAttribute("money");
}
//查看当前订单
@RequestMapping("userOrderLimit")
@ResponseBody
public DataTables userOrderLimit(HttpServletRequest request,int start,int length){
Map<Object,Object> map=new HashMap<Object, Object>();
map.put("uId",request.getSession().getAttribute("frontuserId"));
map.put("pageStart",start);
map.put("pageSize",length);
PageHelp<DoMyOrder> pageHelp= userService.selectOrderLimit(map);
DataTables datatable=new DataTables();
datatable.setData(pageHelp.getList());
datatable.setRecordsFiltered(pageHelp.getRecord());
datatable.setRecordsTotal(pageHelp.getRecord());
return datatable;
}
//跳转订单页面
@RequestMapping("userGoOrder")
public String userGoOrder(HttpSession session){
return "user/myOrder";
}
//跳转历史订单
@RequestMapping("userGoSuccessOrder")
public String userGoSuccessOrder(){
return "user/myOrderSuccess";
}
}
//更新加载用户
@RequestMapping("updateGoAdminById")
@ResponseBody
public String updateGoAdminById(HttpServletRequest request,Admin admin){
return ResponseUtil.successToClient(adminUserService.selectAdminByOne(admin));
}
//更新用户
@RequestMapping("updateAdminById")
@ResponseBody
public String updateAdminById(Admin admin){
return ResponseUtil.successToClient(adminUserService.updateAdmin(admin));
}
}
@Controller
@RequestMapping("/admin/login/")
public class AdminLogin {
@Autowired
private adminLoginService adminLoginService;
@Autowired
public String mainToUserinfo(){
return "admin/user/adminUserinfo";
}
//加载用户
@RequestMapping("adminUserinfoLimit")
@ResponseBody
public DataTables adminUserinfoLimit(HttpServletRequest request,int start,int length,Userinfo userinfo){
Map<Object,Object> map=new HashMap<Object, Object>();
map.put("pageStart",start);
map.put("pageSize",length);
PageHelp<Userinfo> pageHelp= adminUserService.selectAdminUserinfoLimit(map,userinfo);
DataTables datatable=new DataTables();
datatable.setData(pageHelp.getList());
datatable.setRecordsFiltered(pageHelp.getRecord());
datatable.setRecordsTotal(pageHelp.getRecord());
return datatable;
}
//删除用户
@RequestMapping("delUserinfoById")
@ResponseBody
public String delUserinfoById(int uId){
return ResponseUtil.successToClient(adminUserService.delUserinfoById(uId));
}
//更新加载用户
@RequestMapping("updateGoUserinfoById")
@ResponseBody
public String updateGoUserinfoById(int uId){
return ResponseUtil.successToClient(adminUserService.updateGoUserinfoById(uId));
}
//更新用户
@RequestMapping("updateUserinfoById")
@ResponseBody
public String updateUserinfoById(Userinfo userinfo){
return ResponseUtil.successToClient(adminUserService.updateUserinfoById(userinfo));
}
@RequestMapping("mainToAdmin")
public String mainToAdmin(){
return "admin/user/adminAdmin";
}
//加载用户
@RequestMapping("adminAdminLimit")
@ResponseBody
public DataTables adminAdminLimit(HttpServletRequest request,int start,int length,DoAdmin doAdmin){
Map<Object,Object> map=new HashMap<Object, Object>();
map.put("pageStart",start);
map.put("pageSize",length);
sorderService.addOrderdetail(orderdetail);
}
Userinfo selectUserinfoMoney = userService.selectUserinfoMoney((int)request.getSession().getAttribute("frontuserId"));
Double selectOrderdetailPayMoney = sorderService.selectOrderdetailPayMoney(oId);
dfk.setoId(oId);
dfk.setPayMoney(selectOrderdetailPayMoney.toString());
dfk.setuMoney(selectUserinfoMoney.getuMoney());
session.removeAttribute("receiptinfo");
return ResponseUtil.successToClientStr(dfk);
}
}
@Controller
@RequestMapping("/admin/snackinfo/")
public class AdminSnakcinfoController {
@Autowired
private adminSnackInfoService adminSnackInfoService;
@RequestMapping(value="addAdminSnack")
@ResponseBody
public String upload(HttpServletRequest request,
@Controller
@RequestMapping("/sorder")
public class SorderController {
@Autowired
private sorderService sorderService=null;
@Autowired
private userService userService;
@RequestMapping(value="/add",method=RequestMethod.POST)
public String addSorder(Snackinfo snackinfo,HttpSession session) {
System.out.println("-------addCar()------"+snackinfo.getsNumber());
// 1:通过 product.id获取当前的商品数据
Snackinfo findSnackinfo = sorderService.snackfindById(snackinfo.getsId());
findSnackinfo.setsNumber(snackinfo.getsNumber());
//2:判断当前session是否有购物车,如果没有则创建
if (session.getAttribute("receiptinfo")==null) {
//创建购物车,存到session中
session.setAttribute("receiptinfo", new Receiptinfo(new HashSet<Orderdetail>()));
}
Receiptinfo receiptinfo = (Receiptinfo)session.getAttribute("receiptinfo");
//3:把商品信息转化为sorder,并且添加到购物车中(判断购物车是否重复)
receiptinfo = sorderService.addSorder(receiptinfo, findSnackinfo);
map.put("pageSize",length);
PageHelp<DoSnack> pageHelp = shopService.selectOrderSnack(map);
DataTables datatable=new DataTables();
datatable.setData(pageHelp.getList());
datatable.setRecordsFiltered(pageHelp.getRecord());
datatable.setRecordsTotal(pageHelp.getRecord());
return datatable;
}
//type页面
@RequestMapping("puffingType")
public String puffing(HttpServletRequest request,DoSnackType doSnackType){
List<Snackinfo> TypeSnackList=shopService.selectPuffing(doSnackType.getType(),doSnackType.getSnackName());
Map<Integer, String> allType = TypeUtil.getAllType();
String typeString = allType.get(doSnackType.getType());
if(typeString == null || "".equals(typeString)){
typeString = "搜索结果";
}
if(doSnackType.getType() == 666){
typeString = "进口类";
}
request.setAttribute("TypeSnackTitle",typeString);
request.setAttribute("TypeNum",doSnackType.getType());
request.setAttribute("TypeSnackList",TypeSnackList);
return "user/typePage";
}
/**
* 获取商品分类
* @return
*/
@RequestMapping("get_type")
@ResponseBody
public Map<String, Object> getType(){
Map<String, Object> ret = new HashMap<String, Object>();
ret.put("type", "success");
ret.put("content", TypeUtil.getAllDoType());
return ret;
}
}
@Autowired
private userService userService;
@RequestMapping(value="/add",method=RequestMethod.POST)
public String addSorder(Snackinfo snackinfo,HttpSession session) {
System.out.println("-------addCar()------"+snackinfo.getsNumber());
// 1:通过 product.id获取当前的商品数据
Snackinfo findSnackinfo = sorderService.snackfindById(snackinfo.getsId());
findSnackinfo.setsNumber(snackinfo.getsNumber());
//2:判断当前session是否有购物车,如果没有则创建
if (session.getAttribute("receiptinfo")==null) {
//创建购物车,存到session中
session.setAttribute("receiptinfo", new Receiptinfo(new HashSet<Orderdetail>()));
}
Receiptinfo receiptinfo = (Receiptinfo)session.getAttribute("receiptinfo");
//3:把商品信息转化为sorder,并且添加到购物车中(判断购物车是否重复)
receiptinfo = sorderService.addSorder(receiptinfo, findSnackinfo);
receiptinfo.setoPhone(cluTotal(receiptinfo));
return "redirect:gotocar";
}
@RequestMapping("gotocar")
public String gotocar() {
return "product/car";
}
//计算总金额
public String cluTotal(Receiptinfo receiptinfo) {
double tal=0.0;
for(Orderdetail temp : receiptinfo.getOrderdetailSet()){
tal+=temp.getoMoney()*temp.getoNum();
}
return String.valueOf(tal);
}
@RequestMapping(value="/delete",method=RequestMethod.GET)
public String deleteSorder(Snackinfo snackinfo,HttpSession session) {
Receiptinfo receiptinfo = (Receiptinfo)session.getAttribute("receiptinfo");
@Controller
@RequestMapping("/admin/user/")
public class AdminUserControll {
@Autowired
private adminUserService adminUserService;
@RequestMapping("mainToUserinfo")
public String mainToUserinfo(){
return "admin/user/adminUserinfo";
}
//加载用户
@RequestMapping("adminUserinfoLimit")
@ResponseBody
public DataTables adminUserinfoLimit(HttpServletRequest request,int start,int length,Userinfo userinfo){
Map<Object,Object> map=new HashMap<Object, Object>();
map.put("pageStart",start);
map.put("pageSize",length);
PageHelp<Userinfo> pageHelp= adminUserService.selectAdminUserinfoLimit(map,userinfo);
DataTables datatable=new DataTables();
datatable.setData(pageHelp.getList());
datatable.setRecordsFiltered(pageHelp.getRecord());
datatable.setRecordsTotal(pageHelp.getRecord());
return datatable;
}
//删除用户
@RequestMapping("delUserinfoById")
@ResponseBody
public String delUserinfoById(int uId){
return ResponseUtil.successToClient(adminUserService.delUserinfoById(uId));
}
//更新加载用户
@RequestMapping("updateGoUserinfoById")
@ResponseBody
public String updateGoUserinfoById(int uId){
}
@RequestMapping("mainToAdmin")
public String mainToAdmin(){
return "admin/user/adminAdmin";
}
//加载用户
@RequestMapping("adminAdminLimit")
@ResponseBody
public DataTables adminAdminLimit(HttpServletRequest request,int start,int length,DoAdmin doAdmin){
Map<Object,Object> map=new HashMap<Object, Object>();
map.put("pageStart",start);
map.put("pageSize",length);
PageHelp<Admin> pageHelp= adminUserService.selectAdminLimit(map,doAdmin);
DataTables datatable=new DataTables();
datatable.setData(pageHelp.getList());
datatable.setRecordsFiltered(pageHelp.getRecord());
datatable.setRecordsTotal(pageHelp.getRecord());
return datatable;
}
//新建
@RequestMapping("addNewAdmin")
@ResponseBody
public String addNewAdmin(Admin admin){
return ResponseUtil.successToClient(adminUserService.addAdmin(admin));
}
//删除用户
@RequestMapping("delAdminById")
@ResponseBody
public String delAdminById(Admin admin){
return ResponseUtil.successToClient(adminUserService.delAdmin(admin));
}
//更新加载用户
@RequestMapping("updateGoAdminById")
@ResponseBody
public String updateGoAdminById(HttpServletRequest request,Admin admin){
return ResponseUtil.successToClient(adminUserService.selectAdminByOne(admin));
}
//更新用户
@RequestMapping("updateAdminById")
@ResponseBody
public String updateAdminById(Admin admin){
return ResponseUtil.successToClient(adminUserService.updateAdmin(admin));
}
@Controller
@RequestMapping("/admin/snackinfo/")
public class AdminSnakcinfoController {
@Autowired
private adminSnackInfoService adminSnackInfoService;
@RequestMapping(value="addAdminSnack")
@ResponseBody
public String upload(HttpServletRequest request,
@RequestParam("file") MultipartFile file,String fileName,Snackinfo snackinfo) throws Exception {
Date day=new Date();
SimpleDateFormat df = new SimpleDateFormat("yyyyMMdd");
String sBatch=df.format(day).toString()+String.valueOf((int)(Math.random()*9000+1000));
snackinfo.setsCreatedate(DateUtil.getCurrentDateStr());
snackinfo.setState(1);
snackinfo.setsPictureurl(fileName);
snackinfo.setsBatch(sBatch);
adminSnackInfoService.addAdminSnackinfo(snackinfo);
//如果文件不为空,写入上传路径
if(!file.isEmpty()) {
//上传文件路径
String path = request.getSession().getServletContext().getRealPath("/image/");
//上传文件名
String filename = fileName;
File filepath = new File(path,filename);
//判断路径是否存在,如果不存在就创建一个
if (!filepath.getParentFile().exists()) {
filepath.getParentFile().mkdirs();
}
//将上传文件保存到一个目标文件当中
//filepath.delete();
if (!filepath.getParentFile().exists()) {
filepath.getParentFile().mkdirs();
}
//将上传文件保存到一个目标文件当中
file.transferTo(new File(path + File.separator + filename));
return ResponseUtil.successToClient();
} else {
return ResponseUtil.errorToClient();
}
}
}
public class MyHandlerInterceptor implements HandlerInterceptor{
@Override
public boolean preHandle(HttpServletRequest request,
HttpServletResponse response, Object handler) throws Exception {
int k=0;
int p=0;
String uri=request.getRequestURI();
if(uri.indexOf("login")!=-1){
return true;
}
HttpSession session = request.getSession();
List<Permission> list = (List<Permission>)session.getAttribute("allPer");
List<Permission> list2 = (List<Permission>)session.getAttribute("userPer");
for (int i = 0; i < list.size(); i++) {
if(uri.equals((list.get(i).getUrl()))){
for (int j = 0; j < list2.size(); j++) {
k++;
if(uri.contains(list2.get(j).getUrl())){
return true;
}
}
}
p++;
}
if(p>0 && k==list2.size()){
if(!file.isEmpty()) {
//上传文件路径
String path = request.getSession().getServletContext().getRealPath("/image/trimImg/");
//上传文件名
String filename = fileName;
File filepath = new File(path,filename);
//判断路径是否存在,如果不存在就创建一个
//filepath.delete();
if (!filepath.getParentFile().exists()) {
filepath.getParentFile().mkdirs();
}
//将上传文件保存到一个目标文件当中
file.transferTo(new File(path + File.separator + filename));
return ResponseUtil.successToClient();
} else {
return ResponseUtil.errorToClient();
}
}
}
public class MyHandlerInterceptor implements HandlerInterceptor{
@Override
public boolean preHandle(HttpServletRequest request,
HttpServletResponse response, Object handler) throws Exception {
int k=0;
int p=0;
public String mainUpdateAdminuser(DoAdminInfo admin){
return ResponseUtil.successToClient(userService.updateAdminInfo(admin));
}
}
@Controller
@RequestMapping("/admin/order/")
public class AdminOrderControll {
@Autowired
private adminOrderService adminOrderService;
@Autowired
private userService userService;
@Autowired
private adminUserService adminUserService;
@RequestMapping("mainToAdminOrder")
if(orderdetail.getSnackinfo().getsId()==snackinfo.getsId()){
iterator.remove();
receiptinfo.setoPhone(String.valueOf((Double.parseDouble(receiptinfo.getoPhone())-orderdetail.getoMoney()*orderdetail.getoNum())));
}
}
if( set.size() <= 0){
session.removeAttribute("receiptinfo");
}
return "redirect:gotocar";
}
@RequestMapping(value="/clear",method=RequestMethod.GET)
public String clearSorder(Snackinfo snackinfo,HttpSession session) {
Receiptinfo receiptinfo = (Receiptinfo)session.getAttribute("receiptinfo");
if(receiptinfo!=null){
Set<Orderdetail> set = receiptinfo.getOrderdetailSet();
set.clear();
}
receiptinfo.setoPhone(String.valueOf(0d));
session.removeAttribute("receiptinfo");
return "redirect:gotocar";
}
//下订单
@RequestMapping("setOrder")
@ResponseBody
public String setOrder(HttpServletRequest request,HttpSession session,Receiptinfo receiptinfo) {
DoMoneyFK dfk=new DoMoneyFK();
Receiptinfo receiptinfoSession = (Receiptinfo)session.getAttribute("receiptinfo");
Date day=new Date();
SimpleDateFormat df = new SimpleDateFormat("yyyyMMdd");
String oId=df.format(day).toString()+String.valueOf((int)(Math.random()*9000+1000));
receiptinfo.setoId(oId);
receiptinfo.setOrderdetailSet(receiptinfoSession.getOrderdetailSet());
sorderService.addReceiptinfo(receiptinfo);
Order order=new Order();
order.setoId(oId);
order.setuId((int)session.getAttribute("frontuserId"));
order.setoTime(DateUtil.getCurrentTime());
order.setoType(-1);
sorderService.addOrder(order);
Orderdetail orderdetail=new Orderdetail();
orderdetail.setoId(oId);
for (Orderdetail orderdetailSession : receiptinfoSession.getOrderdetailSet()) {
orderdetail.setoNum(orderdetailSession.getoNum());
orderdetail.setoMoney(orderdetailSession.getoMoney());
orderdetail.setsId(orderdetailSession.getsId());
sorderService.addOrderdetail(orderdetail);
}
Userinfo selectUserinfoMoney = userService.selectUserinfoMoney((int)request.getSession().getAttribute("frontuserId"));
Double selectOrderdetailPayMoney = sorderService.selectOrderdetailPayMoney(oId);
public String upload(HttpServletRequest request,
@RequestParam("file") MultipartFile file,String fileName,Snackinfo snackinfo) throws Exception {
Date day=new Date();
SimpleDateFormat df = new SimpleDateFormat("yyyyMMdd");
String sBatch=df.format(day).toString()+String.valueOf((int)(Math.random()*9000+1000));
snackinfo.setsCreatedate(DateUtil.getCurrentDateStr());
snackinfo.setState(1);
snackinfo.setsPictureurl(fileName);
snackinfo.setsBatch(sBatch);
adminSnackInfoService.addAdminSnackinfo(snackinfo);
//如果文件不为空,写入上传路径
if(!file.isEmpty()) {
//上传文件路径
String path = request.getSession().getServletContext().getRealPath("/image/");
//上传文件名
String filename = fileName;
File filepath = new File(path,filename);
//判断路径是否存在,如果不存在就创建一个
if (!filepath.getParentFile().exists()) {
filepath.getParentFile().mkdirs();
}
//将上传文件保存到一个目标文件当中
file.transferTo(new File(path + File.separator + filename));
return ResponseUtil.successToClient();
} else {
return ResponseUtil.errorToClient();
}
}
@RequestMapping("mainToAdminSnackinfo")
public ModelAndView mainToAdminImg(ModelAndView model){
model.setViewName("admin/snackinfo/adminSnackinfo");
List<DoSnackType> allDoType = TypeUtil.getAllDoType();
model.addObject("typeList", allDoType);
return model;
}
//商品
@RequestMapping("adminSnackinfoLimit")
@ResponseBody
public DataTables adminOrderLimit(int start,int length,
String sName,String sType,String startDate,String endDate){
Map<Object,Object> map=new HashMap<Object, Object>();
map.put("pageStart",start);
map.put("pageSize",length);
map.put("sType",sType);
map.put("sName",sName);
map.put("startDate",startDate);
map.put("endDate",endDate);
PageHelp<Snackinfo> pageHelp = adminSnackInfoService.selectAdminSnackinfoLimit(map);
DataTables datatable=new DataTables();