abator安装与使用
?
网上找了个工具abator,这个神奇的工具N年前就有了,唉,想想以前手写ibatis实体。。。,下面是安装步骤,用的meeclipse6.5,版本有些老,但胜在适用1.下载eclipse插件,这些废话不多说了,下面是截图
2.
3.我这里已安装好了,新增时点击New Remote Site...,在Name中输入"Abator for Eclipse Update Site",URL中输入"http://ibatis.apache.org/tools/abator",
新建一个工程,如下图
,在根目录下创建abatorConfig.xml,这里以mysql为例子
如下:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE abatorConfiguration PUBLIC "-//Apache Software Foundation//DTD Abator for iBATIS Configuration 1.0//EN" "http://ibatis.apache.org/dtd/abator-config_1_0.dtd" >
<abatorConfiguration >
? <abatorContext >
??? <jdbcConnection driverconnectionURL="jdbc:mysql://localhost:3306/menu" userId="root" password="root" >
????? <classPathEntry location="D:\jars\mysql-connector-java-5.1.5-bin.jar" />
??? </jdbcConnection>
??? <javaModelGenerator targetPackage="com.entity" targetProject="SSIbatisProject" />
??? <sqlMapGenerator targetPackage="com.dao.impl.sqlMap" targetProject="SSIbatisProject" />
??? <daoGenerator targetPackage="com.dao" targetProject="SSIbatisProject" type="SPRING" />
????? <table tableName="t_sys_menu" domainObjectName="TSystemMenu">
?????? <generatedKey column="MENU_ID" identity="true" sqlStatement="select last_insert_id() as cardId"/>
?????? <columnOverride column="NAME" property="name" javaType="java.lang.String" jdbcType="VARCHAR"/>
?????? <columnOverride column="CODE" property="code" javaType="java.lang.String" jdbcType="VARCHAR"/>
?????? <columnOverride column="REMARK" property="remark" javaType="java.lang.String" jdbcType="VARCHAR"/>
?????? <columnOverride column="PARENT_ID" property="parentId" javaType="java.lang.Integer" jdbcType="int"/>
?????? <columnOverride column="URL" property="url" javaType="java.lang.String" jdbcType="VARCHAR"/>
?????? <columnOverride column="SORT" property="sort" javaType="java.lang.Integer" jdbcType="int"/>
?????? <columnOverride column="STATUS" property="status" javaType="java.lang.Integer" jdbcType="int"/>
?????? <columnOverride column="CREATE_BY" property="createBy" javaType="java.lang.String" jdbcType="VARCHAR"/>
?????? <columnOverride column="CREATE_DATE" property="createDate" javaType="java.util.Date" jdbcType="date"/>
?????? <columnOverride column="LAST_UPATE_DATE" property="lastUpateDate" javaType="java.util.Date" jdbcType="date"/>
?????? <columnOverride column="LAST_UPDATE_BY" property="lastUpdateBy" javaType="java.lang.String" jdbcType="VARCHAR"/>
??? </table>
? </abatorContext>
</abatorConfiguration>
?
?
关键地方:driverClass:驱动类型,connectionURL:连接数据库,userId:用户名,password:密码,classPathEntry location:mysql的jar包
javaModelGenerator targetPackage:实体保存路径,会生成实体与Example
sqlMapGenerator targetPackage:执行sql语句
daoGenerator targetPackage:DAO文件路径,生成dao与daoimpl
targetProject:指向的工程
table tableName:数据库表名
domainObjectName:java实体名称
注意:mysql中的表名称需要写成下列格式
? <table tableName="t_sys_menu" domainObjectName="TSystemMenu">
,domain加在jdbcConnection 中的connectionURL中,例如? <jdbcConnection driverconnectionURL="jdbc:mysql://localhost:3306/menu" userId="root" password="root" >
完了右击abatorConfig.xml,执行Generate iBAIS Aritifacts,自动生成实体,SQL以及DAOIMP,呵呵
?
?