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

基础数据

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

我们规定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; } }

1

2

3

4

5

6

7

8

9

10

11

12

创建IBasicService接口

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

1

2

3

4

5

6

7

8

9

10

11

12

创建BasicServiceImpl

@Service public class BasicServiceImpl implements IBasicService { @Resource private BasicDataMapper basicDataMapper; @Override public List query(BasicData bd) { BasicDataExample example = new BasicDataExample(); return basicDataMapper.selectByExample(example ); } @Override public PageInfo queryPage(BasicDataDto dto) { PageHelper.startPage(dto.getPageNum(), dto.getPageSize()); List 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); } }

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

创建BasicController

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

1

2

3

4

5

6

7

8

9

10

11

12

13

14

创建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"%>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

测试访问

2.添加基础数据

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

IBasicService接口

public void getUpdateInfo(Integer id, Model m);

1

BasicServiceImpl实现

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

1

2

3

4

5

6

7

8

9

10

11

12

13

BasicDataController

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

1

2

3

4

5

页面代码

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>