通用mapper整合mybatis,相同的CRUD没有必要编写,使用插件,例如:mapper(提供了最基本的CRUD功能,继承他接口即可)
使用mapper
1,加入起步依赖
<dependency>
<groupId>tk.mybatis</groupId>
<artifactId>mapper-spring-boot-starter</artifactId>
<version>2.
在pojo模块中添加jpa起步依赖
<!--jpa注解-->
<dependency>
<groupId>javax.persistence</groupId>
<artifactId>persistence-api</artifactId>
<version>1.0</version>
<scope>compile</scope>
</dependency>
然后service在依赖pojo模块
<!--商品微服务api,包含了pojo,和feign-->
<dependency>
<groupId>com.changgou</groupId>
<artifactId>changgou-service-goods-api</artifactId>
<version>1.0-SNAPSHOT</version>
</dependency>
2,创建pojo,并且使用jpa的注解来建立映射关系
package com.changgou.goods.pojo;
import javax.persistence.*;
import java.io.Serializable;
/****
* @Author:admin
* @Description:Brand构建
* @Date 2019/6/14 19:13
*****/
@Table(name = "tb_brand")
public class Brand implements Serializable {
//标识他是一个主键
@Id
//设置生成主键的策略: 为自增
@GeneratedValue(strategy = GenerationType.IDENTITY)
// column 针对 数据库的表中的字段建立映射关系
@Column(name = "id")
private Integer id;//品牌id
@Column(name = "name")
private String name;//品牌名称
@Column(name = "image")
private String image;//品牌图片地址
@Column(name = "letter")
private String letter;//品牌的首字母
@Column(name = "seq")
private Integer seq;//排序
//get方法
public Integer getId() {
return id;
}
//set方法
public void setId(Integer id) {
this.id = id;
}
//get方法
public String getName() {
return name;
}
//set方法
public void setName(String name) {
this.name = name;
}
//get方法
public String getImage() {
return image;
}
//set方法
public void setImage(String image) {
this.image = image;
}
//get方法
public String getLetter() {
return letter;
}
//set方法
public void setLetter(String letter) {
this.letter = letter;
}
//get方法
public Integer getSeq() {
return seq;
}
//set方法
public void setSeq(Integer seq) {
this.seq = seq;
}
}
3,创建Dao继承mapper
package com.changgou.goods.dao;
import com.changgou.goods.pojo.Brand;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;
import java.util.List;
/**
* Mapper<Brand>表示操作Brand pojo
*/
public interface BrandMapper extends Mapper<Brand> {
@Select(value = "select * from tb_brand")
public List<Brand> findAll();
}
4, 组件扫描接口的包路径,一定要使用mapper提供的,import tk.mybatis.spring.annotation.MapperScan;这个包下面的。
package com.changgou;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.cloud.netflix.eureka.EnableEurekaClient;
import tk.mybatis.spring.annotation.MapperScan;
@SpringBootApplication
@EnableEurekaClient //开启eureka客户端
//扫秒指定包下的所有接口,为接口产生代理对象交给spring容器进行管理,mapper扫描
//@MapperScan(basePackages = "com.changgou.goods.dao")
@MapperScan(basePackages = "com.changgou.goods.dao")
public class GoodsApplication {
public static void main(String[] args) {
SpringApplication.run(GoodsApplication.class,args);
}
}
也可以用mybatis-plus