>[success]column方法适用于插入，修改，查询中设置字段的相关操作 [TOC] ## 使用column设置插入字段 ``` public void t1() { BaseService service = Application.getService("demo"); service.setData("1","abc").column("i","s").insert(); //效果等同于service.setData("1","abc").insert("i","s"); } ``` 可以在插入POJO时指定要插入的字段 ``` public void t2() { BaseService service = Application.getService("demo"); DemoBean demo=new DemoBean(); demo.setI(57); demo.setS("aaa"); service.column("i","s").insert(demo); } ``` ## 使用column设置修改字段 ``` public void t3() { BaseService service = Application.getService("demo"); service.setData("1").column("i").update(); //效果等同于service.setData("1").update("i"); } ``` 可以直接将表达式作为参数 ``` public void t4() { BaseService service = Application.getService("demo"); service.column("i=3").update(); //或者 service.column("i=i+1").update(); //或者 service.column("i=i+1","s=CONCAT(s,'abc')").update(); } ``` 可以在修改POJO时指定要修改的字段 ``` public void t5() { BaseService service = Application.getService("demo"); DemoBean demo=new DemoBean(); demo.setI(57); demo.setS("aaa"); service.column("i","s").update(demo); } ``` ## 使用column指定要查询字段 ``` public void t6() { BaseService service = Application.getService("demo"); List<HashMap<String, Object>> list = service.column("i","s").selectList(); Vardump.print(list); } ``` 可以拆开来写 ``` public void t6() { BaseService service = Application.getService("demo"); service.column("i"); service.column("s"); List<HashMap<String, Object>> list = service.selectList(); Vardump.print(list); } ``` 可以直接将算术表达式或者函数表达式作为参数，并返回别名 ``` public void t4() { BaseService service = Application.getService("demo"); service.column("i+1 数字"); service.column("LEFT(s,3) AS 字符串"); List<HashMap<String, Object>> list = service.selectList(); Vardump.print(list); } ```