id="insertAuthor">
insert into Author (id,username,password,email,bio)
values (#{id},#{username...= #{username},
password = #{password},
email = #{email},
bio = #{bio}
where id = #{id}...
id="deleteAuthor">
delete from Author where id = #{id}
如果 id 使用了自动生成的列类型...,password,email,bio)
values (#{username},#{password},#{email},#{bio})
如果你的数据库还支持多行插入, 你也可以传入一个...Authors数组或集合,并返回自动生成的主键。