MyBaits关联查询一对一、一对多

最新推荐文章于 2023-06-29 16:55:18 发布
最新推荐文章于 2023-06-29 16:55:18 发布
阅读量487 收藏
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u011852988/article/details/50622912
版权
CREATE TABLE `person` (
`id` bigint (20) NOT NULL AUTO_INCREMENT COMMENT 'id' ,
` name ` varchar (24) NOT NULL COMMENT '用户名' ,
`pswd` varchar (16) NOT NULL COMMENT '密码' ,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT= '用户'
CREATE TABLE `extinfo` (
`id` bigint (20) NOT NULL AUTO_INCREMENT COMMENT 'id' ,
`personid` bigint (20) NOT NULL COMMENT '用户id' ,
`email` varchar (32) DEFAULT NULL COMMENT 'email' ,
`qq` bigint (20) DEFAULT NULL COMMENT 'QQ号' ,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT= '用户扩展信息（一个用户只能有一条扩展记录）'
CREATE TABLE `address` (
`id` bigint (20) NOT NULL AUTO_INCREMENT COMMENT 'id' ,
`personid` bigint (20) NOT NULL COMMENT '用户id' ,
`addr` varchar (128) DEFAULT NULL COMMENT '地址' ,
`zipcode` varchar (8) DEFAULT NULL COMMENT '邮编' ,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT= '地址（一个用户可以有多个地址）'
CREATE TABLE `orders` (
`id` bigint (20) NOT NULL AUTO_INCREMENT COMMENT 'ID' ,
`personid` bigint (20) NOT NULL COMMENT '用户ID' ,
`product` varchar (128) NOT NULL COMMENT '产品' ,
`num` int (11) NOT NULL COMMENT '数量' ,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8

 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
public class Person implements Serializable {
private long id;
private String name;          //用户名
private String pswd;          //密码
private Extinfo extinfo;
private List<Address> addressList= new ArrayList<Address>( 0 );
private List<Orders> ordersList= new ArrayList<Orders>( 0 );
public class Extinfo implements Serializable {
private long id;
private long personid;          //用户id
private String email;          //email
private long qq;          //QQ号
public class Address implements Serializable {
private long id;
private long personid;          //用户id
private String addr;          //地址
private String zipcode;          //邮编
public class Orders implements Serializable {
private long id;
private long personid;          //用户ID
private String product;          //产品
private int num;          //数量

 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
<? xml version = "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 = "config/jdbc.properties" />
< typeAliases >
< package name = "mypkg.entity" />
</ typeAliases >
< environments default = "development" >
< environment id = "development" >
< transactionManager type = "JDBC" />
< dataSource type = "POOLED" >
< property name = "driver" value = "${driver}" />
< property name = "url" value = "${url}" />
< property name = "username" value = "${username}" />
< property name = "password" value = "${password}" />
</ dataSource >
</ environment >
</ environments >
< mappers >
< mapper resource = "mypkg/entity/Person.xml" />
< mapper resource = "mypkg/entity/Extinfo.xml" />
< mapper resource = "mypkg/entity/Address.xml" />
< mapper resource = "mypkg/entity/Orders.xml" />
</ mappers >
</ configuration >

 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
<? 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">
< mapper namespace = "Person" >
< resultMap id = "rs_base" type = "Person" >
< id column = "id" property = "id" />
< result property = "name" column = "name" />
< result property = "pswd" column = "pswd" />
</ resultMap >
<!-- 一对一，两个一对多，存在N+1问题，不推荐使用 -->
< resultMap id = "rs1" type = "Person" >
< id property = "id" column = "id" />
< result property = "name" column = "name" />
< result property = "pswd" column = "pswd" />
< association property = "extinfo" column = "id" select = "Extinfo.queryByPersonid" />
< collection property = "addressList" column = "id" select = "Address.queryByPersonid" />
< collection property = "ordersList" column = "id" select = "Orders.queryByPersonid" />
</ resultMap >
< select id = "find1" parameterType = "string" resultType = "Person" resultMap = "rs1" >
select * from person where name like "%"#{value}"%"
</ select >
<!-- 一对一，没有N+1问题 -->
< resultMap id = "rs2" type = "Person" >
< id property = "id" column = "p_id" />
< result property = "name" column = "name" />
< result property = "pswd" column = "pswd" />
< association property = "extinfo" column = "id" javaType = "extinfo" >
< id property = "id" column = "e_id" />
< result property = "personid" column = "personid" />
< result property = "email" column = "email" />
< result property = "qq" column = "qq" />
</ association >
</ resultMap >
< select id = "find2" parameterType = "string" resultType = "Person" resultMap = "rs2" >
select *,p.id as p_id, e.id as e_id from person p left join extinfo e on p.id=e.personid
where p.name like "%"#{value}"%"
</ select >
<!-- 一对多，没有N+1问题 -->
< resultMap id = "rs3" type = "Person" >
< id property = "id" column = "p_id" />
< result property = "name" column = "name" />
< result property = "pswd" column = "pswd" />
< collection property = "addressList" column = "id" javaType = "Address" >
< id property = "id" column = "a_id" />
< result property = "personid" column = "personid" />
< result property = "addr" column = "addr" />
< result property = "zipcode" column = "zipcode" />
</ collection >
</ resultMap >
< select id = "find3" parameterType = "string" resultType = "Person" resultMap = "rs3" >
select *,p.id as p_id, a.id as a_id from person p left join address a on p.id=a.personid
where p.name like "%"#{value}"%"
</ select >
<!-- 一对一和一对多，没有N+1问题 -->
< resultMap id = "rs4" type = "Person" autoMapping = "true" >
< id property = "id" column = "p_id" />
< result property = "name" column = "name" />
< result property = "pswd" column = "pswd" />
< association property = "extinfo" column = "id" javaType = "extinfo" >
< id property = "id" column = "e_id" />
< result property = "personid" column = "e_pid" />
< result property = "email" column = "email" />
< result property = "qq" column = "qq" />
</ association >
< collection property = "addressList" column = "id" javaType = "Address" >
< id property = "id" column = "a_id" />
< result property = "personid" column = "a_pid" />
< result property = "addr" column = "addr" />
< result property = "zipcode" column = "zipcode" />
</ collection >
</ resultMap >
< select id = "find4" parameterType = "string" resultType = "Person" resultMap = "rs4" >
select *,p.id as p_id, e.id as e_id, a.id as a_id,e.personid as e_pid ,a.personid as a_pid
from person p left join address a on p.id=a.personid
left join extinfo e on p.id = e.personid
where p.name like '%b%'
</ select >
<!-- 一对多，2个一对多，没有N+1问题 -->
< resultMap id = "rs5" type = "Person" autoMapping = "true" >
< id property = "id" column = "p_id" />
< result property = "name" column = "name" />
< result property = "pswd" column = "pswd" />
< association property = "extinfo" column = "id" javaType = "extinfo" >
< id property = "id" column = "e_id" />
< result property = "personid" column = "e_pid" />
< result property = "email" column = "email" />
< result property = "qq" column = "qq" />
</ association >
< collection property = "addressList" column = "id" ofType = "Address" >
< id property = "id" column = "a_id" />
< result property = "personid" column = "a_pid" />
< result property = "addr" column = "addr" />
< result property = "zipcode" column = "zipcode" />
</ collection >
< collection property = "ordersList" column = "id" ofType = "Orders" >
< id property = "id" column = "o_id" />
< result property = "personid" column = "o_pid" />
< result property = "product" column = "product" />
< result property = "num" column = "num" />
</ collection >
</ resultMap >
< select id = "find5" parameterType = "string" resultType = "Person" resultMap = "rs5" >
select *,p.id as p_id, e.id as e_id, a.id as a_id,e.personid as e_pid ,a.personid as a_pid,o.id as o_id,o.personid as o_pid
from person p left join address a on p.id=a.personid
left join extinfo e on p.id = e.personid
left join orders o on p.id = o.personid
where p.name like '%b%'
</ select >
< insert id = "insert" parameterType = "Person" useGeneratedKeys = "true" keyProperty = "id" >
insert into person(name,pswd) values(#{name},#{pswd})
</ insert >
< update id = "update" parameterType = "Person" >
update person set name=#{name},pswd=#{pswd} where id=#{id}
</ update >
< select id = "load" parameterType = "long" resultType = "Person" resultMap = "rs_base" >
select * from person where id = #{value}
</ select >
< delete id = "delete" parameterType = "long" >
delete from person where id = #{value}
</ delete >
<!-- 查询结果集为Map -->
< select id = "load4Map" resultType = "map" >
select * from person
</ select >
</ mapper >

 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
<? 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">
< mapper namespace = "Extinfo" >
< resultMap id = "rs_base" type = "Extinfo" >
< id column = "id" property = "id" />
< result property = "personid" column = "personid" />
< result property = "email" column = "email" />
< result property = "qq" column = "qq" />
</ resultMap >
< select id = "queryByPersonid" parameterType = "long" resultType = "Extinfo" resultMap = "rs_base" >
select * from extinfo where personid=#{value}
</ select >
</ mapper >
1
2
3
4
5
6
7
8
9
10
11
12
13
14
<? 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">
< mapper namespace = "Address" >
< resultMap id = "rs_base" type = "Address" >
< id column = "id" property = "id" />
< result property = "personid" column = "personid" />
< result property = "addr" column = "addr" />
< result property = "zipcode" column = "zipcode" />
</ resultMap >
< select id = "queryByPersonid" parameterType = "long" resultType = "Address" resultMap = "rs_base" >
select * from address where personid=#{value}
</ select >
</ mapper >
1
2
3
4
5
6
7
8
9
10
11
12
13
14
<? 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">
< mapper namespace = "Orders" >
< resultMap id = "rs_base" type = "Orders" >
< id column = "id" property = "id" />
< result property = "personid" column = "personid" />
< result property = "product" column = "product" />
< result property = "num" column = "num" />
</ resultMap >
< select id = "queryByPersonid" parameterType = "long" resultType = "Orders" resultMap = "rs_base" >
select * from orders where personid=#{value}
</ select >
</ mapper >
1
2
3
4
5
6
7
8
9
10
11
12
13
#全局日志配置
log4j.rootLogger=debug, stdout
#包下所有类的日志级别
log4j.logger.org.apache.ibatis=debug
log4j.logger.java.sql. Connection =info, stdout
log4j.logger.java.sql.Statement=debug, stdout
log4j.logger.java.sql.PreparedStatement=debug, stdout
#日志输出到控制台
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %l  %m%n
#关闭Spring日志
log4j.category.org.springframework = OFF

 

 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
D:\jdk1. 6 .0_45\bin\java -Didea.launcher.port= 7533 -Didea.launcher.bin.path=C:\IDEA. 13.0 . 1 \bin -Dfile.encoding=UTF- 8 -classpath D:\jdk1. 6 .0_45\jre\lib\charsets.jar;D:\jdk1. 6 .0_45\jre\lib\deploy.jar;D:\jdk1. 6 .0_45\jre\lib\javaws.jar;D:\jdk1. 6 .0_45\jre\lib\jce.jar;D:\jdk1. 6 .0_45\jre\lib\jsse.jar;D:\jdk1. 6 .0_45\jre\lib\management-agent.jar;D:\jdk1. 6 .0_45\jre\lib\plugin.jar;D:\jdk1. 6 .0_45\jre\lib\resources.jar;D:\jdk1. 6 .0_45\jre\lib\rt.jar;D:\jdk1. 6 .0_45\jre\lib\ext\dnsns.jar;D:\jdk1. 6 .0_45\jre\lib\ext\localedata.jar;D:\jdk1. 6 .0_45\jre\lib\ext\sunjce_provider.jar;D:\jdk1. 6 .0_45\jre\lib\ext\sunmscapi.jar;D:\jdk1. 6 .0_45\jre\lib\ext\sunpkcs11.jar;D:\IdeaProjects\mybaitsdemo2\out\production\mybaitsdemo2;D:\IdeaProjects\mybaitsdemo2\lib\asm- 3.3 . 1 .jar;D:\IdeaProjects\mybaitsdemo2\lib\junit- 4.0 .jar;D:\IdeaProjects\mybaitsdemo2\lib\cglib- 2.2 . 2 .jar;D:\IdeaProjects\mybaitsdemo2\lib\log4j- 1.2 . 16 .jar;D:\IdeaProjects\mybaitsdemo2\lib\mybatis- 3.2 . 6 .jar;D:\IdeaProjects\mybaitsdemo2\lib\slf4j-api- 1.7 . 5 .jar;D:\IdeaProjects\mybaitsdemo2\lib\javassist- 3.17 . 1 -GA.jar;D:\IdeaProjects\mybaitsdemo2\lib\slf4j-log4j12- 1.7 . 5 .jar;D:\IdeaProjects\mybaitsdemo2\lib\commons-logging- 1.1 . 1 .jar;D:\IdeaProjects\mybaitsdemo2\lib\mysql-connector-java- 5.1 . 17 -bin.jar;C:\IDEA. 13.0 . 1 \lib\idea_rt.jar com.intellij.rt.execution.application.AppMain mypkg.dao.PersonDAO
2014 - 03 - 27 18 : 11 : 13 org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java: 139 )  ==>  Preparing: select *,p.id as p_id, e.id as e_id, a.id as a_id,e.personid as e_pid ,a.personid as a_pid,o.id as o_id,o.personid as o_pid from person p left join address a on p.id=a.personid left join extinfo e on p.id = e.personid left join orders o on p.id = o.personid where p.name like '%b%'
2014 - 03 - 27 18 : 11 : 13 org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java: 139 )  ==> Parameters:
2014 - 03 - 27 18 : 11 : 13 org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java: 139 )  <==      Total: 15
Person{id= 1 , name= '张三b' , pswd= '111' }
Extinfo{id= 1 , personid= 1 , email= 'adf@as.com' , qq= 1231412341 }
Address{id= 1 , personid= 1 , addr= 'adsaaaa' , zipcode= '2342342' }
Address{id= 2 , personid= 1 , addr= 'werwqfqw' , zipcode= '2234234' }
Address{id= 3 , personid= 1 , addr= 'qwefaz' , zipcode= '2342342' }
Orders{id= 1 , personid= 1 , product= 'aaa' , num= 2 }
Person{id= 2 , name= '李四b' , pswd= '222' }
Extinfo{id= 2 , personid= 2 , email= 'jkks@sa.com' , qq= 827238782 }
Address{id= 4 , personid= 2 , addr= 'vzczsd' , zipcode= '13234234' }
Address{id= 5 , personid= 2 , addr= 'aaaaaaaaa' , zipcode= '2342356' }
Address{id= 6 , personid= 2 , addr= 'asawsd' , zipcode= '4564565' }
Orders{id= 2 , personid= 2 , product= 'bbb' , num= 3 }
Orders{id= 3 , personid= 2 , product= 'ccc' , num= 1 }
Person{id= 3 , name= '王五b' , pswd= '111' }
Extinfo{id= 3 , personid= 3 , email= '8238@aa.com' , qq= 234253234 }
Address{id= 7 , personid= 3 , addr= 'jkhkky' , zipcode= '2342342' }
Orders{id= 4 , personid= 3 , product= 'ddd' , num= 3 }
Orders{id= 5 , personid= 3 , product= 'asdf' , num= 21 }
Person{id= 5 , name= 'ggggb' , pswd= 'password' }
Extinfo{id= 5 , personid= 5 , email= '2323423W@asd.com' , qq= 8992837422 }
Orders{id= 7 , personid= 5 , product= 'zzdfa' , num= 232 }
Orders{id= 8 , personid= 5 , product= 'ggg' , num= 66 }
Person{id= 15 , name= 'testnameb' , pswd= 'password' }
Person{id= 19 , name= 'testnameb' , pswd= 'password' }
Process finished with exit code 0
黑白幽默
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
mybatis系列三：一对多双向关联
08-10
在MyBatis系列的第三部分，我们将深入探讨“一对多双向关联”的概念及其实现方法。 首先，理解“一对多”关联是关键。在数据库设计中，这种关系表示一个实体（如订单）可以与多个其他实体（如订单中的商品）相关联...
mybatis一对一与一对多
10-11
在实际开发中，我们常常会遇到一对一（One-to-One）和一对多（One-to-Many）的关系映射，这两种关系在数据库设计中非常常见。本篇文章将详细探讨 MyBatis 如何处理一对一和一对多的映射，以及在 Oracle 数据库中如何...
mybatis——查询
mooonk的博客
07-08 125
一、mybatis实现数据库和Java代码解耦步骤 package com.company.test; import com.company.entity.Flower; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.
MyBaits的各种基本查询方式
Sherry198786的博客
09-09 136
<?xml version="1.0" encoding="gbk"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "mybatis-3-mapper.dtd"> <mapper namespace="org.phf.mapping.UserMapp...
mybatis查询方法
weixin_43189971的博客
06-24 2782
1.一对一，一对多，多对一，多对多 2.懒加载，立即加载 3.注解查询 4.批量增删查， 5.模糊查询 6#和$的区别 7.mybatis两种逆向工程的实现方法 8.嵌套一对一和嵌套一对多，以及为什么使用他们 9.if ，where，set，trim，foreach，choose以及使用方法 10. 注解懒加载开发.....................
Mybatis(一对多查询)
Ledis的博客
11-05 758
Mybatis(一对多查询)
Mybatis中的一般查询
二哈
01-19 1673
1. 经常要使用到根据文本框输入的内容来进行模糊查询，这个时候涉及到几个问题： ①xml文件怎么样写模糊查询语句，即怎么样拼接参数的问题，此外还需要判断某个传递的参数是否为空的问题 ②控制器中怎么样传递这个参数这样在xml文件中的if标签才可以使用这个从控制器中传递的这个自定义的变量从而判断当前的参数是否为空的情况 因为有的时候我们不想输入数据来查询，想查询出全部的数据，这个时候查询条件为空...
mybatis实现多对一的实例
04-16
在实体类和Mapper接口中，可以通过注解@One、@Many等来声明多对一或一对多的关系。 9. **测试验证**：描述中提到这个实例已经过测试，意味着所有的配置和SQL查询都是有效的，并且可以在实际项目中使用。测试通常...
mybatis入门实例(多对一xml)
05-23
首先，多对一关系指的是在数据库设计中，一个实体（表）可以与多个其他实体相关联，而另一个实体只能与一个特定实体关联。例如，一个员工可以属于一个部门，但一个部门可以有多个员工。在Java对象模型中，这通常表现...
MyBatis-Plus多表联合查询并且分页(3表联合)
08-24
MyBatis-Plus 是一个基于 MyBatis 的增强型 ORM 框架，提供了很多实用的功能，例如多表联合查询和分页等。下面我们将详细介绍如何使用 MyBatis-Plus 实现多表联合查询并且分页（3 表联合）。 首先，让我们看一下...
MyBatis操作数据库（查询功能）
qq_73471456的博客
06-13 3611
介绍使用MyBatis操作数据库来进行数据库查询
Mybatis的各种查询功能
梦想也许遥不可及，但重要的是追梦的过程，用博客记录自己的成长，记录自己一步一步向上攀登的印记
04-01 2789
前言查询的记录有多条查询二 SQL语句使用了聚合函数查询三 返回值类型为map 前言 使用Mybatis进行查询的时候，查询出来的数据可能有一条数据，也可能是多条，我们就得根据返回数据的条数来指定返回类型，如果记录是多条，那么返回值类型就不能是实体类。 查询的记录有多条 如果查询出来有多条记录，但是我们方法的返回类型是实体类，就会报下面的错误 org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or n.
MyBatis的各种查询功能
qq_55304388的博客
06-29 695
MyBatis的各种查询功能
mybatis一对一关联查询
qq_34489356的博客
06-14 294
public class CardInfo implements java.io.Serializable{     private int id;     private String cardNumber;// 时长卡卡号     private String password;// 卡密     private int balance;// 此次充时长 单位:秒     priva
MyBatis—利用MyBatis查询（查询所有，查询一行，条件查询）
chenxingxingxing的博客
03-16 3万+
MyBatis—利用MyBatis查询（查询所有，查询一行，条件查询）
mybatis 中 查询sql使用in
qq_37173183的博客
01-22 3881
foreach语句中， collection属性的参数类型可以使：List、数组、map集合 ​ cllection： 必须跟mapper.java中@Param标签指定的元素名一样 ​ item ： 表示在迭代过程中每一个元素的别名，可以随便起名，但是必须跟元素中的#{}里面的名称一样。 实例： 　　　 collection属性是
使用MyBatis实现条件查询
bst2000的专栏
01-03 2万+
一、SQL映射文件 MyBatis真正强大之处就在于SQL映射语句，也就是它的魅力所在。 相对于它强大的功能，SQL映射文件的配置却非常简单。 在前面的学习中，我们简单地对比了SQL映射配置和JDBC代码，发现使用SQL映射文件
mybatis查询多条记录，只返回最后一条
热门推荐
u013862444的博客
06-06 3万+
遇到的问题是，如果封装好的select查询语句直接在mysql中运行的话，正确返回list组数但是，当整合到mybatis里面就只能查询其中一条大牛给的提示：需要说明 select的列不需要和对应的resultMap的元素数量一一对应；mybatis使用association 时必须要保证key和association并列，简单来说就是select后面的列很多都可以省但a.m_id, a.s_id...
Mybatis查询
weixin_44712669的博客
07-15 1819
Mybatis的使用--查询1.定义需要的映射1.1首先再UserMapper接口中定义查询接口，1.2mapper.xml中的注意事项：1.3 注意1.3.1 只传递一个参数1.3.2 传递多个参数2.动态传输的问题2.1 例子;2.2 关于sql注入2.2.1 解决sql注入问题：3. 联表查询3.1 一对一：注意3.1.2 实现过程3.2 一对多查询4. 设置动态sql语句4.1 if的使用，首先定义接口再定义sql.xml方法：测试4.2 trim的使用定义接口定义xml测试4.3 where的使用
mybaits一对多关联查询
最新发布
10-07
在mybatis中，实现一对多关联查询可以使用两种方式：嵌套查询和嵌套结果映射。嵌套查询是指在主查询中执行子查询来获取关联对象的数据，而嵌套结果映射是指在主查询的结果映射中包含关联对象的映射。 对于嵌套查询...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值