MyBatis逆向工程生成的Example类的方法总结

小灰灰 2022-02-14 00:01 283阅读 0赞

**1.**mybatis逆向生成interface中方法详解

<table> 
 <tbody> 
  <tr> 
   <td>方法</td> 
   <td>说明</td> 
  </tr> 
  <tr> 
   <td> <pre>int countByExample(xxxxExample example)</pre> </td> 
   <td>根据相应条件计算记录数</td> 
  </tr> 
  <tr> 
   <td> <pre>int deleteByExample(xxxxExample example)</pre> </td> 
   <td>根据相应条件删除记录数</td> 
  </tr> 
  <tr> 
   <td> <pre>int updateByExample(@Param("xxxx") Xxxx xxxx, @Param("example") xxxxExample example)</pre> </td> 
   <td>根据相应条件插入数据</td> 
  </tr> 
  <tr> 
   <td> <pre>List&lt;TbAddress&gt; selectByExample(xxxxExample example)</pre> </td> 
   <td>根据相应条件查询数据</td> 
  </tr> 
  <tr> 
   <td> <pre>int deleteByPrimaryKey(Long id)</pre> </td> 
   <td>根据主键删除数据</td> 
  </tr> 
  <tr> 
   <td> <pre>Xxxx selectByPrimaryKey(Long id)</pre> </td> 
   <td>根据主键查询数据</td> 
  </tr> 
  <tr> 
   <td> <pre>int updateByPrimaryKey(Xxxx xxxx)</pre> </td> 
   <td>根据主键更新数据</td> 
  </tr> 
  <tr> 
   <td> <pre>int updateByExampleSelective(@Param("xxxx") Xxxx xxxx, @Param("example") XxxxExample example);</pre> </td> 
   <td>按条件更新不未null的字段</td> 
  </tr> 
  <tr> 
   <td> <pre>int insert(Xxxx xxxx)</pre> </td> 
   <td>全部字段都不未null,插入</td> 
  </tr> 
  <tr> 
   <td> <pre>int insertSelective(Xxxx xxxx)</pre> </td> 
   <td>插入不未null的字段</td> 
  </tr> 
  <tr> 
   <td> <pre>int updateByPrimaryKeySelective(Xxxx xxxx)</pre> </td> 
   <td>根据主键插入不null的字段记录</td> 
  </tr> 
 </tbody> 
</table>

2.example详解

mybatis 逆向生成的XxxxExample里面存储的是where语句中的相关条件。

使用方法：XxxxExample  example = new XxxxExample();

Criteria criteria = example.createCriteria();

<table> 
 <tbody> 
  <tr> 
   <td>方法</td> 
   <td>说明</td> 
   <td>在sql语句中的示例</td> 
  </tr> 
  <tr> 
   <td>example.setOrderByClause("字段名&nbsp; asc||desc")</td> 
   <td>根据相应字段进行升序/降序</td> 
   <td>order by xxx asc</td> 
  </tr> 
  <tr> 
   <td>example.setDistinct(false)</td> 
   <td>去除重复数据，true or false</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>criteria.andXxxIsNull()</td> 
   <td>添加字段为null</td> 
   <td>xxx is null</td> 
  </tr> 
  <tr> 
   <td>criteria.andXxxIsNotNull()</td> 
   <td>添加字段不为null</td> 
   <td>xxx is not null</td> 
  </tr> 
  <tr> 
   <td>criteria.andXxxEqualTo(value)</td> 
   <td>设置字段=value</td> 
   <td>xxx = value</td> 
  </tr> 
  <tr> 
   <td>criteria.andXxxEqualNotTo(value)</td> 
   <td>设置字段！=value</td> 
   <td>xxx! = value</td> 
  </tr> 
  <tr> 
   <td>criteria.andXxxGreaterThan(value)</td> 
   <td>设置字段&gt;value</td> 
   <td>xxx&gt;value</td> 
  </tr> 
  <tr> 
   <td>criteria.andXxxGreaterThanOrEqualTo(vlaue)</td> 
   <td>设置字段&gt;=value</td> 
   <td>xxx&gt;=value</td> 
  </tr> 
  <tr> 
   <td>criteria.andXxxlLessThan(value)</td> 
   <td>设置字段&lt;value</td> 
   <td>xxx&lt;value</td> 
  </tr> 
  <tr> 
   <td>criteria.andXxxLessThanOrEqualTo(value)</td> 
   <td>设置字段&lt;=value</td> 
   <td>xxx&lt;=value</td> 
  </tr> 
  <tr> 
   <td>criteria.andXxxIn(List&lt;?&gt; value)</td> 
   <td>包含相应字段值的集合</td> 
   <td>in (value1,value2,..)</td> 
  </tr> 
  <tr> 
   <td>criteria.andXxxNotIN(List&lt;?&gt; value)</td> 
   <td>不包含相应字段值的集合</td> 
   <td>in not (value1,value2,..)</td> 
  </tr> 
  <tr> 
   <td>criteria.andXxxLike("%"+value+"%")</td> 
   <td>你懂的</td> 
   <td>xxx Like “%value%”</td> 
  </tr> 
  <tr> 
   <td>criteria.andXxxNotLike("%"+value+"%")</td> 
   <td>你懂的</td> 
   <td>xxx not like “%value%”</td> 
  </tr> 
  <tr> 
   <td>criteria.andXxxBetween(value1,value2)</td> 
   <td>你懂的</td> 
   <td>between value1 and value2</td> 
  </tr> 
  <tr> 
   <td>criteria.andXxxNotBetween(value1,value2)</td> 
   <td>你懂的</td> 
   <td>&nbsp;not between value1 and value2</td> 
  </tr> 
 </tbody> 
</table>

持续更新。。。。