Mybatis持久层配置

曾经终败给现在 2022-08-17 13:28 209阅读 0赞

**Mybatis持久层配置**

用mybatis-generator-core-1.3.2.jar插件加jdbc数据库连接包自动导出springmvc持久层dao包，mapper包，model包。

操作准备：

下载：mybatis-generator-core-1.3.2.jar，mysql-connector-java-5.1.34.jar，ojdbc14-10.2.0.1.0.jar，sqljdbc4-4.0.jar包。

修改配置文件：generator.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:\JavaProject\generator\sqljdbc4-4.0.jar" /> 
    	
         
    	 
    	 
    	 
    	 
    	 
    	 
         
    	 
    	 <context id="MySQLTables" targetRuntime="MyBatis3" defaultModelType="conditional">
            
    		
    		
    		
    		
    		<commentGenerator>
                <property name="suppressAllComments" value="true" />
            </commentGenerator>
    		
            
    		
    		
            
    		
    		
    	    
    		
    		
             <jdbcConnection driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver" connectionURL="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=test" userId="test" password="1234"> 
    		 </jdbcConnection>
    		 
    		
        
            
    		
            
    		
            
    		
            
    		
            
    		
            
    	 
            
    		
            
    		
    		
            
    		
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
    		
            
            
    		
            <javaModelGenerator targetPackage="com.ouc.model" targetProject="D:\JavaProject\generator\src">
                <property name="enableSubPackages" value="true" />
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
    		
    		
            
            <sqlMapGenerator targetPackage="com.ouc.mapping" targetProject="D:\JavaProject\generator\src">
                <property name="enableSubPackages" value="true" />
            </sqlMapGenerator>
    		
            
            
    		
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.ouc.dao" targetProject="D:\JavaProject\generator\src">
                <property name="enableSubPackages" value="true" />
            </javaClientGenerator>
    		
            
    		
    		
    		<table tableName="V_SupplyUser" domainObjectName="VSupplyUser" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
    		<table tableName="dtproperties" domainObjectName="DtProperties" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
    		<table tableName="W_BadnessInfo" domainObjectName="WBadnessInfo" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
    	    <table tableName="WasterDayRecords" domainObjectName="WasterDayRecords" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
    		<table tableName="WJ_GateInfo" domainObjectName="WJGateInfo" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
    	    <table tableName="WJ_GateList" domainObjectName="WJGateList" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
    	</context>
    </generatorConfiguration>

打开cmd命令行，转到配置文件所在的文件下，执行如下生成语句：

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

![Center][]

![Center 1][]

![Center 2][]

[Center]: /images/20220731/3496dd4f24fb4bf3adb2838818ac3908.png
[Center 1]: /images/20220731/25b065e69af64428aca86b200f3722b6.png
[Center 2]: /images/20220731/b826ac51cb5e40f7ba5833ed87eaed6d.png