<td id="igfqy"></td>

spring boot 整合mybatis

2024-04-27 15:03:40

字體：大中小

來源：轉載

供稿：網友

spring boot 整合mybatis

工作中所使用的框架spring boot + mybatis工作之余看到了搭建方法，順便把它放到這里，以供以后參考

pom.xml依賴

在pom.xml引入所需要的依賴 <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>1.2.6.RELEASE</version> <relativePath/>  </parent> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-redis</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.1.1</version> </dependency> <dependency> <groupId>MySQL</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.21</version> </dependency> </dependencies>

application.properties配置

在application.properties中配置mysql的連接配置spring.datasource.url=jdbc:mysql://localhost:3306/testspring.datasource.username=rootspring.datasource.passWord=rootspring.datasource.driver-class-name=com.mysql.jdbc.Driver

使用MyBatis

在Mysql中創建User表，包含id(BIGINT)、name(INT)、age(VARCHAR)字段。同時，創建映射對象Userpublic class User { private Long id; private String name; private Integer age; // 省略getter和setter}創建User映射的操作UserMapper，為了后續單元測試驗證，實現插入和查詢操作@Mapperpublic interface UserMapper { @Select("SELECT * FROM USER WHERE NAME = #{name}") User findByName(@Param("name") String name); @Insert("INSERT INTO USER(NAME, AGE) VALUES(#{name}, #{age})") int insert(@Param("name") String name, @Param("age") Integer age);}創建Spring Boot主類@SpringBootApplicationpublic class Application { public static void main(String[] args) { SpringApplication.run(Application.class, args); }}創建單元測試 測試邏輯：插入一條name=AAA，age=20的記錄，然后根據name=AAA查詢，并判斷age是否為20測試結束回滾數據，保證測試單元每次運行的數據環境獨立@RunWith(SpringJUnit4ClassRunner.class)@SpringApplicationConfiguration(classes = Application.class)@Transactionalpublic class ApplicationTests { @Autowired private UserMapper userMapper; @Test @Rollback public void findByName() throws Exception { userMapper.insert("AAA", 20); User u = userMapper.findByName("AAA"); Assert.assertEquals(20, u.getAge().intValue()); }}

上一篇：angular之過濾器

下一篇：javascript筆記--（第十二章）變量、作用域及內存