1.创建新工程tkmapper-demo。
勾选依赖
编写application.yml:
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/fmmall2?characterEncoding=utf-8
spring.datasource.username=root
spring.datasource.password=123456
mybatis.type-aliases-package=com.qfedu.tkmapperdemo.beans
mybatis.mapper-locations=classpath:mappers/*Mapper.xml
在com/qfedu/tkmapperdemo下创建包bean、dao,resource下创建包mapper。
添加tkMapper依赖
<dependency>
<groupId>tk.mybatis</groupId>
<artifactId>mapper-spring-boot-starter</artifactId>
<version>2.1.5</version>
</dependency>
2.在启动类中使用tkMapper的@MapperScan注释,引用包名。
package com.qfedu.tkMapperdemo;
import tk.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
@MapperScan("com.qfedu.tkmapperdemo.dao")
public class TkmapperDemoApplication {
public static void main(String[] args) {
SpringApplication.run(TkmapperDemoApplication.class, args);
}
}
3.创建数据表
4.创建实体类
beans-User.java:
@Data
@NoArgsConstructor
@AllArgsConstructor
@ApiModel(value = "User对象",description = "买家信息")
public class User { private int userId; private String username; private String password; private String nickname; private String realname; private String userImg; private String userMobile; private String userEmail; private String userSex; private Date userBirth; private Date userRegtime; private Date userModtime; }
5.创建DAO接口
tkMapper已经完成了对单表的通用操作的封装。封装在Mapper接口和
MySqlMapper接口中。因此如果我们想要完成对单表的操作,只需自定义dao接口继承这两个接口。
dao-UserDAO.java:
public interface UserDAO extends Mapper<User>,MySqlMapper<User>{
}
6.测试
@RunWith(SpringRunner.class)
@SpringBootTest(classes = TkmapperDemoApplication.class)
public class UserDAOTest{
@Autowired
private UserDAO userDAO;
@Test
public void test(){
User user = new User();
user.setUsername("aaaa");
user.setPassword("1111");
user.setUserImg("img/default.png");
user.setUserRegtime(new Date());
user.setUserModtime(new Date());
int i = userDAO.insert(user);
System.out.println(i)
}
}