天天看点

MyBatis Generator 连接mysql数据库示例

<?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" >
<!-- 各元素配置说明:http://mbg.cndocs.ml/index.html -->
<generatorConfiguration>
	<classPathEntry
		location="C:\Users\Alex\.m2\repository\mysql\mysql-connector-java\5.1.21\mysql-connector-java-5.1.21.jar" />
	<context id="mysql">
		<jdbcConnection driverClass="com.mysql.jdbc.Driver"
			connectionURL="jdbc:mysql://数据库ip地址:数据库端口/数据库名?characterEncoding=utf8"
			userId="用户名" password="密码" />
		<javaModelGenerator targetPackage="javabean包路径"
			targetProject="项目名,这里注意和连oracle不一样">
		</javaModelGenerator>
		<sqlMapGenerator targetPackage="xml配置文件包路径"
			targetProject="项目名,这里注意和连oracle不一样">
		</sqlMapGenerator>
		<javaClientGenerator targetPackage="持久层包路径" type="XMLMAPPER"
			targetProject="项目名,这里注意和连oracle不一样">
		</javaClientGenerator>
		<table tableName="表名,注意此处mysql区分大小写">
		</table>
	</context>
</generatorConfiguration>