spring、springMvc、springBoot、mybatis集成

1.yml中写相应的配置

1.1集成dataSource

导包：

<dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>1.1.20</version>
</dependency>

自动集成datasource

spring
	datasource:
    	username: ***
    	password: ***
    	url: jdbc:mysql:///crm
    	driver-class-name: com.mysql.jdbc.Driver
   	 #说明使用的是那个连接池
   	 type: com.alibaba.druid.pool.DruidDataSource

手动集成datasource,需要在主配置类中写相应的方法

@Bean
    @ConfigurationProperties(prefix = "jdbc")
    public DataSource dataSource(){
        DruidDataSource dataSource = new DruidDataSource();

        return dataSource;

yml中的配置

jdbc:
  driverClassName: com.mysql.jdbc.Driver
  url: jdbc:mysql:///crm
  username: ***
  password: ***

1.2集成mybatis

导包：

	<dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
    </dependency>
    <dependency>
      <groupId>org.mybatis.spring.boot</groupId>
      <artifactId>mybatis-spring-boot-starter</artifactId>
      <version>1.1.1</version>
    </dependency>

#集成mybatis
mybatis:
  mapper-locations: classpath:cn/itsource/springboot/mapper/*Mapper.xml

主配置类扫描mapper的接口

//mapper接口的扫描包
@MapperScan(basePackages = "cn.itsource.springboot.mapper")
public class ApplicationConfig implements WebMvcConfigurer
{
	........
		}

2.书写层级关系以继配置mapper.xml

domain层，生成相应的对象
mapper层:

public interface EmployeeMapper {
    //查询所有数据
    List<Employee> queryAll();
 }

resources中配置mapper.xml
cn/itsource/springbooot/mapper
EmplpoyeeMapper.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="cn.itsource.springboot.mapper.EmployeeMapper">

    <select id="queryAll" resultType="cn.itsource.springboot.domain.Employee">
        select
        id,
        username,
        password
        from t_employee
    </select>
</mapper>

service层：

public interface IEmployeeService {
    //查询所有数据
    List<Employee> queryAll();

impl

@Service
public class EmployeeServiceImpl implements IEmployeeService {
    @Autowired
    private EmployeeMapper employeeMapper;
    @Override
    public List<Employee> queryAll() {
        return employeeMapper.queryAll();
    }
}

controller层：

@Controller
@Slf4j
public class HelloController {
	@Autowired
    private IEmployeeService employeeService;
//查询所有员工
    @RequestMapping("/list")
    @ResponseBody
    public List<Employee> queryAll(){

        return  employeeService.queryAll();
    }
}