1select * from person where name = 'unmi'

1<select id="getPersonsByName" resultClass="com.unmi.Person">
2    select id as id,name as name,passwd as passwd from person
3        <dynamic prepend="WHERE">
4            <isNotNull prepend="AND" property="name">
5                (name like #name#)
6            </isNotNull>
7        </dynamic>
8</select>

1<!-- 插入一条Person对应的记录到数据库中 -->
2<insert id="insertPerson"  parameterClass="com.unmi.Person">
3    INSERT INTO PERSON(ID,NAME,PASSWD) VALUES(#id#,#name#,#passwd#)
4</insert>