Ibatis Auto-generated primary key (Oracle,ms Sql server,mysql) "Go"

The Selectkey element of the Ibatis sqlmap configuration file has a type attribute that allows you to specify pre or post representation before generation (pre) or the epigenetic (post).

Oracle Settings

XML code

2. <!--Oracle SEQUENCE--
4. <insert id="insertproduct-oracle" parameterclass="com.domain.Product">
6. <selectkey resultclass="int" keyproperty="id" type="pre">
8. <! [Cdata[select stockidsequence. Nextval as ID from Dual]]>
10. </selectkey>
12. <! [Cdata[insert into PRODUCT (prd_id,prd_description) VALUES (#id #, #description #)]]>
14. </Insert>

MS SQL Server Configuration

XML code

2. <!--Microsoft SQL Server IDENTITY Column--
4. <insert id="Insertproduct-ms-sql" parameterclass="com.domain.Product">
6. <! [Cdata[insert into PRODUCT (prd_description) VALUES (#description #)]]>
8. <selectkey resultclass="int" keyproperty="id" type="POST">
10. <! [Cdata[select @ @IDENTITY as ID]]>
12. <!--This method is unsafe should be used scope_identity () but this function belongs to a domain function and needs to be executed in a block of statements. -
14. </selectkey>
16. </Insert>

The above MS SQL Server configuration is provided by the official website configuration, but in fact, it is just the hidden dangers! Make sure you have a valid primary key, as configured below.

XML code

2. <!--Microsoft SQL Server IDENTITY Column Improved-
4. <insert id="Insertproduct-ms-sql" parameterclass="com.domain.Product">
6. <selectkey resultclass="int" keyproperty="id">
8. <! [Cdata[insert into PRODUCT (prd_description) VALUES (#description #)
10. SELECT scope_identity () as ID]]>
12. </selectkey>
14. </Insert>

MySQL Configuration

XML code

2. <!--MySQL last Insert Id--
4. <insert id="Insertproduct-mysql" parameterclass="com.domain.Product">
6. <! [Cdata[insert into PRODUCT (prd_description) VALUES (#description #)]]>
8. <selectkey resultclass="int" keyproperty="id">
10. <! [Cdata[select last_insert_id () as ID]]>
12. <!--the method last_insert_id () binds to the database connection and is at the same unified session level, without the MS SQL Server function problem. -
14. </selectkey>
16. </Insert>

In this way, it is possible to ensure that the current self-increment primary key is obtained when inserting data to the maximum extent.

Ibatis Auto-generated primary key (Oracle,ms Sql server,mysql) "Go"