Mybatis+mysql Insert database Three ways to return the value of a self-key ID

First, the scene:

Inserting a database value requires immediate return of the primary key ID for next procedure operation

Second, the solution: the first: The use of universal Mapper insertion method

Mapper.insertselective (record);

This method: Inserts a single piece of data, inserts only non-null fields, does not affect fields with default values
Supports Oracle sequence, UUID, mysql-like indentity auto-grow (auto write-back)
Use sequence, UUID, auto-grow when parameter values are empty, using the passed parameter value preferentially

The actual application of the controller: using the method ID will get the value directly using the entity get of the parameter when used on the entity mapped to the parameter

General Mapper related configuration see other articles http://blog.csdn.net/isea533/article/details/41457529

The second type: Writing SQL statements

DAO Layer Method:

[Java]View PlainCopy

1. /**
2. * Insert database and return primary key ID
3. * @param Batch
4. * @return
5. */
6. Integer Insertbatchreturnid (batch batch);

SQL statement notation FOR XML

Remember to add Usegeneratedkeys and Keyproperty configuration, which refers to setting whether to use JDBC's Getgenereatedkeys method to get the primary key and assign a value to the properties of the Keyproperty setting. The latter is the entity Class primary key field (and the case should correspond)

[HTML]View PlainCopy

2. <insert id="Insertbatchreturnid" usegeneratedkeys="true" keyproperty="id" Parametertype="Org.uz.dxt.model.bankbase.Batch" >
6. INSERT INTO T_batch (
8. Batchcode,
10. Bankcode,
12. BizType,
14. Companycode,
16. Wtenddate,
18. Wtdate,
20. Contractid,
22. TotalCount,
24. Totalbase,
26. Handcode)
28. Values
30. (#{batchcode},
32. #{bankcode},
34. #{biztype},
36. #{companycode},
38. #{wtenddate},
40. #{wtdate},
42. #{contractid},
44. #{totalcount},
46. #{totalbase},
48. #{handcode})
50. </Insert>

The actual application of the controller: using the method ID will get the value directly using the entity get of the parameter when used on the entity mapped to the parameter

[Java]View PlainCopy

1. Batchservice.insertbatch (param); //entity
2. Idlist.add (Param.getid ());

Third: SQL statements use <selectKey> get self-increment gradual ID

[HTML]View PlainCopy

2. <insert id="Add" parametertype="estudent">
4. Here's how SQL Server gets the primary key value of the last inserted record
6. <selectkey resulttype="_long" keyproperty="id" order="after">
8. SELECT @ @IDENTITY as ID
10. </selectkey>
12. Insert into Tstudent (name, age) VALUES (#{name}, #{age})
14. </Insert>

Use ditto

It is recommended to use the first and second Chinese laws

The third approach to oracl additional configuration

The actual application of the controller: using the method ID will get the value directly using the entity get of the parameter when used on the entity mapped to the parameter

Mybatis+mysql Insert database Three ways to return the value of a self-key ID