关于mybaties新增一条mysql数据后返回新增的id

港控/mmm° 2023-07-04 04:54 11阅读 0赞

1. mybaties的xml如下:

<insert id="insert"
                parameterType="UserPO"
                useGeneratedKeys="true"
                keyProperty="id">
    
    	        INSERT INTO   /* insert */
    	            base_user  
    	            (
    		id          /* 主键id */
    		,user_name          /* 登录名，用户名 */
            
    	            )
    	        VALUES
    	            (
    	     #{id}  /* 主键 */
    		,#{userName}           /* 登录名，用户名 */
           
    	            )
    	</insert>

2. Dao接口如下

@Repository
    public interface UserDao{
    	public int insert(UserPO userPO) throws Exception;
    
    }

3. 原来的ServiceImpl 返回的是int类型的0或1,0/1是sql执行影响的行数

@Override
        public int insert(UserPO userPO) {
            int result = 0;
            try {
                result = userDao.insert(userPO);
            } catch (Exception e) {
                log.error("用户添加异常！{}", e.getMessage());
            }
            return result;
        }

4. 现修改ServiceImpl ,让它返回插入的数据的id

@Override
        public Long insert(UserPO userPO) {
            Long result = 0L;
            try {
                userDao.insert(userPO);
                result=userPO.getId();
            } catch (Exception e) {
                log.error("用户添加异常！{}", e.getMessage());
            }
            return result;
        }

效果:

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xldHR1Y2Vf_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xldHR1Y2Vf_size_16_color_FFFFFF_t_70 1][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xldHR1Y2Vf_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200208140142669.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xldHR1Y2Vf,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xldHR1Y2Vf_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200208140210638.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xldHR1Y2Vf,size_16,color_FFFFFF,t_70