IBatis框架利用select @@Identity 获取新增记录ID

最新推荐文章于 2021-01-19 00:17:05 发布

weixin_30784141

最新推荐文章于 2021-01-19 00:17:05 发布

阅读量98

点赞数

原文链接：http://www.cnblogs.com/qearl/p/3194426.html

版权

<insert id="InsertPurchaseEvaluations" parameterClass="PurchaseEvaluations">
            INSERT INTO PurchaseEvaluations(
            ApplyMoneyID,
            PurchaseID,
            PurchaseName,
            AddUserID,
            AddUserName,
            AddTime,
            AverageScoreValue,
            EvaluationRemark,
            PurchaseLevel,
            EvaluationType)
            VALUES(
            #ApplyMoneyID#,
            #PurchaseID#,
            #PurchaseName#,
            #AddUserID#,
            #AddUserName#,
            #AddTime#,
            #AverageScoreValue#,
            #EvaluationRemark#,
            #PurchaseLevel#,
            #EvaluationType#)
            <selectKey property="Id" resultClass="int" type="post">
            select @@Identity as Id
        </selectKey>
        </insert>

public int InsertPurchaseEvaluations(PurchaseEvaluations purchaseEvaluations)
        {
            mapper.Insert("InsertPurchaseEvaluations", purchaseEvaluations);
            return purchaseEvaluations.Id;
        }

转载于:https://www.cnblogs.com/qearl/p/3194426.html