springboot集成mybatis

PushManageTaskInfo实体类
package cn.com.domain;

import java.io.Serializable;

public class PushManageTaskInfo implements Serializable
{
    /**
     * 注释内容
     */
    private static final long serialVersionUID = 5945348321524885293L;
   
    private String taskId;
   
    private String pushType;
   
    private int state;
   
    private String product;
   
    private int sendTotal;
   
    private int arrivalTotal;
   
    private int clickTotal;
   
    private String platform;

    public String getTaskId()
    {
        return taskId;
    }

    public void setTaskId(String taskId)
    {
        this.taskId = taskId;
    }

    public String getPushType()
    {
        return pushType;
    }

    public void setPushType(String pushType)
    {
        this.pushType = pushType;
    }

    public int getState()
    {
        return state;
    }

    public void setState(int state)
    {
        this.state = state;
    }

    public String getProduct()
    {
        return product;
    }

    public void setProduct(String product)
    {
        this.product = product;
    }

    public int getSendTotal()
    {
        return sendTotal;
    }

    public void setSendTotal(int sendTotal)
    {
        this.sendTotal = sendTotal;
    }

    public int getArrivalTotal()
    {
        return arrivalTotal;
    }

    public void setArrivalTotal(int arrivalTotal)
    {
        this.arrivalTotal = arrivalTotal;
    }

    public int getClickTotal()
    {
        return clickTotal;
    }

    public void setClickTotal(int clickTotal)
    {
        this.clickTotal = clickTotal;
    }

    public String getPlatform()
    {
        return platform;
    }

    public void setPlatform(String platform)
    {
        this.platform = platform;
    }
}


请求参数类PushManageTaskRequest
package cn.com.vo;

public class PushManageTaskRequest
{
    private Long page;
    private Long pageSize;
    private String taskId;
    public String getTaskId()
    {
        return taskId;
    }
    public void setTaskId(String taskId)
    {
        this.taskId = taskId;
    }
    public Long getPage()
    {
        return page;
    }
    public void setPage(Long page)
    {
        this.page = page;
    }
    public Long getPageSize()
    {
        return pageSize;
    }
    public void setPageSize(Long pageSize)
    {
        this.pageSize = pageSize;
    }
}


响应参数类PushManageTaskResponse
package cn.com.vo;

import java.util.List;

public class PushManageTaskResponse
{
    /**
     * 总条数
     */
    private Long totalResults;
   
    private List<PushManageTaskVo> pushManageResult;

    public Long getTotalResults()
    {
        return totalResults;
    }

    public void setTotalResults(Long totalResults)
    {
        this.totalResults = totalResults;
    }

    public List<PushManageTaskVo> getPushManageResult()
    {
        return pushManageResult;
    }

    public void setPushManageResult(List<PushManageTaskVo> pushManageResult)
    {
        this.pushManageResult = pushManageResult;
    }
}


响应参数返回参数类PushManageTaskVo
package cn.com.vo;

import java.io.Serializable;

public class PushManageTaskVo implements Serializable
{
    /**
     * 注释内容
     */
    private static final long serialVersionUID = 7532416244563204769L;
   
    private String taskId;
   
    private String pushType;
   
    private int state;
   
    private String product;
   
    private int sendTotal;
   
    private int arrivalTotal;
   
    private int clickTotal;
   
    private String platform;

    public String getTaskId()
    {
        return taskId;
    }

    public void setTaskId(String taskId)
    {
        this.taskId = taskId;
    }

    public String getPushType()
    {
        return pushType;
    }

    public void setPushType(String pushType)
    {
        this.pushType = pushType;
    }

    public int getState()
    {
        return state;
    }

    public void setState(int state)
    {
        this.state = state;
    }

    public String getProduct()
    {
        return product;
    }

    public void setProduct(String product)
    {
        this.product = product;
    }

    public int getSendTotal()
    {
        return sendTotal;
    }

    public void setSendTotal(int sendTotal)
    {
        this.sendTotal = sendTotal;
    }

    public int getArrivalTotal()
    {
        return arrivalTotal;
    }

    public void setArrivalTotal(int arrivalTotal)
    {
        this.arrivalTotal = arrivalTotal;
    }

    public int getClickTotal()
    {
        return clickTotal;
    }

    public void setClickTotal(int clickTotal)
    {
        this.clickTotal = clickTotal;
    }

    public String getPlatform()
    {
        return platform;
    }

    public void setPlatform(String platform)
    {
        this.platform = platform;
    }
}




PushManageTaskDao类
package cn.com.dao;

import java.util.List;


import cn.com.domain.PushManageTaskInfo;
import cn.com.vo.PushManageTaskRequest;

public interface PushManageTaskDao
{
    public List<PushManageTaskInfo> queryPushManageInfoList();
   
    public List<PushManageTaskInfo> queryPushManageInfo(PushManageTaskRequest request);
}


IPushManageTaskService类
package cn.com.service;

import java.util.List;

import cn.com.domain.PushManageTaskInfo;
import cn.com.vo.PushManageTaskRequest;
import cn.com.vo.PushManageTaskResponse;

public interface IPushManageTaskService
{
    public List<PushManageTaskInfo> queryPushManageInfoList();
   
    public PushManageTaskResponse selectPushManageInfo(PushManageTaskRequest request);
}



PushManageTaskService实现类
package cn.com.service;

import java.util.ArrayList;
import java.util.List;

import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;

import cn.com.dao.PushManageTaskDao;
import cn.com.domain.PushManageTaskInfo;
import cn.com.vo.PushManageTaskRequest;
import cn.com.vo.PushManageTaskResponse;
import cn.com.vo.PushManageTaskVo;

@Service("pushManageTaskService")
public class PushManageTaskService implements IPushManageTaskService
{
    @Autowired
    private PushManageTaskDao pushManageTaskDao;

    @Override
    public List<PushManageTaskInfo> queryPushManageInfoList()
    {
        return pushManageTaskDao.queryPushManageInfoList();
    }

    @Override
    public PushManageTaskResponse selectPushManageInfo(PushManageTaskRequest request)
    {
        PushManageTaskResponse response = new PushManageTaskResponse();
        List<PushManageTaskVo> pushManageResult=new ArrayList<PushManageTaskVo>();
       
        PageHelper.startPage(request.getPage().intValue(), request.getPageSize().intValue());
       
        List<PushManageTaskInfo> retList=pushManageTaskDao.queryPushManageInfo(request);
       
        PageInfo<PushManageTaskInfo> pageQuery=new PageInfo<PushManageTaskInfo>(retList);
       
        for(PushManageTaskInfo pushInfo : retList)
        {
            PushManageTaskVo resVo = new PushManageTaskVo();
            BeanUtils.copyProperties(pushInfo, resVo);
            pushManageResult.add(resVo);
        }
        response.setPushManageResult(pushManageResult);
        response.setTotalResults(pageQuery.getTotal());
        return response;
    }
}



PushManageController类
package cn.com.web;

import java.util.List;


import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;

import com.alibaba.fastjson.JSONObject;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;

import cn.com.domain.PushManageTaskInfo;
import cn.com.service.IPushManageTaskService;
import cn.com.vo.PushManageTaskRequest;
import cn.com.vo.PushManageTaskResponse;

@Controller
@RequestMapping(value = "/push")
public class PushManageController
{
    @Autowired
    private IPushManageTaskService pushManageTaskService;
   
    /**
     * 返回页面数据
     * @return [参数说明]
     * @return ModelAndView [返回类型说明]
     * @exception throws [违例类型] [违例说明]
     */
    @RequestMapping(value="/pushList",method={RequestMethod.POST,RequestMethod.GET})
    public ModelAndView pushManageList(@RequestParam(required=true,defaultValue="1")Integer page)
    {
        PageHelper.startPage(page, 2);
        List<PushManageTaskInfo> pushList = pushManageTaskService.queryPushManageInfoList();
        PageInfo<PushManageTaskInfo> pageQuery=new PageInfo<PushManageTaskInfo>(pushList);
        ModelAndView mview=new ModelAndView("pushList");
        mview.addObject("page",pageQuery);
        mview.addObject("pushList", pushList);
        return mview;
    }
   
    /**
     * 返回JSON数据格式
     * @return [参数说明]
     * @return PushManageTaskResponse [返回类型说明]
     * @exception throws [违例类型] [违例说明]
     */
    @RequestMapping(value = "/pushInfo", method = {RequestMethod.POST,RequestMethod.GET})
    @ResponseBody
    public PushManageTaskResponse pushManageInfo()
    {
        PushManageTaskRequest request=new PushManageTaskRequest();
        request.setPage(1L);
        request.setPageSize(20L);
        PushManageTaskResponse response=pushManageTaskService.selectPushManageInfo(request);
        String resJson=JSONObject.toJSONString(response);
        System.out.println("=====resJson:"+resJson);
        return response;
    }
}



pushManageTaskMapper.xml文件
[size=medium<?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="cn.com.dao.PushManageTaskDao">

<resultMap id="pushListResultMap" type="cn.com.domain.PushManageTaskInfo">
<result column="task_id" property="taskId" jdbcType="VARCHAR" />
<result column="push_type" property="pushType" jdbcType="VARCHAR" />
<result column="state" property="state" jdbcType="VARCHAR" />
<result column="product" property="product" jdbcType="VARCHAR" />
<result column="send_total" property="sendTotal" jdbcType="INTEGER" />
<result column="arrival_total" property="arrivalTotal" jdbcType="INTEGER" />
<result column="click_total" property="clickTotal" jdbcType="INTEGER" />
<result column="platform" property="platform" jdbcType="VARCHAR" />
</resultMap>

<select id="queryPushManageInfoList" resultMap="pushListResultMap">
SELECT task_id,
push_type,
state,
product,
send_total,
arrival_total,
click_total,
platform
FROM wifi_push_manage_task
</select>

<select id="queryPushManageInfo" resultMap="pushListResultMap" parameterType="cn.com.vo.PushManageTaskRequest">
SELECT task_id,
push_type,
state,
product,
send_total,
arrival_total,
click_total,
platform
FROM wifi_push_manage_task AS pushtask
</select>
</mapper>[/size]


application.properties属性文件
#指定访问页面路径
spring.mvc.view.prefix=/WEB-INF/view/
spring.mvc.view.suffix=.jsp

###切换环境###
##spring.profiles.active=dev

spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
spring.datasource.username=root
spring.datasource.password=libingbing
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource

mybatis.mapperLocations=classpath:mapper/*.xml

######设置服务启动端口号#######
server.port=8010


pom文件
[size=medium<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>cn.com.demo.springboot</groupId>
<artifactId>springboot-demo</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>war</packaging>

<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
</properties>

<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
<version>1.5.10.RELEASE</version>
<exclusions>
<exclusion>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-tomcat</artifactId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>6.0.6</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>org.apache.tomcat.embed</groupId>
<artifactId>tomcat-embed-jasper</artifactId>
<version>8.5.27</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.6</version>
</dependency>
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.2</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.47</version>
</dependency>
</dependencies>

<build>
<finalName>springboot-demo</finalName>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<configuration>
<source>1.8</source>
<target>1.8</target>
</configuration>
</plugin>

<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-war-plugin</artifactId>
<version>3.2.0</version>
<configuration>
<failOnMissingWebXml>false</failOnMissingWebXml>
</configuration>
</plugin>

</plugins>
</build>
</project> [/size]

springboot启动类ApplicationTest
package cn.com;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.builder.SpringApplicationBuilder;
import org.springframework.boot.web.support.SpringBootServletInitializer;

@SpringBootApplication
//扫描Mapper的Dao层
@MapperScan(basePackages={"cn.com.dao"})
public class ApplicationTest extends SpringBootServletInitializer
{
    public static void main(String[] args)
    {
        SpringApplication.run(ApplicationTest.class, args); 
        System.out.println("======ApplicationTest start success======");
    }
   
    @Override 
    protected SpringApplicationBuilder configure(SpringApplicationBuilder builder) { 
        return builder.sources(this.getClass()); 
    }
}

JSP页面
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!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>pushList</title>
</head>
<body>
<table border="1" cellpadding="0" cellspacing="0">
<tr height="30">
  <td>任务ID</td>
  <td>推送类型</td>
  <td>推送状态</td>
  <td>产品类型</td>
  <td>发送总量</td>
  <td>到达总量</td>
  <td>点击总量</td>
  <td>推送平台</td>
</tr>
<c:forEach items="${pushList}" var="push">
<tr height="30">
<td>${push.taskId}</td>
<td>${push.pushType}</td>
<td>${push.state}</td>
<td>${push.product}</td>
<td>${push.sendTotal}</td>
<td>${push.arrivalTotal}</td>
<td>${push.clickTotal}</td>
<td>${push.platform}</td>
</tr>
</c:forEach>
</table>
<p>一共${page.pages}页</p>
<a href="pushList?page=${page.firstPage}">第一页</a>
<a href="pushList?page=${page.nextPage}">下一页</a>
<a href="pushList?page=${page.prePage}">上一页</a>
<a href="pushList?page=${page.lastPage}">最后页</a>
</body>
</html>



项目结构目录截图



最后浏览器打开地址 http://localhost:8010/push/pushList ，就可以访问了