springboot+mybatis整合(入门)

来源：互联网发布：河南软件编辑：程序博客网时间：2024/06/05 13:23

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

@Mapperpublic 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);}

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

@Servicepublic 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

阅读全文

0 0