开发者社区> 编程指南针> 正文
阿里云
为了无法计算的价值
打开APP
阿里云APP内打开

java项目-基于SSM实现物流信息管理系统

简介: 基于SSM框架的物流管理系统主要分为三种用户角色,分别是管理员、员工以及客户用户,其具体功能如下: 管理员:管理员登录后主要功能模块有个人信息,客户管理,反馈信息,基础信息,货物信息以及货物运输。 员工用户:员工用户登录后主要模块有个人信息,配送范围,货物信息,货物运输以及反馈信息。 客户用户:客户用户登录后主要模块有个人信息,配送范围,货物信息,货物运输以及反馈信息。
+关注继续查看

作者主页:编程指南针

作者简介:Java领域优质创作者、CSDN博客专家 、掘金特邀作者、多年架构师设计经验、腾讯课堂常驻讲师

主要内容:Java项目、毕业设计、简历模板、学习资料、面试题库、技术互助

文末获取源码

一,项目简介

基于SSM框架的物流管理系统主要分为三种用户角色,分别是管理员、员工以及客户用户,其具体功能如下:

管理员:管理员登录后主要功能模块有个人信息,客户管理,反馈信息,基础信息,货物信息以及货物运输。

员工用户:员工用户登录后主要模块有个人信息,配送范围,货物信息,货物运输以及反馈信息。

客户用户:客户用户登录后主要模块有个人信息,配送范围,货物信息,货物运输以及反馈信息。

二,环境介绍

语言环境:Java:  jdk1.8

数据库:Mysql: mysql5.7

应用服务器:Tomcat:  tomcat8.5.31

开发工具:IDEA或eclipse

后台开发:SSM框架

前端开发:Bootstrap+Jquery+Echart

三,系统展示

展示一下部分系统的功能:

用户登陆

imageimage.gif编辑

管理员主功能界面:

imageimage.gif编辑

员工管理

imageimage.gif编辑

客户管理

imageimage.gif编辑

反馈信息

imageimage.gif编辑

基础信息管理

imageimage.gif编辑

货物信息审核

imageimage.gif编辑

货物运输

imageimage.gif编辑

客户角色的管理主界面

imageimage.gif编辑

普通管理用户的管理主界面

四,核心代码展示

package com.action;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.multipart.MultipartFile;
import com.model.*;
import com.service.*;
import com.util.*;
@Controller
public class GgtypeAction {
    @Autowired
    private GgtypeService ggtypeService;
    @RequestMapping("/getGgtypes")
    public void getGgtypes(HttpServletRequest request,
            HttpServletResponse response) throws Exception {
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        String page = (String) request.getParameter("page");
        String rows = (String) request.getParameter("rows");
        String ggtypeName = (String) request.getParameter("ggtypeName");
        String ggtypeId = (String) request.getParameter("ggtypeId");
        PageBean pageBean = new PageBean(Integer.parseInt(page), Integer.parseInt(rows));
        Ggtype ggtype = new Ggtype();
        try {
            if (StringUtil.isNotEmpty(ggtypeName)) {
                ggtype.setGgtypeName(ggtypeName);
            }
            if (StringUtil.isNotEmpty(ggtypeId)) {
                ggtype.setGgtypeId(Integer.parseInt(ggtypeId));
            }
            JSONArray jsonArray = JSONArray.fromObject(ggtypeService.queryGgtypes(ggtype, pageBean.getStart(), pageBean.getRows()));
            JSONObject result = new JSONObject();
            int total = ggtypeService.queryGgtypes(ggtype, 0, 0).size();
            result.put("rows", jsonArray);
            result.put("total", total);
            ResponseUtil.write(response, result);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    @RequestMapping("/addGgtype")
    public void addGgtype(HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        try {
            JSONObject result = new JSONObject();
            String ggtypeName = (String) request.getParameter("ggtypeName");
            String ggtypeMark = (String) request.getParameter("ggtypeMark");
            String ggtypeId = (String) request.getParameter("ggtypeId");
            Ggtype ggtype = new Ggtype();
            if (StringUtil.isNotEmpty(ggtypeId)) {
                ggtype = ggtypeService.getGgtype(Integer.parseInt(ggtypeId));
            }
            if (StringUtil.isNotEmpty(ggtypeName)) {
                ggtype.setGgtypeName(ggtypeName);
            }
            if (StringUtil.isNotEmpty(ggtypeMark)) {
                ggtype.setGgtypeMark(ggtypeMark);
            }
            if (StringUtil.isNotEmpty(ggtypeId)) {
                ggtypeService.modifyGgtype(ggtype);
            } else {
                ggtypeService.save(ggtype);
            }
            result.put("success", "true");
            ResponseUtil.write(response, result);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    @RequestMapping("/deleteGgtype")
    public void deleteGgtype(HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        try {
            String delIds = (String) request.getParameter("delIds");
            System.out.println("delIds = " + delIds);
            JSONObject result = new JSONObject();
            String str[] = delIds.split(",");
            for (int i = 0; i < str.length; i++) {
                ggtypeService.deleteGgtype(Integer.parseInt(str[i]));
            }
            result.put("success", "true");
            result.put("delNums", str.length);
            ResponseUtil.write(response, result);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    @RequestMapping("/ggtypeComboList")
    public void ggtypeComboList(HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        try {
            JSONArray jsonArray = new JSONArray();
            JSONObject jsonObject = new JSONObject();
            jsonObject.put("id", "");
            jsonObject.put("ggtypeName", "请选择...");
            jsonArray.add(jsonObject);
            jsonArray.addAll(JSONArray.fromObject(ggtypeService.queryGgtypes(null, 0, 0)));
            ResponseUtil.write(response, jsonArray);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

image.gif

package com.action;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.sf.json.JSONObject;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import com.model.*;
import com.service.*;
@Controller
public class AdminAction {
    @Autowired
    private AdminService adminService;
    @RequestMapping("/mimaAdmin")
    public void mimaAdmin(HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        try {
            JSONObject result = new JSONObject();
            String adminPassword = (String) request.getParameter("adminPassword");
            String adminPassword1 = (String) request.getParameter("adminPassword1");
            Admin admin = new Admin();
            admin.setAdminName("admin");
            admin.setAdminPassword(adminPassword);
            if (adminService.queryAdmins(admin, 0, 0).size()==1) {
                admin = (Admin)(adminService.queryAdmins(admin, 0, 0)).get(0);
                admin.setAdminPassword(adminPassword1);
                adminService.modifyAdmin(admin);
                request.setAttribute("error", "密码修改成功!");
                request.getRequestDispatcher("adminmima.jsp").forward(request,
                        response);
            }else{
                result.put("success", "true");
                request.setAttribute("error", "原密码错误,请重新输入!");
                request.getRequestDispatcher("adminmima.jsp").forward(request,
                        response);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

image.gif

package com.action;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.multipart.MultipartFile;
import com.model.*;
import com.service.*;
import com.util.*;
@Controller
public class RoleAction {
    @Autowired
    private RoleService roleService;
    @RequestMapping("/getRoles")
    public void getRoles(HttpServletRequest request,
            HttpServletResponse response) throws Exception {
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        String page = (String) request.getParameter("page");
        String rows = (String) request.getParameter("rows");
        String roleName = (String) request.getParameter("roleName");
        String roleId = (String) request.getParameter("roleId");
        String roleMark2 = (String) request.getParameter("roleMark2");
        PageBean pageBean = new PageBean(Integer.parseInt(page), Integer.parseInt(rows));
        Role role = new Role();
        try {
            if (StringUtil.isNotEmpty(roleName)) {
                role.setRoleName(roleName);
            }
            if (StringUtil.isNotEmpty(roleId)) {
                role.setRoleId(Integer.parseInt(roleId));
            }
            if (StringUtil.isNotEmpty(roleMark2)) {
                role.setRoleMark2(Integer.parseInt(roleMark2));
            }
            JSONArray jsonArray = JSONArray.fromObject(roleService.queryRoles(role, pageBean.getStart(), pageBean.getRows()));
            JSONObject result = new JSONObject();
            int total = roleService.queryRoles(role, 0, 0).size();
            result.put("rows", jsonArray);
            result.put("total", total);
            ResponseUtil.write(response, result);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    @RequestMapping("/addRole")
    public void addRole(HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        try {
            JSONObject result = new JSONObject();
            String roleName = (String) request.getParameter("roleName");
            String roleMark = (String) request.getParameter("roleMark");
            String roleMark1 = (String) request.getParameter("roleMark1");
            String roleMark2 = (String) request.getParameter("roleMark2");
            String roleId = (String) request.getParameter("roleId");
            Role role = new Role();
            if (StringUtil.isNotEmpty(roleId)) {
                role = roleService.getRole(Integer.parseInt(roleId));
            }
            if (StringUtil.isNotEmpty(roleName)) {
                role.setRoleName(roleName);
            }
            if (StringUtil.isNotEmpty(roleMark)) {
                role.setRoleMark(roleMark);
            }
            if (StringUtil.isNotEmpty(roleMark1)) {
                role.setRoleMark1(roleMark1);
            }
            if (StringUtil.isNotEmpty(roleMark2)) {
                role.setRoleMark2(Integer.parseInt(roleMark2));
            }
            if (StringUtil.isNotEmpty(roleId)) {
                roleService.modifyRole(role);
            } else {
                roleService.save(role);
            }
            result.put("success", "true");
            ResponseUtil.write(response, result);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    @RequestMapping("/deleteRole")
    public void deleteRole(HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        try {
            String delIds = (String) request.getParameter("delIds");
            System.out.println("delIds = " + delIds);
            JSONObject result = new JSONObject();
            String str[] = delIds.split(",");
            for (int i = 0; i < str.length; i++) {
                roleService.deleteRole(Integer.parseInt(str[i]));
            }
            result.put("success", "true");
            result.put("delNums", str.length);
            ResponseUtil.write(response, result);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    @RequestMapping("/roleComboList")
    public void roleComboList(HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        String roleMark2 = (String) request.getParameter("roleMark2");
        Role role = new Role();
        if (StringUtil.isNotEmpty(roleMark2)) {
            role.setRoleMark2(Integer.parseInt(roleMark2));
        }
        try {
            JSONArray jsonArray = new JSONArray();
            JSONObject jsonObject = new JSONObject();
            jsonObject.put("id", "");
            jsonObject.put("roleName", "请选择...");
            jsonArray.add(jsonObject);
            //jsonArray.addAll(JSONArray.fromObject(roleService.queryRoles(role, 0, 0)));
            ResponseUtil.write(response, jsonArray);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

image.gif

package com.action;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.multipart.MultipartFile;
import com.model.*;
import com.service.*;
import com.util.*;
import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;
import java.net.URLEncoder;
//导入导出
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
@Controller
public class GonggaoAction {
    @Autowired
    private GonggaoService gonggaoService;
    @Autowired
    private GgtypeService ggtypeService;
    /***上传导入开始***/
    private InputStream excelFile;
    public InputStream getExcelFile() {
        return excelFile;
    }
    /***上传导入结束***/
    @RequestMapping("/getGonggaos")
    public void getGonggaos(HttpServletRequest request,
            HttpServletResponse response) throws Exception {
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        String page = (String) request.getParameter("page");
        String rows = (String) request.getParameter("rows");
        String gonggaoName = (String) request.getParameter("gonggaoName");
        String gonggaoId = (String) request.getParameter("gonggaoId");
        String ggtypeId = (String) request.getParameter("ggtypeId");
        String sdate = (String) request.getParameter("sdate");
        String edate = (String) request.getParameter("edate");
        PageBean pageBean = new PageBean(Integer.parseInt(page), Integer.parseInt(rows));
        Gonggao gonggao = new Gonggao();
        try {
            if (StringUtil.isNotEmpty(gonggaoName)) {
                gonggao.setGonggaoName(gonggaoName);
            }
            if (StringUtil.isNotEmpty(gonggaoId)) {
                gonggao.setGonggaoId(Integer.parseInt(gonggaoId));
            }
            if (StringUtil.isNotEmpty(ggtypeId)) {
                gonggao.setGgtypeId(Integer.parseInt(ggtypeId));
            }
            JSONArray jsonArray = JSONArray.fromObject(gonggaoService.queryGonggaos(
                    gonggao, pageBean.getStart(), pageBean.getRows(), sdate, edate));
            JSONObject result = new JSONObject();
            int total = gonggaoService.queryGonggaos(gonggao, 0, 0, sdate, edate).size();
            result.put("rows", jsonArray);
            result.put("total", total);
            ResponseUtil.write(response, result);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    @RequestMapping("/addGonggao")
    public void addGonggao(HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        JSONObject result = new JSONObject();
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        String gonggaoName = (String) request.getParameter("gonggaoName");
        String gonggaoMark = (String) request.getParameter("gonggaoMark");
        String gonggaoDate = (String) request.getParameter("gonggaoDate");
        String ggtypeId = (String) request.getParameter("ggtypeId");
        String gonggaoId = (String) request.getParameter("gonggaoId");
        Gonggao gonggao = new Gonggao();
        if (StringUtil.isNotEmpty(gonggaoId)) {
            gonggao = gonggaoService.getGonggao(Integer.parseInt(gonggaoId));
        }
        if (StringUtil.isNotEmpty(gonggaoName)) {
            gonggao.setGonggaoName(gonggaoName);
        }
        if (StringUtil.isNotEmpty(gonggaoMark)) {
            gonggao.setGonggaoMark(gonggaoMark);
        }
        if (StringUtil.isNotEmpty(gonggaoDate)) {
            gonggao.setGonggaoDate(DateUtil.formatString(gonggaoDate,
                    "yyyy-MM-dd hh:mm:ss"));
        }
        if (StringUtil.isNotEmpty(ggtypeId)) {
            gonggao.setGgtypeId(Integer.parseInt(ggtypeId));
            Ggtype ggtype = new Ggtype();
            ggtype = ggtypeService.getGgtype(Integer.parseInt(ggtypeId));
            gonggao.setGgtypeName(ggtype.getGgtypeName());
        }
        try {
            if (StringUtil.isNotEmpty(gonggaoId)) {
                gonggaoService.modifyGonggao(gonggao);
                result.put("success", "true");
                ResponseUtil.write(response, result);
            } else {
                Date date = new Date();
                gonggao.setGonggaoDate(date);
                gonggaoService.save(gonggao);
                result.put("success", "true");
                ResponseUtil.write(response, result);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    @RequestMapping("/deleteGonggao")
    public void deleteGonggao(HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        JSONObject result = new JSONObject();
        String delIds = (String) request.getParameter("delIds");
        try {
            String str[] = delIds.split(",");
            for (int i = 0; i < str.length; i++) {
                gonggaoService.deleteGonggao(Integer.parseInt(str[i]));
            }
            result.put("success", "true");
            result.put("delNums", str.length);
            ResponseUtil.write(response, result);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    @RequestMapping("/gonggaoComboList")
    public void gonggaoComboList(HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        String ggtypeId = (String) request.getParameter("ggtypeId");
        Gonggao gonggao = new Gonggao();
        if (StringUtil.isNotEmpty(ggtypeId)) {
            gonggao.setGgtypeId(Integer.parseInt(ggtypeId));
        }
        try {
            JSONArray jsonArray = new JSONArray();
            JSONObject jsonObject = new JSONObject();
            jsonObject.put("id", "");
            jsonObject.put("gonggaoName", "请选择...");
            jsonArray.add(jsonObject);
            jsonArray.addAll(JSONArray.fromObject(gonggaoService.queryGonggaos(gonggao, 0, 0, null, null)));
            ResponseUtil.write(response, jsonArray);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    @RequestMapping("/gonggaoTongji")
    public void gonggaoTongji(HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        String sdate=request.getParameter("sdate");
        String edate=request.getParameter("edate");
        List<Integer> ggtypeIds = new ArrayList<Integer>();
        List<String> ggtypeNames = new ArrayList<String>();
        List<Integer> gonggaoZongshus = new ArrayList<Integer>();
        List<Ggtype> ggtypes = new ArrayList<Ggtype>();
        List<Gonggao> gonggaos = new ArrayList<Gonggao>();
        Gonggao gonggao = new Gonggao();
        Integer zongshu = 0;
        try {
            ggtypes = ggtypeService.queryGgtypes(null, 0,0);
            for(int i=0;i<ggtypes.size();i++){
                ggtypeIds.add(ggtypes.get(i).getGgtypeId());
                ggtypeNames.add(ggtypes.get(i).getGgtypeName());
            }
            for(int i=0;i<ggtypeIds.size();i++){
                Integer gonggaoZongshu = 0;
                gonggao.setGgtypeId(ggtypeIds.get(i));
                gonggaos = gonggaoService.queryGonggaos(gonggao, 0, 0, sdate, edate);
                for(int j=0;j<gonggaos.size();j++){
                    gonggaoZongshu = gonggaoZongshu + gonggaos.size();
                }
                zongshu = zongshu + gonggaoZongshu;
                gonggaoZongshus.add(gonggaoZongshu);
            }
            HttpSession session = request.getSession();
            session.setAttribute("ggtypeNames", ggtypeNames);
            session.setAttribute("gonggaoZongshus", gonggaoZongshus);
            session.setAttribute("zongshu", zongshu);
            response.sendRedirect("admin/gonggaotongji.jsp");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    @RequestMapping("/shangchuanGonggao")
    public void shangchuanGonggao(HttpServletRequest request, HttpServletResponse response,MultipartFile uploadFile)
            throws Exception {
        try {
            String gonggaoId = (String) request.getParameter("gonggaoId");
            String directory = "/file";
            String targetDirectory = request.getSession().getServletContext().getRealPath(directory);
            String fileName = uploadFile.getOriginalFilename();
            File dir = new File(targetDirectory,fileName);
            if(!dir.exists()){
                dir.mkdirs();
            }
            //MultipartFile自带的解析方法
            uploadFile.transferTo(dir);
            String shangchuandizhi = "/file" + "/" + fileName;
            String shangchuanname = fileName;
            Gonggao gonggao = gonggaoService.getGonggao(Integer.parseInt(gonggaoId));
            gonggao.setGonggaoImg(shangchuandizhi);
            gonggao.setGonggaoImgName(shangchuanname);
            gonggaoService.modifyGonggao(gonggao);
            JSONObject result = new JSONObject();
            result.put("success", "true");
            ResponseUtil.write(response, result);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    @RequestMapping("/xiazaiGonggao")
    public void xiazaiGonggao(HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        String filename = (String) request.getParameter("filename");
        //模拟文件,myfile.txt为需要下载的文件
        String path = request.getSession().getServletContext().getRealPath("file")+"\\"+filename;
        //获取输入流
        InputStream bis = new BufferedInputStream(new FileInputStream(new File(path)));
        //转码,免得文件名中文乱码
        filename = URLEncoder.encode(filename,"UTF-8");
        //设置文件下载头
        response.addHeader("Content-Disposition", "attachment;filename=" + filename);
        //1.设置文件ContentType类型,这样设置,会自动判断下载文件类型
        response.setContentType("multipart/form-data");
        BufferedOutputStream out = new BufferedOutputStream(response.getOutputStream());
        int len = 0;
        while((len = bis.read()) != -1){
            out.write(len);
            out.flush();
        }
        out.close();
    }
    @RequestMapping("/daoruGonggao")
    public void daoruGonggao(HttpServletRequest request, HttpServletResponse response,MultipartFile uploadFile)
            throws Exception {
        try {
            String directory = "/file";
            String targetDirectory = request.getSession().getServletContext().getRealPath(directory);
            String fileName = uploadFile.getOriginalFilename();
            File dir = new File(targetDirectory,fileName);
            if(!dir.exists()){
                dir.mkdirs();
            }
            //MultipartFile自带的解析方法
            uploadFile.transferTo(dir);
            excelFile = new FileInputStream(dir);
            Workbook wb = new HSSFWorkbook(excelFile);
            Sheet sheet = wb.getSheetAt(0);
            int rowNum = sheet.getLastRowNum() + 1;
            for (int i = 1; i < rowNum; i++) {
                Gonggao gonggao = new Gonggao();
                Row row = sheet.getRow(i);
                int cellNum = row.getLastCellNum();
                for (int j = 0; j < cellNum; j++) {
                    Cell cell = row.getCell(j);
                    String cellValue = null;
                    switch (cell.getCellType()) { // 判断excel单元格内容的格式,并对其进行转换,以便插入数据库
                    case 0:
                        cellValue = String.valueOf((int) cell
                                .getNumericCellValue());
                        break;
                    case 1:
                        cellValue = cell.getStringCellValue();
                        break;
                    case 2:
                        cellValue = cell.getStringCellValue();
                        break;
                    }
                    switch (j) {// 通过列数来判断对应插如的字段
                    case 1:
                        gonggao.setGonggaoName(cellValue);
                        break;
                    case 2:
                        gonggao.setGonggaoMark(cellValue);
                        break;
                    }
                }
                gonggaoService.save(gonggao);
            }
            JSONObject result = new JSONObject();
            result.put("success", "true");
            ResponseUtil.write(response, result);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    @RequestMapping("/daochuGonggao")
    public void daochuGonggao(HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        String delIds = (String) request.getParameter("delIds");
        JSONObject result = new JSONObject();
        String str[] = delIds.split(",");
        // 创建一个Excel文件
        HSSFWorkbook workbook = new HSSFWorkbook();
        // 创建一个工作表
        HSSFSheet sheet = workbook.createSheet("gonggaos记录");
        // 添加表头行
        HSSFRow hssfRow = sheet.createRow(0);
        // 设置单元格格式居中
        HSSFCellStyle cellStyle = workbook.createCellStyle();
        cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        // 添加表头内容
        HSSFCell headCell = hssfRow.createCell(0);
        headCell.setCellValue("编号");
        headCell.setCellStyle(cellStyle);
        headCell = hssfRow.createCell(1);
        headCell.setCellValue("用户名");
        headCell.setCellStyle(cellStyle);
        headCell = hssfRow.createCell(2);
        headCell.setCellValue("密码");
        headCell.setCellStyle(cellStyle);
        headCell = hssfRow.createCell(3);
        headCell.setCellValue("姓名");
        headCell.setCellStyle(cellStyle);
        headCell = hssfRow.createCell(4);
        headCell.setCellValue("性别");
        headCell.setCellStyle(cellStyle);
        headCell = hssfRow.createCell(5);
        headCell.setCellValue("年龄");
        headCell.setCellStyle(cellStyle);
        headCell = hssfRow.createCell(6);
        headCell.setCellValue("电话");
        headCell.setCellStyle(cellStyle);
        headCell = hssfRow.createCell(7);
        headCell.setCellValue("备注1");
        headCell.setCellStyle(cellStyle);
        headCell = hssfRow.createCell(8);
        headCell.setCellValue("备注2");
        headCell.setCellStyle(cellStyle);
        headCell = hssfRow.createCell(9);
        headCell.setCellValue("备注3");
        headCell.setCellStyle(cellStyle);
        headCell = hssfRow.createCell(10);
        headCell.setCellValue("备注4");
        headCell.setCellStyle(cellStyle);
        headCell = hssfRow.createCell(13);
        headCell.setCellValue("标志1");
        headCell.setCellStyle(cellStyle);
        headCell = hssfRow.createCell(14);
        headCell.setCellValue("备注2");
        headCell.setCellStyle(cellStyle);
        headCell = hssfRow.createCell(15);
        headCell.setCellValue("权限");
        headCell.setCellStyle(cellStyle);
        headCell = hssfRow.createCell(16);
        headCell.setCellValue("部门");
        headCell.setCellStyle(cellStyle);
        // 添加数据内容
        for (int i = 0; i < str.length; i++) {
            hssfRow = sheet.createRow((int) i + 1);
            Gonggao gonggao = gonggaoService.getGonggao(Integer.parseInt(str[i]));
            // 创建单元格,并设置值
            HSSFCell cell = hssfRow.createCell(0);
            cell.setCellValue(gonggao.getGonggaoId());
            cell.setCellStyle(cellStyle);
            cell = hssfRow.createCell(1);
            cell.setCellValue(gonggao.getGonggaoName());
            cell.setCellStyle(cellStyle);
            cell = hssfRow.createCell(7);
            cell.setCellValue(gonggao.getGonggaoMark());
            cell.setCellStyle(cellStyle);
            cell = hssfRow.createCell(16);
            cell.setCellValue(gonggao.getGgtypeName());
            cell.setCellStyle(cellStyle);
        }
        // 保存Excel文件
        try {
            Date date = new Date();
            String strdate = DateUtil.formatDate(date, "yyyyMMddhhmmss");
            OutputStream outputStream = new FileOutputStream("D:/gonggao"
                    + strdate + ".xls");
            workbook.write(outputStream);
            outputStream.close();
            result.put("success", "true");
            ResponseUtil.write(response, result);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

image.gif

五,项目总结

   本项目主要基于物流信息的基本管理功能实现的一个信息化管理系统,客户登陆系统后可以添加货物并进行运输信息的选择和添加,普通用户进入系统可以对用户的发货信息进行审核,并根据运输情况改变运输状态,客户在货物运达后可以进行验收操作。整个业务流程十分完整。管理员主要进行基础信息的基本管理,也可以进行相关的业务操作。

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
【JAVASE开发】JAVA项目(学生管理系统)
这里很明显存放的是我们的数据,那就 new 一个StudentDataBase,声明学号(stuNo)、姓名(stuName)、班级(stuClass)、性别(stuSex)、年龄(stuSex)、分数(stuScore),有参与无参的构造方法,getter 与 setter 方法、add 方法、print(输出)方法。......
17 0
Java项目-基于SSM实现律师事务所管理平台
随着时代的发展,中国的法治越来越健全,人们发生经济纠纷时更愿意通过法律渠道来解决问题和纠纷,随着这样需求的增加,越来越多的专业律师事务所在全国各地成立。本系统的主要作用就是为律师事务所提供一个信息综合管理平台,用户可以通过我们的这个平台来查询历史案件,在线咨询我们事务所的律师,如果我们的律师接了客户的单子,可以通过平台来进行查询案件执行情况等。      系统主要分为三个角色,一个普通用户,可以通过注册后登陆系统的前端,查看相关信息并实现在线咨询,二是管理员用户,可以登陆后台进行相关信息的管理,主要实现的功能有:首页轮播图管理、事务所新闻管理、客户管理、历史案件管理、律师管理、个人信息维护等
18 0
IDEA+Java+SSM+Jsp+Mysql实现Web商品信息管理系统(上)
IDEA+Java+SSM+Jsp+Mysql实现Web商品信息管理系统
47 0
Java项目:UMS 用户管理系统(二)
Java项目:UMS 用户管理系统(二)
37 0
Java项目:UMS 用户管理系统(一)
Java项目:UMS 用户管理系统(一)
38 0
Java课程设计【学生信息管理系统】(1)
Java课程设计【学生信息管理系统】(1)
146 0
【Java】升级版学生管理系统项目(下)
打印菜单: 增加学生信息: 查看学生信息: 删除学生信息: 修改学生信息: 查找学生信息: 代码效果演示图:
38 0
基于java的土地档案管理系统
基于java的土地档案管理系统
80 0
+关注
编程指南针
作者简介:阿里云特邀作者、Java领域优质创作者、CSDN博客专家 、掘金特邀作者、多年架构师设计经验、CSDN名师课堂讲师、腾讯课堂常驻讲师 主要内容:Java项目、毕业设计、简历模板、学习资料、面试题库、技术互助
108
文章
0
问答
文章排行榜
最热
最新
相关电子书
更多
低代码开发师(初级)实战教程
立即下载
阿里巴巴DevOps 最佳实践手册
立即下载
冬季实战营第三期:MySQL数据库进阶实战
立即下载