springboot集成mybatis

[size=large][b]PushManageTaskInfo实体类[/b][/size]
[size=medium]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;
}
}
[/size]

[size=large][b]请求参数类PushManageTaskRequest[/b][/size]
[size=medium]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;
}
}
[/size]

[size=large][b]响应参数类PushManageTaskResponse[/b][/size]
[size=medium]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;
}
}[/size]


[size=large][b]响应参数返回参数类PushManageTaskVo[/b][/size]
[size=medium]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;
}
}[/size]


[size=large][b]PushManageTaskDao类[/b][/size]
[size=medium]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);
}
[/size]

[size=large][b]IPushManageTaskService类[/b][/size]
[size=medium]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);
}
[/size]


[size=large][b]PushManageTaskService实现类[/b][/size]
[size=medium]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;
}
}
[/size]


[b][size=large]PushManageController类[/size][/b]
[size=medium]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;
}
}
[/size]


[size=large][b]pushManageTaskMapper.xml文件[/b][/size]
[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]


[size=large][b]application.properties属性文件[/b][/size]
[size=medium]#指定访问页面路径
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[/size]


[size=x-large][b]pom文件[/b][/size]
[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]

[size=large][b]springboot启动类ApplicationTest[/b][/size]
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());
}
}

[b][size=large]JSP页面[/size][/b]
[size=medium]<%@ 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>
[/size]


[size=large][b]项目结构目录截图[/b][/size]
[img]http://dl2.iteye.com/upload/attachment/0130/2321/c370874c-667a-3747-a0d1-103df60dd3d5.png[/img]


[b][size=medium]最后浏览器打开地址 http://localhost:8010/push/pushList ，就可以访问了[/size][/b]