[TOC] ## 顺序参数，按顺序一一对应 >[success]SQL：UPDATE `demo` SET `s`=?,`i`=?,`t`=? WHERE (`id`=?) 参数：abc(String), 1(Integer), a(String), 4(Integer) ``` public void t1(){ BaseService service = Application.getService("demo"); //where参数的值需要排在最后 service.where("id=#{id}").setData("abc",1,'a',4).insert("s","i","t"); } ``` ## map参数，map的键与update的参数对应 >[success]SQL：UPDATE `demo` SET `s`=?,`i`=?,`t`=? WHERE (`id`=?) 参数：abcde(String), 1(Integer), s(String), 56(Integer) ``` public void t2(){ BaseService service = Application.getService("demo"); HashMap<String, Object> map=new HashMap<>(); map.put("t", 's'); map.put("i", 1); map.put("s", "abcde"); map.put("id", 56); service.where("id=#{id}").setData(map).update("s","i","t"); } ``` ## POJO参数，成员属性与表字段名对应，条件会根据主键自动匹配 >[success]SQL：UPDATE `demo` SET `i`=?,`s`=? WHERE (`id`=?) AND (`t`=?) 参数：58(Integer), aaa(String), 13(Long), 36e6412c-45d1-4cb7-98b9-cbc241a2c715(String) ``` public void t3(){ BaseService service = Application.getService("demo"); DemoBean demo=new DemoBean(); demo.setI(58); demo.setS("aaa"); demo.setT("36e6412c-45d1-4cb7-98b9-cbc241a2c715"); demo.setId(13); service.update(demo); } ``` ## 修改POJO时，某些属性有值，但你不希望被修改 >[success]SQL：UPDATE `demo` SET `i`=? WHERE (`id`=?) AND (`t`=?) 参数：59(Integer), 13(Long), 36e6412c-45d1-4cb7-98b9-cbc241a2c715(String) ``` public void t4(){ BaseService service = Application.getService("demo"); DemoBean demo=new DemoBean(); demo.setI(5); demo.setS("aaa"); demo.setT("36e6412c-45d1-4cb7-98b9-cbc241a2c715"); demo.setId(13); //这里s跟t都不会被修改 service.update(demo,"s,t"); } ```