一.通过存储过程实现(一般不用这种写法,我是练习一下存储过程):
1.sql语句如下:
BEGIN
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET flag=0;
SET flag =1;
START TRANSACTION;
INSERT INTO USER (username,password) VALUES(name,password);
SET last_id = LAST_INSERT_ID();
IF flag=0 THEN
ROLLBACK;
ELSE
COMMIT;
END IF;
END
2.mybaits,mapper.xml文件配置:
<!-- 获取生成id LAST_INSERT_ID() -->
<select id="returnUserId" parameterType="java.util.HashMap" statementType="CALLABLE" resultType="java.util.Map">
{CALL NEW_LAST_ID(
#{name,mode=IN,jdbcType=VARCHAR},
#{password,mode=IN,jdbcType=INTEGER},
#