SpringBoot整合Mybatis

dependency>
    groupId>org.mybatis.spring.bootgroupId>
    artifactId>mybatis-spring-boot-starterartifactId>
    version>1.2.0version>
dependency> 

@Mapper
public interface EmployeeMapper{
    //根据id查询
    public Employee  queryById(int empno) throws Exception;
    //查询指定页数据
    public List  queryByPage(@Param("start")int start, @Param("pageSize") int pageSize) throws Exception;
    // 添加员工
    public void add(Employee emp) throws Exception;
}

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="com.zl.app.mapper.EmployeeMapper">
    
    select id="queryById" resultType="Employee">
        select * from emp where empno = #{empno}
    select>
    
    select id="queryByPage" resultType="Employee">
        
        
        
        select * from emp limit  #{start} ,#{pageSize}
    select>
    
    insert id="add" parameterType="Employee">
        INSERT INTO `emp` (`empno`,`ename`,`job`,`mgr`,`hiredate`,`sal`,`comm`,`deptno`) VALUES (
                            #{empno,jdbcType=INTEGER},#{ename,jdbcType=VARCHAR}, //指定数据类型防止空指针异常
                            #{job,jdbcType=VARCHAR},#{mgr,jdbcType=INTEGER},
                            #{hiredate,jdbcType=DATE},#{sal,jdbcType=DECIMAL},
                            #{comm,jdbcType=DECIMAL},#{deptno,jdbcType=INTEGER}
                            )
    insert>
mapper>

#mybatis的配置
mybatis:
  type-aliases-package: com.zl.app.entity
  mapper-locations: classpath*:mapper/*Mapper.xml

@SpringBootApplication
@MapperScan("com.zl.app.mapper")
public class SpringBoot05JdbcDemoApplication {
    public static void main(String[] args) {
        SpringApplication.run(SpringBoot05JdbcDemoApplication.class, args);
    }