Mybatis mapper.xml

使用insert后获得自增id的方法

  <insert id="addTravellerFootAtDao" useGeneratedKeys="true" keyProperty="footId">
        INSERT INTO travellerfoot(footTitle, footDate, footText, travellerId) VALUES (#{footTitle},#{footDate},#{footText},#{travellerId});
  </insert>

public int addTravellerFootAtDao(TravellerFootBean addFoot) {
        TravellerFootDao dao=getSqlSession().getMapper(TravellerFootDao.class);
        int result=dao.addTravellerFootAtDao(addFoot);
        int id=addFoot.getFootId();
        System.out.println("dao层结果 addTravellerFootAtDao："+result);
        System.out.println("返回自增主键："+id);
        return id;
    }
keyProperty为自增的id字段。调用insert后自动将自增id赋值进insert调用的实体类中

多行批量删除

<delete id&