关于这点不多说了,直接说使用方法:
使用@Option注解,返回的仍然是成功添加的记录条数。而自增主键的值则保留在相应实体类下的id属性中。
@Insert("insert into team(leader,course_id,max_num) values(#{leader},#{course_id},#{max_num})")
@Options(useGeneratedKeys = true,keyProperty = "id",keyColumn = "id")
void createTeam(Team team);//返回值不是int
Dao错误用例:
@Override
public int createTeam(Long num,Integer courseId,Integer maxNum)
{
Team team = new Team();
team.setLeader(num);
team.setCourseId(courseId);
team.setMaxNum(maxNum);
return teamMapper.createTeam(team);
}
Dao正确用例:
@Override
public int createTeam(Long num,Integer courseId,Integer maxNum)
{
Team team = new Team();
team.setLeader(num);
team.setCourseId(courseId);
team.setMaxNum(maxNum);
teamMapper.createTeam(team)
return team.getId();
}