springboot例子

@Mapper
public interface FinancingMapper {

    @Insert("<script>" +
            "insert into financingproduct values(#{id},#{risk},#{income},#{saleStarting},#{saleEnd},#{end})" +
            "</script>")
    int insertFinancingProduct (String id,int risk,String income,String saleStarting,String saleEnd,String end);

    @Delete("<script>" +
            "delete from financingproduct where id = #{id}" +
            "</script>")
    int delFinancingProductById (String id);

    @Update("<script>" +
            "update financingproduct set risk=#{risk},income=#{income},saleStarting=#{saleStarting},saleEnd=#{saleEnd},end=#{end} where id = #{id}" +
            "</script>")
    int updFinancingProductById (int risk,String income,String saleStarting,String saleEnd,String end,String id);

    @Select("<script>" +
            "select * from financingproduct where id = #{id}" +
            "</script>")
    FinancingProduct getFinancingProductById(@Param("id") String id);

    @Select("<script>" +
            "select count(1) from financingproduct limit #{offset},#{limit}"
            +
            "</script>")
    long getFinancingProductCount(Integer offset,Integer limit);

    @Select("<script>" +
            "select * from financingproduct limit #{offset},#{limit}"
            +
            "</script>")
    List<FinancingProduct> getFinancingProductList(Integer offset,Integer limit);
}

@Service
public class FinancingService {
    @Autowired
    FinancingMapper financingMapper;

    public FinancingProduct getFinancingProductById(String id){
        return financingMapper.getFinancingProductById(id);
    }

    public int insertFinancingProduct(String id,int risk,String income,String saleStarting,String saleEnd,String end){
        return financingMapper.insertFinancingProduct(id, risk,income,saleStarting,saleEnd,end);
    }

    public int delFinancingProductById (String id){
        return financingMapper.delFinancingProductById(id);
    }

    public int updFinancingProductById (int risk,String income,String saleStarting,String saleEnd,String end,String id){
        return financingMapper.updFinancingProductById(risk,income,saleStarting,saleEnd,end,id);
    }

    public long getFinancingProductCount(Integer offset,Integer limit){
        return financingMapper.getFinancingProductCount(offset,limit);
    }

    public List<FinancingProduct> getFinancingProductList(Integer offset,Integer limit){
        return financingMapper.getFinancingProductList(offset,limit);
    }
}

@Controller
public class FinancingController {
    @Autowired
    FinancingService financingServiceImpl;

    @RequestMapping("/insertFinancingProduct")
    @ResponseBody
    public int  insertFinancingProduct(HttpServletRequest httpServletRequest, ModelMap modelMap,String id,int risk,String income,String saleStarting,String saleEnd,String end){
        return financingServiceImpl.insertFinancingProduct(id, risk,income+"%",saleStarting,saleEnd,end);
    }

    @RequestMapping("/delFinancingProductById")
    public String  delFinancingProductById(HttpServletRequest httpServletRequest, ModelMap modelMap,String id){
        financingServiceImpl.delFinancingProductById(id);
        return "getFinancingProductList";
    }

    @RequestMapping("/updFinancingProductById")
    @ResponseBody
    public int  updFinancingProductById(HttpServletRequest httpServletRequest, ModelMap modelMap,int risk,String income,String saleStarting,String saleEnd,String end,String id){
        return financingServiceImpl.updFinancingProductById(risk,income+"%",saleStarting,saleEnd,end,id);
    }

    @RequestMapping("/getFinancingProductById")
    public String  getFinancingProductById(HttpServletRequest httpServletRequest, ModelMap modelMap,String id){
        FinancingProduct financingProduct = financingServiceImpl.getFinancingProductById(id);
        modelMap.addAttribute("financingProduct", financingProduct);
        return "index";
    }

    @RequestMapping("/getFinancingProductList")
    public String  getFinancingProductList(HttpServletRequest httpServletRequest, ModelMap modelMap){
        int limit = 3;
        int offset = 0;
        Long total = 0L;
        PageHelper pageHelper = PageHelper.builder();
        offset = (pageHelper.getPageNumFromUrl(httpServletRequest) - 1)*limit; //limit后第一个参数
        total = pageHelper.getTotalFromUrl(httpServletRequest); //limit后最后一个参数

        //如果total为空，那么查询获取总记录数
        if (total == null) total = financingServiceImpl.getFinancingProductCount(offset,limit);

        //查询获取数据
        List<FinancingProduct> result = financingServiceImpl.getFinancingProductList(offset,limit);
        String banner = pageHelper.getPageBanner(limit, total, httpServletRequest);
        modelMap.addAttribute("page", banner);
        modelMap.addAttribute("result", result);
        return "index";
    }


}


utils中的PageHelper

/**
 * 一个基于GET请求进行的分页类,可做适当的设置
 * 使用方法:
 * 默认样式PageHelper.builder()
 * 或者定制样式
 * PageHelper.builder("myid","mytotal",80000L,1000,7)
 * 完整例子:(控制器某方法)
 * public String foo(HttpServletRequest request,ModelMap model,Condition cond){
 *     //从con参数进行解析...省略....
 *     Integer limit = 20; //每页限制显示20条
 *     PageHelper page = PageHelper.builder();
 *     Long total = page.getTotalFromUrl(request);
 *     if(total ==null){
 *         total = service.getTotalFromDb(); //用自己的方法从数据库获取总记录数
 *     }
 *     Integer pageNum = page.getPageNumFromUrl(request);//得到请求的页码
 *     String banner = page.getPageBanner(limit,total,request);//返回生成的分页按钮
 *     model.put("pagebanner",banner);//加入模板引擎里
 *     List<Object> list = service.getRecords(pageNum * limit,.....);//给出本次查询返回值的offset
 *     .....省略
 */
public class PageHelper {
    //样式属性,可设置
    private String pagetag = "_pgid_";//下一页在url上的name属性名
    private String totaltag = "_totalnums_";//总记录数在url上的name属性名
    private Long switchNumber = 100000L;//总记录数到达这数字,则切换样式(无尾页按钮)
    private Integer bannerWidth = 800;//分页banner的宽度
    private Integer btnNumber = 5;//分页显示的按钮数,需要单数,比如5,7,9
    //一些初始设置值
    private Integer pgid=1;//当前按钮页
    private Integer firstBtn=0;//第一个页按钮
    private Integer lastBtn=0;//最后一个页按钮
    private String baseURL="";//除_total=10000&_pgid=2 之外的uri
    private Integer pages=1; //总分页数
    private Long total=0L;//总记录数
    //省略号样式
    private String points = "style='margin:0;border-style:none;background:none;padding:5px 0px;color:#808080;float:left;'";
    //未选中的页码按钮样式
    private  String a_style = "style='box-sizing:border-box;display:block;float:left;margin-right:10px;"
            + "padding:2px 12px;height:30px;line-height:24px;border:1px #cccccc solid;background:#fff;"
            + "text-decoration:none;color:#808080;font-size:12px;'";
    // 禁止使用的样式disable
    private String disable_style = "style='box-sizing:border-box;float:left;padding:2px 12px;height:30px;line-height:24px;font-size:12px;"
            + "color:#bbb;border:1px #ccc solid;background:#fcfcfc;margin:0;margin-right:10px;'";

    //选中按钮的样式
    private String select_style = "style='box-sizing:border-box;display:block;float:left;margin-right:10px;"
            + "padding:2px 12px;height:30px;line-height:24px;"
            + "text-decoration:none;font-size:12px;border:1px #cccccc solid;background:#077ee3;color:#fff;'";

    //总分页数和总记录数的样式
    private String total_style ="style='box-sizing:border-box;border-style:none;background:none;font-size:12px;"
            + "margin:0px;height:30px;padding:3px 0px;color:#666;display:block;float:left;line-height:24px;'";

    //按钮鼠标进入和离开时候的事件属性
    private String mouseEvent = "onmouseenter='nbf_mouseenter(this)' onmouseleave='nbf_mouseleave(this)'";

    //要执行的鼠标script语句
    private String scripts ="<script type='text/javascript'>"
            + "function nbf_mouseenter(obj){obj.style.color='#077ee3';obj.style.border='1px #077ee3 solid';}"
            + "function nbf_mouseleave(obj){obj.style.color='#808080';obj.style.border='1px #cccccc solid';}</script>";

    /**
     * 使用默认样式的构建方法
     * @return
     */
    public static PageHelper builder(){
        return new PageHelper();
    }

    /**
     * 带样式的构建方法
     * @param pagetag 页码的name值(附加在url上)
     * @param totaltag 记录总数的name值(附加在url上)
     * @param switchNumber 总记录数到达该值,则切换样式
     * @param bannerWidth 分页div的宽度
     * @param btnNumber 分页按钮的个数(必须是单数,至少5个)
     * @return 该类的实例
     */
    public static PageHelper builder(String pagetag, String totaltag
                                        , Long switchNumber, Integer bannerWidth
                                        , Integer btnNumber){
        return new PageHelper(pagetag,totaltag,switchNumber,bannerWidth,btnNumber);
    }

    private PageHelper(){}

    /**
     *  给对象赋样式的自定义值
     * @param pagetag
     * @param totaltag
     * @param switchNumber
     * @param bannerWidth
     * @param btnNumber
     */
    private PageHelper(String pagetag, String totaltag
            , Long switchNumber, Integer bannerWidth
            , Integer btnNumber){
        if(pagetag!=null && pagetag.trim().isEmpty()==false)
        this.pagetag = pagetag;
        if(totaltag!=null && totaltag.trim().isEmpty()==false)
        this.totaltag = totaltag;
        if(switchNumber!=null)
        this.switchNumber = switchNumber;
        if(bannerWidth!=null)
        this.bannerWidth = bannerWidth;
        if(btnNumber!=null)
        this.btnNumber = btnNumber;
    }

    /**
     * 从url上获取total的总记录值
     * @param request 由控制器透传的httpserverrequest
     * @return Long
     */
    public Long getTotalFromUrl(HttpServletRequest request) {
        String totalTag = request.getParameter(totaltag); //从页面获取总记录数
        if (totalTag != null && totalTag.trim().isEmpty() == false) { //说明已经查询过总数了
            try {
                return Long.valueOf(totalTag); //将String 类型的数字转化为Long类型
            } catch (Exception e) {
                return null;  //报错则返回null
            }


        }
        return null; //如果页面没有传回总记录数那么返回null
    }

    /**
     * 从url上获取请求的页码数值,最小值是1
     * @param request
     * @return Integer
     */
    public Integer getPageNumFromUrl(HttpServletRequest request) {
        String pgid = request.getParameter(pagetag); //获取请求参数
        if (pgid != null && pgid.trim().isEmpty() == false) { //从url获取请求的页码
            try {
                return Integer.valueOf(pgid); //将String类型的数字转化为数字
            } catch (Exception e) {
                return 1; //如果发生错误，当前页数默认为1
            }


        }
        return 1; //如果没有从前端页面获取当前页数，默认为1
    }

    /**
     * 得到一个分页按钮的HTML字符串,可直接嵌入网页内
     * @param limit 每页限制返回的记录数
     * @param total 该查询返回的总记录数(需要提取用count语句获得)
     * @param request 控制器透传的HttpServletRequest
     * @return 分页的html代码(String)
     */
    public String getPageBanner(Integer limit,Long total,HttpServletRequest request){
        if(total<=limit) return "";
        this.total = total;
        String URI = request.getRequestURI();
        pgid = getPageNumFromUrl(request);

        String params ="";
        Enumeration<String> names = request.getParameterNames();
        while (names.hasMoreElements()){
            String name = names.nextElement();
            if(name.equalsIgnoreCase(pagetag) || name.equalsIgnoreCase(totaltag))
                continue;
            String value = request.getParameter(name);
            params+=name+"="+value+"&";
        }
        //params=params.substring(0,params.lastIndexOf("&"));
        baseURL=URI+"?"+params;
        pages =(int)Math.ceil(((double)total / (double)limit));//计算出总分页数
        Integer baseBtnNum = (int)Math.floor((double)(btnNumber/2));//计算当前按钮两边的按钮数
        //第一个页按钮
        firstBtn = pgid - baseBtnNum;
        //最后一个页按钮
        lastBtn = pgid + baseBtnNum;
        if(firstBtn<1){
            lastBtn=lastBtn+(1-firstBtn);
            firstBtn=1;
        }
        if(lastBtn>pages){
            firstBtn = firstBtn - (lastBtn-pages);
            lastBtn = pages;
        }
        if (firstBtn<1)
            firstBtn=1;

        //开始构建banner的html代码
        String Banner ="<div class='nbf_pageslice' "+buildBanner()+ ">"
                + buildHome()
                + buildPreBtn();
        if(total>0){
            Banner+=buildBtns();
        }
        Banner+=buildNextBtn();
        if(total>0 && total<switchNumber){
            Banner+=buildTail();
        }
        Banner+=buildTotalPage();
        Banner+=scripts;
        Banner+="<div style='clear:both'></div></div>";
        return Banner;
    }


    private String buildUrl(Integer pgid){
        String newUri = baseURL+totaltag+"="+total+"&"+pagetag+"="+pgid;

        return newUri;
    }

    /**
     * 构建首页
     * @return
     */
    private String buildHome(){
        if(pgid!=1){
            String URI = buildUrl(1);
            return "<a class='enable_btn' "+mouseEvent+" "+ a_style+" href='"+URI+"' title='首页'>首页</a>";
        }else{
            return "<p class='nbf_p_style' "+disable_style+">首页</p>";
        }
    }

    /**
     * 构建尾页
     * @return
     */
    private String buildTail(){
        if (pgid != pages) {
            String URI = buildUrl(pages);
            return "<a class='enable_btn'"+mouseEvent+" "+a_style+" href='"+URI+"' title='尾页'>尾页</a>";
        } else {
            return "<p class='nbf_p_style' "+disable_style+">尾页</p>";
        }
    }

    /**
     * 构建整个banner的样式
     * @return
     */
    private String buildBanner(){
        return "style='width:"+ bannerWidth +"px;margin-left:auto;margin-right:auto;height:40px;padding:20px 0px;'";
    }

    /**
     * 构建上一页按钮
     * @return
     */
    private String buildPreBtn(){
        if (pgid != 1) {
            String URI = buildUrl(pgid - 1);
            return "<a class='enable_btn' "+mouseEvent+" "+a_style+" href='"+URI+"' title='上一页'>上一页</a>";
        } else {
            return "<p class='nbf_p_style' "+disable_style+">上一页</p>";
        }
    }

    /**
     * 构建下一页按钮
     * @return
     */
    private String buildNextBtn(){
        if (pgid != pages) {
            String URI = buildUrl(pgid + 1);
            return "<a class='enable_btn'"+mouseEvent+" "+a_style+" href='"+URI+"' title='下一页'>下一页</a>";
        } else {
            return"<p class='nbf_p_style' "+disable_style+">下一页</p>";
        }
    }

    /**
     * 构建中间的所有页按钮
     * @return
     */
    private String buildBtns(){
        String btns="";
        if(firstBtn>1){
            btns="<p class='nbf_p_style' "+points+">...</p>";
        }
        for(int i=firstBtn;i<=lastBtn;i++){
            if(i==pgid){
               btns+="<a class='disable_btn' "+select_style+" href='javascript:;' title='第" + i + "页' >"+i+"</a>";
            }else{
                String URI = buildUrl(i);
                btns+="<a class='enable_btn' "+mouseEvent+" "+a_style+" href='"+URI+"' title='第" +i+ "页'>"+i+"</a>";
            }
            }
            if(lastBtn<pages){
                btns+="<p class='nbf_p_style'  "+points+">...</p>";
            }
        return btns;
    }

    private String buildTotalPage(){
        return "<p class='nbf_p_style' "+total_style+" >共<span style='color:red;'> " + pages
        +" </span>页<span style='color:red;'> " + total + " </span>条数据</p>";
    }


}

index.html页面中的内容

<script src="${request.contextPath}/static/dist/jquery.js"></script>
<body>


<div class="x-body lay-change-page">
    <div class="layui-card">
        <div class="layui-card-body">
            <table class="layui-table">
                <thead>
                <tr>
                    <th>ID</th>
                    <th>风险评级</th>
                    <th>预期收益</th>
                    <th>发售起始日</th>
                    <th>发售结束日</th>
                    <th>产品到期日</th>
                    <th style="min-width:150px">操作</th>
                </tr>
                </thead>
                <tbody>
                    <#if result??>
                        <#list result as list>
                            <tr>
                                <td>${list.id}</td>
                                <td>${list.risk!}</td>
                                <td>${list.income!}</td>
                                <td>
                                    <#if list.saleStarting??>
                                        ${list.saleStarting?string('yyyy-MM-dd hh:mm:ss')}
                                    </#if>
                                </td>
                                <td>
                                    <#if list.saleEnd??>
                                        ${list.saleEnd?string('yyyy-MM-dd hh:mm:ss')}
                                    </#if>
                                </td>
                                <td>
                                    <#if list.end??>
                                        ${list.end?string('yyyy-MM-dd hh:mm:ss')}
                                    </#if>
                                </td>
                                 <td class="td-manage">
                                     <a title="删除" href="${request.contextPath}/delFinancingProductById?id=${list.id}"
                                        class="a-link" ><!--onclick="delFinancingById(${list.id})"-->
                                         删除
                                     </a>
                                     <a title="修改" href="javascript:;"
                                        class="a-link" onclick="OpenLayer('edit?id=${list.id}',['700px','80%'])">
                                         修改
                                     </a>
                                     |
                                     <a class="a-link" title="通过" href="javascript:;"
                                        onclick="audit(${list.id})">   <!--OpenFrame('停用','${request.contextPath}/search/pass?id=${list.id}',['确定','取消'],'.commit',['800px','400px'])-->
                                         通过
                                     </a>
                                 </td>
                            </tr>
                        </#list>
                </#if>
                </tbody>
            </table>
        </div>
    </div>
 <#if page??>${page}</#if>
</div>


<script>

    /*function delFinancingById(id) {
        alert(id);
        $.ajax({
            url:'delFinancingProductById',
            type:'GET',
            dataType:'text',
            data:{id:id},
            success:function (msg) {
                alert(id);
                alert(msg);
                alert("删除成功！");
            }
        })
    }*/
</script>
</body>

application.yml

server:
  port: 8083
spring:
  profiles:
    active: dev
  mvc:
    static-path-pattern: /static/**



---
spring:
  profiles: release
  datasource:
    url: jdbc:mysql://192.168.10.5:3306/keyword?useSSL=false
    password: xcm123
    username: client
  resources:
    static-locations:
      - file:/keywords/
      - file:/keywords/static/
  freemarker:
    cache: false
    charset: utf-8
    allow-request-override: false
    check-template-location: true
    content-type: text/html
    expose-request-attributes: true
    expose-session-attributes: true
    suffix: .html
    template-loader-path: file:/keywords/templates/
    request-context-attribute: request

---
spring:

  profiles: dev
  datasource:
#    url: jdbc:mysql://10.0.0.191/keyword?useUnicode=true&characterEncoding=utf-8&useSSL=false
#    password: xcM@12345
#    username: client
    url: jdbc:mysql://127.0.0.1/licai?useUnicode=true&characterEncoding=utf-8&useSSL=false
    password: root
    username: root
  freemarker:
    cache: false
    charset: utf-8
    allow-request-override: false
    check-template-location: true
    content-type: text/html
    expose-request-attributes: true
    expose-session-attributes: true
    suffix: .html
    template-loader-path: classpath:/templates/
    request-context-attribute: request

logging:
  level:
    com.hstt.antiweb.mapper.*: debug


pom.xml

<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-freemarker</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>
    <dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>2.0.0</version>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <scope>runtime</scope>
    </dependency>
    <dependency>
        <groupId>org.apache.commons</groupId>
        <artifactId>commons-collections4</artifactId>
        <version>4.0</version>
    </dependency>
    <dependency>
        <groupId>org.apache.commons</groupId>
        <artifactId>commons-lang3</artifactId>
        <version>3.4</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/commons-codec/commons-codec -->
    <dependency>
        <groupId>commons-codec</groupId>
        <artifactId>commons-codec</artifactId>
        <version>1.10</version>
    </dependency>

    <dependency>
        <groupId>com.aliyun.oss</groupId>
        <artifactId>aliyun-sdk-oss</artifactId>
        <version>2.5.0</version>

    </dependency>

    <dependency>
        <groupId>commons-io</groupId>
        <artifactId>commons-io</artifactId>
        <version>2.6</version>
    </dependency>


    <dependency>
        <groupId>com.google.code.gson</groupId>
        <artifactId>gson</artifactId>
    </dependency>

    <dependency>
        <groupId>com.google.collections</groupId>
        <artifactId>google-collections</artifactId>
        <version>1.0-rc2</version>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>
</dependencies>