基础数据
项目中我们往往要用到很多数据量不大且不会经常变动的数据，比如部门信息，付款方式，性别等信息，如果这些信息我们都单独用一张表来维护，显示不是很明智，所以我们可以将这一类数据统一存放在一张表中。通过数据结构来维护。如下:
我们规定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> </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"; }
ok~添加成功，下篇介绍修改，删除和带条件查询
