最近有个项目需要用到sql server 数据库,除了引用必需的jar包之外,还需比mysql多一个属性参数“catalog”,否则无法逆向,具体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>
<!-- 数据库驱动包位置 -->
<!-- <classPathEntry location="D:\generator\mysql-connector-java-5.1.21.jar" /> -->
<classPathEntry location="D:\generator\sqljdbc4.jar" />
<context id="DB2Tables" targetRuntime="MyBatis3">
<commentGenerator>
<property name="suppressAllComments" value="true" />
</commentGenerator>
<!-- 数据库链接URL、用户名、密码 -->
<!-- <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/sy" userId="sypro" password="sypro"> -->
<jdbcConnection driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver"
connectionURL="jdbc:sqlserver://192.168.11.111:1111;datebaseName=Student" userId="ROOT" password="123456">
</jdbcConnection>
<javaTypeResolver>
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<!-- 生成模型的包名和位置 -->
<javaModelGenerator targetPackage="com.shinoa.ssm.model" targetProject=".\src">
<property name="enableSubPackages" value="false" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<!-- 生成的映射文件包名和位置 -->
<sqlMapGenerator targetPackage="com.shinoa.ssm.mapper" targetProject=".\src">
<property name="enableSubPackages" value="false" />
</sqlMapGenerator>
<!-- 生成的映射文件包名和位置 -->
<javaClientGenerator type="XMLMAPPER" targetPackage="com.shinoa.ssm.mapper" targetProject=".\src">
<property name="enableSubPackages" value="false" />
</javaClientGenerator>
<!-- 要生成那些表(更改tableName和domainObjectName就可以) -->
<!-- ps:catalog属性必需输入,值为数据库名 -->
<table catalog="Student" tableName="Viscera_WangZhen" />
</context>
</generatorConfiguration>