MyBatis DAO layer passing parameters to Mapping.xml

Summarize the several ways that I used the Mybatis,dao layer to pass parameters to the Mapping.xml file:

First: Pass a single argument

DAO Layer Code fragment:

[Java]View PlainCopy

1. /**
2. * Check xxxx details according to ArticleID.
3. *
4. * @param ArticleID
5. * @return {@link cmsproductarticle}
6. */
7. Public cmsproductarticle Getcmsproductarticlebyarticleid (Long ArticleID);

Mapping Fragment:

[SQL]View PlainCopy

2. <select id= "getcmsproductarticlebyarticleid" parametertype="Long" resulttype=" Xxx.xxxxx.xxx.xxxxx.xxx.CmsProductArticle ">
4. SELECT
6. *
8. from
10. TableA A, TableB b
12. WHERE
14. a.article_id = b.article_id
16. and A.del_flag! = 2
18. and b.article_id = #{articleid}
20. </select>

When passing a single parameter, set parametertype directly to the parameter type (Long) you passed in, and get the parameter directly with "#{}", the parameter name must match the DAO layer parameter name.

Resulttype is the type returned by the results of the SQL query, and the DAO layer interface returns the entity class, so the resulttype here is the path to the entity class (holding down the CTRL key, the path is correct when the mouse clicks the path directly into the entity class)

Second type: Pass multiple parameters

1, marked with annotations

DAO Layer Code fragment:

[Java]View PlainCopy

1. /**
2. * Query whether CompanyID exists.
3. *
4. * @param CompanyID
5. * @param imgid
6. * @return int
7. */
8. public int Querycompanyidandimgidisexist (@Param ("CompanyID") Long CompanyID, @Param ("id")  Long Imgid);

Mapping Fragment:

[Java]View PlainCopy

1. <select id="querycompanyidandimgidisexist" resulttype="Integer" >
2. Select
3. Count (1)
4. From table_img img
5. where img.company_id = #{companyid}
6. and img.id = #{id}
7. </select>

You do not need to write parametertype at this time, but note that the parameter names within "#{}" must match the names defined within the annotation @param ("") in the DAO layer.

2, direct transfer of parameters

DAO Layer Code fragment:

[Java]View PlainCopy

1. /**
2. * Query whether CompanyID exists.
3. *
4. * @param CompanyID
5. * @param imgid
6. * @return int
7. */
8. public int Querycompanyidandimgidisexist (long companyid, long imgid);

Mapping Fragment:

[Java]View PlainCopy

1. <select id="querycompanyidandimgidisexist" resulttype="Integer" >
2. Select
3. Count (1)
4. From table_img img
5. where img.company_id = #{0}
6. and img.id = #{1}
7. </select>

#{0} and #{1} are the order of your arguments in DAO

3, passing parameters in map

Implement the Class code fragment:

[Java]View PlainCopy

1. map<string,object> searchcondition = new hashmap<> ();
2. Searchcondition.put ("CategoryId", categoryId);
3. Searchcondition.put ("status", status);
4. list<cmsproductarticle> cmsproductarticles = Cmsprodcutarticledao.getcmsproductarticles (searchCondition);

DAO Layer Code fragment:

[Java]View PlainCopy

1. /**
2. * Query product template set based on search criteria.
3. *
4. * @param searchcondition
5. * @return list<cmsproductarticle>
6. */
7. Public list<cmsproductarticle> getcmsproductarticles (map<string, object> searchcondition);

Mapping Fragment:

[SQL]View PlainCopy

2. <select id="getcmsproductarticles" parametertype="Java.util.Map" resulttype=" Xxx.xxxxxxx.xxx.xxxxx.xxxxxxx.CmsProductArticle ">
4. SELECT
6. *
8. from
10. Table A, table B
12. WHERE
14. a.article_id = b.article_id
16. and A.del_flag! = 2
18. <if test="CategoryId! = null" >
20. and a.category_id = #{categoryid}
22. </if>
24. <if test="Status! = NULL" >
26. and a.status = #{status}
28. </if>
30. </select>

#{categoryid}, #{status} corresponds to your key in the map

The third kind: to pass the entity class

DAO Layer Code fragment:

[Java]View PlainCopy

1. /**
2. Update.
3. *
4. * @param cmsproductarticle
5. * @return
6. */
7. Public void Updatecmsproductarticle (cmsproductarticle cmsproductarticle);

Mapping Fragment:

[SQL]View PlainCopy

2. <update id="updatecmsproductarticlebase" parametertype=" Xxx.xxxxxxx.xxx.xxxxx.xxxxxxx.CmsProductArticle ">
4. UPDATE Table
6. SET
8. category_id = #{categoryid}, Supply_type = #{supplytype}, Pay_type = #{paytype}, Pay_value = #{payvalue}, status = #{statu S
10. WHERE
12. article_id = #{articleid}
14. and Del_flag! = 2
16. </update>

#{categoryid} and other properties in the corresponding entity class.

MyBatis DAO layer passing parameters to Mapping.xml