1.Freemarker简介及入门

1.1.学习网址

http://freemarker.foofun.cn/

1.2.创建模块spboot04

1.3.application.yml中添加内容

mybatis:
  mapper-locations: classpath:mappers/**/*.xml
  type-aliases-package: com.zjzaki.spboot04.entity
logging:
  level:
    com.zjzaki.spboot04: debug
server:
  port: 8080
spring:
  application:
    name: spboot04
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    name: defaultDataSource
    url: jdbc:mysql://localhost:3306/ssm?useUnicode=true&characterEncoding=UTF-8
    username: root
    password: 123456
  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/**

1.4.添加ftl文件模板

1.5.在templates下新建index.ftl

index.ftl

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title></title>
</head>
<body>
  这是一个测试页面
</body>
</html>

1.6.在controller包下面新建IndexController

package com.zjzaki.spboot04.controller;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;

/**
 * @Author zjzaki
 * @Package com.zjzaki.spboot04.controller
 * @Date 2023-08-09 18:42:29
 */
@Controller
public class IndexController {

    @GetMapping("/")
    public String index(){
        return "index";
    }
}

1.7.启动项目

访问页面, 成功访问

2.Freemarker语法

2.1.templates下创建common.ftl

<#assign ctx>
    ${springMacroRequestContext.contextPath}
</#assign>
<#global ctx2>
    ${springMacroRequestContext.contextPath}
</#global>

2.2.修改index.ftl中的内容

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title></title>
</head>
<body>
    <h1>1.取值</h1>
    <h2>1.1. 提供默认值</h2>
        <#--报错-->
        <#--${uname}    -->
        <#--不报错，但是页面无内容-->
        <#--${uname !}-->
        <#--给值设置一个默认值-->
        ${uname! '无名'}

    <h2>1.2. 对null值先进行判断</h2>
    <p>1）exists用在逻辑判断；</p>
    <#if uname?exists>
        ${uname}
    </#if>
    <br>
    <p>2）??是判断对象是否为空</p>
    <#if uname??>
        ${uname}
    </#if>
    <br>
    <p>3）if_exists用来打印东西</p>
    ${uname?if_exists}
    <br>

    <h1>2.条件</h1>
    <#if sex=='nv'>
        女
    <#elseif sex='nan'>
        男
    <#else>
        未知
    </#if>
    <br>

    <h1>3.循环</h1>
    <p>1）取出数组中的元素</p>
    <#list arr as a>
        ${a}==
    </#list>
    <br>
    <p>2）取出集合中的对象（注：访问的类要被public所修饰）</p>
    <#list lst as item>
        ${item.id} : ${item.name}    <br>
    </#list>

    <h1>4 include</h1>
    <#include "/common.ftl" >

    <h2>5 局部变量(assign)/全局变量(global)</h2>
    ${ctx}：${ctx2}
</body>
</html>

2.3.新建entity包,并创建User实体类

package com.zjzaki.spboot04.entity;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

/**
 * @Author zjzaki
 * @Package com.zjzaki.spboot04.entity
 * @Date 2023-08-09 18:54:34
 */
@Data
@NoArgsConstructor
@AllArgsConstructor
public class User {

    /**
     * 用户编号
     */
    private Integer id;

    /**
     * 用户姓名
     */
    private String name;
}

2.4.IndexController中添加内容

package com.zjzaki.spboot04.controller;

import com.zjzaki.spboot04.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 zjzaki
 * @Package com.zjzaki.spboot04.controller
 * @Date 2023-08-09 18:42:29
 */
@Controller
public class IndexController {

    @GetMapping("/")
    public String index(Model model){

        System.out.println("come in............");
        model.addAttribute("uname", "小刘");
        model.addAttribute("sex", "girl");
        List<User> 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";
    }
}

2.5.重启项目

效果

3.Freemarker综合案例

3.1.创建表

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_struts_class
-- ----------------------------
DROP TABLE IF EXISTS `t_struts_class`;
CREATE TABLE `t_struts_class` (
  `cid` int(11) NOT NULL,
  `cname` varchar(255) DEFAULT NULL,
  `cteacher` varchar(255) DEFAULT NULL,
  `pic` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for t_struts_student
-- ----------------------------
DROP TABLE IF EXISTS `t_struts_student`;
CREATE TABLE `t_struts_student` (
  `sid` int(11) NOT NULL,
  `cid` int(11) NOT NULL,
  `sname` varchar(255) NOT NULL,
  `spin` varchar(255) DEFAULT NULL,
  `sex` varchar(4) DEFAULT NULL,
  `mark` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `t_struts_class` VALUES ('1', 't211', '晓', '/upload/1.png');
INSERT INTO `t_struts_class` VALUES ('2', 't212', '晓1', '/upload/9.png');
INSERT INTO `t_struts_class` VALUES ('3', 't216', '晓', '/upload/3.png');
INSERT INTO `t_struts_class` VALUES ('4', 't207', '宇7', '/upload/4.png');
INSERT INTO `t_struts_class` VALUES ('5', 't209', '宇', '/upload/7.png');
INSERT INTO `t_struts_student` VALUES ('1', '1', '尹超', 'yinchao', '1', '1,3');
INSERT INTO `t_struts_student` VALUES ('4', '2', '老邓头', 'laodengtou', '2', '1,2,3');
INSERT INTO `t_struts_student` VALUES ('5', '2', '测试', 'ceshi', '2', 'mark');
INSERT INTO `t_struts_student` VALUES ('7', '1', '桃子23', 'TZ23', '女', '23');
INSERT INTO `t_struts_student` VALUES ('8', '1', '桃子21', 'TZ21', '女', '21');
INSERT INTO `t_struts_student` VALUES ('11', '1', '超', 'C', '女', '34');
INSERT INTO `t_struts_student` VALUES ('12', '2', '12', '12', '男', '12');

3.2.pom.xml中添加内容

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-aspects</artifactId>
    <version>5.0.2.RELEASE</version>
</dependency>
    
<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper-spring-boot-starter</artifactId>
    <version>1.2.3</version>
</dependency>

3.3.application.yml中添加内容

pagehelper:
  reasonable: true
  supportMethodsArguments: true
  page-size-zero: true
  helper-dialect: mysql

3.4.entity中添加Clazz实体类

package com.zjzaki.spboot04.entity;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

/**
 * @Author zjzaki
 * @Package com.zjzaki.spboot04.entity
 * @Date 2023-08-09 19:11:55
 */
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Clazz {

    private Integer cid;

    private String cname;

    private String cteacher;

    private String pic;
}

3.5.mapper包中添加ClazzMapper

package com.zjzaki.spboot04.mapper;

import com.zjzaki.spboot04.entity.Clazz;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

/**
 * @Author zjzaki
 * @Package com.zjzaki.spboot04.mapper
 * @Date 2023-08-09 19:14:14
 */
@Repository
public interface ClazzMapper {

    int deleteByPrimaryKey(Integer cid);

    int insert(Clazz record);

    int insertSelective(Clazz record);

    Clazz selectByPrimaryKey(Integer cid);

    List<Clazz> listPager(Clazz clazz);

    List<Map> listMapPager(Clazz clazz);

    int updateByPrimaryKeySelective(Clazz record);

    int updateByPrimaryKey(Clazz record);
}

3.6.在resources中的mappers添加ClazzMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.zjzaki.spboot04.mapper.ClazzMapper" >
    <resultMap id="BaseResultMap" type="com.zjzaki.spboot04.entity.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="com.zjzaki.spboot04.entity.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="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>

3.6.新建utils包, 添加PageBean和StringUtils

pageBean

package com.zjzaki.spboot04.utils;

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<String,String[]> 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<String, String[]> getParamMap() {
    return paramMap;
  }

  public void setParamMap(Map<String, String[]> 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 + "]";
  }

}

StringUtils

package com.zjzaki.spboot04.utils;

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);
  }

}

3.7.biz包下新建ClazzBiz接口

package com.zjzaki.spboot04.biz;

import com.zjzaki.spboot04.entity.Clazz;
import com.zjzaki.spboot04.utils.PageBean;

import java.util.List;
import java.util.Map;

/**
 * @Author zjzaki
 * @Package com.zjzaki.spboot04.biz
 * @Date 2023-08-09 19:22:35
 */
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<Clazz> listPager(Clazz clazz, PageBean pageBean);
    List<Map> listMapPager(Clazz clazz, PageBean pageBean);
}

3.8.biz包下新建impl包,创建ClazzBizImpl

package com.zjzaki.spboot04.biz.impl;

import com.zjzaki.spboot04.biz.ClazzBiz;
import com.zjzaki.spboot04.entity.Clazz;
import com.zjzaki.spboot04.mapper.ClazzMapper;
import com.zjzaki.spboot04.utils.PageBean;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
import java.util.Map;

/**
 * @Author zjzaki
 * @Package com.zjzaki.spboot04.biz.impl
 * @Date 2023-08-09 19:25:55
 */
@Service
public class ClazzBizImpl implements ClazzBiz {
    @Autowired
    private ClazzMapper clazzMapper;

    @Override
    public int deleteByPrimaryKey(Integer cid) {
        System.out.println("不做任何操作...");
        return clazzMapper.deleteByPrimaryKey(cid);
    }

    @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<Clazz> listPager(Clazz clazz, PageBean pageBean) {
        return clazzMapper.listPager(clazz);
    }

    @Override
    public List<Map> listMapPager(Clazz clazz, PageBean pageBean) {
        if (true)
            throw new RuntimeException("查询班级信息异常，异常存在于ClazzBizImpl.list。。。。");
        return clazzMapper.listMapPager(clazz);
    }
}

3.9.controller包中添加ClazzController

package com.zjzaki.spboot04.controller;

import com.zjzaki.spboot04.biz.ClazzBiz;
import com.zjzaki.spboot04.entity.Clazz;
import com.zjzaki.spboot04.utils.PageBean;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import javax.servlet.http.HttpServletRequest;
import java.util.List;

/**
 * @Author zjzaki
 * @Package com.zjzaki.spboot04.controller
 * @Date 2023-08-09 19:28:09
 */
@Controller
@RequestMapping("/clz")
public class ClazzController {

    @Autowired
    private ClazzBiz clazzBiz;

    @RequestMapping("/list")
    public String list(Clazz clazz, HttpServletRequest request) {
        System.out.println("我添加了 新的代码,终于不重启了....");
        PageBean pageBean = new PageBean();
        pageBean.setRequest(request);
        List<Clazz> lst = this.clazzBiz.listPager(clazz, pageBean);

        String pagestr = PageFreemarker.toHTML(pageBean);
        request.setAttribute("lst", lst);
        request.setAttribute("pageBean", pageBean);
        request.setAttribute("pagestr", pagestr);
        return "clz/clzList";
    }

    @RequestMapping("/toEdit")
    public String toEdit(Clazz clazz, HttpServletRequest request) {
        Integer cid = clazz.getCid();
        //传递的id代表了修改，没传代表新增
        if (cid != null) {
            List<Clazz> 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";
    }
}

3.10.utils中添加PageFreemarker

package com.zjzaki.spboot04.utils;

import java.util.Map;
import java.util.Map.Entry;
import java.util.Set;

/**
 * @Author zjzaki
 * @Package com.zjzaki.spboot04.utils
 * @Date 2023-08-09 19:29:45
 */
public class PageFreemarker {

    public static String toHTML(PageBean pageBean) {
        StringBuffer sb = new StringBuffer();
        //隐藏的form表单---这个就是上一次请求下次重新发的奥义所在
        //上一次请求的URL
        sb.append("<form action='" + pageBean.getUrl() + "' id='pageBeanForm' method='post'>");
        sb.append(" <input type='hidden' name='page'>");
        //上一次请求的参数
        Map<String, String[]> paramMap = pageBean.getParamMap();
        if (paramMap != null && paramMap.size() > 0) {
            Set<Entry<String, String[]>> entrySet = paramMap.entrySet();
            for (Entry<String, String[]> entry : entrySet) {
                //参数名
                String key = entry.getKey();
                //参数值
                for (String value : entry.getValue()) {
                    //上一次请求的参数，再一次组装成了新的Form表单
                    //注意：page参数每次都会提交，我们需要避免
                    if (!"page".equals(key)) {
                        sb.append(" <input type='hidden' name='" + key + "' value='" + value + "' >");
                    }
                }
            }
        }
        sb.append("</form>");

        //分页条
        sb.append("<ul class='pagination justify-content-center'>");
        sb.append(" <li class='page-item " + (pageBean.getPage() == 1 ? "disabled" : "") + "'><a class='page-link'");
        sb.append(" href='javascript:gotoPage(1)'>首页</a></li>");
        sb.append(" <li class='page-item " + (pageBean.getPage() == 1 ? "disabled" : "") + "'><a class='page-link'");
        sb.append(" href='javascript:gotoPage(" + pageBean.previousPage() + ")'>&lt;</a></li>");// less than 小于号
        //sb.append(" <li class='page-item'><a class='page-link' href='#'>1</a></li>");
        //sb.append(" <li class='page-item'><a class='page-link' href='#'>2</a></li>");
        sb.append(" <li class='page-item active'><a class='page-link' href='#'>" + pageBean.getPage() + "</a></li>");
        sb.append(" <li class='page-item " + (pageBean.getPage() == pageBean.maxPage() ? "disabled" : "") + "'><a class='page-link' href='javascript:gotoPage(" + pageBean.nextPage() + ")'>&gt;</a></li>");
        sb.append(" <li class='page-item " + (pageBean.getPage() == pageBean.maxPage() ? "disabled" : "") + "'><a class='page-link' href='javascript:gotoPage(" + pageBean.maxPage() + ")'>尾页</a></li>");
        sb.append(" <li class='page-item go-input'><b>到第</b><input class='page-link'");
        sb.append(" type='text' id='skipPage' name='' /><b>页</b></li>");
        sb.append(" <li class='page-item go'><a class='page-link'");
        sb.append(" href='javascript:skipPage()'>确定</a></li>");
        sb.append(" <li class='page-item'><b>共" + pageBean.getTotal() + "条</b></li>");
        sb.append("</ul>");

        //分页执行的JS代码
        sb.append("<script type='text/javascript'>");
        sb.append(" function gotoPage(page) {");
        sb.append("   document.getElementById('pageBeanForm').page.value = page;");
        sb.append("   document.getElementById('pageBeanForm').submit();");
        sb.append(" }");
        sb.append(" function skipPage() {");
        sb.append("   var page = document.getElementById('skipPage').value;");
        sb.append("   if (!page || isNaN(page) || parseInt(page) < 1 || parseInt(page) > " + pageBean.maxPage() + ") {");
        sb.append("     alert('请输入1~" + pageBean.maxPage() + "的数字');");
        sb.append("     return;");
        sb.append("   }");
        sb.append("   gotoPage(page);");
        sb.append(" }");
        sb.append("</script>");

        return sb.toString();
    }
}

3.11.新建aspect包,在aspect包下添加PagerAspect

package com.zjzaki.spboot04.aspect;

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.zjzaki.spboot04.utils.PageBean;
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 zjzaki
 * @Package com.zjzaki.spboot04.aspect
 * @Date 2023-08-09 19:34:53
 */
@Component
@Aspect
public class PagerAspect {
    /**
     * *：返回值类型
     * *..：无限包
     * *Service：以Service结尾接口名
     * *Pager：以Pager方法
     * 只要同时匹配上诉四个条件，就会被列为目标对象
     * 上述配置要生效，代理注解<aop:aspectj-autoproxy/>不能少
     *
     * @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.isPaginatio())
            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;
    }
}

3.12.templates中添加clz目录,并添加clzList.ftl

<!DOCTYPE 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">ID</th>
        <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>

3.13.添加clzEdit.ftl

<!DOCTYPE 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>

3.14.application.xml

#新增内容
server:
  port: 8080
  servlet:
    context-path: /spboot04

3.15.修改Spboot04Application

package com.zjzaki.spboot04;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@MapperScan("com.zjzaki.spboot04.mapper")
@SpringBootApplication
public class Spboot04Application {

    public static void main(String[] args) {
        SpringApplication.run(Spboot04Application.class, args);
    }
}

4.springboot视图渲染技术

1.Freemarker简介及入门

1.1.学习网址

1.2.创建模块spboot04

1.3.application.yml中添加内容

1.4.添加ftl文件模板

1.5.在templates下新建index.ftl

1.6.在controller包下面新建IndexController

1.7.启动项目

2.Freemarker语法

2.1.templates下创建common.ftl

2.2.修改index.ftl中的内容

2.3.新建entity包,并创建User实体类

2.4.IndexController中添加内容

2.5.重启项目

3.Freemarker综合案例

3.1.创建表

3.2.pom.xml中添加内容

3.3.application.yml中添加内容

3.4.entity中添加Clazz实体类

3.5.mapper包中添加ClazzMapper

3.6.在resources中的mappers添加ClazzMapper.xml

3.6.新建utils包, 添加PageBean和StringUtils

3.7.biz包下新建ClazzBiz接口

3.8.biz包下新建impl包,创建ClazzBizImpl

3.9.controller包中添加ClazzController

3.10.utils中添加PageFreemarker

3.11.新建aspect包,在aspect包下添加PagerAspect

3.12.templates中添加clz目录,并添加clzList.ftl

3.13.添加clzEdit.ftl

3.14.application.xml

3.15.修改Spboot04Application

3.16.重启项目—测试

热门文章

最新文章

相关课程

相关电子书