-
引入相关的依赖
<dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.11</version> <scope>test</scope> </dependency> <!--引⼊springboot的web⽀持--> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <!--引入MySQL的依赖--> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.38</version> </dependency> <!--引入mybatis整合springboot所使用的依赖--> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>2.1.2</version> </dependency> <!--springboot连接数据库的驱动jar--> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.1.12</version> </dependency> </dependencies>
2.配置application.yml
# spring整合MyBatis配置 spring: datasource: type: com.alibaba.druid.pool.DruidDataSource #连接所使用的数据源 driver-class-name: com.mysql.jdbc.Driver #所使用的驱动类 url: jdbc:mysql://locahost:3306/mybatis1?charsetEncoding=UTF-8 username: root password: root # 配置mapper文件所在的包 mybatis: mapper-locations: classpath:com/wd/mapper/*.xml
application.java
//声明当前文件是一个springboot应用的入口类 @SpringBootApplication //修饰范围:用在类上 标识是springboot的入口类 这个注释只能出现一次 @MapperScan("com.wd.dao") //用来指定Dao接口所在的位置 public class Application { public static void main(String[] args) { //运行springboot的核心方式 SpringApplication.run(Application.class,args); } }
public interface Userdao { List<user> findAllUser(); user findUserById(@Param("id") int id); }
mapper文件:编写方法的实现
<mapper namespace="com.wd.dao.Userdao"> <select id="findAllUser" resultType="com.wd.entity.user"> select * from t_user </select> <select id="findUserById" resultType="com.wd.entity.user"> select * from t_user where id=#{id} </select> </mapper>
public interface UserService { List<user> findAllUser(); user findUserById(int id); }
serviceImpl:service接口的实现类,实现接口文章来源:https://www.toymoban.com/news/detail-411506.html
@Service //代表在工厂中创建有个service对象 @Transactional //当前类是支持事务的 public class UserServiceImpl implements UserService{ @Resource private Userdao userDao; @Override public List<user> findAllUser() { return userDao.findAllUser(); } @Override public user findUserById(int id) { return userDao.findUserById(id); } }
@RestController @RequestMapping("/user") public class usercontroller { @Resource private UserService userService; @RequestMapping("/users") public List<user> findUsers(){ System.out.println("************"); return userService.findAllUser(); } /** * 查询单个用户方法 * @return:单个用户对象 * @PathVaribale:代表接收路径中所包含的参数 */ @RequestMapping("/users/{id}") public user findUserById(@PathVariable("id") int id){ System.out.println("id="+ id); return userService.findUserById(id); } }
@RequestMapping("/users/{id}") public user findUserById(@PathVariable("id") int id){ }
文章来源地址https://www.toymoban.com/news/detail-411506.html
到了这里,关于Springboot集成MyBatis进行开发的文章就介绍完了。如果您还想了解更多内容,请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章,希望大家以后多多支持TOY模板网!