id, user_id, dog_name, pedigree_num, sex, weight, dog_birthday, get_home_date, create_time, update_time,dogType, deleteFlag ,avatar,type_name select from cab_mylove_dog where user_id = #{userId,jdbcType=VARCHAR} and deleteFlag = '0' limit #{start},#{limit} SELECT count(id) FROM cab_mylove_dog WHERE user_id =#{userId,jdbcType=VARCHAR} and deleteFlag = '0' select from cab_mylove_dog where id = #{id} delete from cab_mylove_dog where id = #{id,jdbcType=INTEGER} insert into cab_mylove_dog (id, user_id, dog_name, pedigree_num, sex, weight, dog_birthday, get_home_date, create_time, update_time,dogType, deleteFlag,avatar) values (#{id,jdbcType=INTEGER}, #{userId,jdbcType=BIGINT}, #{dogName,jdbcType=VARCHAR}, #{pedigreeNum,jdbcType=VARCHAR}, #{sex,jdbcType=INTEGER}, #{weight,jdbcType=DOUBLE}, #{dogBirthday,jdbcType=TIMESTAMP}, #{getHomeDate,jdbcType=TIMESTAMP}, #{createTime,jdbcType=TIMESTAMP}, #{updateTime,jdbcType=TIMESTAMP},#{dogType,jdbcType=VARCHAR},#{deleteflag,jdbcType=INTEGER},#{avatar,jdbcType=VARCHAR}) insert into cab_mylove_dog id, user_id, dog_name, pedigree_num, sex, weight, dog_birthday, get_home_date, create_time, update_time, dogType, deleteFlag, avatar, type_name #{id,jdbcType=INTEGER}, #{userId,jdbcType=BIGINT}, #{dogName,jdbcType=VARCHAR}, #{pedigreeNum,jdbcType=VARCHAR}, #{sex,jdbcType=INTEGER}, #{weight,jdbcType=DOUBLE}, #{dogBirthday,jdbcType=TIMESTAMP}, #{getHomeDate,jdbcType=TIMESTAMP}, #{createTime,jdbcType=TIMESTAMP}, #{updateTime,jdbcType=TIMESTAMP}, #{dogType,jdbcType=VARCHAR}, #{deleteflag,jdbcType=INTEGER}, #{avatar,jdbcType=VARCHAR}, #{typeName,jdbcType=VARCHAR}, update cab_mylove_dog user_id = #{userId,jdbcType=VARCHAR}, dog_name = #{dogName,jdbcType=VARCHAR}, pedigree_num = #{pedigreeNum,jdbcType=VARCHAR}, sex = #{sex,jdbcType=INTEGER}, weight = #{weight,jdbcType=DOUBLE}, dog_birthday = #{dogBirthday,jdbcType=TIMESTAMP}, get_home_date = #{getHomeDate,jdbcType=TIMESTAMP}, create_time = #{createTime,jdbcType=TIMESTAMP}, update_time = #{updateTime,jdbcType=TIMESTAMP}, dogType = #{dogType,jdbcType=VARCHAR}, deleteFlag = #{deleteflag,jdbcType=INTEGER}, avatar=#{avatar,jdbcType=VARCHAR}, type_name=#{typeName,jdbcType=VARCHAR}, where id = #{id,jdbcType=INTEGER} and user_id = #{userId} update cab_mylove_dog set user_id = #{userId,jdbcType=VARCHAR}, dog_name = #{dogName,jdbcType=VARCHAR}, pedigree_num = #{pedigreeNum,jdbcType=VARCHAR}, sex = #{sex,jdbcType=INTEGER}, weight = #{weight,jdbcType=DOUBLE}, dog_birthday = #{dogBirthday,jdbcType=TIMESTAMP}, get_home_date = #{getHomeDate,jdbcType=TIMESTAMP}, create_time = #{createTime,jdbcType=TIMESTAMP}, update_time = #{updateTime,jdbcType=TIMESTAMP}, dogType = #{dogType,jdbcType=VARCHAR}, deleteFlag = #{deleteflag,jdbcType=INTEGER}, avatar=#{avatar,jdbcType=VARCHAR} where id = #{id,jdbcType=INTEGER}