Springboot+MyBatis——通用Mapper

快来打我* 2022-02-17 10:57 389阅读 0赞

1，[新建一个Maven项目，并配置成Springboot框架+MyBatis持久层+druid连接池+MySQL数据库][Maven_Springboot_MyBatis_druid_MySQL]  
2，添加通用Mapper的依赖

<dependency>
            <groupId>tk.mybatis</groupId>
            <artifactId>mapper-spring-boot-starter</artifactId>//SpringBoot项目中添加该依赖
            <version>1.2.3</version>
        </dependency>

<dependency>
    	<groupId>tk.mybatis</groupId>
    	<artifactId>mapper</artifactId>//常规项目
    	<version>4.0.0</version>
    </dependency>

3，新增一个接口继承Mapper,MysqlMapper接口

public interface MyMapper<T> extends Mapper<T>,MySqlMapper<T>{
    }

4，编写实体类，并在类名添加 @table注解，成员变量添加 @Column注解

@Table(name="studentinfo")//name为表名
    public class Student {
    	@Column(name="stuno")//name为字段名
    	private Integer stuno;
    	@Column(name="stuname")
    	private String stuname;
    	@Column(name="stubirth")
    	private Date stubirth;
    	@Column(name="stusex")
    	private Integer stusex;
    	@Column(name="stuaddr")
    	private String stuaddr;
    	@Column(name="stutel")
    	private String stutel;
    	public Integer getStuno() {
    		return stuno;
    	}
    	public void setStuno(Integer stuno) {
    		this.stuno = stuno;
    	}
    	public String getStuname() {
    		return stuname;
    	}
    	public void setStuname(String stuname) {
    		this.stuname = stuname;
    	}
    	public Date getStubirth() {
    		return stubirth;
    	}
    	public void setStubirth(Date stubirth) {
    		this.stubirth = stubirth;
    	}
    	public Integer getStusex() {
    		return stusex;
    	}
    	public void setStusex(Integer stusex) {
    		this.stusex = stusex;
    	}
    	public String getStuaddr() {
    		return stuaddr;
    	}
    	public void setStuaddr(String stuaddr) {
    		this.stuaddr = stuaddr;
    	}
    	public String getStutel() {
    		return stutel;
    	}
    	public void setStutel(String stutel) {
    		this.stutel = stutel;
    	}
    	@Override
    	public String toString() {
    		return "Student [stuno=" + stuno + ", stuname=" + stuname + ", stubirth=" + stubirth + ", stusex=" + stusex
    				+ ", stuaddr=" + stuaddr + ", stutel=" + stutel + "]";
    	}
    }

5，编写对应的接口类实现自定义的Mapper类，并加上Mapper注解

@Mapper
    public interface TestMapper extends MyMapper<Student>{
    }

6，使用Service去调用

@Service
    public class TestService {
    	@Autowired
    	TestMapper testMapper;
    	public Object queryAllStudents() {
    		return testMapper.selectAll();
    	}
    }

7，使用控制器组件去调用Service组件

@Controller
    public class TestController {
    	Logger logger=LoggerFactory.getLogger(getClass());
    
    	@Autowired
    	TestService testService;
    
    	@RequestMapping("a")
    	@ResponseBody
    	public String test1() {
    		String str=JSON.toJSONString(testService.queryAllStudents());
    		logger.info(str);
    		return str;
    	}
    }

8，在浏览器中进行调用

[Maven_Springboot_MyBatis_druid_MySQL]: https://blog.csdn.net/weixin_40429030/article/details/89377506