注:【网页版】右上方的悬浮框( 有目录索引 )
IDEA 工具 创建 Maven 项目工程
一、配置步骤
1-1】pom.xml 中导入依赖
<!-- 分页工具 -->
<!-- https://mvnrepository.com/artifact/com.github.pagehelper/pagehelper -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.2</version>
</dependency>
<!-- mybatis 逆向工程 -->
<!-- https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core -->
<dependency>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-core</artifactId>
<version>1.3.7</version>
</dependency>
<!-- servlet-api -->
<!-- https://mvnrepository.com/artifact/javax.servlet/servlet-api -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
<scope>provided</scope>
</dependency>
<!-- jstl -->
<!-- https://mvnrepository.com/artifact/jstl/jstl -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!-- mysql -->
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.40</version>
</dependency>
<!-- c3p0 -->
<!-- https://mvnrepository.com/artifact/c3p0/c3p0 -->
<dependency>
<groupId>c3p0</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.1.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-aspects -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aspects</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<!-- mybatis-spring -->
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.2</version>
</dependency>
<!-- mybatis -->
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.2</version>
</dependency>
<!-- spring -->
<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<!-- springMVC -->
<!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<!-- 支持ajax向页面传输数据的依赖 -->
<!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind -->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.9.9.3</version>
</dependency>
1-2】web.xml 配置相关属性
<!-- 过滤乱码的情况(字符编码过滤器)-->
<filter>
<filter-name>CharacterEncodingFilter</filter-name><!--[译:字符编码过滤器]-->
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>utf-8</param-value>
</init-param>
<init-param>
<param-name>forceRequestEncoding</param-name>
<param-value>true</param-value>
</init-param>
<init-param>
<param-name>forceResponseEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>CharacterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- post转换为 delete 和put -->
<filter>
<filter-name>HiddenHttpMethodFilter</filter-name><!--[译:隐藏的超文本传输协议 方法过滤器]-->
<filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>HiddenHttpMethodFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- 能支持servlet运行的文件 -->
<servlet>
<servlet-name>springDispatcherServlet</servlet-name><!--[译:Spring 分发器]-->
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>springDispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!-- ioc容器模块 -->
<context-param>
<param-name>contextConfigLocation</param-name><!--[译:上下文配置地址]-->
<param-value>classpath:applicatonContext.xml</param-value>
<!--指代:resources 下 applicatonContext.xml( resources右键,选中XMLConfigurationFile,新建 Spring Config。此处先空着)-->
</context-param>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class><!--[译:上下文加载监听]-->
</listener>
1-3】WEB-INF 下 SpringMVC 配置文件(springDispatcherServlet-servlet.xml)
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd">
<!--1 配置扫描的包,只扫描 controller -->
<context:component-scan base-package="com.debj" use-default-filters="false">
<context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
</context:component-scan>
<!--2 配置视图解析器 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/views/"/>
<property name="suffix" value=".jsp"/>
</bean>
<!--3 加入外部资源的适配器 -->
<mvc:default-servlet-handler/> <!--默认的程序管理员-->
<mvc:annotation-driven/> <!--注解驱动-->
</beans>
1-4】resources 下 applicatonContext.xml 及 内部引入的外部资源
【1-4-1】db.properties,数据库连接信息(内部将要引入)
driverClass=com.mysql.jdbc.Driver
jdbcUrl=jdbc:mysql://localhost:3306/test?characterEncoding=utf8
user=root
password=root
【1-4-2】mybatis-config.xml,MyBatis 配置文件(内部将要引入)
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<!--[译:配置]-->
<configuration>
<!--1 别名 处理器 [译:类型别名] -->
<typeAliases>
<package name="com.debj.entity"/>
</typeAliases>
<!--2 分页操作 [译:插件、拦截]-->
<plugins>
<plugin interceptor="com.github.pagehelper.PageInterceptor" />
</plugins>
</configuration>
【1-4-3】applicatonContext.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<!--1 扫描包除了 controller 以外的包 -->
<context:component-scan base-package="com.debj" >
<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
</context:component-scan>
<!--2 引入外部文件,配置数据源,spring 和 mybatis 整合的配置 -->
<context:property-placeholder location="classpath:db.properties"/>
<bean class="com.mchange.v2.c3p0.ComboPooledDataSource" id="dataSource">
<property name="driverClass" value="${driverClass}"/>
<property name="jdbcUrl" value="${jdbcUrl}"/>
<property name="user" value="${user}"/>
<property name="password" value="${password}"/>
</bean>
<!--3 引入外部文件,配置扫描器将 mybatis 的接口文件放入到 ioc 容器中 -->
<bean class="org.mybatis.spring.SqlSessionFactoryBean" id="sqlSessionFactory">
<property name="configLocation" value="classpath:mybatis-config.xml"/>
<property name="dataSource" ref="dataSource"/>
<!--本文件中 ComboPooledDataSource 类的 bean-->
<property name="mapperLocations" value="classpath:mapper/*.xml"/>
</bean>
<!--4 批量处理数据的位置 -->
<bean class="org.mybatis.spring.SqlSessionTemplate" id="sqlSessionTemplate">
<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"/>
<!--本文件中 SqlSessionFactoryBean 类的 bean-->
<constructor-arg name="executorType" value="BATCH"/> <!--批处理-->
</bean>
<!--5 配置 mapper 包下的接口-->
<bean id="mapperScanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.debj.dao"/>
</bean>
<!--6 配置事务的控制[译:数据源事务管理器] -->
<bean class="org.springframework.jdbc.datasource.DataSourceTransactionManager" id="transactionManager">
<property name="dataSource" ref="dataSource"/>
<!-- 本文件中 ComboPooledDataSource 类的 bean-->
</bean>
<!--7 开启基于注解的事务 -->
<aop:config>
<aop:pointcut id="txPoint" expression="execution(* com.debj.service..*(..))"/> <!-- .. 表示多个参数 -->
<aop:advisor advice-ref="txAdvice" pointcut-ref="txPoint"/>
</aop:config>
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="*"/>
<tx:method name="get*" read-only="true"/>
<!-- 给所有方法配置事务,get??? 的方法为只读 -->
</tx:attributes>
</tx:advice>
</beans>
二、MyBatis 逆向工程
1-1】创建表并添加数据
# 需按顺序执行,有外键联系,删除则反之
CREATE TABLE `tbl_dept` (
`dept_id` int(25) NOT NULL AUTO_INCREMENT,
`dept_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`dept_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
CREATE TABLE `tbl_emp` (
`emp_id` int(25) NOT NULL AUTO_INCREMENT,
`emp_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`gender` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`d_id` int(25) DEFAULT NULL,
PRIMARY KEY (`emp_id`),
KEY `fk_dept_id` (`gender`),
KEY `d_id` (`d_id`),
CONSTRAINT `tbl_emp_ibfk_1` FOREIGN KEY (`d_id`) REFERENCES `tbl_dept` (`dept_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
INSERT INTO `test`.`tbl_dept` (`dept_id`, `dept_name`) VALUES ('1', '市场部');
INSERT INTO `test`.`tbl_dept` (`dept_id`, `dept_name`) VALUES ('2', '开发部');
INSERT INTO `test`.`tbl_emp` (`emp_name`, `gender`, `email`, `d_id`) VALUES ('居壹', '1', 'adFpgu@163.com', '1');
INSERT INTO `test`.`tbl_emp` (`emp_name`, `gender`, `email`, `d_id`) VALUES ('居贰', '0', 'adAdfm@163.com', '2');
1-2】配置 mbg.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>
<context id="DB2Tables" targetRuntime="MyBatis3">
<!--1:连接数据库的配置-->
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/test"
userId="root"
password="root">
</jdbcConnection>
<javaTypeResolver >
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<!--java生成bean 的位置-->
<javaModelGenerator
targetPackage="com.debj.entity"
targetProject=".\src\main\java">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<!--生成映射文件的位置-->
<sqlMapGenerator
targetPackage="mapper"
targetProject=".\src\main\resources">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<!--生成接口文件的位置-->
<javaClientGenerator type="XMLMAPPER"
targetPackage="com.debj.dao"
targetProject=".\src\main\java">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
<!--映射表生成实体类-->
<table tableName="tbl_emp" domainObjectName="Employee"/>
<table tableName="tbl_dept" domainObjectName="Department"/>
</context>
</generatorConfiguration>
1-3】测试代码
Running MyBatis Generator With Java
package com.debj.test;
import org.mybatis.generator.api.MyBatisGenerator;
import org.mybatis.generator.config.Configuration;
import org.mybatis.generator.config.xml.ConfigurationParser;
import org.mybatis.generator.internal.DefaultShellCallback;
import java.io.File;
import java.util.ArrayList;
import java.util.List;
public class TestGenertor {
public static void main(String[] args) throws Exception {
List<String> warnings = new ArrayList<String>();
boolean overwrite = true;
File configFile = new File("mbg.xml");
ConfigurationParser cp = new ConfigurationParser(warnings);
Configuration config = cp.parseConfiguration(configFile);
DefaultShellCallback callback = new DefaultShellCallback(overwrite);
MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
myBatisGenerator.generate(null);
}
}
三、修改 MyBatis 逆向工程的代码
根据表的信息,自动生成实体类、接口、mapper SQL 映射文件 和一些基本语句
3-1】实体类相关修改
// Employee 中添加新属性
private Department department;
/* 生成:有参、无参构造方法;生成 get/set 方法;重写 toString 方法 */
// Department
/* 生成:有参、无参构造文法;重写 toString 方法 */
3-2】EmployeeMapper 接口,新增方法
// 本有代码
List<Employee> selectByExample(EmployeeExample example);
Employee selectByPrimaryKey(Integer empId);
// 因 实体类 Employee 中新增一属性(Department 对象),查询的相关方法,新增两个
List<Employee> selectByExampleWithDepartment(EmployeeExample example);
Employee selectByPrimaryKeyWithDepartment(Integer empId);
3-3】EmployeeMapper.xml 新增 sql 映射语句
<!--
新增 resultMap
-->
<resultMap id="WithDept" type="com.debj.entity.Employee">
<id column="emp_id" jdbcType="INTEGER" property="empId" />
<result column="emp_name" jdbcType="VARCHAR" property="empName" />
<result column="gender" jdbcType="CHAR" property="gender" />
<result column="email" jdbcType="VARCHAR" property="email" />
<result column="d_id" jdbcType="INTEGER" property="dId" />
<association property="department" javaType="com.debj.entity.Department">
<id property="deptId" column="dept_id"/>
<result property="deptName" column="dept_name"/>
</association>
</resultMap>
<!--
新增内容
-->
<sql id="WithDept_Column_List">
e.emp_id,e.emp_name,e.gender,e.email,e.d_id,d.dept_id,d.dept_name
</sql>
<select id="selectByExampleWithDepartment" parameterType="com.debj.entity.EmployeeExample" resultMap="WithDept">
select
<if test="distinct">
distinct
</if>
<include refid="WithDept_Column_List" />
FROM tbl_emp e
LEFT JOIN tbl_dept d
ON e.d_id = d.dept_id
<if test="_parameter != null">
<include refid="Example_Where_Clause" />
</if>
<if test="orderByClause != null">
order by ${orderByClause}
</if>
</select>
<select id="selectByPrimaryKeyWithDepartment" parameterType="java.lang.Integer" resultMap="WithDept">
select
<include refid="WithDept_Column_List" />
FROM tbl_emp e
LEFT JOIN tbl_dept d
ON e.`d_id` =d.`dept_id`
where emp_id = #{empId,jdbcType=INTEGER}
</select>
- 与原代码相对比我们不难发现:一改变的是 sql 查询语句的列集。二改变的是 sql 查询语句的返回结果集。
3-4】测试
package com.debj.test;
import com.debj.dao.EmployeeMapper;
import com.debj.entity.Employee;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import java.util.List;
public class TestDao {
public static void main(String[] args) {
ClassPathXmlApplicationContext ctx = new ClassPathXmlApplicationContext("applicatonContext.xml");
/* DepartmentMapper mapper = ctx.getBean(DepartmentMapper.class);
Department department = new Department(3,"YF");
mapper.insertSelective(department);*/
EmployeeMapper bean = ctx.getBean(EmployeeMapper.class);
/* Employee employee = new Employee();
employee.setEmpName("zhangsan");
employee.setEmail("zhangsan@163.com");
bean.insertSelective(employee);*/
// 查询全部信息
List<Employee> employees = bean.selectByExampleWithDepartment(null);
System.out.println(employees);
//批量添加数据
/* Employee employee = new Employee();
for(int i=0;i<200;i++){
String uuid = UUID.randomUUID().toString().substring(0, 5);
employee.setEmpName(uuid);
employee.setEmail(uuid+"@163.com");
employee.setGender("M");
bean.insertSelective(employee);
}*/
}
}