@Insert("insert into miaosha_message (id , messageid ,content , create_time ,status,over_time,message_type ,send_type , good_name , price,messageHead)" + "value (#{id},#{messageId},#{content},#{createTime},#{status},#{overTime},#{messageType},#{sendType},#{goodName},#{price},#{messageHead}) ") @Options(useGeneratedKeys = true, keyProperty = "id", keyColumn = "id") public void insertMiaoShaMessage(MiaoShaMessageInfo miaoShaMessage);
@Insert("insert into miaosha_message_user (id , userid ,messageid , goodid ,orderid)" + "value (#{id},#{userId},#{messageId},#{goodId},#{orderId}) ") @Options(useGeneratedKeys = true, keyProperty = "id", keyColumn = "id") public void insertMiaoShaMessageUser(MiaoShaMessageUser miaoShaMessageUser);
/** * 插入数据,限制为实体包含`id`属性并且必须为自增列,实体配置的主键策略无效 * * @param record * @return */ @Options(useGeneratedKeys = true) @InsertProvider(type = SpecialProvider.class, method = "dynamicSQL") int insertUseGeneratedKeys(T record);
/** * 插入数据库,`null`值也会插入,不会使用列的默认值 * * @param record * @return */ @Options(useGeneratedKeys = true) @InsertProvider(type = SqlServerProvider.class, method = "dynamicSQL") int insert(T record);
/** * 批量插入,支持批量插入的数据库可以使用,例如MySQL,H2等,另外该接口限制实体包含`id`属性并且必须为自增列 * * @param recordList * @return */ @Options(useGeneratedKeys = true) @InsertProvider(type = SpecialProvider.class, method = "dynamicSQL") int insertList(List<? extends T> recordList);
/** * 批量插入,支持批量插入的数据库可以使用,例如MySQL,H2等,另外该接口限制实体包含`id`属性并且必须为自增列 * * @param recordList * @return */ @Options(useGeneratedKeys = true) @InsertProvider(type = SpecialProvider.class, method = "dynamicSQL") int insertList(List<? extends T> recordList);
/** * 插入数据库,`null`值也会插入,不会使用列的默认值 * * @param record * @return */ @Options(useGeneratedKeys = true) @InsertProvider(type = SqlServerProvider.class, method = "dynamicSQL") int insert(T record);
/** * 插入数据,限制为实体包含`id`属性并且必须为自增列,实体配置的主键策略无效 * * @param record * @return */ @Options(useGeneratedKeys = true) @InsertProvider(type = SpecialProvider.class, method = "dynamicSQL") int insertUseGeneratedKeys(T record);
@Insert("insert into miaosha_user (id , nickname ,password , salt ,head,register_date,last_login_date)value (#{id},#{nickname},#{password},#{salt},#{head},#{registerDate},#{lastLoginDate}) ") @Options(useGeneratedKeys = true, keyProperty = "id", keyColumn = "id") public void insertMiaoShaUser(MiaoshaUser miaoshaUser);
@Options(useGeneratedKeys = true) @InsertProvider(type = SqlServerProvider.class, method = "dynamicSQL") int insertSelective(T record);
@Options(useGeneratedKeys = true) @InsertProvider(type = SqlServerProvider.class, method = "dynamicSQL") int insertSelective(T record);
@Insert("insert into blog (title,content,update_time) values (#{blog.title},#{blog.content},now())") @Options(useGeneratedKeys = true, keyProperty = "blog.id") int save(@Param("blog") BlogContent blog); }
@Insert(SqlConstants.INSERT_SLAVE_SQL) @Options(useGeneratedKeys = true, keyProperty = "userId") int insertSlave(UserEntity user);
@Insert({"insert into sys_role(role_name, enabled, create_by, create_time)", "values(#{roleName}, #{enabled}, #{createBy}, #{createTime, jdbcType=TIMESTAMP})"}) @Options(useGeneratedKeys = true, keyProperty = "id") int insert2(SysRole sysRole);
@Insert(SqlConstants.INSERT_SLAVE_SQL) @Options(useGeneratedKeys = true, keyProperty = "userId") int insert(UserEntity user);
@InsertProvider(type = PrivilegeProvider.class, method = "insert") @Options(useGeneratedKeys = true, keyProperty = "id") int insert(SysPrivilege sysPrivilege);
@Options(useGeneratedKeys = true,keyProperty = "id") @GetMapping("/insert") public int insertDept(Department department){ return departmentMapper.insertDept(department); } }
/** * 插入数据库,`null`值也会插入,不会使用列的默认值 * * @param record * @return */ @Options(useGeneratedKeys = true) @InsertProvider(type = SqlServerProvider.class, method = "dynamicSQL") int insert(T record);
/** * 批量插入,支持批量插入的数据库可以使用,例如MySQL,H2等,另外该接口限制实体包含`id`属性并且必须为自增列 * * @param recordList * @return */ @Options(useGeneratedKeys = true) @InsertProvider(type = SpecialProvider.class, method = "dynamicSQL") int insertList(List<? extends T> recordList);
/** * 批量插入,支持数据库自增字段,支持回写 * * @param recordList * @return */ @Options(useGeneratedKeys = true, keyProperty = "id") @InsertProvider(type = SpecialProvider.class, method = "dynamicSQL") int insertList(List<T> recordList);