删除用户-delete

@Delete("delete from user where id = #{id}")
public Integer deleteById(Integer id);

DML语句执行完毕的返回值，表示该DML语句执行完毕影响的行数。

Mybatis中的 # 号 与 $ 号：

例：

@Delete("delete from dept where id = #{id}")

@Select("select id,name,score from ${tableName} order by ${sortField}"