<!-- 配置文件 -->
<configuration>
<properties resource="db.properties"></properties> <!--读取当前propertis文件-->
<settings>
<setting name="cacheEnabled" value="true"/> <!--开启二级缓存-->
<setting name="logImpl" value="LOG4J"/> <!--日志接口配置-->
</settings>
<typeAliases> <!-- 给返回值类型起别名 -->
<!-- <typeAlias type="com.crx.model" alias="a"/> -->
<package name="com.crx.model"/> <!-- 自动起别名customer -->
</typeAliases>
<typeHandlers> <!-- 常见的数据类型映射 类型处理器 --><!--
<typeHandler handler="h" javaType="java.util.Date" jdbcType="date"/>-->
</typeHandlers>
<environments default="development"> <!-- 配置所有数据源,并设置默认开发环境 -->
<environment id="development"> <!-- 开发环境 -->
<transactionManager type="JDBC"></transactionManager> <!-- 事物管理 -->
<dataSource type="POOLED"> <!-- 数据源,池连方式 -->
<property name="driver" value="${driverClassName}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</dataSource>
</environment>
<environment id="test">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<property name="driver" value="${driverClassName}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</dataSource>
</environment>
</environments>
<mappers> <!-- 配置所有可以执行sql的xml文件 -->
<mapper class="com.crx.mapper.CustomerMapper"/>
<mapper resource="mapper/CustomerMapper.xml"/>
</mappers>
</configuration>
逆向工程、
generatorConfig.xml文件、放在web工程下
<?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="mysqlTables" targetRuntime="MyBatis3">
<!-- 配置数据库连接 -->
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/douyin"
userId="root"
password="root">
</jdbcConnection>
<javaTypeResolver >
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<!-- 配置java Model生成 -->
<javaModelGenerator targetPackage="com.crx.model" targetProject=".\src">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<!-- 配置mapper.xml文件生成 -->
<sqlMapGenerator targetPackage="mapper" targetProject=".\config">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<!-- 配置Mapper.java 接口生成 -->
<javaClientGenerator type="XMLMAPPER" targetPackage="com.crx.mapper" targetProject=".\src">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
<!-- 选择要生成的数据库 -->
<table tableName="customer"></table>
<table tableName="video"></table>
</context>
</generatorConfiguration>
Generator、工具类
List<String> warnings = new ArrayList<>();
boolean overwrite = true;
File configFile = new File("generatorConfig.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的配置文件详解,包括环境配置、类型别名、类型处理器等核心组件设置,并展示了如何使用generatorConfig.xml进行数据库表到Java对象及Mapper接口的自动生成。
601

被折叠的 条评论
为什么被折叠?



