SpringBoot如何利用MyBatis进行连接数据库

spring.datasource.type=com.zaxxer.hikari.HikariDataSource

  com.zaxxer
  HikariCP
  

  org.mybatis.spring.boot
  mybatis-spring-boot-starter
  
  1.0.1-SNAPSHOT

package org.springboot.sample.mapper;

import java.util.List;

import org.springboot.sample.entity.Student;

/**
 * StudentMapper，映射SQL语句的接口，无逻辑实现
 *
 * @author 单红宇(365384722)
 * @create 2016年1月20日
 */
public interface StudentMapper extends MyMapper {

  List likeName(String name);

  Student getById(int id);

  String getNameById(int id);

}

package org.springboot.sample.config.mybatis;

import tk.mybatis.mapper.common.Mapper;
import tk.mybatis.mapper.common.MySQLMapper;

/**
 * 被继承的Mapper，一般业务Mapper继承它
 *
 */
public interface MyMapper extends Mapper, MySqlMapper {
  //TODO
  //FIXME 特别注意，该接口不能被扫描到，否则会出错
}

<?xml version="1.0" encoding="UTF-8"?>



  
  
    
    
    
    
    
  

  
    SELECT *
    FROM STUDENT
    WHERE ID = #{id}
  

  
    SELECT *
    FROM STUDENT
    WHERE NAME LIKE CONCAT('%',#{name},'%')
  

  
    SELECT NAME
    FROM STUDENT
    WHERE ID = #{id}
  


 

package org.springboot.sample.entity;

import java.io.Serializable;

/**
 * 学生实体
 *
 * @author  单红宇(365384722)
 * @create  2016年1月12日
 */
public class Student implements Serializable{

  private static final long serialVersionUID = 2120869894112984147L;

  private int id;
  private String name;
  private String sumScore;
  private String avgScore;
  private int age;

  // get set 方法省略

}

mybatis.mapper-locations=classpath*:org/springboot/sample/mapper/sql/mysql/*Mapper.xml
mybatis.type-aliases-package=org.springboot.sample.entity

  @Autowired
  private StudentMapper stuMapper;

  @RequestMapping("/likeName")
  public List likeName(@RequestParam String name){
    return stuMapper.likeName(name);
  }

@SpringBootApplication
@MapperScan("sample.mybatis.mapper")
public class SampleMybatisApplication implements CommandLineRunner {

  @Autowired
  private CityMapper cityMapper;

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

  @Override
  public void run(String... args) throws Exception {
    System.out.println(this.cityMapper.findByState("CA"));
  }

}

package sample.mybatis.mapper;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import sample.mybatis.domain.City;

/**
 * @author Eddú Meléndez
 */
public interface CityMapper {

  @Select("SELECT * FROM CITY WHERE state = #{state}")
  City findByState(@Param("state") String state);

}

  com.github.pagehelper
  pagehelper
  4.1.0

package org.springboot.sample.config;

import java.util.Properties;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import com.github.pagehelper.PageHelper;

/**
 * MyBatis 配置
 *
 * @author 单红宇(365384722)
 * @create 2016年1月21日
 */
@Configuration
public class MyBatisConfiguration {

  private static final Logger logger = LoggerFactory.getLogger(MyBatisConfiguration.class);

  @Bean
  public PageHelper pageHelper() {
    logger.info("注册MyBatis分页插件PageHelper");
    PageHelper pageHelper = new PageHelper();
    Properties p = new Properties();
    p.setProperty("offsetAsPageNum", "true");
    p.setProperty("rowBoundsWithCount", "true");
    p.setProperty("reasonable", "true");
    pageHelper.setProperties(p);
    return pageHelper;
  }

}

  @RequestMapping("/likeName")
  public List likeName(@RequestParam String name){
    PageHelper.startPage(1, 1);
    return stuMapper.likeName(name);
  }