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

xml文件写法：

 

< 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/qqflying/archive/2012/07/13/2589965.html