SpringBoot_F~MyBatis

一 引入依赖

    <dependency>

        <groupId>org.mybatis.spring.boot</groupId>

        <artifactId>mybatis-spring-boot-starter</artifactId>

        <version>1.1.1</version>

    </dependency>

二 application.properties 添加相关配置

    mybatis.type-aliases-package=com.study.springboot.SpringBoot_A.bean

三 添加扫描@MapperScan（否则就需要在每个Mapper接口上添加@Mapper注解）

    @MapperScan(basePackages = "")

四 采用注解方式编写mapper （xml方式不介绍）

    public interface UserMapper {

        @Select("select * from user")

        @Results({

            @Result(property = "userName", column = "user_name"),

            @Result(property = "nickName", column = "nick_name"),

            @Result(property = "passWord", column = "pass_word"),

            @Result(property = "regTime", column = "reg_time")

        })

        List<User> getAll();

        @Insert("insert into user (user_name, nick_name, pass_word) values (#{userName}, #{nickName}, #{passWord})")

        Integer addUser(@Param("userName") String userName, @Param("nickName") String nickName, @Param("passWord") String passWord);

        //    Integer addUser(User user);

        @Update("UPDATE user SET userName = #{userName}, nick_name = #{nickName} WHERE id = #{id}")

        Integer updateUser(User user);

        }

        @Delete("DELETE FROM user WHERE id =#{id}")

        void delete(Long id);

    }