@Select("select * from user where id=#{uid} and name=#{name}") //使用常见数据类型, 和String类型必须使用@Param给定别名 User selectOne(@Param("uid") int id, @Param("name") String name); @Update("update user set pwd=#{newPwd} where id=#{id}") int update(@Param("id") int id, @Param("newPwd") String newPWd); @Insert("insert into user values(#{id}, #{name}, #{pwd})") int insert(User user); @Delete("delete from user where id=#{id}") int delete(@Param("id") int id);