MyBatis Generator 是MyBatis 官方出品的一款,用来自动生成MyBatis的 mapper、dao、entity 的框架,让我们省去规律性最强的一部分最基础的代码编写。
pom.xml文件- 引入web、mybatis、pagehelper和mysql依赖。
- generator插件引入mysql依赖,在配置文件中就可以省略引入mysql驱动。
- ${basedir} 为项目路径
Generator配置文件UTF-8 UTF-8 1.8 2.1.0 1.2.5 org.springframework.boot spring-boot-starter-web org.mybatis.spring.boot mybatis-spring-boot-starter ${mybatis.version} com.github.pagehelper pagehelper-spring-boot-starter ${mybatis.pagehelper.version} mysql mysql-connector-java runtime org.springframework.boot spring-boot-devtools runtime true org.springframework.boot spring-boot-starter-test test org.mybatis.generator mybatis-generator-maven-plugin 1.3.7 Generate MyBatis Artifacts package generate ${basedir}/src/main/resources/mybatis-generator/generatorConfig.xml true true mysql mysql-connector-java 8.0.17 org.mybatis.generator mybatis-generator-core 1.3.7 org.springframework.boot spring-boot-maven-plugin
- MyBatis Generator 详解可参考Generator详解 。
- 文件路径为 ${basedir}/src/main/resources/mybatis-generator/generatorConfig.xml。
配置文件
此处配置了pagehelper分页参数,稍后用到,引入分页。
#datasource config spring.datasource.driver-class-name=com.mysql.jdbc.Driver spring.datasource.username=root spring.datasource.password=123456 spring.datasource.url=jdbc:mysql://localhost:3306/test?serverTimezone=GMT ## mapper xml config mybatis.mapper-locations=classpath*:mapper/*Mapper.xml #mybatis.mapper-locations=classpath:mapper/*Mapper.xml mybatis.type-aliases-package=com.huzh.springbootmybatisgenerator.dao #Mybatis Generator config #dao类和实体类的位置 mybatis.project=src/main/java #mapper文件的位置 mybatis.resources=src/main/resources #pagehelper config pagehelper.helperDialect=mysql pagehelper.reasonable=true pagehelper.supportMethodsArguments=true pagehelper.params=count=countSql生成文件
双击即可生成 mapper、dao、entity文件
public class User implements Serializable {
private Long id;
private String name;
private Integer age;
private String email;
private static final long serialVersionUID = 1L;
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name == null ? null : name.trim();
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email == null ? null : email.trim();
}
@Override
public String toString() {
StringBuilder sb = new StringBuilder();
sb.append(getClass().getSimpleName());
sb.append(" [");
sb.append("Hash = ").append(hashCode());
sb.append(", id=").append(id);
sb.append(", name=").append(name);
sb.append(", age=").append(age);
sb.append(", email=").append(email);
sb.append(", serialVersionUID=").append(serialVersionUID);
sb.append("]");
return sb.toString();
}
}
mapper类
public interface UserMapper {
int deleteByPrimaryKey(Long id);
int insert(User record);
User selectByPrimaryKey(Long id);
Page selectAll();
int updateByPrimaryKey(User record);
}
xml映射文件
测试类delete from user where id = #{id,jdbcType=BIGINT} SELECT LAST_INSERT_ID() insert into user (`name`, age, email ) values (#{name,jdbcType=VARCHAR}, #{age,jdbcType=INTEGER}, #{email,jdbcType=VARCHAR} )update user set `name` = #{name,jdbcType=VARCHAR}, age = #{age,jdbcType=INTEGER}, email = #{email,jdbcType=VARCHAR} where id = #{id,jdbcType=BIGINT}
需要给UserMapper类添加@Mapper注解,否则会报错
@RunWith(SpringRunner.class)
@SpringBootTest
public class SpringbootMybatisGeneratorApplicationTests {
@Autowired
private UserMapper userMapper;
@Test
public void contextLoads() {
System.out.println("====================");
System.out.println(userMapper.selectAll());
}
}
添加分页
- UserMapper 中的selectAll方法返回类型修改为Page< User >。
@Mapper
public interface UserMapper {
int deleteByPrimaryKey(Long id);
int insert(User record);
User selectByPrimaryKey(Long id);
Page selectAll();
int updateByPrimaryKey(User record);
}
- 测试类
@RunWith(SpringRunner.class)
@SpringBootTest
public class SpringbootMybatisGeneratorApplicationTests {
@Autowired
private UserMapper userMapper;
@Test
public void contextLoads() {
System.out.println("====================");
PageHelper.startPage(1, 2);
Page userList = userMapper.selectAll();
System.out.println(userList);
}
}



