@Insert("insert into order_info(user_id, goods_id, goods_name, goods_count, goods_price, order_channel, status, create_date)values(" + "#{userId}, #{goodsId}, #{goodsName}, #{goodsCount}, #{goodsPrice}, #{orderChannel},#{status},#{createDate} )") @SelectKey(keyColumn="id", keyProperty="id", resultType=long.class, before=false, statement="select last_insert_id()") public long insert(OrderInfo orderInfo);
@Insert("insert into any_user(open_id, password, login_type, nickname, avatar, gender, meta, md5) values (#{openId}, #{password}, #{loginType}, #{nickname}, #{avatar}, #{gender}, #{meta}, #{md5})") @SelectKey(statement = "SELECT LAST_INSERT_ID()", keyProperty = "id", before = false, resultType = long.class) int insert(User user);
@Insert({"insert into sys_role(role_name, enabled, create_by, create_time)", "values(#{roleName}, #{enabled}, #{createBy}, #{createTime, jdbcType=TIMESTAMP})"}) @SelectKey(statement = "SELECT LAST_INSERT_ID()", keyProperty = "id", resultType = Long.class, before = false) int insert3(SysRole sysRole);
@InsertProvider(type = PrivilegeProvider.class, method = "insert") @SelectKey(statement = "SELECT LAST_INSERT_ID()", keyProperty = "id", resultType = Long.class, before = false) int insert2(SysPrivilege sysPrivilege);
/** * 通过@SelectKey使insert成功后返回主键id,也就是订单id * @param orderInfo * @return */ @Insert("insert into sk_order_info(user_id, goods_id, goods_name, goods_count, goods_price, order_channel, status, create_date)values(" + "#{userId}, #{goodsId}, #{goodsName}, #{goodsCount}, #{goodsPrice}, #{orderChannel},#{status},#{createDate} )") @SelectKey(keyColumn = "id", keyProperty = "id", resultType = long.class, before = false, statement = "select last_insert_id()") public long insert(OrderInfo orderInfo);
/** * 插入记录并获取记录 id <p> * * @param flow * @return 插入记录数 */ @InsertProvider(type = ProjectFlowMapperProvider.class, method = "insert") @SelectKey(statement = "SELECT LAST_INSERT_ID() AS id", keyProperty = "flow.id", resultType = int.class, before = false) int insertAndGetId(@Param("flow") ProjectFlow flow);
@Insert("INSERT INTO myobject_table (objectId,objectName) VALUES (#{objectId}, #{objectName})") @SelectKey(statement="SELECT nextVal('my_sequence')", keyProperty="objectId", before=true, resultType=int.class) int insertMyObject_Annotation(MyObject myObject); }
/** * 插入记录 <p> * * @param flowNode * @return 插入记录数 */ @InsertProvider(type = FlowNodeMapperProvider.class, method = "insert") @SelectKey(statement = "SELECT LAST_INSERT_ID() AS id", keyProperty = "flowNode.id", resultType = int.class, before = false) int insert(@Param("flowNode") FlowNode flowNode);
/** * 插入项目信息 * * @param project * @return */ @InsertProvider(type = ProjectMapperProvider.class, method = "insert") @SelectKey(statement = "SELECT LAST_INSERT_ID()", keyProperty = "newProject.id", before = false, resultType = int.class) int insert(@Param("newProject") Project project);
/** * 新增 * 所有字段传入 model.params,不能为空 * @param model * @return */ @InsertProvider(method = "insert", type = SqlTemplate.class) @SelectKey(before=false,keyProperty="params.id",resultType=Object.class,statementType=StatementType.STATEMENT,statement="SELECT LAST_INSERT_ID() AS id") int insert(Table model);
@Insert("insert into order_info(user_id, goods_id, goods_name, goods_count, goods_price, order_channel, status, create_date)values(" + "#{userId}, #{goodsId}, #{goodsName}, #{goodsCount}, #{goodsPrice}, #{orderChannel},#{status},#{createDate} )") @SelectKey(keyColumn="id", keyProperty="id", resultType=long.class, before=false, statement="select last_insert_id()") public long insert(OrderInfo orderInfo);
/** * 插入用户 * * @param user * @return */ @InsertProvider(type = UserMapperProvider.class, method = "insert") @SelectKey(statement = "SELECT LAST_INSERT_ID()", keyProperty = "user.id", before = false, resultType = int.class) int insert(@Param("user") User user);
/** * 插入数据源 * * @param dataSource * @return */ @InsertProvider(type = DataSourceMapperProvider.class, method = "insert") @SelectKey(statement = "SELECT LAST_INSERT_ID() as id", keyProperty = "dataSource.id", before = false, resultType = Integer.class) int insert(@Param("dataSource") DataSource dataSource);
/** * 插入记录并获取记录 id <p> * * @param job * @return 插入记录数 */ @InsertProvider(type = StreamingJobMapperProvider.class, method = "insert") @SelectKey(statement = "SELECT LAST_INSERT_ID() AS id", keyProperty = "job.id", resultType = int.class, before = false) int insertAndGetId(@Param("job") StreamingJob job);
/** * 插入记录 * * @param adHoc * @return 插入记录数 */ @InsertProvider(type = AdHocMapperProvider.class, method = "insert") @SelectKey(statement = "SELECT LAST_INSERT_ID() as id", keyProperty = "adHoc.id", before = false, resultType = Integer.class) int insert(@Param("adHoc") AdHoc adHoc);
/** * 插入一个资源文件 * * @param resource * @return */ @InsertProvider(type = ResourceMapperProvider.class, method = "insert") @SelectKey(statement = "SELECT LAST_INSERT_ID() AS id", keyProperty = "resource.id", resultType = int.class, before = false) int insert(@Param("resource") Resource resource);
/** * 插入记录并获取记录 id <p> * * @param result * @return 插入记录数 */ @InsertProvider(type = StreamingResultMapperProvider.class, method = "insert") @SelectKey(statement = "SELECT LAST_INSERT_ID() AS id", keyProperty = "result.execId", resultType = int.class, before = false) int insert(@Param("result") StreamingResult result);
/** * 插入记录并获取记录 id <p> * * @return 修改记录数 */ @InsertProvider(type = ExecutionFlowMapperProvider.class, method = "insert") @SelectKey(statement = "SELECT LAST_INSERT_ID() AS id", keyProperty = "executionFlow.id", resultType = int.class, before = false) int insertAndGetId(@Param("executionFlow") ExecutionFlow executionFlow);
@Insert(INSERT) @Options(useGeneratedKeys = true, keyProperty = "address_id") // SELECT LAST_INSERT_ID(); does not work with HSQLDB @SelectKey(statement = "CALL IDENTITY()", before = false, keyProperty = "addressId", resultType = short.class) int insert(Address record); }
@Insert(INSERT) @Options(useGeneratedKeys = true, keyProperty = "customer_id", flushCache = true) // SELECT LAST_INSERT_ID(); does not work with HSQLDB @SelectKey(statement = "CALL IDENTITY()", before = false, keyProperty = "customerId", resultType = Short.class) int insert(Customer record);