利用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>