轉(zhuǎn)載地址

http://blog.csdn.net/liaoxiaohua1981/article/details/6862764

在MyBatis的select、insert、update、delete這些元素中都提到了parameterType這個(gè)屬性。MyBatis現(xiàn)在可以使用的parameterType有基本數(shù)據(jù)類型和Java復(fù)雜數(shù)據(jù)類型

• 基本數(shù)據(jù)類型：包含int,String,Date等。基本數(shù)據(jù)類型作為傳參，只能傳入一個(gè)。通過#{參數(shù)名} 即可獲取傳入的值
• 復(fù)雜數(shù)據(jù)類型：包含JAVA實(shí)體類、Map。通過#{屬性名}或#{map的KeyName}即可獲取傳入的值

?

• 基本數(shù)據(jù)類型參數(shù)示例：

根據(jù)班級ID查詢教師列表

xml文件

[html] view plaincopy

<select?id="selectTeacher"?parameterType="int"?resultType="com.myapp.domain.Teacher">??

????select?*?from?Teacher?where?c_id=#{id}??

</select>??

java代碼

[java] view plaincopy

List<Teacher>?tList?=?teacherMapper.selectTeacher(2);????

for?(Teacher?entityTemp?:?tList)?{????

????System.out.println(entityTemp.toString());????

}????

• JAVA實(shí)體類型參數(shù)示例：

[html] view plaincopy

<select?id="selectTeacher"?parameterType="com.myapp.domain.Teacher"?resultType="com.myapp.domain.Teacher">??

????select?*?from?Teacher?where?c_id=#{id}??

</select>??

[java] view plaincopy

java代碼??

??

Teacher?queryTeacher=new?Teacher();??

queryTeacher.setId(2);??

List<Teacher>?tList?=?teacherMapper.selectTeacher(queryTeacher);????

for?(Teacher?entityTemp?:?tList)?{????

????System.out.println(entityTemp.toString());?}??

• Map參數(shù)示例：
  [html] view plaincopy
• <select?id="selectTeacher"?parameterType="Map"?resultType="com.myapp.domain.Teacher">??
• ????select?*?from?Teacher?where?c_id=#{id}?and?sex=#{sex}??
• </select>??

[java] view plaincopy
• java代碼??
• ??
• Map<String,String>?map=new?HasMap<String,String>();??
• map.put("id","2");??
• map.put("sex","男");??
• List<Teacher>?tList?=?teacherMapper.selectTeacher(map);????
• for?(Teacher?entityTemp?:?tList)?{????
• ????System.out.println(entityTemp.toString());?}??

?另外MyBatis還提供了一個(gè)使用注解來參入多個(gè)參數(shù)的方式。這種方式需要在接口的參數(shù)上添加@Param注解

示例：

接口方法

[java] view plaincopy

public?List<Teacher>?selectTeacher(@Param(value="id")?String?id,@Param(value="sex")?String?sex);??

XML文件

[html] view plaincopy

<select?id="selectTeacher"??resultType="com.myapp.domain.Teacher">??

????select?*?from?Teacher?where?c_id=#{id}?and?sex=#{sex}??

</select>??

測試代碼

[java] view plaincopy

List<Teacher>?tList?=?teacherMapper.selectTeacher("2","男");????

for?(Teacher?entityTemp?:?tList)?{????

????System.out.println(entityTemp.toString());??

總結(jié)

以上是生活随笔為你收集整理的mybatis传参数的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。