四、使用Map做为参数

王朝学院·作者佚名  2016-08-27
窄屏简体版  字體: 小  |  中  |  大  |  超大  

一、建立表1.1、建立表,并插入数据

/*SQLyog EnterPRise v12.09 (64 bit)MySQL- 5.6.27-log : Database - mybatis

**********************************************************************//*!40101 SET NAMES utf8*/;/*!40101 SET SQL_MODE=''*/;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0*/;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0*/;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'*/;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0*/;CREATEDATABASE/*!32312 IF NOT EXISTS*/`mybatis`/*!40100 DEFAULT CHARACTER SET utf8*/;USE`mybatis`;/*Table structure for table `author`*/DROPTABLEIFEXISTS`author`;CREATETABLE`author` (

`author_id`int(11) unsignedNOTNULLAUTO_INCREMENT COMMENT'作者ID主键',

`author_username`varchar(30)NOTNULLCOMMENT'作者用户名',

`author_passWord`varchar(32)NOTNULLCOMMENT'作者密码',

`author_email`varchar(50)NOTNULLCOMMENT'作者邮箱',

`author_bio`varchar(1000)DEFAULT'这家伙很赖,什么也没留下'COMMENT'作者简介',

`register_time`datetimeDEFAULTCURRENT_TIMESTAMPCOMMENT'注册时间',PRIMARYKEY(`author_id`)

) ENGINE=InnoDB AUTO_INCREMENT=10DEFAULTCHARSET=utf8;/*Data for the table `author`*/insertinto`author`(`author_id`,`author_username`,`author_password`,`author_email`,`author_bio`,`register_time`)values(1,'张三','123456','123@QQ.com','张三是个新手,刚开始注册','2015-10-29 10:23:59'),(2,'李四','123asf','lisi@163.com','魂牵梦萦','2015-10-29 10:24:29'),(3,'王五','dfsd342','ww@sina.com','康熙王朝','2015-10-29 10:25:23'),(4,'赵六','123098sdfa','zhaoliu@qq.com','花午骨','2015-10-29 10:26:09'),(5,'钱七','zxasqw','qianqi@qq.com','这家伙很赖,什么也没留下','2015-10-29 10:27:04'),(6,'张三丰','123456','zhangsf@qq.com','这家伙很赖,什么也没留下','2015-10-29 11:48:00'),(7,'金庸','qwertyuiop','wuji@163.com','这家伙很赖,什么也没留下','2015-10-29 11:48:24'),(8,'知道了','456789','456789@qq.com','哈哈哈哈哈雅虎','2015-10-29 14:03:27'),(9,'不知道','1234567890','123456@qq.com','哈哈哈哈哈雅虎','2015-10-29 14:01:16');/*!40101 SET SQL_MODE=@OLD_SQL_MODE*/;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS*/;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS*/;/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES*/;

二、创建项目2.1、创建项目

2.2、创建POJO类

packagecom.pb.mybatis.po;importjava.util.Date;/***

* @Title: Author.java

* @Package com.pb.mybatis.po

* @ClassName Author

* @Description: TODO(Blog作者类)

*@author刘楠

* @date 2015-10-29 上午9:27:53

*@versionV1.0*/publicclassAuthor {//作者IDprivateintauthorId;//作者用户名privateString authorUserName;//作者密码privateString authorPassword;//作者邮箱privateString authorEmail;//作者介绍privateintauthorBio;//注册时间privateDate registerTime;/***@returnthe authorId*/publicintgetAuthorId() {returnauthorId;

}/***@paramauthorId the authorId to set*/publicvoidsetAuthorId(intauthorId) {this.authorId =authorId;

}/***@returnthe authorUserName*/publicString getAuthorUserName() {returnauthorUserName;

}/***@paramauthorUserName the authorUserName to set*/publicvoidsetAuthorUserName(String authorUserName) {this.authorUserName =authorUserName;

}/***@returnthe authorPassword*/publicString getAuthorPassword() {returnauthorPassword;

}/***@paramauthorPassword the authorPassword to set*/publicvoidsetAuthorPassword(String authorPassword) {this.authorPassword =authorPassword;

}/***@returnthe authorEmail*/publicString getAuthorEmail() {returnauthorEmail;

}/***@paramauthorEmail the authorEmail to set*/publicvoidsetAuthorEmail(String authorEmail) {this.authorEmail =authorEmail;

}/***@returnthe authorBio*/publicintgetAuthorBio() {returnauthorBio;

}/***@paramauthorBio the authorBio to set*/publicvoidsetAuthorBio(intauthorBio) {this.authorBio =authorBio;

}/***@returnthe registerTime*/publicDate getRegisterTime() {returnregisterTime;

}/***@paramregisterTime the registerTime to set*/publicvoidsetRegisterTime(Date registerTime) {this.registerTime =registerTime;

}/**(non Javadoc)

* <p>Title: toString</p>

* <p>Description:重写toString方法 </p>

*@return*@seejava.lang.Object#toString()*/@OverridepublicString toString() {return"Author [authorId=" + authorId + ", authorUserName="

+ authorUserName + ", authorPassword=" +authorPassword+ ", authorEmail=" + authorEmail + ", authorBio=" +authorBio+ ", registerTime=" + registerTime + "]";

}

}

2.3、创建configruation

<?xmlversion="1.0" encoding="UTF-8"?>

<!DOCTYPE configuration

PUBLIC"-//mybatis.org//DTD Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

<properties resource="db.properties" />

<typeAliases>

<!--使用默认别名 -->

<packagename="com.pb.mybatis.po"/>

</typeAliases>

<environmentsdefault="development">

<environment id="development">

<transactionManager type="JDBC"/>

<dataSource type="POOLED">

<property name="driver" value="${jdbc.driver}"/>

<property name="url" value="${jdbc.url}"/>

<property name="username" value="${jdbc.username}"/>

<property name="password" value="${jdbc.password}"/>

</dataSource>

</environment>

</environments>

<mappers>

<!-- 加载映射 -->

<packagename="com.pb.mybatis.mapper"/>

</mappers>

</configuration>

2.3、创建mapper接口

publicinterfaceAuthorMapper {/***

* @Title: findById

* @Description: TODO(根据查找一个用户)

*@paramid

*@returnAuthor*/publicAuthor findAuthorById(intauthorId);

}

2.4、创建mapper.xml

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="com.pb.mybatis.mapper.AuthorMapper"><!--使用resultMap映射 type使用别名,--><resultMaptype="Author"id="authorResultMap"><!--主键--><idproperty="authorId"column="author_id"/><!--普通属性与表中的字段对应--><resultproperty="authorUserName"column="author_username"/><resultproperty="authorPassword"column="author_password"/><resultproperty="authorEmail"column="author_email"/><resultproperty="authorBio"column="author_bio"/><resultproperty="registerTime"column="register_time"/></resultMap><!--根据查找一个用户--><selectid="findAuthorById"parameterType="int"resultMap="authorResultMap">SELECT * FROM author

WHERE author_id=#{authorId}</select></mapper>

三、传入多个ID,进行查找使用List

3.1、更改Mapper接口

/***

* @Title: findAuthors

* @Description: TODO(根据多个ID进行查找)

*@paramidLists

*@returnList<Author>*/publicList<Author> findAuthors(List<Integer> idLists);

3.2、更改Mapper.xml

<!--根据多个ID查找--><selectid="findAuthors"resultMap="authorResultMap">SELECT * FROM author

WHERE author_id in<foreachcollection="list"item="item"index="index"open="("close=")"separator=",">#{item}</foreach><!--collection:传入参数的名称 index:索引: item:collection的别名--></select>

3.3、测试

@TestpublicvoidtestFindAuthors() {//获取会话SqlsessionsqlSession=sqlSessionFactory.openSession();//Mapper接口AuthorMapper authorMapper=sqlSession.getMapper(AuthorMapper.class);

List<Integer> list=newArrayList<Integer>();

list.add(1);

list.add(3);

list.add(4);

list.add(6);

list.add(7);//调用方法List<Author> authors=authorMapper.findAuthors(list);

System.out.println(authors);//关闭会话sqlSession.close();

}

四、使用Map做为参数4.1、在Mapper接口中增加相应方法

/***

* @Title: findAuthorsByMap

* @Description: TODO(使用Map做为参数)

*@parammap

*@returnList<Author>*/publicList<Author> findAuthorsByMap(Map<String, Object> map);

4.2、更改Mapper.xml

<!--使用Map查找--><selectid="findAuthorsByMap"resultMap="authorResultMap">SELECT * FROM author<!--参数使用Map的Key-->WHERE author_username LIKE "%"#{username}"%"

or author_bio like"%"#{bio}"%"</select>

4.3、测试

@TestpublicvoidtestFindAuthorsByMap() {//获取会话SqlSession sqlSession=sqlSessionFactory.openSession();//Mapper接口AuthorMapper authorMapper=sqlSession.getMapper(AuthorMapper.class);

Map<String, Object> map=newHashMap<String, Object>();

map.put("username", "张");

map.put("bio", "哈");//调用方法List<Author> authors=authorMapper.findAuthorsByMap(map);

System.out.println(authors);//关闭会话sqlSession.close();for(Author a:authors){

System.out.println(a.toString());

}

}

五、直接使用多个参数

5.1、Mapper接口

/***

* @Title: findAuthorsByParams

* @Description: TODO(使用多个参数

*@paramid

*@paramusername

*@returnList<Author>*/publicList<Author> findAuthorsByParams(intauthorId,String authorUserName);

5.2、Mapper.xml

<!--直接使用多个参数--><selectid="findAuthorsByParams"resultMap="authorResultMap">SELECT * FROM author

WHERE author_id=#{0}

OR author_username LIKE "%"#{1}"%"<!--其中,#{0}代表接收的是dao层中的第一个参数,#{1}代表dao层中第二参数,更多参数一致往后加即可。--></select>

5.3、测试

@TestpublicvoidtestFindAuthorsByParams() {//获取会话SqlSession sqlSession=sqlSessionFactory.openSession();//Mapper接口AuthorMapper authorMapper=sqlSession.getMapper(AuthorMapper.class);//调用方法List<Author> authors=authorMapper.findAuthorsByParams(6,"张");

System.out.println(authors);//关闭会话sqlSession.close();for(Author a:authors){

System.out.println(a.toString());

}

}

六、直接使用多个参数注解写法

6.1、Mapper接口

publicList<Author> findAuthorsByParams(@Param("id")intauthorId,@Param("username")String authorUserName);

6.2、Mapper.xml

<!--使用注解的方式使用多个参数--><selectid="findAuthorsByParams"resultMap="authorResultMap">SELECT * FROM author

WHERE author_id=#{id}

or author_username LIKE "%"#{username}"%"<!--使用注解的方式。,直接使用Param中的参数即可--></select>

 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
© 2005- 王朝網路 版權所有 導航