iBatis 代码自动生成工具 iBator

来源:互联网 发布:淘宝买家怎么延长收货 编辑:程序博客网 时间:2024/06/05 07:55

利用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
原创粉丝点击