[TOC] ## 1、表使用别名 ``` BaseService service = Application.getService("表名", "别名") ``` 或者 ``` BaseService service = Application.getService(); service.setTable("表名", "别名"); ``` 或者 ``` @Table(value="表名",alias="别名") public class PojoBean { } BaseService service = Application.getService(PojoBean.class); ``` ## 2、join的表使用别名 ``` service.leftJoin("表名","别名").on("别名.字段..."); service.rightJoin("表名","别名").on("别名.字段..."); service.innerJoin("表名","别名").on("别名.字段..."); ``` ## 3、查询结果使用别名 ``` service.column("字段名 as 别名"); service.column("字段名 别名"); service.column("函数(字段名) as 别名"); service.column("函数(字段名) 别名"); ``` ## 4、使用别名的复杂案例 ``` public void t12() { BaseService service = Application.getService("demo", "d"); service.column("d.id 编号","a.aname as 姓名","left(d.s,3) as 字符串"); service.column("case d.t when 'a' then 1 when 'b' then 2 else 3 end as 条件项目"); service.leftJoin("admin","a").on("a.aid=d.id"); service.where("d.id", ">",15); service.where("a.aid", 23); List<HashMap<String, Object>> list = service.selectList(); Vardump.print(list); } ``` 上面代码执行的sql为 ``` SELECT `d`.`id` 编号, `a`.aname as 姓名, left(`d`.`s`,3) as 字符串, case `d`.`t` when 'a' then 1 when 'b' then 2 else 3 end as 条件项目 FROM `demo` `d` LEFT JOIN `admin` `a` ON `a`.aid=`d`.`id` WHERE (`a`.aid=?) AND (`d`.id>?) ``` 参数为 ``` 23(Integer), 15(Integer) ```