@EnableTransactionManagement
@ScanEntity({"top.sanguohf.egg.test.entity"})
@SpringBootApplication
public class YangSqlTest {
    public static void main(String[] args) {
        SpringApplication.run(YangSqlTest.class);
    }
}

@Data
@TableName("user")
public class User {
    @Id
    @Field("user_name")
    private String userName;
    private String password;
    protected String id;
    private BigDecimal price;
}

@RunWith(SpringRunner.class)
@SpringBootTest
public class TestOne {

    @Autowired
    private CommonService commonService;
    @Test
    public void test3() throws NoSuchFieldException, IOException, ClassNotFoundException 		{
        EntityParams params = new EntityParams();
        params.setTableClassName("User");
        List list = commonService.findList(params);
    }
}

@Data
public class EntityParams {
    private String tableClassName;

    private JSONObject condition;
    private List<EntityOrderBy> orderBy;

    public List<EntityOrderBy> getOrderBy() {
        if(orderBy==null)
            orderBy=new LinkedList<>();
        return orderBy;
    }
}

public ResponseResult findPageList(@RequestBody BatisPage<XfSalestype> xfSalestype) throws Exception {
        XfSalestype xf = xfSalestype.getCondition() == null ? new XfSalestype() : xfSalestype.getCondition();
        EntityConditionBuilder builder = EntityConditionBuilder.getInstance().eq("dr", DelState.NORMAL);
        if (!StringUtils.isEmpty(xf.getScode())) {
            builder.like("scode", xf.getScode());
        }
        if (!StringUtils.isEmpty(xf.getStypename())) {
            builder.like("stypename", xf.getStypename());
        }
        if (!StringUtils.isEmpty(xf.getCompname())) {
            builder.like("compname", xf.getCompname());
        }
    	JSONObject jsonObject = builder.combineAnd();//最终的查询条件
        CommonPageResp<List<XfSalestype>> entityPageList = commonService.findEntityPageList(XfSalestype.class, XfSalestype.class, jsonObject, new Page(xfSalestype.getPageNo(), xfSalestype.getPageSize()));
        return new ResponseResult(CommonCode.SUCCESS, entityPageList);
    }

@TableName("user")
public class User {
    @Id
    @Field("user_name")
    private String userName;
    private String password;
    protected String id;
    @IgnoreSelectReback
    private BigDecimal price;
}

@ViewTable
public class TeacherView {

    @MainTable(tableAlias = "oneOs")
    private Teacher teacher;

    @ReferTable(tableAlias = "op",relation = "inner join",condition = "oneOs.teacherId = op.id")
    private User user;
}

@ViewTable
public class UserClassesView {

    @Condition(column = "teacherId",value = "1")
    @MainTable(tableAlias = "userOne")
    private TeacherView teacherView;

    @ReferTable(tableAlias = "aliasClass",relation = "left join",condition = "userOne.id = aliasClass.classesId and userOne.userName = aliasClass.name")
    private Classes classes;

    @OrderBys({
            @OrderBy(column = "teacherId",direct = "desc")
    })
    @Conditions({
            @Condition(column = "teacherId",value = "1"),
            @Condition(column = "teacherName",value = "8")
    })
    @ReferTable(tableAlias = "teacher",relation = "left join",condition = "userOne.id = teacher.teacherId",includeColumns = {"teacherName"})
    private Teacher teacher;

}

@EnableTransactionManagement
@ScanEntity({"top.sanguohf.egg.test.entity","top.sanguohf.egg.configure.entity"})
@SpringBootApplication
public class YangSqlTest {
    public static void main(String[] args) {
        SpringApplication.run(YangSqlTest.class);
    }
}

@EnableTransactionManagement //开启事务
@ScanEntity({"top.sanguohf.egg.test.entity","top.sanguohf.egg.configure.entity"})
@SpringBootApplication
public class YangSqlTest {
    public static void main(String[] args) {
        SpringApplication.run(YangSqlTest.class);
    }
}

package com.kc.app.xfjl.entity;
/**这是一个具体项目中的实体，不需要知道每个字段多的含义。我为了完整性，将项目中的整个代码都精简出来*/
@Data
@TableName("xf_rMaterial")
public class XfRMaterial {

    @Id //定义此表的主键
    @Field("pk_material")
    private String pk_material;

    @Field("rMeCode")
    private String rMeCode;

    @Field("rMeCodeName")
    private String rMeCodeName;

    @Field("rMeSpecName")
    private String rMeSpecName;

    @Field("mMenicCode")
    private String mMenicCode;

    @Field("cMeMemo")
    private String cMeMemo;

    @Field("cMaker")
    private String cMaker;
    
    //@OrderBy(direct = "desc")
    @Field("dnMaketime")
    private Date dnMaketime;

    @Field("dr")
    private Integer dr;

    @Field("pk_matertype")
    private String pk_matertype;

    @Field("pk_corp")
    private String pk_corp;
}

package com.kc.app.xfjl.controller;

@Controller
@RequestMapping("xfRMaterial")
public class XfRMaterialController {
    //直接注入通用的service
    @Autowired
    private CommonService commonService;

    @ApiOperation("分页获取参数")
    @PostMapping("getPageList")
    @ResponseBody
    public ResponseResult findPageList(@RequestBody BatisPage<XfRMaterial> xfRMaterial) throws Exception {
        XfRMaterial xf = xfRMaterial.getCondition()==null?new XfRMaterial():xfRMaterial.getCondition();
        EntityConditionBuilder builder = EntityConditionBuilder.getInstance().eq("dr", 1);
        if(!StringUtils.isEmpty(xf.getPk_material())){
            builder.like("pk_material",xf.getPk_material());
        }
        if(!StringUtils.isEmpty(xf.getRMeCode())){
            builder.like("rMeCode",xf.getRMeCode());
        }
        if(!StringUtils.isEmpty(xf.getRMeCodeName())){
            builder.like("rMeCodeName",xf.getRMeCodeName());
        }
        if(!StringUtils.isEmpty(xf.getRMeSpecName())){
            builder.like("rMeSpecName",xf.getRMeSpecName());
        }
        if(!StringUtils.isEmpty(xf.getMMenicCode())){
            builder.like("mMenicCode",xf.getMMenicCode());
        }
        if(!StringUtils.isEmpty(xf.getTypename())){
            builder.like("typename",xf.getTypename());
        }
        if(!StringUtils.isEmpty(xf.getCMeMemo())){
            builder.like("cMeMemo",xf.getCMeMemo());
        }
        //定义查询的排序字段
        ArrayList sorts = new ArrayList<EntityOrderBy>();
        EntityOrderBy order = new EntityOrderBy();
        order.setDirect("desc");
        order.setColumn("dnMaketime");
        sorts.add(order);

        CommonPageResp<List<XfRMaterial>> entityPageList = commonService.findEntityPageList(XfRMaterialView.class, XfRMaterialVo.class,builder.combineAnd(),sorts, new Page(xfRMaterial.getPageNo(), xfRMaterial.getPageSize()));
        PageResult result = new PageResult(entityPageList.getCount(),entityPageList.data);
        return new ResponseResult(CommonCode.SUCCESS,result);
    }
    @ApiOperation("查询所有记录")
    @PostMapping("getList")
    @ResponseBody
    public ResponseResult findList(@RequestBody XfRMaterial xfRMaterial) throws Exception {
        EntityConditionBuilder builder = EntityConditionBuilder.getInstance().eq("dr", 1);
        List<XfRMaterial> list = commonService.findEntityList(XfRMaterial.class, XfRMaterial.class,builder.combineAnd());
        return new ResponseResult(CommonCode.SUCCESS,list);
    }
    @ApiOperation("插入一条记录")
    @PostMapping("save")
    @ResponseBody
    public ResponseResult save(@RequestBody XfRMaterial xfRMaterial) throws Exception {
        if(StringUtils.isEmpty(xfRMaterial.getPk_material()))
            xfRMaterial.setPk_material(UUIDUtils.createUUID());
        xfRMaterial.setDr(1);
        xfRMaterial.setDnMaketime(new Date());
        xfRMaterial.setDnModifytime(new Date());
        commonService.insertEntity(xfRMaterial);
        return new ResponseResult(CommonCode.SUCCESS,xfRMaterial);
    }
    @ApiOperation("修改一条记录")
    @PostMapping("update")
    @ResponseBody
    public ResponseResult update(@RequestBody XfRMaterial xfRMaterial) throws Exception {
        xfRMaterial.setDnModifytime(new Date());
        commonService.updateEntity(xfRMaterial);
        return new ResponseResult(CommonCode.SUCCESS);
    }
    @ApiOperation("保存或者插入")
    @PostMapping("addOrUpdate")
    @ResponseBody
    public ResponseResult addOrUpdate(@RequestBody XfRMaterial xfRMaterial) throws Exception {
        if(StringUtils.isEmpty(xfRMaterial.getPk_material()))
            save(xfRMaterial);
        else update(xfRMaterial);
        return new ResponseResult(CommonCode.SUCCESS);
    }
    @ApiOperation("批量删除")
    @DeleteMapping("batchDelete")
    @ResponseBody
    public ResponseResult batchDelete(@RequestBody List<XfRMaterial> xfRMaterial) throws Exception {
        commonService.batchEntityDelete(xfRMaterial);
        return new ResponseResult(CommonCode.SUCCESS);
    }
    @ApiOperation("删除单个")
    @DeleteMapping("delete")
    @ResponseBody
    public ResponseResult delete(@RequestBody XfRMaterial xfRMaterial) throws Exception {
        xfRMaterial.setDr(0);
        xfRMaterial.setDnModifytime(new Date());
        commonService.updateEntity(xfRMaterial);
        return new ResponseResult(CommonCode.SUCCESS);
    }
}

@EnableTransactionManagement
@SpringBootApplication
//配置实体类的扫描路径
@ScanEntity({"com.kc.app.xfjl.entity","com.kc.app.xfjl.vo","com.kc.app.xfjl.view"})
public class XfjlApplication {
    public static void main(String[] args) {
        SpringApplication.run(XfjlApplication.class, args);
    }
}

package com.kc.app.xfjl.view;
//定义表之间的关系（可以理解为一条join语句，可以复用之前定义的实体）
@ViewTable
public class XfRMaterialView {

    @MainTable(tableAlias = "xfRMaterialVo") //定义视图查询的主表信息（其也可是视图实体）
    private XfRMaterial xfRMaterial;

    @ReferTable(tableAlias = "xfMatertype",relation = "left join",condition = "xfRMaterialVo.pk_matertype = xfMatertype.pkMatertype",includeColumns = {"typename"})
    private XfMatertype xfMatertype; //这里也可以是其它视图
}

package com.kc.app.xfjl;

@SpringBootTest
@RunWith(SpringRunner.class)
public class BaseTest {
    @Autowired
    private CommonService commonService;
    
    @Test
    public void test3() throws Exception {
        List<Map> entityList = commonService.findEntityList(XfRMaterialView.class, Map.class);//这里的map是接收的实体类，也可以定义指定的java类型
        System.out.println(entityList);
    }
}