怎么在springboot中集成mybatis xml方式

本文小编为大家详细介绍"怎么在springboot中集成mybatis xml方式"，内容详细，步骤清晰，细节处理妥当，希望这篇"怎么在springboot中集成mybatis xml方式"文章能帮助大家解决疑惑，下面跟着小编的思路慢慢深入，一起来学习新知识吧。

springboot集成mybatis

1，添加pom引用

   org.mybatis.spring.boot  mybatis-spring-boot-starter  1.1.1         mysql     mysql-connector-java   

2 application.properties

mybatis.config-locations=classpath:mybatis/mybatis-config.xmlmybatis.mapper-locations=classpath:mybatis/mapper/*.xmlmybatis.type-aliases-package=com.kerry.model spring.datasource.driverClassName = com.mysql.jdbc.Driverspring.datasource.url = jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8spring.datasource.username = rootspring.datasource.password = 123456

3 在resource目录下创建mybatis目录并创建mybatis-config.xml文件

mybatis目录下创建mapper目录存放mapper类接口文件

package com.kerry.mapper; import java.util.List; import com.kerry.model.User; public interface UserMapper {  List getAll();  User getOne(Integer id);  void insert(User user);  void update(User user);  void delete(Integer id); }

model类文件

package com.kerry.mapper; import java.util.List;import com.kerry.model.User; public interface UserMapper {  List getAll();  User getOne(Integer id);  void insert(User user);  void update(User user);  void delete(Integer id);}

userMapper.xml

                            id, name, age, address         SELECT       FROM user         SELECT       FROM user  WHERE id = #{id}         INSERT INTO      user     (id,name,age,address)     VALUES     (#{id},#{name}, #{age}, #{address})          UPDATE      user     SET     name = #{name},    age = #{age},    address = #{address}    WHERE      id = #{id}          DELETE FROM     user     WHERE      id =#{id}   

controller：

package com.kerry.web;import java.util.List;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.web.bind.annotation.PathVariable;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RestController; import com.kerry.model.User;import com.kerry.mapper.UserMapper; @RestControllerpublic class UserController {  @Autowired private UserMapper userMapper;  @RequestMapping("/getUsers") public List getUsers() { List users=userMapper.getAll(); return users; }   @RequestMapping("/getUser")  public User getUser(Integer id) {   User user=userMapper.getOne(id);    return user;  }    @RequestMapping("/add")  public void save(User user) {   userMapper.insert(user);  }    @RequestMapping(value="update")  public void update(User user) {   userMapper.update(user);  }    @RequestMapping(value="/delete/{id}")  public void delete(@PathVariable("id") Integer id) {   userMapper.delete(id);  }  }

最后在启动类上加上 扫描maper interface注解

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

或者在每个XXMapper类上加上@mapper注解也行 二选一即可

比如

package com.kerry.mapper; import java.util.List;import org.apache.ibatis.annotations.Mapper;import com.kerry.model.User; @Mapperpublic interface UserMapper {  List getAll();  User getOne(Integer id);  void insert(User user);  void update(User user);  void delete(Integer id); }

个人建议使用直接在启动类上application上@MapperScan方便，一次搞定，不必每写一个mapper类都加上@mapper注解

附上项目结构目录 选中的类以及文件

读到这里，这篇"怎么在springboot中集成mybatis xml方式"文章已经介绍完毕，想要掌握这篇文章的知识点还需要大家自己动手实践使用过才能领会，如果想了解更多相关内容的文章，欢迎关注行业资讯频道。