Windows 通过CMD窗口利用mybatis-generator连接Oracle快速生成代码

怼烎@ 2023-10-10 11:44 3阅读 0赞

环境说明：Windows10、JDK8、ojdbc6-11.2.0.4.jar、mybatis-generator-core-1.3.7.jar

1、在C盘新建autoMybatis文件夹，文件夹中新建generator.xml文件，并将ojdbc6-11.2.0.4.jar 和mybatis-generator-core-1.3.7.jar拷贝至当前文件夹中：

整体截图:

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70][]

配置文件如下:

<?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="ojdbc6-11.2.0.4.jar"/>
    	
    	<context id="oracle" targetRuntime="MyBatis3">
    		<commentGenerator>
    			
    			<property name="suppressAllComments" value="true" />
    		</commentGenerator>
    		
    		<jdbcConnection driverClass="oracle.jdbc.OracleDriver"
    			connectionURL="jdbc:oracle:thin:@127.0.0.1:1521:orcl" 
    			userId="******"
    			password="******">
    		</jdbcConnection> 
    
    		
    		<javaTypeResolver>
    			<property name="forceBigDecimals" value="false" />
    		</javaTypeResolver>
    
    		
    		<javaModelGenerator targetPackage="com.digipwoer.online.entity"
    			targetProject="C:\autoMybatis\entity">
    			
    			<property name="enableSubPackages" value="false" />
    			
    			<property name="trimStrings" value="true" />
    		</javaModelGenerator>
            
            
    		<sqlMapGenerator targetPackage="mapper.erms" 
    			targetProject="C:\autoMybatis\mapper">
    			<property name="enableSubPackages" value="false" />
    		</sqlMapGenerator>
    		
    		
    		<javaClientGenerator type="XMLMAPPER" targetPackage="com.digipower.erms.mapper" 
    			targetProject="C:\autoMybatis\xml">
    			<property name="enableSubPackages" value="false" />
    			<property name="rootClass" value="com.digipower.erms.common.model.BaseModel"/>
    		</javaClientGenerator>
    		
    		 
    
    		 <table tableName="t_construction_project" domainObjectName="TConstructionProject"    
                    enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"    
                    enableSelectByExample="false" selectByExampleQueryId="false" >
             </table> 
    		 
    		 <table tableName="t_singleproject" domainObjectName="TSingleProject"    
                    enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"    
                    enableSelectByExample="false" selectByExampleQueryId="false" >
             </table> 
    		 
    		 <table tableName="a_single_project" domainObjectName="ASingleProject"    
                    enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"    
                    enableSelectByExample="false" selectByExampleQueryId="false" >
             </table> 
    		 
    		 <table tableName="b_single_project" domainObjectName="BSingleProject"    
                    enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"    
                    enableSelectByExample="false" selectByExampleQueryId="false" >
             </table> 
    		 
    		 <table tableName="c_single_project" domainObjectName="CSingleProject"    
                    enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"    
                    enableSelectByExample="false" selectByExampleQueryId="false" >
             </table> 
    		 
    		 <table tableName="d_single_project" domainObjectName="DSingleProject"    
                    enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"    
                    enableSelectByExample="false" selectByExampleQueryId="false" >
             </table> 
    		 
    		  <table tableName="e_single_project" domainObjectName="ESingleProject"    
                    enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"    
                    enableSelectByExample="false" selectByExampleQueryId="false" >
             </table> 
    		 
    		  <table tableName="f_single_project" domainObjectName="FSingleProject"    
                    enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"    
                    enableSelectByExample="false" selectByExampleQueryId="false" >
             </table> 
    		 
    		  <table tableName="g_single_project" domainObjectName="GSingleProject"    
                    enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"    
                    enableSelectByExample="false" selectByExampleQueryId="false" >
             </table> 
    		 
    		  <table tableName="h_single_project" domainObjectName="HSingleProject"    
                    enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"    
                    enableSelectByExample="false" selectByExampleQueryId="false" >
             </table> 
    		 
    		  <table tableName="i_single_project" domainObjectName="ISingleProject"    
                    enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"    
                    enableSelectByExample="false" selectByExampleQueryId="false" >
             </table>
    
    		<table tableName="j_single_project" domainObjectName="JSingleProject"    
                    enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"    
                    enableSelectByExample="false" selectByExampleQueryId="false" >
             </table> 
    
            <table tableName="k_single_project" domainObjectName="KSingleProject"    
                    enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"    
                    enableSelectByExample="false" selectByExampleQueryId="false" >
             </table> 	
    		<table tableName="l_single_project" domainObjectName="LSingleProject"    
                    enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"    
                    enableSelectByExample="false" selectByExampleQueryId="false" >
             </table> 		 
    		
    	</context>
    </generatorConfiguration>

2、打开CMD命令行，切换到autoMybatis路径下，执行以下命令：

java -jar mybatis-generator-core-1.3.7.jar -configfile generator.xml -overwrite

3、提示错误信息：无法加载Oracle的驱动，

截图待补充：

解决办法:在 `generatorConfig.xml` 文件中配置`<classPathEntry>` 元素

![20201104184553238.png][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20201104184229917.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n,size_16,color_FFFFFF,t_70
[20201104184553238.png]: https://img-blog.csdnimg.cn/20201104184553238.png