mark

最新推荐文章于 2024-08-12 14:10:37 发布

iteye_11163

最新推荐文章于 2024-08-12 14:10:37 发布

阅读量108

点赞数

分类专栏： mybatis 转载文章标签： HowToSelectMultipleParams

本文链接：https://blog.csdn.net/iteye_11163/article/details/82095995

版权

转载同时被 2 个专栏收录

3 篇文章 0 订阅

订阅专栏

mybatis

2 篇文章 0 订阅

订阅专栏

From http://code.google.com/p/mybatis/wiki/HowToSelectMultipleParams

Solution

Add the @Param("name") to your Mapper.java
Change the parameterType in Mapper.xml to "map"

1. Add the @Param("name") to your Mapper.java

UserMapper.java:

import
 org
.
apache
.
ibatis
.
annotations
.
Param
;


public
 
interface
 
UserMapper
{

   
User
 selectUser
(
@Param
(
"username"
)
 
String
 usrename
,
 
@Param
(
"hashedPassword"
)
 
String
 hashedPassword
);


}

2. Change the parameterType in Mapper.xml to "map"

UserMapper.xml:

<select
 
id
=
”selectUser”
 
parameterType
=
”map”
 
resultType
=
”User”
>

  select id, username, hashedPassword
  from some_table
  where usrename = #{username}
  and hashedPassword = #{hashedPassword}

</sql>