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接口继承这两个接口。
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)
}
}
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
文章由极客之音整理，本文链接：https://www.bmabk.com/index.php/post/128170.html
