Mybatis中添加一条记录返回记录主键id

Mybatis中添加一条记录，返回记录主键id：

mapper.xml中写法：

   <insert id="replyConMessage" parameterType="java.util.Map" useGeneratedKeys="true" keyProperty="id">
        INSERT INTO xb_consultants_message_reply(message_id,user_from,user_to,reply_content)
        VALUES(#{messageId},#{userFrom},#{userTo},#{replyContent})
    </insert>

获取id是通过传入的参数来拿：如果参数是map类型，mybatis会将返回的主键值负值给id熟悉；如果是一个对象，对象需要定义一个id熟悉来接收返回的主键值。

一、传入map类型参数

 public int replyConMessage(int messageId, String userFrom, String userTo, String replyContent) {
        Map<String, Object> params = new HashMap<>();
        params.put("messageId", messageId);
        params.put("userFrom", userFrom);
        params.put("userTo", userTo);
        params.put("replyContent", replyContent);
        iConsultants.replyConMessage(params);
        return Integer.parseInt(params.get("id").toString());

二、传入一个对象

public class Department {
    private int id;
    private int departmentId;
    private String departmentName;
    private String departmentManagerName;
    //...GET SET ...

}

public void testDao(){
    deptDao = session.getMapper(DepartmentDao.class);
    Department department = new Department();
    department.setDepartmentName("ares");
    department.setDepartmentManagerName("tom");
    department.setDepartmentId(32);

    deptDao.addDept(department);
    System.out.println("新部门ID:"+department.getId());
}