<mapper namespace="com.jim.logstashmvc.dao.generated.mapper.ProductMapper">
 <resultMap id="BaseResultMap" type="com.jim.logstashmvc.dao.generated.entity.Product">
 <!--
  WARNING - @mbggenerated
 -->
 <id column="id" jdbcType="BIGINT" property="id" />
 <result column="name" jdbcType="VARCHAR" property="name" />
 </resultMap>
</mapper>

<!-- MyBatis -->
  <dependency>
   <groupId>org.mybatis</groupId>
   <artifactId>mybatis</artifactId>
   <version>${mybatis.version}</version>
  </dependency>

  <!-- Spring集成 -->
  <dependency>
   <groupId>org.mybatis</groupId>
   <artifactId>mybatis-spring</artifactId>
   <version>${mybatis.spring.version}</version>
  </dependency>

  <!-- MBG -->
  <dependency>
   <groupId>org.mybatis.generator</groupId>
   <artifactId>mybatis-generator-core</artifactId>
   <version>${MBG.version}</version>
   <scope>compile</scope>
   <optional>true</optional>
  </dependency>

  <!-- 分頁(yè) -->
  <dependency>
   <groupId>com.github.pagehelper</groupId>
   <artifactId>pagehelper</artifactId>
   <version>${pagehelper.version}</version>
  </dependency>

  <!-- 通用Mapper -->
  <dependency>
   <groupId>tk.mybatis</groupId>
   <artifactId>mapper</artifactId>
   <version>${mapper.version}</version>
  </dependency>

  <!-- TkMybatis 會(huì)使用到JPA的注解 -->
  <dependency>
   <groupId>javax.persistence</groupId>
   <artifactId>persistence-api</artifactId>
   <version>1.0</version>
  </dependency>

  <dependency>
   <groupId>org.postgresql</groupId>
   <artifactId>postgresql</artifactId>
   <version>9.3-1102-jdbc41</version>
  </dependency>

<!--MBG-->
   <plugin>
    <groupId>org.mybatis.generator</groupId>
    <artifactId>mybatis-generator-maven-plugin</artifactId>
    <version>${MBG.version}</version>
    <configuration>
     <configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>
     <overwrite>true</overwrite>
     <verbose>true</verbose>
    </configuration>
    <dependencies>
     <dependency>
      <groupId>org.postgresql</groupId>
      <artifactId>postgresql</artifactId>
      <version>9.3-1102-jdbc41</version>
     </dependency>

     <dependency>
      <groupId>tk.mybatis</groupId>
      <artifactId>mapper</artifactId>
      <version>${mapper.version}</version>
     </dependency>

    </dependencies>
   </plugin>

<bean id="jimDataSource" class="org.apache.commons.dbcp.BasicDataSource">
  <property name="driverClassName" value="${jdbc.driverClass}"/>
  <property name="url" value="${jdbc.url}"/>
  <property name="username" value="${jdbc.username}"/>
  <property name="password" value="${jdbc.password}"/>

  <property name="initialSize" value="5"/>
  <property name="minIdle" value="10"/>
  <property name="maxWait" value="60000"/>
  <property name="timeBetweenEvictionRunsMillis" value="60000"/>
  <property name="minEvictableIdleTimeMillis" value="3600000"/>
  <property name="validationQuery" value="SELECT 1"/>
  <property name="testWhileIdle" value="true"/>
  <property name="testOnBorrow" value="false"/>
  <property name="testOnReturn" value="false"/>
 </bean>

 <bean id="jimSqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  <property name="dataSource" ref="jimDataSource"/>
  <property name="mapperLocations" value="classpath:mapper/*.xml"/>
  <property name="typeAliasesPackage" value="com.jim.logstashmvc.dao.generated.entity"/>
  <property name="plugins">
   <array>
    <bean class="com.github.pagehelper.PageHelper">
     <property name="properties">
      <value>
      dialect=postgresql
      reasonable=true
      supportMethodsArguments=true
      returnPageInfo=check
      params=count=countSql
     </value>

     </property>
    </bean>
   </array>
  </property>

 </bean>

 <bean class="tk.mybatis.spring.mapper.MapperScannerConfigurer">
  <property name="sqlSessionFactoryBeanName" value="jimSqlSessionFactory"/>
  <property name="basePackage" value="com.jim.logstashmvc.dao.generated.mapper"/>
 </bean>

@Service
public interface IService<T> {

 T selectByKey(Object key);

 int save(T entity);

 int delete(Object key);

 int updateAll(T entity);

 int updateNotNull(T entity);

 List<T> selectByExample(Object example);

 //TODO 其他...
} 

public abstract class BaseService<T> implements IService<T> {

 @Autowired
 protected Mapper<T> mapper;

 public Mapper<T> getMapper() {
  return mapper;
 }

 @Override
 public T selectByKey(Object key) {
  return mapper.selectByPrimaryKey(key);
 }

 public int save(T entity) {
  return mapper.insert(entity);
 }

 public int delete(Object key) {
  return mapper.deleteByPrimaryKey(key);
 }

 public int updateAll(T entity) {
  return mapper.updateByPrimaryKey(entity);
 }

 public int updateNotNull(T entity) {
  return mapper.updateByPrimaryKeySelective(entity);
 }

 public List<T> selectByExample(Object example) {
  return mapper.selectByExample(example);
 }

 //TODO 其他...
} 

@Service
public class ProductServiceImpl extends BaseService<Product> implements ProductService {
 @Override
 public List<Product> selectByProduct(Product product, int page, int rows) {
  Example example = new Example(Product.class);
  Example.Criteria criteria = example.createCriteria();
  if(!StringUtils.isBlank(product.getName())){
   criteria.andEqualTo("name",product.getName());
  }
  if (product.getId() != null) {
   criteria.andEqualTo("id", product.getId());
  }
  PageHelper.startPage(page, rows);
  return selectByExample(example);

 }

}