目录
新建一个模块 勾选以下的组件

pom.xml中数据库的版本降低

调整
- mybatis:
- mapper-locations: classpath:mappers/*xml
- type-aliases-package: com.cdl.springboot04.mybatis.entity
- server:
- port: 8080
- spring:
- application:
- name: springboot04
- datasource:
- driver-class-name: com.mysql.jdbc.Driver
- name: defaultDataSource
- password: 123456
- url: jdbc:mysql://localhost:3306/mysql?useUnicode=true&characterEncoding=UTF-8&useSSL=false
- username: root
- freemarker:
- cache: false
- charset: utf-8
- expose-request-attributes: true
- expose-session-attributes: true
- suffix: .ftl
- template-loader-path: classpath:/templates/
- # resources:
- # static-locations: classpath:/static/# 应用服务 WEB 访问端口
- mvc:
- static-path-pattern: classpath:/static/
测试:





新建一个Freemarker的界面
- HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
- "http://www.w3.org/TR/html4/loose.dtd">
- <html>
- <head>
- <title>title>
- head>
- <body>
- 欢迎来到 Freemaker 首页
- body>
- html>
- package com.cdl.springboot04.controller;
-
- import org.springframework.stereotype.Controller;
- import org.springframework.web.bind.annotation.RequestMapping;
-
- /**
- * @author cdl
- * @site www.cdl.com
- * @create 2022-11-01 18:33
- */
- @Controller
- public class IndexController {
-
- @RequestMapping("/")
- public String index(){
- System.out.println("come in ...");
- // suffix: .ftl
- // template-loader-path: classpath:/templates/
- // /templates/index.ftl
- return "index";
- }
-
- }
在启动类运行

访问成功

提供默认值
后台代码
- package com.cdl.springboot04.controller;
-
- import org.springframework.stereotype.Controller;
- import org.springframework.ui.Model;
- import org.springframework.web.bind.annotation.GetMapping;
- import org.springframework.web.bind.annotation.RequestMapping;
- import org.springframework.web.servlet.ModelAndView;
-
- import java.util.ArrayList;
-
- /**
- * @author cdl
- * @site www.cdl.com
- * @create 2022-11-01 18:33
- */
- @Controller
- public class IndexController {
-
- // @RequestMapping("/")
- // public ModelAndView index(){
- //第一种写法
- // ModelAndView mv = new ModelAndView();
- // mv.setViewName("index");
- // mv.addObject("uname","小陈");
- // System.out.println("come in ...");
- suffix: .ftl
- template-loader-path: classpath:/templates/
- /templates/index.ftl
- // return mv;
-
- // }
-
- @GetMapping("/")
- public String index(Model model) {
- System.out.println("come in............");
- model.addAttribute("uname", "小刘");
- model.addAttribute("sex", "girl");
- return "index";
- }
-
-
- }
前端代码
- HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
- "http://www.w3.org/TR/html4/loose.dtd">
- <html>
- <head>
- <title>title>
- head>
- <body>
- <#--欢迎来到 Freemaker 首页-->
- <h3>取值h3>
- <p>提供默认值p>
- <#--当接受的参数值不为空,这个问题是需要避免的-->
- <#--${uname}-->
- ${uname !}
- body>
- html>
前端结果

当后台没有传值的时候
${uname ! "小王"} 结果是小王的默认值
后台
- package com.cdl.springboot04.controller;
-
- import com.cdl.springboot04.entity.User;
- import org.springframework.stereotype.Controller;
- import org.springframework.ui.Model;
- import org.springframework.web.bind.annotation.GetMapping;
-
- import java.util.ArrayList;
- import java.util.List;
-
- /**
- * @author cdl
- * @site www.cdl.com
- * @create 2022-11-01 18:33
- */
- @Controller
- public class IndexController {
-
- // @RequestMapping("/")
- // public ModelAndView index(){
- //第一种写法
- // ModelAndView mv = new ModelAndView();
- // mv.setViewName("index");
- // mv.addObject("uname","小陈");
- // System.out.println("come in ...");
- suffix: .ftl
- template-loader-path: classpath:/templates/
- /templates/index.ftl
- // return mv;
-
- // }
-
- @GetMapping("/")
- public String index(Model model) {
- System.out.println("come in............");
- model.addAttribute("uname", "小刘");
- model.addAttribute("sex", "girl");
- List
lst = new ArrayList<>(); - lst.add(new User(1, "zs"));
- lst.add(new User(2, "ls"));
- lst.add(new User(3, "ww"));
-
- model.addAttribute("lst",lst);
- model.addAttribute("arr", new Integer[]{5, 6, 7, 8, 9});
- return "index";
- }
-
-
-
- }
前端
- HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
- "http://www.w3.org/TR/html4/loose.dtd">
- <html>
- <head>
- <title>title>
- head>
- <body>
- <#--欢迎来到 Freemaker 首页-->
- <h3>取值h3>
- <p>提供默认值p>
- <#--当接受的参数值不为空,这个问题是需要避免的-->
- <#--${uname}-->
- ${uname ! "小王"}
-
- <h3>对null值先进行判断h3>
- <p>exists用在逻辑判断p>
- <#if uname?exists>
- ${uname}
- #if>
- <br>
-
- <p>??是判断对象是否为空p>
- <#if uname??>
- ${uname}
- #if>
- <br>
-
- <p>if_exists用来打印东西p>
- ${uname?if_exists}
- <br>
-
-
- <h3>2.条件h3>
- <#if sex=='nv'>
- 女
- <#elseif sex='nan'>
- 男
- <#else>
- 未知
- #if>
- <br>
-
-
- <h3>3.循环h3>
- <p>1)取出数组中的元素p>
- <#list arr as a>
- ${a}==
- #list>
- <br>
- <p>2)取出集合中的对象(注:访问的类要被public所修饰)p>
- <#list lst as item>
- ${item.id} : ${item.name} <br>
- #list>
-
- <h3>4 include指令h3>
- <#include "/common.ftl" >
-
- <h3>5 局部变量(assign)/全局变量(global)h3>
- ${ctx} :${ctx2}
-
- body>
- html>
- <#assign ctx>
- ${springMacroRequestContext.contextPath}
- #assign>
- <#global ctx2>
- ${springMacroRequestContext.contextPath}
- #global>
-
- mybatis:
- mapper-locations: classpath:mappers/*xml
- type-aliases-package: com.cdl.springboot04.mybatis.entity
- server:
- port: 8080
- servlet:
- context-path: /springboot04
- spring:
- application:
- name: springboot04
- datasource:
- driver-class-name: com.mysql.jdbc.Driver
- name: defaultDataSource
- password: 123456
- url: jdbc:mysql://localhost:3306/mysql?useUnicode=true&characterEncoding=UTF-8&useSSL=false
- username: root
- freemarker:
- cache: false
- charset: utf-8
- expose-request-attributes: true
- expose-session-attributes: true
- suffix: .ftl
- template-loader-path: classpath:/templates/
- # resources:
- # static-locations: classpath:/static/# 应用服务 WEB 访问端口
- mvc:
- static-path-pattern: classpath:/static/
利用Freemarker完成基本的增删改查,参照之前ssm项目进行改造
新建一个model 的包 将之前ssm项目中的Clazz类复制进来
- package com.cdl.springboot04.model;
-
-
- import com.sun.istack.internal.NotNull;
- import lombok.AllArgsConstructor;
- import lombok.Data;
- import lombok.NoArgsConstructor;
-
- /**
- * NotNull:针对的是基本数据类型
- * @NotEmpty 作用于集合
- * @NotBlank 作用于字符串
- */
- @Data
- @NoArgsConstructor
- @AllArgsConstructor
- public class Clazz {
- protected Integer cid;
-
- protected String cname;
-
- protected String cteacher;
-
- protected String pic;
-
-
- }
注意:扫描包的更改
- mybatis:
- mapper-locations: classpath:mappers/*xml
- type-aliases-package: com.cdl.springboot04.model
- server:
- port: 8080
- servlet:
- context-path: /springboot04
- spring:
- application:
- name: springboot04
- datasource:
- driver-class-name: com.mysql.jdbc.Driver
- name: defaultDataSource
- password: 123456
- url: jdbc:mysql://localhost:3306/mysql?useUnicode=true&characterEncoding=UTF-8&useSSL=false
- username: root
- freemarker:
- cache: false
- charset: utf-8
- expose-request-attributes: true
- expose-session-attributes: true
- suffix: .ftl
- template-loader-path: classpath:/templates/
- # resources:
- # static-locations: classpath:/static/# 应用服务 WEB 访问端口
- mvc:
- static-path-pattern: classpath:/static/
新建一个mapper的包 将对应的mapper复制进去
- package com.cdl.springboot04.mapper;
-
- import com.cdl.springboot04.model.Clazz;
- import org.springframework.stereotype.Repository;
-
- import java.util.List;
- import java.util.Map;
-
- @Repository
- public interface ClazzMapper {
- int deleteByPrimaryKey(Integer cid);
-
- int insert(Clazz record);
-
- int insertSelective(Clazz record);
-
- Clazz selectByPrimaryKey(Integer cid);
-
- List
listPager(Clazz clazz); -
- List
-
- int updateByPrimaryKeySelective(Clazz record);
-
- int updateByPrimaryKey(Clazz record);
- }
将mapper.xml的文件放入resources下的mapper中

- "1.0" encoding="UTF-8" ?>
- mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
- <mapper namespace="com.cdl.springboot04.mapper.ClazzMapper" >
- <resultMap id="BaseResultMap" type="com.cdl.springboot04.model.Clazz" >
- <constructor >
- <idArg column="cid" jdbcType="INTEGER" javaType="java.lang.Integer" />
- <arg column="cname" jdbcType="VARCHAR" javaType="java.lang.String" />
- <arg column="cteacher" jdbcType="VARCHAR" javaType="java.lang.String" />
- <arg column="pic" jdbcType="VARCHAR" javaType="java.lang.String" />
- constructor>
- resultMap>
- <sql id="Base_Column_List" >
- cid, cname, cteacher, pic
- sql>
- <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
- select
- <include refid="Base_Column_List" />
- from t_struts_class
- where cid = #{cid,jdbcType=INTEGER}
- select>
-
- <select id="listMapPager" resultType="java.util.Map" parameterType="Clazz" >
- select
- <include refid="Base_Column_List" />
- from t_struts_class
- <where>
- <if test="cname != null and cname != ''">
- and cname like CONCAT('%',#{cname},'%')
- if>
- <if test="cid != null and cid != ''">
- and cid = #{cid}
- if>
- where>
- select>
-
- <select id="listPager" resultType="com.cdl.springboot04.model.Clazz" parameterType="Clazz" >
- select
- <include refid="Base_Column_List" />
- from t_struts_class
- <where>
- <if test="cname != null and cname != ''">
- and cname like CONCAT('%',#{cname},'%')
- if>
- <if test="cid != null and cid != ''">
- and cid = #{cid}
- if>
- where>
- select>
-
- <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
- delete from t_struts_class
- where cid = #{cid,jdbcType=INTEGER}
- delete>
- <insert id="insert" parameterType="Clazz" >
- insert into t_struts_class (cid, cname, cteacher,
- pic)
- values (#{cid,jdbcType=INTEGER}, #{cname,jdbcType=VARCHAR}, #{cteacher,jdbcType=VARCHAR},
- #{pic,jdbcType=VARCHAR})
- insert>
- <insert id="insertSelective" parameterType="Clazz" >
- insert into t_struts_class
- <trim prefix="(" suffix=")" suffixOverrides="," >
- <if test="cid != null" >
- cid,
- if>
- <if test="cname != null" >
- cname,
- if>
- <if test="cteacher != null" >
- cteacher,
- if>
- <if test="pic != null" >
- pic,
- if>
- trim>
- <trim prefix="values (" suffix=")" suffixOverrides="," >
- <if test="cid != null" >
- #{cid,jdbcType=INTEGER},
- if>
- <if test="cname != null" >
- #{cname,jdbcType=VARCHAR},
- if>
- <if test="cteacher != null" >
- #{cteacher,jdbcType=VARCHAR},
- if>
- <if test="pic != null" >
- #{pic,jdbcType=VARCHAR},
- if>
- trim>
- insert>
- <update id="updateByPrimaryKeySelective" parameterType="Clazz" >
- update t_struts_class
- <set >
- <if test="cname != null" >
- cname = #{cname,jdbcType=VARCHAR},
- if>
- <if test="cteacher != null" >
- cteacher = #{cteacher,jdbcType=VARCHAR},
- if>
- <if test="pic != null" >
- pic = #{pic,jdbcType=VARCHAR},
- if>
- set>
- where cid = #{cid,jdbcType=INTEGER}
- update>
- <update id="updateByPrimaryKey" parameterType="Clazz" >
- update t_struts_class
- set cname = #{cname,jdbcType=VARCHAR},
- cteacher = #{cteacher,jdbcType=VARCHAR},
- pic = #{pic,jdbcType=VARCHAR}
- where cid = #{cid,jdbcType=INTEGER}
- update>
- mapper>
新建一个biz的包 放接口
- package com.cdl.springboot04.biz;
-
- import com.cdl.springboot04.model.Clazz;
- import com.cdl.springboot04.util.PageBean;
- import org.springframework.cache.annotation.CacheEvict;
- import org.springframework.cache.annotation.CachePut;
-
- import java.util.List;
- import java.util.Map;
-
- public interface ClazzBiz {
- int deleteByPrimaryKey(Integer cid);
-
- int insert(Clazz record);
-
- int insertSelective(Clazz record);
-
- Clazz selectByPrimaryKey(Integer cid);
-
- int updateByPrimaryKeySelective(Clazz record);
-
- int updateByPrimaryKey(Clazz record);
-
- List
listPager(Clazz clazz, PageBean pageBean); - List
- }
将对应的工具类拿过来
- package com.cdl.springboot04.util;
-
- import java.util.HashMap;
- import java.util.Map;
-
- import javax.servlet.http.HttpServletRequest;
-
- /**
- * 分页工具类
- *
- */
- public class PageBean {
-
- private int page = 1;// 页码
-
- private int rows = 10;// 页大小
-
- private int total = 0;// 总记录数
-
- private boolean pagination = true;// 是否分页
-
- private String url; //保存上一次请求的URL
-
- private Map
paramMap = new HashMap<>();// 保存上一次请求的参数 -
- /**
- * 初始化pagebean的,保存上一次请求的重要参数
- * @param req
- */
- public void setRequest(HttpServletRequest req) {
- // 1.1 需要保存上一次请求的URL
- this.setUrl(req.getRequestURL().toString());
- // 1.2 需要保存上一次请求的参数 bname、price
- this.setParamMap(req.getParameterMap());
- // 1.3 需要保存上一次请求的分页设置 pagination
- this.setPagination(req.getParameter("pagination"));
- // 1.4 需要保存上一次请求的展示条目数
- this.setRows(req.getParameter("rows"));
- // 1.5 初始化请求的页码 page
- this.setPage(req.getParameter("page"));
- }
-
- public void setPage(String page) {
- if(StringUtils.isNotBlank(page))
- this.setPage(Integer.valueOf(page));
- }
-
- public void setRows(String rows) {
- if(StringUtils.isNotBlank(rows))
- this.setRows(Integer.valueOf(rows));
- }
-
- public void setPagination(String pagination) {
- // 只有在前台jsp填写了pagination=false,才代表不分页
- if(StringUtils.isNotBlank(pagination))
- this.setPagination(!"false".equals(pagination));
- }
-
-
- public String getUrl() {
- return url;
- }
-
- public void setUrl(String url) {
- this.url = url;
- }
-
- public Map
getParamMap() { - return paramMap;
- }
-
- public void setParamMap(Map
paramMap) { - this.paramMap = paramMap;
- }
-
-
-
- public PageBean() {
- super();
- }
-
- public int getPage() {
- return page;
- }
-
- public void setPage(int page) {
- this.page = page;
- }
-
- public int getRows() {
- return rows;
- }
-
- public void setRows(int rows) {
- this.rows = rows;
- }
-
- public int getTotal() {
- return total;
- }
-
- public void setTotal(int total) {
- this.total = total;
- }
-
- public void setTotal(String total) {
- this.total = Integer.parseInt(total);
- }
-
- public boolean isPagination() {
- return pagination;
- }
-
- public void setPagination(boolean pagination) {
- this.pagination = pagination;
- }
-
- /**
- * 获得起始记录的下标
- *
- * @return
- */
- public int getStartIndex() {
- return (this.page - 1) * this.rows;
- }
-
- /**
- * 最大页
- * @return
- */
- public int maxPage() {
- // total % rows == 0 ? total / rows : total / rows +1
- return this.total % this.rows == 0 ? this.total / this.rows : this.total / this.rows + 1;
- }
-
- /**
- * 下一页
- * @return
- */
- public int nextPage() {
- // 如果当前页小于最大页,那就下一页为当前页+1;如果不小于,说明当前页就是最大页,那就无需+1
- return this.page < this.maxPage() ? this.page + 1 : this.page;
- }
-
- /**
- * 上一页
- * @return
- */
- public int previousPage() {
- return this.page > 1 ? this.page - 1 : this.page;
- }
-
- @Override
- public String toString() {
- return "PageBean [page=" + page + ", rows=" + rows + ", total=" + total + ", pagination=" + pagination + "]";
- }
-
- }
- package com.cdl.springboot04.util;
-
- public class StringUtils {
- // 私有的构造方法,保护此类不能在外部实例化
- private StringUtils() {
- }
-
- /**
- * 如果字符串等于null或去空格后等于"",则返回true,否则返回false
- *
- * @param s
- * @return
- */
- public static boolean isBlank(String s) {
- boolean b = false;
- if (null == s || s.trim().equals("")) {
- b = true;
- }
- return b;
- }
-
- /**
- * 如果字符串不等于null或去空格后不等于"",则返回true,否则返回false
- *
- * @param s
- * @return
- */
- public static boolean isNotBlank(String s) {
- return !isBlank(s);
- }
-
- }
对应接口的实现类

- package com.cdl.springboot04.biz.impl;
-
- import com.cdl.springboot04.biz.ClazzBiz;
- import com.cdl.springboot04.mapper.ClazzMapper;
- import com.cdl.springboot04.model.Clazz;
- import com.cdl.springboot04.util.PageBean;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.stereotype.Service;
-
- import java.util.List;
- import java.util.Map;
-
- /**
- * @author小李飞刀
- * @site www.javaxl.com
- * @company xxx公司
- * @create 2022-08-17 15:13
- */
- @Service
- public class ClazzBizImpl implements ClazzBiz {
- @Autowired
- private ClazzMapper clazzMapper;
- @Override
- public int deleteByPrimaryKey(Integer cid) {
- // System.out.println("不做任何操作...");
- return clazzMapper.deleteByPrimaryKey(cid);
- // return 0;
- }
-
- @Override
- public int insert(Clazz record) {
- return clazzMapper.insert(record);
- }
-
- @Override
- public int insertSelective(Clazz record) {
- return clazzMapper.insertSelective(record);
- }
-
- @Override
- public Clazz selectByPrimaryKey(Integer cid) {
- return clazzMapper.selectByPrimaryKey(cid);
- }
-
- @Override
- public int updateByPrimaryKeySelective(Clazz record) {
- return clazzMapper.updateByPrimaryKeySelective(record);
- }
-
- @Override
- public int updateByPrimaryKey(Clazz record) {
- return clazzMapper.updateByPrimaryKey(record);
- }
-
- @Override
- public List
listPager(Clazz clazz, PageBean pageBean) { - return clazzMapper.listPager(clazz);
- }
-
- @Override
- public List
- if(true)
- throw new RuntimeException("查询班级信息异常,异常存在于ClazzBizImpl.list。。。。");
- return clazzMapper.listMapPager(clazz);
- }
- }
导入所需要的pom依赖
-
- <dependency>
- <groupId>org.springframeworkgroupId>
- <artifactId>spring-aspectsartifactId>
- <version>5.0.2.RELEASEversion>
- dependency>
-
- <dependency>
- <groupId>com.github.pagehelpergroupId>
- <artifactId>pagehelper-spring-boot-starterartifactId>
- <version>1.2.3version>
- dependency>
- package com.cdl.springboot04.aspect;
-
- import com.cdl.springboot04.util.PageBean;
- import com.github.pagehelper.PageHelper;
- import com.github.pagehelper.PageInfo;
- import org.aspectj.lang.ProceedingJoinPoint;
- import org.aspectj.lang.annotation.Around;
- import org.aspectj.lang.annotation.Aspect;
- import org.springframework.stereotype.Component;
-
- import java.util.List;
-
- /**
- * @author小李飞刀
- * @site www.javaxl.com
- * @company xxx公司
- * @create 2022-08-12 16:32
- */
- @Component
- @Aspect
- public class PagerAspect {
-
- /**
- * *:返回值类型
- * *..:无限包
- * *Service:以Service结尾接口名
- * *Pager:以Pager方法
- * 只要同时匹配上诉四个条件,就会被列为目标对象
- * 上述配置要生效,代理注解
不能少 - * @param args
- * @return
- * @throws Throwable
- */
- @Around("execution(* *..*Biz.*Pager(..))")
- public Object invoke(ProceedingJoinPoint args) throws Throwable {
- Object[] params = args.getArgs();
- PageBean pageBean = null;
- for (Object param : params) {
- if(param instanceof PageBean){
- pageBean = (PageBean)param;
- break;
- }
- }
-
- if(pageBean != null && pageBean.isPagination())
- PageHelper.startPage(pageBean.getPage(),pageBean.getRows());
-
- // 执行目标方法
- Object list = args.proceed(params);
-
- if(null != pageBean && pageBean.isPagination()){
- PageInfo pageInfo = new PageInfo((List) list);
- pageBean.setTotal(pageInfo.getTotal()+"");
- }
- return list;
- }
-
-
- }
application.yml中添加该配置
pagehelper:
reasonable: true
supportMethodsArguments: true
page-size-zero: true
helper-dialect: mysql
- mybatis:
- mapper-locations: classpath:mappers/*xml
- type-aliases-package: com.cdl.springboot04.model
- server:
- port: 8080
- servlet:
- context-path: /springboot04
- spring:
- application:
- name: springboot04
- datasource:
- driver-class-name: com.mysql.jdbc.Driver
- name: defaultDataSource
- password: 123456
- url: jdbc:mysql://localhost:3306/mysql?useUnicode=true&characterEncoding=UTF-8&useSSL=false
- username: root
- freemarker:
- cache: false
- charset: utf-8
- expose-request-attributes: true
- expose-session-attributes: true
- suffix: .ftl
- template-loader-path: classpath:/templates/
- # resources:
- # static-locations: classpath:/static/# 应用服务 WEB 访问端口
- mvc:
- static-path-pattern: classpath:/static/
- pagehelper:
- reasonable: true
- supportMethodsArguments: true
- page-size-zero: true
- helper-dialect: mysql
此时就具备了分页的功能

将对应的clzList.jsp和clzEdit.jsp复制放入clz里面 参考得出clzList.ftl和clzEdit.ftl
clzList.jsp
- <%@ page language="java" contentType="text/html; charset=UTF-8"
- pageEncoding="UTF-8"%>
- <%@ taglib uri="http://jsp.veryedu.cn" prefix="z"%>
- <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
- 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">
- <link
- href="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.5.0/css/bootstrap.css"
- rel="stylesheet">
- <script
- src="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.5.0/js/bootstrap.js">script>
- <title>博客列表title>
- <style type="text/css">
- .page-item input {
- padding: 0;
- width: 40px;
- height: 100%;
- text-align: center;
- margin: 0 6px;
- }
-
- .page-item input, .page-item b {
- line-height: 38px;
- float: left;
- font-weight: 400;
- }
-
- .page-item.go-input {
- margin: 0 10px;
- }
- style>
- head>
- <body>
- <form class="form-inline"
- action="${pageContext.request.contextPath }/clz/list" method="post">
- <div class="form-group mb-2">
- <input type="text" class="form-control-plaintext" name="cname"
- placeholder="请输入班级名称">
- div>
- <button type="submit" class="btn btn-primary mb-2">查询button>
- <a class="btn btn-primary mb-2" href="${pageContext.request.contextPath }/clz/toEdit">新增a>
- form>
-
- <table class="table table-striped bg-success">
- <thead>
- <tr>
- <th scope="col">IDth>
- <th scope="col">班级名称th>
- <th scope="col">指导老师th>
- <th scope="col">班级相册th>
- <th scope="col">操作th>
- tr>
- thead>
- <tbody>
- <c:forEach var="b" items="${lst }">
- <tr>
- <td>${b.cid }td>
- <td>${b.cname }td>
- <td>${b.cteacher }td>
- <td>
- <img src="${pageContext.request.contextPath }${b.pic }" style="height: 100px;width: 100px;" />
- td>
- <td>
- <a href="${pageContext.request.contextPath }/clz/toEdit?cid=${b.cid}">修改a>
- <a href="${pageContext.request.contextPath }/clz/del?cid=${b.cid}">删除a>
- <a href="${pageContext.request.contextPath }/clzUpload.jsp?cid=${b.cid}">上传图片a>
- <a href="${pageContext.request.contextPath }/clz/download?cid=${b.cid}">下载图片a>
- td>
- tr>
- c:forEach>
- tbody>
- table>
- <z:page pageBean="${pageBean }">z:page>
-
- body>
- html>
clzEdit.jsp
- <%@ page language="java" contentType="text/html; charset=UTF-8"
- pageEncoding="UTF-8"%>
- 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>
- head>
- <body>
- <%--<form action="${pageContext.request.contextPath }/clz/${empty b ? 'add' : 'edit'}" method="post">--%>
- <form action="${pageContext.request.contextPath }/clz/${empty b ? 'valiAdd' : 'edit'}" method="post">
- cid:<input type="text" name="cid" value="${b.cid }"><span style="color: red;">${msg.cid}span><br>
- cname:<input type="text" name="cname" value="${b.cname }"><span style="color: red;">${msg.cname}span><br>
- cteacher:<input type="text" name="cteacher" value="${b.cteacher }"><span style="color: red;">${msg.cteacher}span><br>
- <input type="submit">
- form>
- body>
- html>
- html>
- <html lang="en">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
- <link
- href="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.5.0/css/bootstrap.css"
- rel="stylesheet">
- <script
- src="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.5.0/js/bootstrap.js">script>
- <title>班级列表title>
- <style type="text/css">
- .page-item input {
- padding: 0;
- width: 40px;
- height: 100%;
- text-align: center;
- margin: 0 6px;
- }
-
- .page-item input, .page-item b {
- line-height: 38px;
- float: left;
- font-weight: 400;
- }
-
- .page-item.go-input {
- margin: 0 10px;
- }
- style>
- head>
- <body>
- <#include "/common.ftl">
- <#--查询的条件框-->
- <form class="form-inline"
- action="${ctx }/clz/list" method="post">
- <div class="form-group mb-2">
- <input type="text" class="form-control-plaintext" name="cname"
- placeholder="请输入班级名称">
- div>
- <button type="submit" class="btn btn-primary mb-2">查询button>
- <a class="btn btn-primary mb-2" href="${ctx }/clz/toEdit">新增a>
- form>
- <#--数据展示表格-->
- <table class="table table-striped bg-success">
- <thead>
- <tr>
- <th scope="col">IDth>
- <th scope="col">班级名称th>
- <th scope="col">指导老师th>
- <th scope="col">操作th>
- tr>
- thead>
- <tbody>
- <#list lst as b>
- <tr>
- <td>${b.cid !}td>
- <td>${b.cname !}td>
- <td>${b.cteacher !}td>
- <td>
- <a href="${ctx }/clz/toEdit?cid=${b.cid}">修改a>
- <a href="${ctx }/clz/del?cid=${b.cid}">删除a>
- td>
- tr>
- #list>
- tbody>
- table>
- <#--jsp是借助助手类,而这里是Freemarker,没有jsp相关依赖-->
- ${pagestr !}
- body>
- html>
- html>
- <html lang="en">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
- <title>班级的编辑界面title>
- head>
- <body>
- <#include "/common.ftl">
- <#if b??>
- <#--修改-->
- <form action="${ctx }/clz/edit" method="post">
- cid:<input type="text" name="cid" value="${b.cid !}"><br>
- cname:<input type="text" name="cname" value="${b.cname !}"><br>
- cteacher:<input type="text" name="cteacher" value="${b.cteacher !}"><br>
- <input type="submit">
- form>
- <#else>
- <#--新增-->
- <form action="${ctx }/clz/add" method="post">
- cid:<input type="text" name="cid" value=""><br>
- cname:<input type="text" name="cname" value=""><br>
- cteacher:<input type="text" name="cteacher" value=""><br>
- <input type="submit">
- form>
- #if>
- body>
- html>
因为新建了clz的包,所以业务逻辑层要修改
- package com.cdl.springboot04.controller;
-
- import com.cdl.springboot04.biz.ClazzBiz;
- import com.cdl.springboot04.model.Clazz;
- import com.cdl.springboot04.util.PageBean;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.stereotype.Controller;
- import org.springframework.validation.BindingResult;
- import org.springframework.validation.FieldError;
- import org.springframework.web.bind.annotation.RequestMapping;
-
- import javax.servlet.http.HttpServletRequest;
- import java.util.HashMap;
- import java.util.List;
- import java.util.Map;
-
- /**
- * @author小李飞刀
- * @site www.javaxl.com
- * @company xxx公司
- * @create 2022-08-17 15:23
- */
- @Controller
- @RequestMapping("/clz")
- public class ClazzController {
- @Autowired
- private ClazzBiz clazzBiz;
- // list->clzList
- // toList->重定向list->"redirect:/clz/list"
- // toEdit->跳转到编辑界面->clzEdit
- // Clazz : 以前是通过模型驱动接口封装,现在是直接在方法中接受参数即可
- @RequestMapping("/list")
- public String list(Clazz clazz, HttpServletRequest request){
- System.out.println("我添加了 新的代码,终于不重启了....");
- PageBean pageBean = new PageBean();
- pageBean.setRequest(request);
- List
lst = this.clazzBiz.listPager(clazz, pageBean); - request.setAttribute("lst",lst);
- request.setAttribute("pageBean",pageBean);
- return "clz/clzList";
- }
-
- @RequestMapping("/toEdit")
- public String toEdit(Clazz clazz, HttpServletRequest request){
- Integer cid = clazz.getCid();
- // 传递的id代表了修改,没传代表新增
- if(cid != null){
- List
lst = this.clazzBiz.listPager(clazz, null); - request.setAttribute("b",lst.get(0));
- }
- return "clz/clzEdit";
- }
-
- @RequestMapping("/add")
- public String add(Clazz clazz){
- this.clazzBiz.insertSelective(clazz);
- return "redirect:/clz/list";
- }
-
-
- @RequestMapping("/edit")
- public String edit(Clazz clazz){
- this.clazzBiz.updateByPrimaryKeySelective(clazz);
- return "redirect:/clz/list";
- }
-
- @RequestMapping("/del")
- public String del(Clazz clazz){
- this.clazzBiz.deleteByPrimaryKey(clazz.getCid());
- return "redirect:/clz/list";
- }
-
-
- }
测试一波:
运行后台启动报错

因为启动类没有开启扫描
- package com.cdl.springboot04;
-
- import org.mybatis.spring.annotation.MapperScan;
- import org.springframework.boot.SpringApplication;
- import org.springframework.boot.autoconfigure.SpringBootApplication;
-
- @MapperScan("com.cdl.springboot04.mapper")//扫描
- @EnableTransactionManagement//开启事务
- @SpringBootApplication
- public class Springboot04Application {
-
- public static void main(String[] args) {
-
- SpringApplication.run(Springboot04Application.class, args);
- }
-
- }
后台启动成功

前端页面访问成功

模糊查询

添加进application.yml
logging: level: com.cdl.springboot04: debug
- mybatis:
- mapper-locations: classpath:mappers/*xml
- type-aliases-package: com.cdl.springboot04.model
- server:
- port: 8080
- servlet:
- context-path: /springboot04
- spring:
- application:
- name: springboot04
- datasource:
- driver-class-name: com.mysql.jdbc.Driver
- name: defaultDataSource
- password: 123456
- url: jdbc:mysql://localhost:3306/mysql?useUnicode=true&characterEncoding=UTF-8&useSSL=false
- username: root
- freemarker:
- cache: false
- charset: utf-8
- expose-request-attributes: true
- expose-session-attributes: true
- suffix: .ftl
- template-loader-path: classpath:/templates/
- # resources:
- # static-locations: classpath:/static/# 应用服务 WEB 访问端口
- mvc:
- static-path-pattern: classpath:/static/
- pagehelper:
- reasonable: true
- supportMethodsArguments: true
- page-size-zero: true
- helper-dialect: mysql
- logging:
- level:
- com.cdl.springboot04: debug
删除

删除成功

新增

新增成功

修改

修改成功

新建一个分页的工具类
- package com.cdl.springboot04.util;
-
- import java.util.Map;
- import java.util.Map.Entry;
- import java.util.Set;
-
- /**
- * @author cdl
- * @site www.cdl.com
- * @create 2022-11-02 1:25
- */
- public class FreemarkerPageHelper {
-
- public static String toHTML(PageBean pageBean) {
- StringBuffer sb = new StringBuffer();
- // 隐藏的form表单---这个就是上一次请求下次重新发的奥义所在
- // 上一次请求的URL
- sb.append(");
- sb.append(" ");
- // 上一次请求的参数
- Map
paramMap = pageBean.getParamMap(); - if(paramMap != null && paramMap.size() > 0) {
- Set
> entrySet = paramMap.entrySet(); - for (Entry
entry : entrySet) { - // 参数名
- String key = entry.getKey();
- // 参数值
- for (String value : entry.getValue()) {
- // 上一次请求的参数,再一次组装成了新的Form表单
- // 注意:page参数每次都会提交,我们需要避免
- if(!"page".equals(key)) {
- sb.append(" ");
- }
- }
- }
- }
- sb.append("");
-
- // 分页条
- sb.append("
"
); - sb.append("
- );
- sb.append(" href='javascript:gotoPage(1)'>首页");
- sb.append("
- );
- sb.append(" href='javascript:gotoPage("+pageBean.previousPage()+")'><");// less than 小于号
- // sb.append("
- 1
"); - // sb.append("
- 2
"); - sb.append("
- "
+pageBean.getPage()+""); - sb.append("
- >
"); - sb.append("
- 尾页
"); - sb.append("
- 到第);
- sb.append(" type='text' id='skipPage' name='' />页");
- sb.append("
- );
- sb.append(" href='javascript:skipPage()'>确定");
- sb.append("
- 共"
+pageBean.getTotal()+"条"); - sb.append("");
-
- // 分页执行的JS代码
- sb.append("");
-
- return sb.toString();
- }
-
- }
添加使用分页工具类的代码
- package com.cdl.springboot04.controller;
-
- import com.cdl.springboot04.biz.ClazzBiz;
- import com.cdl.springboot04.model.Clazz;
- import com.cdl.springboot04.util.FreemarkerPageHelper;
- import com.cdl.springboot04.util.PageBean;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.stereotype.Controller;
- import org.springframework.validation.BindingResult;
- import org.springframework.validation.FieldError;
- import org.springframework.web.bind.annotation.RequestMapping;
-
- import javax.servlet.http.HttpServletRequest;
- import java.util.HashMap;
- import java.util.List;
- import java.util.Map;
-
- /**
- * @author小李飞刀
- * @site www.javaxl.com
- * @company xxx公司
- * @create 2022-08-17 15:23
- */
- @Controller
- @RequestMapping("/clz")
- public class ClazzController {
- @Autowired
- private ClazzBiz clazzBiz;
- // list->clzList
- // toList->重定向list->"redirect:/clz/list"
- // toEdit->跳转到编辑界面->clzEdit
- // Clazz : 以前是通过模型驱动接口封装,现在是直接在方法中接受参数即可
- @RequestMapping("/list")
- public String list(Clazz clazz, HttpServletRequest request){
- System.out.println("我添加了 新的代码,终于不重启了....");
- PageBean pageBean = new PageBean();
- pageBean.setRequest(request);
- List
lst = this.clazzBiz.listPager(clazz, pageBean); - request.setAttribute("lst",lst);
- request.setAttribute("pageBean",pageBean);
- //分页
- request.setAttribute("pagestr", FreemarkerPageHelper.toHTML(pageBean));
- return "clz/clzList";
- }
-
- @RequestMapping("/toEdit")
- public String toEdit(Clazz clazz, HttpServletRequest request){
- Integer cid = clazz.getCid();
- // 传递的id代表了修改,没传代表新增
- if(cid != null){
- List
lst = this.clazzBiz.listPager(clazz, null); - request.setAttribute("b",lst.get(0));
- }
- return "clz/clzEdit";
- }
-
- @RequestMapping("/add")
- public String add(Clazz clazz){
- this.clazzBiz.insertSelective(clazz);
- return "redirect:/clz/list";
- }
-
-
- @RequestMapping("/edit")
- public String edit(Clazz clazz){
- this.clazzBiz.updateByPrimaryKeySelective(clazz);
- return "redirect:/clz/list";
- }
-
- @RequestMapping("/del")
- public String del(Clazz clazz){
- this.clazzBiz.deleteByPrimaryKey(clazz.getCid());
- return "redirect:/clz/list";
- }
-
-
- }
成功


注意:
