基于javaweb+mysql的ssm+maven电器商城系统(java+ssm+jsp+jquery+javascript+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM+Maven电器商城系统(java+ssm+jsp+jquery+javascript+mysql)
项目介绍
本项目分为前后台,前台为普通用户登录,后台管理员登录; 管理员角色包含以下功能: 修改个人信息,员工信息管理,商品管理,图片管理,图表管理,用户信息管理,管理员登录,订单管理等功能。
用户角色包含以下功能: 修改个人信息,提交付款,查看商品详情,查看我的订单,查看电器分类,查看购物车,用户登录,确认订单等功能。
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 5.是否Maven项目: 否;查看源码目录中是否包含pom.xml;若包含,则为maven项目,否则为非maven项目 6.数据库:MySql 5.7、8.0等版本均可;
技术栈
- 后端:Spring springmvc mybatis 2. 前端:JSP+css+javascript+jQuery
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2.使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,配置tomcat 3. 将项目中config/jdbc.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目,在浏览器中输入http://localhost:8080/ 登录 用户账号/密码: user/123456 管理员账号/密码:admin/admin
// 进行转码,使其支持中文文件名
response.setHeader("content-disposition", "attachment;filename=" + new String(excelName.getBytes("GB2312"), "ISO-8859-1") + ".xlsx");
workbook.write(response.getOutputStream());
} catch (IOException e) {
e.printStackTrace();
}
}
//请确认收货
@RequestMapping("userOrderConfirm")
@ResponseBody
public String userOrderConfirm(HttpServletRequest request,int id,int typeNum){
int eId;
if(typeNum==0){
eId = (int)request.getSession().getAttribute("adminId");
}else{
eId=0;
}
return ResponseUtil.successToClient(userService.upDateByorderConfirm(id,typeNum,eId));
}
}
}
@RequestMapping(value="updateAdminSnack")
@ResponseBody
public String updateAdminSnack(HttpServletRequest request,MultipartFile file,String fileName,Snackinfo snackinfo) throws Exception {
//如果文件不为空,写入上传路径
if(file !=null) {
snackinfo.setsPictureurl(fileName);
adminSnackInfoService.updateAdminSnackinfo(snackinfo);
//上传文件路径
String path = request.getSession().getServletContext().getRealPath("/image/");
//上传文件名
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 {
adminSnackInfoService.updateAdminSnackinfo(snackinfo);
return ResponseUtil.successToClient();
}
}
}
@RequestMapping("updateSelectAdminOrderDetial")
@ResponseBody
public String updateSelectAdminOrderDetial(int dId){
return ResponseUtil.successToClient(adminOrderService.updateSelectAdminOrderDetial(dId));
}
//updateOrderDetial订单
@RequestMapping("updateOrderdetail")
@ResponseBody
public String updateOrderdetail(Orderdetail orderdetail){
return ResponseUtil.successToClient(adminOrderService.updateOrderdetail(orderdetail));
}
//删除OrderDetial
@RequestMapping("deleteOrderdetail")
@ResponseBody
public String deleteOrderdetail(int dId,String oId){
List<Orderdetail> orderdetailList = adminOrderService.selectOrderdetailByoId(oId);
if(orderdetailList.size()>=2){
adminOrderService.deleteOrderdetailBydId(dId);
return ResponseUtil.successToClient(1);
}else{
adminOrderService.deleteAdminOrder(oId);
return ResponseUtil.successToClient(2);
}
}
//导出订单详情
@RequestMapping("outExcelOrder")
@ResponseBody
public void outExcelOrder(HttpServletResponse response,String oId){
SXSSFWorkbook workbook = new SXSSFWorkbook();
reportSheet(workbook,oId);
outputExcel(response, workbook, "订单详情");
}
private void reportSheet(SXSSFWorkbook workbook,String oId) {
List<DoExcelOrder> outExcelOrderDetail = adminOrderService.outExcelOrderDetail(oId);
for (int i = 0; i < outExcelOrderDetail.size(); i++) {
if(i!=0){
outExcelOrderDetail.get(i).setOId("");
outExcelOrderDetail.get(i).setOName("");
outExcelOrderDetail.get(i).setOPhone("");
outExcelOrderDetail.get(i).setOAddress("");
}
outExcelOrderDetail.get(i).setMoney(outExcelOrderDetail.get(i).getMoney()+"元");
}
ExcelUtil2 excelUtil=new ExcelUtil2();
List<JSONObject> columns = new ArrayList<>();
columns.add(excelUtil.defaultGetColumn("订单号", "oId", 15 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("收货人", "oName", 15 * 256, false, false));
//订单
@RequestMapping("adminOrderLimit")
@ResponseBody
public DataTables adminOrderLimit(int start,int length,
String oId,String oTimeStart,String oTimeEnd,String adUserName){
Map<Object,Object> map=new HashMap<Object, Object>();
map.put("pageStart",start);
map.put("pageSize",length);
map.put("oId",oId);
map.put("oTimeStart",oTimeStart);
map.put("oTimeEnd",oTimeEnd);
map.put("adUserName",adUserName);
PageHelp<DoAdminOrder> pageHelp= adminOrderService.selectAdminOrderLimit(map);
DataTables datatable=new DataTables();
datatable.setData(pageHelp.getList());
datatable.setRecordsFiltered(pageHelp.getRecord());
datatable.setRecordsTotal(pageHelp.getRecord());
return datatable;
}
//删除订单
@RequestMapping("deleteAdminOrder")
@ResponseBody
public String deleteAdminOrder(String oId){
return ResponseUtil.successToClient(adminOrderService.deleteAdminOrder(oId));
}
//update加载订单
@RequestMapping("updateSelectAdminOrder")
@ResponseBody
public String updateSelectAdminOrder(int rId){
return ResponseUtil.successToClient(adminOrderService.updateSelectAdminOrder(rId));
}
//update订单
@RequestMapping("updateAdminOrder")
@ResponseBody
public String updateAdminOrder(Receiptinfo receiptinfo){
return ResponseUtil.successToClient(adminOrderService.updateAdminOrder(receiptinfo));
}
//updateOrderDetial加载订单
@RequestMapping("updateSelectAdminOrderDetial")
@ResponseBody
public String updateSelectAdminOrderDetial(int dId){
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()){
response.getWriter().write("Sorry");
return false;
}
if(list.size()==p){
return true;
}
return false;
}
@Override
public void postHandle(HttpServletRequest request,
HttpServletResponse response, Object handler,
@Autowired
private adminOrderService adminOrderService;
@Autowired
private userService userService;
@RequestMapping("mainToAdminOrder")
public String mainToAdminOrder(){
return "admin/order/adminOrder";
}
//订单
@RequestMapping("adminOrderLimit")
@ResponseBody
public DataTables adminOrderLimit(int start,int length,
String oId,String oTimeStart,String oTimeEnd,String adUserName){
Map<Object,Object> map=new HashMap<Object, Object>();
map.put("pageStart",start);
map.put("pageSize",length);
map.put("oId",oId);
map.put("oTimeStart",oTimeStart);
map.put("oTimeEnd",oTimeEnd);
map.put("adUserName",adUserName);
PageHelp<DoAdminOrder> pageHelp= adminOrderService.selectAdminOrderLimit(map);
DataTables datatable=new DataTables();
datatable.setData(pageHelp.getList());
datatable.setRecordsFiltered(pageHelp.getRecord());
datatable.setRecordsTotal(pageHelp.getRecord());
return datatable;
}
//删除订单
@RequestMapping("deleteAdminOrder")
@ResponseBody
public String deleteAdminOrder(String oId){
return ResponseUtil.successToClient(adminOrderService.deleteAdminOrder(oId));
}
//update加载订单
@RequestMapping("updateSelectAdminOrder")
@ResponseBody
public String updateSelectAdminOrder(int rId){
return ResponseUtil.successToClient();
}
}
public class loginFilter implements Filter{
@Override
public void init(FilterConfig filterConfig) throws ServletException {
// TODO Auto-generated method stub
}
@Override
public void doFilter(ServletRequest request, ServletResponse response,
FilterChain chain) throws IOException, ServletException {
HttpServletRequest req = (HttpServletRequest)request;
HttpServletResponse resp =(HttpServletResponse) response;
HttpSession session = req.getSession();
// 获得用户请求的URI
String path = req.getRequestURI();
// 从session取得已经登录验证的凭证 我这里的demo用的是password来作为登录凭证
String adminName = (String) session.getAttribute("adminName");
// login.jsp页面无需过滤(根据自己项目的要求来)
if(path.indexOf("adminGoMain") == -1) {//注意:登录页面千万不能过滤 不然过滤器就。。。。。自行调试不要偷懒!这样记忆深刻
chain.doFilter(req, resp);
return;
} else if(path.indexOf("adminGoMain") > -1){//如果不是login.jsp进行过滤
if (adminName == null || "".equals(adminName)) {
resp.sendRedirect("adminLogin");
} else {
// 已经登陆,继续此次请求
request.getSession().setAttribute("adminName", adminSelect.get(0).getAdUsername());
request.getSession().setAttribute("adminId", adminSelect.get(0).getAdId());
List<Permission> allPer = adminLoginService.selectAllPermission();
List<Permission> userPer = adminLoginService.selectRolePermission(adminSelect.get(0).getRoleId());
request.getSession().setAttribute("allPer", allPer);
request.getSession().setAttribute("userPer", userPer);
return "redirect:adminGoMain";
}
request.setAttribute("msg","用户名或密码错误");
return "admin/adminLogin";
}
//登录Main
@RequestMapping("adminGoMain")
public String adminLogin(HttpServletRequest request){
List<Type> typeList = typeService.getall();
request.setAttribute("adminMenu",adminLoginService.selectAllAdminMenu());
request.setAttribute("adminMenuChild",adminLoginService.selectAllAdminMenuChild());
request.getSession().setAttribute("type",typeList);
return "admin/adminMain";
}
//退出
@RequestMapping("adminMainToLoginOut")
@ResponseBody
public String adminMainToLoginOut(HttpServletRequest request){
request.getSession().removeAttribute("adminName");
return ResponseUtil.successToClient();
}
}
@RequestMapping("outExcelOrder")
@ResponseBody
public void outExcelOrder(HttpServletResponse response,String oId){
SXSSFWorkbook workbook = new SXSSFWorkbook();
reportSheet(workbook,oId);
outputExcel(response, workbook, "订单详情");
}
private void reportSheet(SXSSFWorkbook workbook,String oId) {
List<DoExcelOrder> outExcelOrderDetail = adminOrderService.outExcelOrderDetail(oId);
for (int i = 0; i < outExcelOrderDetail.size(); i++) {
if(i!=0){
outExcelOrderDetail.get(i).setOId("");
outExcelOrderDetail.get(i).setOName("");
outExcelOrderDetail.get(i).setOPhone("");
outExcelOrderDetail.get(i).setOAddress("");
}
outExcelOrderDetail.get(i).setMoney(outExcelOrderDetail.get(i).getMoney()+"元");
}
ExcelUtil2 excelUtil=new ExcelUtil2();
List<JSONObject> columns = new ArrayList<>();
columns.add(excelUtil.defaultGetColumn("订单号", "oId", 15 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("收货人", "oName", 15 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("电话", "oPhone", 15 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("地址", "oAddress", 26 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("商品名", "sName", 15 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("数量", "num", 12 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("单价", "money", 12 * 256, false, false));
excelUtil.createSheet(workbook, outExcelOrderDetail, columns, "订单详情");
}
private void outputExcel(HttpServletResponse response, SXSSFWorkbook workbook, String excelName) {
response.setContentType("application/vnd.ms-excel");
try {
// 进行转码,使其支持中文文件名
response.setHeader("content-disposition", "attachment;filename=" + new String(excelName.getBytes("GB2312"), "ISO-8859-1") + ".xlsx");
workbook.write(response.getOutputStream());
} catch (IOException e) {
e.printStackTrace();
}
}
//请确认收货
@RequestMapping("userOrderConfirm")
@ResponseBody
public AjaxResult readUserinfo(Userinfo userinfo,HttpServletRequest request){
AjaxResult aj=new AjaxResult();
Userinfo usr= userService.selectUserinfoById(userinfo);
if(usr!=null){
aj.setTag(usr);
}
return aj;
}
//修改个人信息
@RequestMapping("editUserinfo")
@ResponseBody
public int editUserinfo(Userinfo userinfo){
int rs= userService.updateUserinfoById(userinfo);
return rs;
}
//跳转注册
@RequestMapping("userPersonalInfo")
public String gotoPersonalInfo(){
return "user/personalInfo";
}
//加载个人信息界面
@RequestMapping("userInfo")
public String gotoUserInfo(){
return "user/userInfo";
}
//跳转个人积分页面
@RequestMapping("userIntegral")
public String userIntegral(){
return "user/integral";
}
//跳转个人图片
@RequestMapping("userGerenImg")
public String userGerenImg(){
return "user/gerenImg";
}
//加载个人积分
@RequestMapping("userIntegralLimit")
@ResponseBody
public DataTables userIntegralLimit(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);
public String deleteOrderdetail(int dId,String oId){
List<Orderdetail> orderdetailList = adminOrderService.selectOrderdetailByoId(oId);
if(orderdetailList.size()>=2){
adminOrderService.deleteOrderdetailBydId(dId);
return ResponseUtil.successToClient(1);
}else{
adminOrderService.deleteAdminOrder(oId);
return ResponseUtil.successToClient(2);
}
}
//导出订单详情
@RequestMapping("outExcelOrder")
@ResponseBody
public void outExcelOrder(HttpServletResponse response,String oId){
SXSSFWorkbook workbook = new SXSSFWorkbook();
reportSheet(workbook,oId);
outputExcel(response, workbook, "订单详情");
}
private void reportSheet(SXSSFWorkbook workbook,String oId) {
List<DoExcelOrder> outExcelOrderDetail = adminOrderService.outExcelOrderDetail(oId);
for (int i = 0; i < outExcelOrderDetail.size(); i++) {
if(i!=0){
outExcelOrderDetail.get(i).setOId("");
outExcelOrderDetail.get(i).setOName("");
outExcelOrderDetail.get(i).setOPhone("");
outExcelOrderDetail.get(i).setOAddress("");
}
outExcelOrderDetail.get(i).setMoney(outExcelOrderDetail.get(i).getMoney()+"元");
}
ExcelUtil2 excelUtil=new ExcelUtil2();
List<JSONObject> columns = new ArrayList<>();
columns.add(excelUtil.defaultGetColumn("订单号", "oId", 15 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("收货人", "oName", 15 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("电话", "oPhone", 15 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("地址", "oAddress", 26 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("商品名", "sName", 15 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("数量", "num", 12 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("单价", "money", 12 * 256, false, false));
excelUtil.createSheet(workbook, outExcelOrderDetail, columns, "订单详情");
}
private void outputExcel(HttpServletResponse response, SXSSFWorkbook workbook, String excelName) {
response.setContentType("application/vnd.ms-excel");
try {
// 进行转码,使其支持中文文件名
response.setHeader("content-disposition", "attachment;filename=" + new String(excelName.getBytes("GB2312"), "ISO-8859-1") + ".xlsx");
workbook.write(response.getOutputStream());
} catch (IOException e) {
List<DoExcelOrder> outExcelOrderDetail = adminOrderService.outExcelOrderDetail(oId);
for (int i = 0; i < outExcelOrderDetail.size(); i++) {
if(i!=0){
outExcelOrderDetail.get(i).setOId("");
outExcelOrderDetail.get(i).setOName("");
outExcelOrderDetail.get(i).setOPhone("");
outExcelOrderDetail.get(i).setOAddress("");
}
outExcelOrderDetail.get(i).setMoney(outExcelOrderDetail.get(i).getMoney()+"元");
}
ExcelUtil2 excelUtil=new ExcelUtil2();
List<JSONObject> columns = new ArrayList<>();
columns.add(excelUtil.defaultGetColumn("订单号", "oId", 15 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("收货人", "oName", 15 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("电话", "oPhone", 15 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("地址", "oAddress", 26 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("商品名", "sName", 15 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("数量", "num", 12 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("单价", "money", 12 * 256, false, false));
excelUtil.createSheet(workbook, outExcelOrderDetail, columns, "订单详情");
}
private void outputExcel(HttpServletResponse response, SXSSFWorkbook workbook, String excelName) {
response.setContentType("application/vnd.ms-excel");
try {
// 进行转码,使其支持中文文件名
response.setHeader("content-disposition", "attachment;filename=" + new String(excelName.getBytes("GB2312"), "ISO-8859-1") + ".xlsx");
workbook.write(response.getOutputStream());
} catch (IOException e) {
e.printStackTrace();
}
}
//请确认收货
@RequestMapping("userOrderConfirm")
@ResponseBody
public String userOrderConfirm(HttpServletRequest request,int id,int typeNum){
int eId;
if(typeNum==0){
DataTables datatable=new DataTables();
datatable.setData(pageHelp.getList());
datatable.setRecordsFiltered(pageHelp.getRecord());
datatable.setRecordsTotal(pageHelp.getRecord());
return datatable;
}
//跳转个人账户页面
@RequestMapping("userAccount")
public String userAccount(){
return "user/account";
}
//加载个人积分
@RequestMapping("userAccountLimit")
@ResponseBody
public DataTables userAccountLimit(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<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);
@Controller
@RequestMapping("/admin/snackinfo/")
public class AdminSnakcinfoController {
@Autowired
private adminSnackInfoService adminSnackInfoService;
@Autowired
private typeService typeService;
@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();
}
//将上传文件保存到一个目标文件当中
file.transferTo(new File(path + File.separator + filename));
return ResponseUtil.successToClient();
} else {
return ResponseUtil.errorToClient();
}
}
@RequestMapping("mainToAdminSnackinfo")
}
//导出订单详情
@RequestMapping("outExcelOrder")
@ResponseBody
public void outExcelOrder(HttpServletResponse response,String oId){
SXSSFWorkbook workbook = new SXSSFWorkbook();
reportSheet(workbook,oId);
outputExcel(response, workbook, "订单详情");
}
private void reportSheet(SXSSFWorkbook workbook,String oId) {
List<DoExcelOrder> outExcelOrderDetail = adminOrderService.outExcelOrderDetail(oId);
for (int i = 0; i < outExcelOrderDetail.size(); i++) {
if(i!=0){
outExcelOrderDetail.get(i).setOId("");
outExcelOrderDetail.get(i).setOName("");
outExcelOrderDetail.get(i).setOPhone("");
outExcelOrderDetail.get(i).setOAddress("");
}
outExcelOrderDetail.get(i).setMoney(outExcelOrderDetail.get(i).getMoney()+"元");
}
ExcelUtil2 excelUtil=new ExcelUtil2();
List<JSONObject> columns = new ArrayList<>();
columns.add(excelUtil.defaultGetColumn("订单号", "oId", 15 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("收货人", "oName", 15 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("电话", "oPhone", 15 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("地址", "oAddress", 26 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("商品名", "sName", 15 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("数量", "num", 12 * 256, false, false));
columns.add(excelUtil.defaultGetColumn("单价", "money", 12 * 256, false, false));
excelUtil.createSheet(workbook, outExcelOrderDetail, columns, "订单详情");
}
private void outputExcel(HttpServletResponse response, SXSSFWorkbook workbook, String excelName) {
response.setContentType("application/vnd.ms-excel");
try {
// 进行转码,使其支持中文文件名
response.setHeader("content-disposition", "attachment;filename=" + new String(excelName.getBytes("GB2312"), "ISO-8859-1") + ".xlsx");
workbook.write(response.getOutputStream());
} catch (IOException e) {
e.printStackTrace();
}
}
//请确认收货
@RequestMapping("userOrderConfirm")
@ResponseBody
public String userOrderConfirm(HttpServletRequest request,int id,int typeNum){
int eId;
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;
@Autowired
private typeService typeService;
@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());
Userinfo selectUserinfoMoney = userService.selectUserinfoMoney((int)request.getSession().getAttribute("frontuserId"));
Double selectOrderdetailPayMoney = sorderService.selectOrderdetailPayMoney(oId);
dpm.setPayMoney(selectOrderdetailPayMoney.toString());
dpm.setuMoney(selectUserinfoMoney.getuMoney());
return ResponseUtil.successToClient(dpm);
}
//确认付款
@RequestMapping("userOrderPayMoneyConfirm")
@ResponseBody
public String userOrderPayMoneyConfirm(HttpServletRequest request,Float payNumber,Float uMoney,String uPasword,String oId){
Userinfo userinfo = (Userinfo)request.getSession().getAttribute("exituser");
if(userinfo.getuPassword().equals(uPasword)){
sorderService.updateOrderByoId(oId);
userService.updateUserinfoBypay(userinfo.getuId(), uMoney-payNumber);
}else{
return ResponseUtil.errorToClient();
}
return ResponseUtil.successToClient();
}
//删除订单
@RequestMapping("deleteMyOrder")
@ResponseBody
public String deleteAdminOrder(String oId){
return ResponseUtil.successToClient(adminOrderService.deleteAdminOrder(oId));
}
//跳转管理员信息
@RequestMapping("mainToAdminuser")
public String mainToAdminuser(){
return "admin/persionInfo/adminInfo";
}
//加载管理员信息
@RequestMapping("mainSelectAdminuser")
@ResponseBody
public String mainSelectAdminuser(HttpServletRequest request){
int adId =(int)request.getSession().getAttribute("adminId");
return ResponseUtil.successToClient(userService.selectAdminInfo(adId));
}
//更新管理员信息
@RequestMapping("mainUpdateAdminuser")
@ResponseBody
public String mainUpdateAdminuser(DoAdminInfo admin){
return ResponseUtil.successToClient(userService.updateAdminInfo(admin));
//跳转个人图片
@RequestMapping("userGerenImg")
public String userGerenImg(){
return "user/gerenImg";
}
//加载个人积分
@RequestMapping("userIntegralLimit")
@ResponseBody
public DataTables userIntegralLimit(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<Integral> pageHelp= userService.selectIntegralLimit(map);
DataTables datatable=new DataTables();
datatable.setData(pageHelp.getList());
datatable.setRecordsFiltered(pageHelp.getRecord());
datatable.setRecordsTotal(pageHelp.getRecord());
return datatable;
}
//跳转个人账户页面
@RequestMapping("userAccount")
public String userAccount(){
return "user/account";
}
//加载个人积分
@RequestMapping("userAccountLimit")
@ResponseBody
public DataTables userAccountLimit(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<Account> pageHelp= userService.selectAccountLimit(map);
DataTables datatable=new DataTables();
datatable.setData(pageHelp.getList());