好好编程-物流项目15【基础数据-分页查询和添加】-阿里云开发者社区

好好编程-物流项目15【基础数据-分页查询和添加】

2021-12-02 114

版权

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

简介： 项目中我们往往要用到很多数据量不大且不会经常变动的数据，比如部门信息，付款方式，性别等信息，如果这些信息我们都单独用一张表来维护，显示不是很明智，所以我们可以将这一类数据统一存放在一张表中。通过数据结构来维护

基础数据

项目中我们往往要用到很多数据量不大且不会经常变动的数据，比如部门信息，付款方式，性别等信息，如果这些信息我们都单独用一张表来维护，显示不是很明智，所以我们可以将这一类数据统一存放在一张表中。通过数据结构来维护。如下:

我们规定parent_id为null的表示类别数据，parent_id不为null则表示为该类型下的数据。

1.查询基础数据

left.jsp跳转

创建Dto

public class BasicDataDto extends BasePage{
  public BasicData basic;
  public BasicData getBasic() {
    return basic;
  }
  public void setBasic(BasicData basic) {
    this.basic = basic;
  }
}

创建IBasicService接口

public interface IBasicService {
  public List<BasicData> query(BasicData bd);
  public PageInfo<BasicData> queryPage(BasicDto dto);
  public void addBasicData(BasicData bd);
  public void deleteBasicData(int id);
  public void updateBasicData(BasicData bd);
}

创建BasicServiceImpl

@Service
public class BasicServiceImpl implements IBasicService {
  @Resource
  private BasicDataMapper basicDataMapper;
  @Override
  public List<BasicData> query(BasicData bd) {
    BasicDataExample example = new BasicDataExample();
    return basicDataMapper.selectByExample(example );
  }
  @Override
  public PageInfo<BasicData> queryPage(BasicDataDto dto) {
    PageHelper.startPage(dto.getPageNum(), dto.getPageSize());
    List<BasicData> list = this.query(dto.getBasic());
    return new PageInfo<>(list);
  }
  @Override
  public void addBasicData(BasicData bd) {
    basicDataMapper.insertSelective(bd);
  }
  @Override
  public void deleteBasicData(int id) {
    basicDataMapper.deleteByPrimaryKey(id);
  }
  @Override
  public void updateBasicData(BasicData bd) {
    basicDataMapper.updateByPrimaryKeySelective(bd);
  }
}

创建BasicController

@Controller
@RequestMapping("/basic")
public class BasicDataController {
  @Resource
  private IBasicService basicService;
  @RequestMapping("/query")
  public String queryPage(BasicDataDto dto,Model model){
    PageInfo<BasicData> pageInfo = basicService.queryPage(dto);
    model.addAttribute("pageModel", pageInfo);
    return "basic/basic.jsp";
  }
}

创建basic.jsp页面，

<%@ page language="java" contentType="text/html; charset=UTF-8"
  pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<link href="/css/style.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="/js/jquery.js"></script>
<script type="text/javascript">
  $(document).ready(function() {
    $(".click").click(function() {
      $(".tip").fadeIn(200);
    });
    $(".tiptop a").click(function() {
      $(".tip").fadeOut(200);
    });
    $(".sure").click(function() {
      $(".tip").fadeOut(100);
    });
    $(".cancel").click(function() {
      $(".tip").fadeOut(100);
    });
  });
</script>
</head>
<body>
  <div class="place">
    <span>位置：</span>
    <ul class="placeul">
      <li><a href="#">首页</a></li>
      <li><a href="#">数据表</a></li>
      <li><a href="#">基本内容</a></li>
    </ul>
  </div>
  <div class="rightinfo">
    <div class="tools">
      <ul class="toolbar">
        <li class="click">
          <a href="userUpdate">
            <span>
                <img src="/images/t01.png" />
            </span>
            添加
          </a>
        </li>
        <li class="click"><span><img src="/images/t02.png" /></span>修改</li>
        <li><span><img src="/images/t03.png" /></span>删除</li>
        <li><span><img src="/images/t04.png" /></span>统计</li>
      </ul>
      <ul class="toolbar1">
        <li><span><img src="/images/t05.png" /></span>设置</li>
      </ul>
    </div>
    <table class="tablelist">
      <thead>
        <tr>
          <th><input name="" type="checkbox" value="" checked="checked" /></th>
          <th>编号<i class="sort"><img src="/images/px.gif" /></i></th>
          <th>基础数据</th>
          <th>父节点</th>
          <th>描述信息</th>
          <th>操作</th>
        </tr>
      </thead>
      <tbody>
        <c:forEach items="${pageModel.list }" var="basic">
          <tr>
            <td><input name="" type="checkbox" value="" /></td>
            <td>${basic.baseId }</td>
            <td>${basic.baseName }</td>
            <td>${basic.parentId }</td>
            <td>${basic.baseDesc }</td>
            <td>
              <a href="/user/userUpdate?id=${basic.baseId }" 
              class="tablelink">修改</a> 
              <a href="javascript:void(0)" onclick="deleteUser(${basic.baseId})" 
              class="tablelink"> 删除</a></td>
          </tr>
        </c:forEach>
      </tbody>
    </table>
      <div class="inline pull-right page" style="margin-top: 20px;">
        <form action="/user/queryPage" id="pager">
          <input type="hidden" name="pageSize" id="pageSize" value="${pageModel.pageSize }">
          <input type="hidden" name="pageNum" id="pageNum" value="${pageModel.pageNum }">
        </form>
        <jsp:include page="/pageBar.jsp"></jsp:include>
      </div>
  </div>
  <script type="text/javascript">
    $('.tablelist tbody tr:odd').addClass('odd');
    function deleteUser(userId){
      if(window.confirm("确定要删除该用户吗?")){
        location.href="/user/delete?id="+userId;
      }
    }
  </script>
</body>
</html>

测试访问

2.添加基础数据

实现步骤和添加用户差不多，我们快速实现效果。

IBasicService接口

public void getUpdateInfo(Integer id, Model m);

BasicServiceImpl实现

@Override
public void getUpdateInfo(Integer id, Model m) {
  BasicDataExample example = new BasicDataExample();
  example.createCriteria().andParentIdIsNull();
  // 查询所有的父类型
  List<BasicData> parents = basicDataMapper.selectByExample(example );
  m.addAttribute("parents", parents);
  if(id != null && id > 0){
    // 表示是更新数据，根据id查询出对应的数据信息
    BasicData data = basicDataMapper.selectByPrimaryKey(id);
    m.addAttribute("basic", data);
  }
}

BasicDataController

@RequestMapping("/basicUpdate")
public String basicUpdate(Integer id,Model m){
  basicService.getUpdateInfo(id,m);
  return "basic/basicUpdate";
}

页面代码

<%@ page language="java" contentType="text/html; charset=UTF-8"
  pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<link href="/css/style.css" rel="stylesheet" type="text/css" />
<link href="/css/select.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="/js/jquery.js"></script>
<script type="text/javascript" src="/js/jquery.idTabs.min.js"></script>
<script type="text/javascript" src="/js/select-ui.min.js"></script>
<script type="text/javascript">
$(document).ready(function(e) {
    $(".select1").uedSelect({
    width : 345       
  });
  $(".select2").uedSelect({
    width : 167  
  });
  $(".select3").uedSelect({
    width : 100
  });
});
</script>
</head>
<body>
  <div class="place">
    <span>位置：</span>
    <ul class="placeul">
      <li><a href="/">首页</a></li>
      <li><a href="/user/query">基础数据管理</a></li>
    </ul>
  </div>
  <div class="formbody">
    <div class="formtitle">
      <span>基本信息</span>
    </div>
    <form action="/basic/saveOrUpdate">
      <ul class="forminfo">
        <li><label>基础数据</label>
          <input name="baseName"  type="text" 
          class="dfinput" />
          <i>基础数据不能超过30个字符</i>
        </li>
        <li><label>描述</label>
          <input name="baseDesc" type="text" 
          class="dfinput" />
        </li>
        <li><label>所属类型</label>
          <div class="vocation">
              <select class="select1" name="parentId">
              <option value="0">--本身就是大类--</option>
              <c:forEach items="${ parents}" var="parent">
                <option value="${parent.baseId }">${parent.baseName }</option>
              </c:forEach>
              </select>
          </div>
          <i></i>
        </li>
        <li><label>&nbsp;</label>
          <input name="" type="submit"
          class="btn" value="确认保存" /></li>
        </ul>
    </form>
  </div>
  <div style="display: none">
    <script src='http://v7.cnzz.com/stat.php?id=155540&web_id=155540'
      language='JavaScript' charset='gb2312'></script>
  </div>
</body>
</html>

保存数据

@RequestMapping("/saveOrUpdate")
public String saveOrUpdate(BasicData bd){
  if(bd.getParentId()==0){
    bd.setParentId(null);
  }
  basicService.addBasicData(bd);
  return "redirect:/basic/query";
}