08MyBatis注解方式之@Insert

LD is tigger forever，CG are not brothers forever， throw the pot and shine forever.
Modesty is not false, solid is not naive, treacherous but not deceitful, stay with good people, and stay away from poor people.
talk is cheap, show others the code,Keep progress，make a better result.
Survive during the day and develop at night。

目录

概 述

MyBatis-08MyBatis注解方式之@Insert

@Insert注解本身很简单，需要注意的是如果需要返回主键的值，情况会稍微复杂一点，这种XML方式配置本质是一样的

不需要返回主键
1.RoleMapper接口增加接口方法

/**
     * 
     * 
     * @Title: insertSysRole
     * 
     * @Description: insertSysRole 不需要返回主键的情况
     * 
     * @param sysRole
     * @return
     * 
     * @return: int
     */
    @Insert({ "insert into sys_role(id, role_name, enabled, create_by, create_time) values(#{id}, #{roleName}, #{enabled}, #{createBy}, #{createTime, jdbcType=TIMESTAMP})" })
    int insertSysRole(SysRole sysRole);

返回自增主键

/**
     * 
     * 
     * @Title: insertSysRole2
     * 
     * @Description: insertSysRole2 返回自增主键的情况
     * 
     * @param sysRole
     * @return
     * 
     * @return: int
     */
    @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 insertSysRole2(SysRole sysRole);

返回自增主键

/**
     * 
     * 
     * @Title: insertSysRole2
     * 
     * @Description: insertSysRole2 返回自增主键的情况
     * 
     * @param sysRole
     * @return
     * 
     * @return: int
     */
    @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 insertSysRole2(SysRole sysRole);

MyBatis-09MyBatis注解方式之@Update/@Delete

1. RoleMapper接口增加接口方法
   2.在这里插入代码片

    /**
     * 
     * 
     * @Title: updateSysRoleById
     * 
     * @Description: updateSysRoleById
     * 
     * @param sysRole
     * @return
     * 
     * @return: int
     */
    @Update({ "update sys_role set role_name = #{roleName},enabled = #{enabled},create_by = #{createBy},create_time = #{createTime, jdbcType=TIMESTAMP} where id = #{id}" })
    int updateSysRoleById(SysRole sysRole);

@Delete 方法：

/**
     * 
     * 
     * @Title: deleteSysRoleById
     * 
     * @Description: deleteSysRoleById
     * 
     * @param id
     * @return
     * 
     * @return: int
     */
    @Delete("delete from sys_role where id = #{id}")
    int deleteSysRoleById(Long id);

总结：

相关工具如下：

分析：

小结：

主要讲述了接下来@Insert详解，请大家指正~

参考资料和推荐阅读

1.链接: 参考资料.