MyBatis自动生成

用github的Mybatis generator自动生成mybatis文件、dao文件和service文件。

（https://github.com/mybatis/generator/releases）

1. generator.xml ：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
<!-- 数据库驱动包位置 -->
<classPathEntry location="D:/workspace/createDao/lib/mysql-connector-java-5.1.34.jar" /> 
<!-- <classPathEntry location="C:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar" />-->
<context id="DB2Tables">
<property name="autoDelimitKeywords" value="true"/>
<property name="beginningDelimiter" value="`"/>
<property name="endingDelimiter" value="`"/>

<commentGenerator type="org.mybatis.generator.DbCommentGenerator"/>

<!-- 数据库链接URL、用户名、密码 -->
<jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://172.28.17.222:32959/idccmdb" userId="bg_idcuser" password="GK(B8@ks^*JH"> 
<!--<jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver" connectionURL="jdbc:oracle:thin:@localhost:1521:orcl" userId="msa" password="msa">-->
</jdbcConnection>
<javaTypeResolver>
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<!-- 生成模型的包名和位置 -->
<javaModelGenerator targetPackage="com.chinanetcenter.service.itop.mybatis.entry" targetProject="D:\workspace\itop\itop-service\src\main\java">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<!-- 生成的映射文件包名和位置 -->
<sqlMapGenerator targetPackage="com.chinanetcenter.service.itop.mybatis.mapper" targetProject="D:\workspace\itop\itop-service\src\main\resources\mapper">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<!-- 生成DAO的包名和位置 -->
<javaClientGenerator type="XMLMAPPER" targetPackage="com.chinanetcenter.service.itop.mybatis.dao" targetProject="D:\workspace\itop\itop-service\src\main\java">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
<!-- 要生成那些表(更改tableName和domainObjectName就可以) -->

<!-- 
<table tableName="sys_menu"/>
<table tableName="sys_role" />
<table tableName="sys_role_menu" />
<table tableName="sys_user" />
<table tableName="sys_user_role" />
-->

<table tableName="view_power" />
<table tableName="view_networkdevice_interface" />
<table tableName="view_nic_convert_module" />
<table tableName="view_networkdevice_current_connect" />

</context>
</generatorConfiguration>

2.  _Service.ftl：生成service文件

package ${parentPackage}.service${morePackage};

import org.springframework.beans.factory.annotation.Autowired;

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;

import ${parentPackage}.mybatis.dao${morePackage}.*;
import ${parentPackage}.mybatis.entry${morePackage}.*;
import com.leweiyou.service.util.Commons;

import java.util.List;
import java.util.Set;

/**
 * 鍑℃槸浠寮�ご鐨凷ervice绫伙紝閮藉睘浜庤嚜鍔ㄧ敓鎴愮殑绫伙紝涓嶆彁鍊″湪杩欓噷娣诲姞service鏂规硶锛岃鍦╔XXXService绫婚噷鍔犺嚜瀹氫箟鏂规硶銆�
 * @author Zhangweican
 *
 */
public abstract class _${entryName}Service{


@Autowired
protected ${entryName}Mapper ${entityNameLowerCase}Mapper;


//================鏂规硶鑷姩鐢熸垚鍖�===============
    /**
     * 鏀寔鍒嗛〉鏌ヨ
     */
public PageInfo<${entryName}> selectByExample(${entryName}Example e,int offer, int limit) throws RuntimeException{
PageHelper.startPage(offer, limit);
PageInfo<${entryName}> page = new PageInfo<${entryName}>(${entityNameLowerCase}Mapper.selectByExample(e));
return page;
}

    /**
     * 鏌ヨ鍞竴瀵硅薄锛屽鏋滄病鏈夎褰曡繑鍥濶ull
     */
  public ${entryName} selectOne(${entryName}Example example) throws RuntimeException{
List<${entryName}> list = ${entityNameLowerCase}Mapper.selectByExample(example);
      return (list == null || list.size() == 0) ? null : list.get(0);
  }


    /**
     * 鏌ヨ璁板綍鏉℃暟
     */
public int countByExample(${entryName}Example example) throws RuntimeException{
        return ${entityNameLowerCase}Mapper.countByExample(example);
    }
}

3.  用MyBatisGeneratorTools生成mybatis文件，用 ServiceGeneratorToolsByFreemark生成service文件。