springboot学习五：springboot整合mybaits

@Transactional：当出错时有错误回滚机制；@MapperScan("com.whut.springboot1.mapper")烧苗mybaits层的mapper包

1. pom.xml依赖:

org.mybatis.spring.bootmybatis-spring-boot-starter1.1.1


mysqlmysql-connector-java

2.application.properties:

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

3.mapper层：这里可以不注入spring容器，即加入@Mapper注解

public interface UserMapper {@Select("SELECT * FROM USERS WHERE NAME = #{name}")User findByName(@Param("name") String name);@Insert("INSERT INTO USERS(NAME, AGE) VALUES(#{name}, #{age})")int insert(@Param("name") String name, @Param("age") Integer age);
}

4.controller层

@RestController
public class MybaitsController {@Autowiredprivate UserService userService;@RequestMapping("/insertUser")public Integer insertUser(String name, Integer age) {return userService.insertUser(name, age);}
}

5.entity层

@Data
public class User {private Integer id;private String name;private int age;
}

 6.service层：在类中userdao上会报错，说UserMapper没有注入进去

@Service
@Slf4j
public class UserService {@Autowiredprivate UserMapper userDao;@Transactionalpublic int insertUser(String name, Integer age) {int insertUserResult = userDao.insert(name, age);int i = 1 / age;return insertUserResult;}
}

 7.访问即可：

http://127.0.0.1:8080/insertUser?name=“zhq”&age=23

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！