简洁版 只有基本的crud
通过解析数据的表反向生成逆向文件
导入pom依赖
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.example</groupId>
<artifactId>MyBatis_MBG</artifactId>
<version>1.0-SNAPSHOT</version>
<properties>
<maven.compiler.source>8</maven.compiler.source>
<maven.compiler.target>8</maven.compiler.target>
</properties>
<!-- 依赖MyBatis核心包 -->
<dependencies>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.7</version>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
</dependencies>
<!-- 控制Maven在构建过程中相关配置 -->
<build> <!-- 构建过程中用到的插件 -->
<plugins> <!-- 具体插件,逆向工程的操作是以构建过程中插件形式出现的 -->
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.3.0</version> <!-- 插件的依赖 -->
<dependencies> <!-- 逆向工程的核心依赖 -->
<dependency>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-core</artifactId>
<version>1.3.2</version>
</dependency> <!-- 数据库连接池 -->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.2</version>
</dependency> <!-- MySQL驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.8</version>
</dependency>
</dependencies>
</plugin>
</plugins>
</build>
</project>
创建逆向工程的配置文件
文件名必须是:generatorConfig.xml
报红不需要管
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
<!-- MyBatis3 生成带条件的crud-->
<context id="DB2Tables" targetRuntime="Mybatis3Simple">
<!-- 数据库连接配置 -->
<!-- 注意xml中不支持&,用&代替 -->
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/cs?characterEncoding=utf-8"
userId="root" password="root"></jdbcConnection>
<!-- 处理NUMERIC和DECIMAL类型的策略 -->
<javaTypeResolver>
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<!-- 配置pojo生成的位置 -->
<javaModelGenerator targetPackage="com.atguigu.mybatis.pojo" targetProject=".\src\main\java">
<!-- 是否使用子包-->
<property name="enableSubPackages" value="true" />
<!-- 去掉字符串前后空格-->
<property name="trimStrings" value="true" />
</javaModelGenerator>
<!-- 配置sql映射文件的生成位置 -->
<sqlMapGenerator targetPackage="com.atguigu.mybatis.mapper" targetProject=".\src\main\resources">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</sqlMapGenerator>
<!-- 配置dao接口的生成位置 -->
<!-- 接口路径要跟映射文件路径一致-->
<javaClientGenerator type="XMLMAPPER" targetPackage="com.atguigu.mybatis.mapper"
targetProject="src\main\java">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaClientGenerator>
<!-- 要逆向依据的数据表 -->
<!-- 表名和实体类类名-->
<table tableName="teacher" domainObjectName="Teach"></table>
</context>
</generatorConfiguration>
文件生成
双击运行这个插件
会帮你生成好实体类和接口
奢华版(带条件的crud)
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
<!-- MyBatis3 生成带条件的crud-->
<context id="DB2Tables" targetRuntime="MyBatis3">
<!-- 数据库连接配置 -->
<!-- 注意xml中不支持&,用&代替 -->
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/cs?characterEncoding=utf-8"
userId="root" password="root"></jdbcConnection>
<!-- 处理NUMERIC和DECIMAL类型的策略 -->
<javaTypeResolver>
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<!-- 配置pojo生成的位置 -->
<javaModelGenerator targetPackage="com.atguigu.mybatis.pojo" targetProject=".\src\main\java">
<!-- 是否使用子包-->
<property name="enableSubPackages" value="true" />
<!-- 去掉字符串前后空格-->
<property name="trimStrings" value="true" />
</javaModelGenerator>
<!-- 配置sql映射文件的生成位置 -->
<sqlMapGenerator targetPackage="com.atguigu.mybatis.mapper" targetProject=".\src\main\resources">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</sqlMapGenerator>
<!-- 配置dao接口的生成位置 -->
<!-- 接口路径要跟映射文件路径一致-->
<javaClientGenerator type="XMLMAPPER" targetPackage="com.atguigu.mybatis.mapper"
targetProject="src\main\java">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaClientGenerator>
<!-- 要逆向依据的数据表 -->
<!-- 表名和实体类类名-->
<table tableName="teacher" domainObjectName="Teach"></table>
</context>
</generatorConfiguration>
文件生成
双击运行这个插件
输出 success就是生成成功
使用
selectByExample 用条件来进行查询
selectByPrimaryKey 说明根据主键来查询
updateByExampleSelective 根据条件选择性修改
updateByExample 根据条件修改
updateByPrimaryKeySelective 根据主键选择性修改
updateByPrimaryKey 根据主键修改
package com.atguigu.mybatis.test;
import com.atguigu.mybatis.mapper.TeachMapper;
import com.atguigu.mybatis.pojo.Teach;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;
import javax.annotation.Resource;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
public class MBGtest {
@Test
public void testMBG(){
try {
InputStream resourceAsStream = Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory build = new SqlSessionFactoryBuilder().build(resourceAsStream);
SqlSession sqlSession = build.openSession(true);
TeachMapper mapper = sqlSession.getMapper(TeachMapper.class);
//查询所有数据
List<Teach> list = mapper.selectByExample(null);//没有条件就是查询所有
list.forEach(emp -> System.out.println(list));
} catch (IOException e) {
e.printStackTrace();
}
}
}
使用条件查询内容
package com.atguigu.mybatis.test;
import com.atguigu.mybatis.mapper.TeachMapper;
import com.atguigu.mybatis.pojo.Teach;
import com.atguigu.mybatis.pojo.TeachExample;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;
import javax.annotation.Resource;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
public class MBGtest {
@Test
public void testMBG(){
try {
InputStream resourceAsStream = Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory build = new SqlSessionFactoryBuilder().build(resourceAsStream);
SqlSession sqlSession = build.openSession(true);
TeachMapper mapper = sqlSession.getMapper(TeachMapper.class);
//获取条件查询
TeachExample teachExample = new TeachExample();
//让你的某个字段等于 3
//可以用链式结构一直往后and. and.and
//如果有其他条件 如 : or方法来连接
//teachExample.or().andDidIsNoNull 并且不为空
teachExample.createCriteria().andTidEqualTo(3);
//把条件放进去就会根据你的条件来获取返回内容
List<Teach> list = mapper.selectByExample(teachExample);//没有条件就是查询所有
list.forEach(emp -> System.out.println(list));
} catch (IOException e) {
e.printStackTrace();
}
}
}
修改
//根据主键修改 会匹配到相同的id然后修改
mapper.updateByPrimaryKey(new Teach(3,"admin"));
//选择性修改,如果属性值为null的内容不会变
mapper.updateByPrimaryKeySelective(new Teach(3,null));
数据连接失败
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
无法创建到数据库服务器的连接。
1.检查数据库和pow里的jar版本是否一致
2.检查有没有在逆向工程插件中添加SQL依赖