mybatis generator生成连接mysql与sqlserver的区别

最新推荐文章于 2025-05-14 20:08:23 发布

@CAPRICA@

最新推荐文章于 2025-05-14 20:08:23 发布

阅读量3.5k

点赞数

分类专栏： java

java 专栏收录该内容

18 篇文章

订阅专栏

本文介绍了使用MyBatisGenerator工具生成代码的基本配置方法，并对比了针对MySQL和SQL Server数据库的不同配置细节。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mybatis generator生成连接mysql与sqlserver所在的区别在于驱动和数据库URL不同

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">
       
    <generatorConfiguration>
        
       <!--数据库驱动包位置-->
        <classPathEntry location="...\mysql-connector-java-5.1.7-bin.jar" /> 
       
        <context id="DB2Tables" targetRuntime="MyBatis3">
            <commentGenerator> 
                <property name="suppressAllComments" value="true" /> 
            </commentGenerator> 
       
         <!--数据库URL、用户名、密码-->
            <jdbcConnection driverClass="com.mysql.jdbc.Driver" 
                connectionURL="jdbc:mysql://localhost/数据库" userId="登录名" password="密码"> 
            </jdbcConnection> 
          
           
            <javaTypeResolver> 
                <property name="forceBigDecimals" value="false" /> 
            </javaTypeResolver> 
     
          <!--生成模型包的位置 -->
            <javaModelGenerator targetPackage="fl.shopping.entity" 
                targetProject="E:\table"> 
                <property name="enableSubPackages" value="true" /> 
                <property name="trimStrings" value="true" /> 
            </javaModelGenerator> 
             
           <!--生成映射文件的包名和位置-->
            <sqlMapGenerator targetPackage="fl.shopping.mapping"  targetProject="E:\table"> 
                <property name="enableSubPackages" value="true" /> 
            </sqlMapGenerator> 
        
            <!--生成映dao的包名和位置-->
            <javaClientGenerator type="XMLMAPPER" 
                targetPackage="fl.shopping.dao" targetProject="E:\table"> 
                <property name="enableSubPackages" value="true" /> 
            </javaClientGenerator>
             
            <!--需要生成那些数据库（更改tableName和domainObjectName）-->
            <table tableName="users" domainObjectName="User" enableCountByExample="false" enableUpdateByExample="false"
            enableDeleteByExample="false"                enableSelectByExample="false" selectByExampleQueryId="false"  > 
            </table>
             
             
        </context> 
    </generatorConfiguration> 

连接sqlserver不同的在于：

<classPathEntry location="....\sqljdbc4-3.0.jar" /> 
 
<jdbcConnection driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver" 
                connectionURL="jdbc:sqlserver://localhost:1433;DatabaseName=数据库" userId="登录名" password="密码"> 
            </jdbcConnection> 