版权声明:原创作品,允许转载,转载时请务必以超链接形式标明文章
原始出处 、作者信息和本声明。否则将追究法律责任。
http://sunfish.blog.51cto.com/417500/108315
|
PersonDaoImp如下:
/**
* 删除性别为man,年龄为 11,12 的Person记录 */ public int deletePerson(Map<String, Object> map) { List<Person> personList= new ArrayList<Person>(); Person p1= new Person(11); person p2= new Person(12); personList.add(p1); personList.add(p2); map.put( "personList", personList); map.put( "sex",'man'); return getSqlMapClientTemplate().delete( "person.deletePerson", map); }
<!--
删除相应的person记录 -->
< delete id =" deletePerson " parameterClass ="map" > delete from 表名 where sex=#sex# < iterate prepend ="and" property =" personList " open ="(" close =")" conjunction ="or" > age=$ personList[]. age$ </ iterate > </ delete > delete from 表名 where sex='man' and (age =11 or age=12 ) 当然你也可以这么写: person.xml如下:
<!--
删除相应的person记录 -->
< delete id =" deletePerson " parameterClass ="map" > delete from 表名 where sex=#sex# and age in < iterate property =" personList " open ="(" close =")" conjunction ="," > $ personList[]. age$ </ iterate > </ delete > delete from 表名 where sex='man' and age in (11 ,12 ) 最后Person代码大致如下:
public
class Person{
public Person(int age){ this.age=age; } /** * 年龄 */ private int age; /** * 性别 */ private String sex; //get/set方法略 ... } //end of Person 本文出自 “sunfish 翻车鱼” 博客,请务必保留此出处http://sunfish.blog.51cto.com/417500/108315 |