mybatis代码生成

最新推荐文章于 2025-08-11 09:20:14 发布

原创最新推荐文章于 2025-08-11 09:20:14 发布 · 168 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #开发工具 #数据库

数据库专栏收录该内容

3 篇文章

订阅专栏

本文介绍如何使用Eclipse插件mybatisGenerator自动生成MyBatis相关代码，包括SQL映射文件及Java模型类等，有效减少代码重复工作。

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

自动生成 mybatis代码，特别是sqlmap文件，可以有效的减少dao等代码的重复劳动。
eclipse中添加插件： mybatis Generator - http://mybatis.googlecode.com/svn/sub-projects/generator/trunk/eclipse/UpdateSite/

添加生成代码的配置文件


<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE ibatorConfiguration PUBLIC "-//Apache Software Foundation//DTD Apache iBATIS Ibator Configuration 1.0//EN" "http://ibatis.apache.org/dtd/ibator-config_1_0.dtd" >

<ibatorConfiguration>
	<classPathEntry
		location="/home/xxx/xxx.war/WEB-INF/lib/mysql-connector-java-5.1.6.jar" />

<ibatorContext id="DB2Tables" targetRuntime="Ibatis2Java5">

        <!-- 去除自动生成的注释 -->  
        <commentGenerator>  
            <property name="suppressAllComments" value="true" />  
            <!-- 是否生成注释代时间戳  
             <property name="suppressDate" value="true" />  
             -->  
        </commentGenerator>  

		<jdbcConnection driverClass="com.mysql.jdbc.Driver"
			connectionURL="jdbc:mysql://localhost/test" userId="test"
			password="123456">
		</jdbcConnection>

		<javaTypeResolver>
			<property name="forceBigDecimals" value="false" />
		</javaTypeResolver>

		<javaModelGenerator targetPackage="test.model"
			targetProject="Test-web">
			<property name="enableSubPackages" value="true" />
			<property name="trimStrings" value="true" />
		</javaModelGenerator>

		<sqlMapGenerator targetPackage="test.dao"
			targetProject="Test-web">
			<property name="enableSubPackages" value="true" />
		</sqlMapGenerator>

		<!-- 生成DAO的类文件以及配置文件 -->
		<daoGenerator targetPackage="test.dao" targetProject="Test-web"
			type="GENERIC-CI" /> 

               <!-- 避免生成一大堆Example方法,代码看去清晰一些 -->
		<table tableName="user" domainObjectName="User"
			enableCountByExample="false" enableUpdateByExample="false"
			enableDeleteByExample="false" enableSelectByExample="false"
			selectByExampleQueryId="false">

 <!-- 去除一列，这样 PASSWORD这列就不会生成  
            <ignoreColumn column="PASSWORD"/>  
        -->    
        <!-- columnOverride 将数据库字段对应成javabean里面的字段  -->  
            <columnOverride column="USERID" property="userid" />  
            <columnOverride column="USERNAME" property="username" />  
            <columnOverride column="PASSWORD" property="password" />  
		</table>

	</ibatorContext>
</ibatorConfiguration>

在文件上点击鼠标右键，可以看到插件生成的选项，选择即可生成代码

daoGenerator 标签的类型，见如下链接.
http://ibatis.apache.org/docs/tools/abator/configreference/daoGenerator.html


IBATIS	The generated DAO objects will conform to the iBATIS DAO framework.
GENERIC-CI	The generated DAO objects will rely only on the SqlMapClient. The SqlMapClient will be supplied by constructor dependency injection.
GENERIC-SI	The generated DAO objects will rely only on the SqlMapClient. The SqlMapClient will be supplied by setter dependency injection.
SPRING	The generated DAO objects will conform to the Spring DAO framework.