iBatis 代码自动生成工具 iBator

利用eclipse插件ibator生成代码。
右击ibatorConfig.xml配置文件,创建代码
1.创建前
这里写图片描述
2.创建后
这里写图片描述
3.ibatorConfig.xml配置文件详细代码

<?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="E:/myoracle/oracle/product/11.2.0/dbhome_1/jdbc/lib/ojdbc6.jar" />
    <ibatorContext id="bms">
        <jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
            connectionURL="jdbc:oracle:thin:@127.0.0.1:1521:orcl"
            userId="system" password="oracle" />

        <javaModelGenerator targetPackage="com.webserver.domain"
            targetProject="business_test" />
        <sqlMapGenerator
            targetPackage="com.webserver.sqlmapdao"
            targetProject="business_test" />
        <daoGenerator targetPackage="com.webserver.dao"
            targetProject="business_test" type="SPRING" />

        <!-- bms_account -->
        <table tableName="bms_account" domainObjectName="Account" >
          <generatedKey column="id" sqlStatement="SELECT BMS_ACCOUNT_SEQ.NEXTVAL FROM DUAL"/>
        </table>
        <!-- bms_account_role -->
        <table tableName="bms_account_role" domainObjectName="AccountRole" >
        </table>
        <!-- bms_role -->
        <table tableName="bms_role" domainObjectName="Role" >
          <generatedKey column="id" sqlStatement="SELECT BMS_ROLE_SEQ.NEXTVAL FROM DUAL"/>
        </table>
        <!-- bms_feature -->
        <table tableName="bms_feature" domainObjectName="Feature" >
          <generatedKey column="id" sqlStatement="SELECT BMS_FEATURE_SEQ.NEXTVAL FROM DUAL"/>
        </table>
        <!-- bms_feature_operation -->
        <table tableName="bms_feature_operation" domainObjectName="FeatureOperation" >
          <generatedKey column="id" sqlStatement="SELECT BMS_FEATURE_OPERATION_SEQ.NEXTVAL FROM DUAL"/>
        </table>
        <!-- bms_role_privilege -->
        <table tableName="bms_role_privilege" domainObjectName="RolePrivilege" >
          <generatedKey column="id" sqlStatement="SELECT BMS_ROLE_PRIVILEGE_SEQ.NEXTVAL FROM DUAL"/>
        </table>
        <!-- bms_operation -->
        <table tableName="bms_operation" domainObjectName="Operation" >
        </table>
        <!-- bms_employee -->
        <table tableName="bms_employee" domainObjectName="Employee" >
        <generatedKey column="id" sqlStatement="SELECT BMS_EMPLOYEE_SEQ.NEXTVAL FROM DUAL"/>
        </table>
        <!-- bms_employee_department -->
        <table tableName="bms_employee_department" domainObjectName="EmployeeDepartment" >
        </table>
        <!-- bms_department -->
        <table tableName="bms_department" domainObjectName="Department" >
        <generatedKey column="id" sqlStatement="SELECT BMS_DEPARTMENT_SEQ.NEXTVAL FROM DUAL"/>
        </table>
        <!-- bms_post -->
        <table tableName="bms_post" domainObjectName="Post" >
        <generatedKey column="id" sqlStatement="SELECT BMS_POST_SEQ.NEXTVAL FROM DUAL"/>
        </table>
        <!-- bms_agent -->
        <table tableName="bms_agent" domainObjectName="Agent" >
        <generatedKey column="id" sqlStatement="SELECT BMS_AGENT_SEQ.NEXTVAL FROM DUAL"/>
        </table>
        <!-- bms_agent_contact -->
        <table tableName="bms_agent_contact" domainObjectName="AgentContact" >
        <generatedKey column="id" sqlStatement="SELECT BMS_AGENT_CONTACT_SEQ.NEXTVAL FROM DUAL"/>
        </table>
        <!-- bms_product -->
        <table tableName="bms_product" domainObjectName="Product" >
        <generatedKey column="id" sqlStatement="SELECT BMS_PRODUCT_SEQ.NEXTVAL FROM DUAL"/>
        </table>
        <!-- bms_service -->
        <table tableName="bms_service" domainObjectName="Service" >
        <generatedKey column="id" sqlStatement="SELECT BMS_SERVICE_SEQ.NEXTVAL FROM DUAL"/>
        </table>
        <!-- bms_service_type -->
        <!-- 
        <table tableName="bms_service_type" domainObjectName="ServiceType" >
        <generatedKey column="id" sqlStatement="SELECT BMS_SERVICE_TYPE_SEQ.NEXTVAL FROM DUAL"/>
        </table>
         -->
        <!-- bms_task -->
        <table tableName="bms_task" domainObjectName="Task" >
        <generatedKey column="id" sqlStatement="SELECT BMS_TASK_SEQ.NEXTVAL FROM DUAL"/>
        </table>
        <!-- bms_remark -->
        <table tableName="bms_remark" domainObjectName="Remark" >
        <generatedKey column="id" sqlStatement="SELECT BMS_REMARK_SEQ.NEXTVAL FROM DUAL"/>
        </table>
        <!-- bms_contract -->
        <table tableName="bms_contract" domainObjectName="Contract" >
        <generatedKey column="id" sqlStatement="SELECT BMS_CONTRACT_SEQ.NEXTVAL FROM DUAL"/>
        </table>
        <!-- bms_purchase -->
        <table tableName="bms_purchase" domainObjectName="Purchase" >
        <generatedKey column="id" sqlStatement="SELECT BMS_PURCHASE_SEQ.NEXTVAL FROM DUAL"/>
        </table>
        <!-- bms_area -->
        <table tableName="bms_area" domainObjectName="Area" >
        <generatedKey column="id" sqlStatement="SELECT BMS_AREA_SEQ.NEXTVAL FROM DUAL"/>
        </table>
        <!-- bms_contract_history -->
        <table tableName="bms_contract_history" domainObjectName="ContractHistory" >
        <generatedKey column="id" sqlStatement="SELECT BMS_CONTRACT_HISTORY_SEQ.NEXTVAL FROM DUAL"/>
        </table>
        <!-- bms_purchase_history -->
        <table tableName="bms_purchase_history" domainObjectName="PurchaseHistory" >
        <generatedKey column="id" sqlStatement="SELECT BMS_PURCHASE_HISTORY_SEQ.NEXTVAL FROM DUAL"/>
        </table>
    </ibatorContext>
</ibatorConfiguration>
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值