springboot+mybatis整合(入门)

1、使用idea创建springboot项目 选择web、mybatis
或者在pom.xml增加

<!-- mybatis -->
<dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.0</version>
        </dependency>
<!-- mysql -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

2、编写Mapper
使用到的注解有：@Mapper

@Mapper
public interface User2Mapper {
    /**
     * 2017年7月6日12:31:11
     * 根据id获得用户信息
     *
     * @param id
     * @return User
     */
    @Select("SELECT id,name,age FROM user WHERE id=#{id}")
    User findById(@Param("id") Integer id);
    /**
     * 2017年7月6日12:31:11
     * 新增用户信息
     *
     * @param user
     * @return User
     */
    @Transactional
    @Insert("INSERT INTO user(name,age) VALUES(#{name},#{age})")
    @Options(useGeneratedKeys = true,keyProperty = "id")
    int insertUserInfo(User user);
    @Update("UPDATE user SET name=#{name},age=#{age} WHERE id=#{id}")
    int updateUserInfo(User user);
    @Delete("DELETE FROM user WHERE id=#{id}")
    int deleteUserInfoById(Integer id);

}
//结果返回map
@Mapper
@Component
public interface BaseMapper {
    @Select("select * from base_person where del_flag='0' and status2='0' limit 10")
    @MapKey("id")
    Map<Long, Map<String, Object>> queryBasePerson();
}

3、接口和接口实现
定义一个接口UserService
定义一个接口的实现使用注解@Service声明 Service
@Autowired 将定义好的Mapper注入

@Service
public class UserServiceImpl implements UserService{
    @Autowired
    private UserMapper userMapper;
    @Autowired
    User2Mapper user2Mapper;
    public List<User> findList() {
        return userMapper.findUserInfo();
    }
    public User findById(Integer id){
        return user2Mapper.findById(id);
    }
    @Transactional
    @Override
    public int insertUserInfo(User user) {
        try {
            User user1= new User();
            user1.setName("1");
            user1.setAge(1);
            user2Mapper.insertUserInfo(user1);
            return user2Mapper.insertUserInfo(user);
        }catch (Exception e){
            e.printStackTrace();
        }
        return 0;
    }
 }

4、在Controller里面使用@Autowired 调用即可
5、在application.yml增加数据库配置

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/hshk
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver

源码托管在：http://git.oschina.net/luweiwei/SpringbootMybatisDemo/tree/master