功能说明

平台生成的业务对象对应的Mybatis文件：

Eg:
BasItem.java->BasItemMapper.xml->BasItemMapper.java->BasItemExample.java->BasItemService.java->BasItemServiceImpl.java

范例说明

1. Mybatis查询：以BasItem对象为例### 1. example.and()—– 最外面连接符为 and 多个condition的连接符为 and
   //创建 example
   BasItemExample example = BasItemExample.create();
   //排序字段
   example.setOrderByClause(” ITEM_CODE , CREATE_TIME”);
   //查询条件 1、添加条件 ITEM_NAME=’电视机’
   example.and().andCreateCondition(“ITEM_NAME”, Operation.EQ, “电视机”)
   //2、添加条件 CREATOR=’linjx’
   .andCreateCondition(“CREATOR”, Operation.EQ, “linjx”);
   //example 查询
   List basItems = basItemService.find(example);
   //SQL: select * from BAS_ITEM WHERE (ITEM_NAME = ? and CREATOR = ?) order by ITEM_CODE, CREATE_TIME
   ==> Parameters: 电视机(String), linjx(String)
2. example.andOr() —– 最外面连接符为 and 多个condition的连接符为 or
   //创建 example
   BasItemExample example = BasItemExample.create();
   //查询条件
   example.andOr().andCreateCondition(“ITEM_NAME”, Operation.EQ, “电视机”)
   .andCreateCondition(“CREATOR”, Operation.EQ, “linjx”);
   //example 查询
   List basItems = basItemService.find(example);
   //SQL: select * from BAS_ITEM WHERE (ITEM_NAME = ? OR CREATOR = ?)
   ==> Parameters: 电视机(String), linjx(String)
3. example.or() orAnd() —– 最外面连接符为 or多个condition的连接符为 and
   //创建 example
   BasItemExample example = BasItemExample.create();
   //查询条件
   example.or().andCreateCondition(“ITEM_NAME”, Operation.EQ, “电视机”)
   .andCreateCondition(“CREATOR”, Operation.EQ, “linjx”);
   //example 查询
   List basItems = basItemService.find(example);
   //SQL: select * from BAS_ITEM WHERE (ITEM_NAME = ? And CREATOR = ?)
   ==> Parameters: 电视机(String), linjx(String)
   由于代码上用or()加了2个条件，但是在or()添加条件之前example内不存在其他条件所以 最外面的连接符被系统去掉.
   //创建 example
   BasItemExample example = BasItemExample.create();
   //条件 ITEM_NAME=‘电视机’ and CREATOR=‘linjx’ or ITEM_NAME=‘BOOK’
   example.and().andCreateCondition(“ITEM_NAME”, Operation.EQ, “电视机”)
   .andCreateCondition(“CREATOR”, Operation.EQ, “linjx”);
   example.or(). andCreateCondition(“ITEM_NAME”, Operation.EQ, “book”)
   //example 查询
   List basItems = basItemService.find(example);
   //SQL: select * from BAS_ITEM WHERE (ITEM_NAME = ? And CREATOR = ?) or (ITEM_NAME=?)
   ==> Parameters: 电视机(String), linjx(String) , 衣服(String)
   由于Example的方式并不能完全满足复杂SQL查询，所以平台扩展了高级拼接查询语句.
4. 不带参数的查询
   example = BasItemExample.create();
   //查询条件
   example.and().andCreateCondition(” ITEM_CODE in(select a.ITEM_CODE from WMS_INB_ASN_DETAIL a where a.bar_code is not null)”);
   //example 查询
   basItems = basItemService.find(example);

//SQL: select * from BAS_ITEM WHERE ITEM_CODE in(select a.ITEM_CODE from WMS_INB_ASN_DETAIL a where a.bar_code is not null)

1. 带参数的查询
   example = BasItemExample.create();
   //查询条件
   String sqlCondition = ” ITEM_NAME=?”

+ “ and ITEM_CODE in(select a.ITEM_CODE from WMS_INB_ASN_DETAIL a where a.bar_code in(?,?,?))”; //in 语句知道了列表个数
sqlCondition += ” or (ITEM_NAME is not null and BAR_CODE is not null and ITEM_NAME like ?)”;
List