用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文件。