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>
一、传入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 ...
}
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());
}