升级版大数据教程配套103三大框架mybatis教案-day022

1、Mybatis第二Mybatis第二框架课1程计12Sql34、Mybatis1程计12Sql34、Mybatis2和输mybatis 。2.1 parameterType(输入类型2.1.1 传递简单类型2.1.2 传递pojoMybatisognlMybatisognl 2.1.3pojoPojopojo需求：根据用户名查询用户信息，查询条件放到QueryVouserpublicclassQueryVoprivateUserpublicUsergetUser()returnpublicvoidsetUser(Useruser)this.user=Sql 语SELECT*FRO

2、MSql 语SELECT*FROMuserwhereusernamelike刘Mapper 文接测试方public void testFindUserByQueryVo() throws Exception = ses/获得mapper对UserMapperuserMapper=/创建QueryVo对使用包装类型查询用使用 ognl 从对象中取属性值，如果是包装对象可以使用.操作符来取内容部的属- SELECT * FROM user where username like %$user.username%2.2 resultType(输

3、出类型2.2.1 select2.2 resultType(输出类型2.2.1 selectid=findUserCountparameterType=userselectcount(1)fromMapperfindUserCount(Useruser)throwsPublicvoidtestFindUserCount()throwsQueryVoqueryVo=new/创建user对UserusernewUser(); /根据queryvo查询用Listlist=userMapper.findUserByQueryVo(queryVo); =UserMapperuserMapper=User

4、user=new=UserMapperuserMapper=Useruser=newcount=selectOne。2.2.2pojo2.2.3pojo2.3 resultTypepojo resultMappojo resultMappojoresultMap pojolist2.3.1Resultmap public class Orders eger id; egeruserId; privateStringprivateDateprivateStringuserId问题的原因：ordersuser_iduserId问题的原因：ordersuser_idPOJOuserId2.3.2re

5、sultMap select id,user_id userId,number,createtime,note from ordersOrdersid=3,userId=null,number=1000010,createtime=WedFeb0413:22:35CST2015,publicvoid List orders = sesSystem.out.pr 2.3.3resultMapmapper.xml sql Orders.java2.3.3resultMapmapper.xml sql Orders.java ordersResultMapsql查询列和Users.java /定义多

6、个idresultpojo columnpropertysql publicvoid idproperty=idcolumn=idresultproperty=userIdcolumn=user_idresultproperty=numbercolumn=number resultproperty=notecolumn=noteselectid=getOrderList2resultMap=ordersResultMap select*from3态mybatis3.1 传递pojo3态mybatis3.1 传递pojoselectid=findUserListparameterType=use

7、rselect*fromwhereifandiftest=username!=nullandandusernamelikeList orders = sesselectList(cndohitmybatisusermapperUserMappergetOrderList2); Systemoutpr 3.2 sqlselectid=findUserListparameterType=user3.2 sqlselectid=findUserListparameterType=userselect*fromiftest=id!=nullandandiftest=username!=nullanda

8、ndusernamelikewhere可以自动处理第一个and3.3 sqlList，mybatisidsqlSELECT*FROMUSERSWHEREusernameLIKE张ANDid=10ORid=89ORSELECT*FROMUSERSWHEREusernameSELECT*FROMUSERSWHEREusernameLIKE张ANDidINpojolist select * from useriftest=ids!=null and ids and username like %$user username%3.4 SqlSqlsql 3.4 SqlSqlsql 传递pojosele

9、ctid=findUserListparameterType=userselect*fromiftest=id!=nullandandpublicvoidtestFindUserList3() User user = new User(); usersetUsername(张);ArrayListids=newArrayList idsadd(1); idsadd(10); ids queryVo setIds(ids);List users = ses Systemoutpr iftest=username!=nullandandusernamelikeiftest=username!=nu

10、llandandusernamelikewheresqliftest=id!=nullandandiftest=username!=nullandandusernamelike：selectid=findUserListselect*frominclude includeql片段44.1 includeql片段44.1 4.2 4.2.1 一对一：一个订单只能由一用户创Sql 语句WHERESql 语句WHEREorders.user_id=po publicclassOrdersCustomeger id; eger userId; private

11、String number; privateDatecreatetime; private String note;privateStringusername;/ privateStringaddress;/ selectWHEREorders.user_id=selectWHEREorders.user_id=Mapper 接口publicListfindOrdersList()测试PublicvoidtestfindOrdersList()throws=UserMapperuserMapper=Listlist=小结posql .1

12、.6小结posql 4.2.2 Sql 语句WHEREorders.user_id=po OrdersUser属性，user联查询用户是一对一关系，所以这里使用单个User查询查询订单关联用户信息使用resultmapresultMaptype=Ordersidcolumn=idresultcolumn=user_idresultcolumn=numberresultcolumn=createtimeresultcolumn=note!-一对一关-!-property:Orders对象的user属javaType：user属性对应类 ：user_id-tionpro

13、perty=usercolumn:user表的主键对应的列 property：user对象中id属性idcolumn=user_idresultcolumn=usernameMapper 接 /Mapper 接口publicListfindOrdersListResultMap()throws测试voidtestfindOrdersListResultMap()throws=UserMapperuserMapper=Listlist=小结pojo4.3 4.3.1Sqlu.*, 4.3 4.3.1Sqlu.*, userLEFTJOINo

14、rdersoONu.id=4.3.2poUserListorders4.3.3resultMap4.3.3resultMaptype=user!-用户信-idproperty=idresultproperty=usernameresultproperty=birthdayresultproperty=sexresultproperty=address!-一对多关-collectionproperty=ordersidproperty=id!-用户 id已经在 user对象中存在，此处可以不设置!-property=orders：关联查询的property=orders：关联查询的结果ofTyp

15、e=orders：指定关联查询的结果集中的对象类型即 List 中的对象类型。此处可id及4.3.4MapperList4.3.5resultproperty=numberresultproperty=createtimeresultproperty=note u.*, o.iuserLEFTJOINorderso ONu.id=5Mybatis整合5.1 1、 25Mybatis整合5.1 1、 2 3、 5.2 jar1、springjar2、Mybatisjar 4jar5jarpublicvoidgetUserOrderList()= sqlSesUserMapper userMapp

16、er = sesList result = userMapper.getUserOrderList();for (User user : result) 5.3 javajar（jar包5.3 javajar（jar包 3、Factory对象，配置到spring容器4、 或者mapper文5.3.1?xml=1.0encoding=UTF-85.3.2?xml=1.0encoding=UTF-beans5.3.2?xml=1.0encoding=UTF-beans!DOCTYPEPUBLIC-/DTDConfigpackagemapper.3:/localhost:3306/m

17、ybatis?characterEncoding=utf-加载配置文件context:property-placeholder location=classpath:perties 数据库连接池beanid=dataSourcedestroy-propertyamevalue=$jdbc.driverpropertyname=urlvalue=$jdbc.urlpropertyname=usernamevalue=$jdbc.usernamepropertyname=passwordvalue=$jdbc.passwordpropertyname=maxActivevalue=10

18、propertyname=maxIdlevalue=5mapper配置!- 让spring管理factory使用mybatis和spring整合包中的-beanFactory数据库连接池propertyname=dataSourceref=dataSource加载mybatis的全局配置文件propertyname=configLocationvalue=classpath:mybatis/SqlMapConfig.xml12。5.4.112。5.4.1Support实现publicImplextendsSupportimplementspublic User findUserById(id)throwsException = getSqlSesUseruser=.selectOne(test.findUserById, /不能关闭，让spring容器来完配配 测试方publicvoidtestFindUserByI