MyBatis Generator连接mysql数据库

ゝ一纸荒年。 2022-04-24 13:26 220阅读 0赞

<?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="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>

<?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>
        
        <properties resource="generator.properties"></properties>
     
        
        <classPathEntry location="${jdbc.driverLocation}"/>
     
        <context id="default" targetRuntime="MyBatis3">
     
            
            <commentGenerator>
                <property name="suppressDate" value="true"/>
                <property name="suppressAllComments" value="true"/>
            </commentGenerator>
     
            
            <jdbcConnection
                    driverClass="${jdbc.driverClass}"
                    connectionURL="${jdbc.connectionURL}"
                    userId="${jdbc.userId}"
                    password="${jdbc.password}">
            </jdbcConnection>
     
     
            
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
     
     
            
            <javaModelGenerator targetPackage="com.slx.zsxt.model"
                                targetProject="src/main/java">
     
                
                <property name="enableSubPackages" value="false"/>
                
                <property name="constructorBased" value="true"/>
                
                <property name="trimStrings" value="true"/>
                
                <property name="immutable" value="false"/>
            </javaModelGenerator>
     
            
            <sqlMapGenerator targetPackage="com.slx.zsxt.mapper"
                             targetProject="src/main/java">
                <property name="enableSubPackages" value="false"/>
            </sqlMapGenerator>
     
            
            <javaClientGenerator targetPackage="com.slx.zsxt.dao"
                                 targetProject="src/main/java" type="XMLMAPPER">
                <property name="enableSubPackages" value="true"/>
            </javaClientGenerator>
     
     
            <table tableName="reguser" domainObjectName="User"
                   enableCountByExample="false" enableUpdateByExample="false"
                   enableDeleteByExample="false" enableSelectByExample="false"
                   selectByExampleQueryId="false">
            </table>
     
            <table tableName="adminuser" domainObjectName="Admin"
                   enableCountByExample="false" enableUpdateByExample="false"
                   enableDeleteByExample="false" enableSelectByExample="false"
                   selectByExampleQueryId="false">
            </table>
            <table tableName="configinfo" domainObjectName="Confinfo"
                   enableCountByExample="false" enableUpdateByExample="false"
                   enableDeleteByExample="false" enableSelectByExample="false"
                   selectByExampleQueryId="false">
            </table>
            <table tableName="grade" domainObjectName="Grade"
                   enableCountByExample="false" enableUpdateByExample="false"
                   enableDeleteByExample="false" enableSelectByExample="false"
                   selectByExampleQueryId="false">
            </table>
            <table tableName="gradelog" domainObjectName="Gradelog"
                   enableCountByExample="false" enableUpdateByExample="false"
                   enableDeleteByExample="false" enableSelectByExample="false"
                   selectByExampleQueryId="false">
            </table>
            <table tableName="reginfo" domainObjectName="Reginfo"
                   enableCountByExample="false" enableUpdateByExample="false"
                   enableDeleteByExample="false" enableSelectByExample="false"
                   selectByExampleQueryId="false">
            </table>
        </context>
    </generatorConfiguration>

<?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="C:/Oracle/Middleware/wlserver_10.3/server/lib/ojdbc6.jar"/>
        <context id="my" targetRuntime="MyBatis3">
            <commentGenerator>
                <property name="suppressDate" value="false"/>
                <property name="suppressAllComments" value="true"/>
            </commentGenerator>
    
            <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                            connectionURL="jdbc:mysql://localhost:3306/HZY?characterEncoding=utf8"
                            userId="root"
                            password="123456"/>
    
            <javaModelGenerator targetPackage="com.thundersoft.entity"
                                targetProject="/home/user/MyProject/thunderemm/code2-ideal/smybatis/src/main/java">
                <property name="enableSubPackages" value="true"/>
                <property name="trimStrings" value="true"/>
            </javaModelGenerator>
    
            <sqlMapGenerator targetPackage="com.thundersoft.entity.xml"
                             targetProject="/home/user/MyProject/thunderemm/code2-ideal/smybatis/src/main/java">
                <property name="enableSubPackages" value="true"/>
            </sqlMapGenerator>
    
            <javaClientGenerator targetPackage="com.thundersoft.mapper"
                                 targetProject="/home/user/MyProject/thunderemm/code2-ideal/smybatis/src/main/java" type="XMLMAPPER">
                <property name="enableSubPackages" value="true"/>
            </javaClientGenerator>
    
    
            <table tableName="CTAS_FEE_BASE" domainObjectName="FeeBase"
                   enableCountByExample="false" enableUpdateByExample="false"
                   enableDeleteByExample="false" enableSelectByExample="false"
                   selectByExampleQueryId="false">
            </table>
    
        </context>
    </generatorConfiguration>

几个要点：  
a) 因为生成过程中需要连接db，所以第3行指定了驱动jar包的位置

b) 15-17行为连接字符串

c) 19-33行指定生成“entity实体类、mybatis映射xml文件、mapper接口”的具体位置

d) 40-46行为具体要生成的表，如果有多个表，复制这一段，改下表名即可