解析Mybatis對(duì)sql表的一對(duì)多查詢問題
Mybatisd對(duì)sql表的一對(duì)多查詢
select * from projectrecord pr left join projects po on po.pid=pr.pid left join emp e on e.empno = pr.empno where pr.pid=1
<?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="com.msb.mapper.EmpMapper"> <!--resultMap是一個(gè)映射表,對(duì)應(yīng)的字段會(huì)對(duì)應(yīng)數(shù)據(jù)表的字段 --> <resultMap id="projectMap" type="projects"> <id column="pid" property="pid"></id> <result column="pname" property="pname"></result> <result column="money" property="money"></result> <collection property="projectrecordList" ofType="projectrecord"> <id property="pid" column="pid"></id> <id property="empno" column="empno"></id> <association property="emp" javaType="emp"> <id property="empno" column="empno"></id> <result property="ename" column="ename"></result> <result property="job" column="job"></result> <result property="sal" column="sal"></result> <result property="hiredate" column="hiredate"></result> <result property="mgr" column="mgr"></result> <result property="comm" column="comm"></result> <result property="deptno" column="deptno"></result> </association> </collection> </resultMap> <!--Projects findPiddle(int pid);--> <select id="findPiddle" resultMap="projectMap"> select *from emp e inner join projectrecord pr on pr.empno=e.empno inner join projects po on po.pid= pr.pid where pr.pid=#{pid} </select> </mapper>
//mapper表 package com.msb.mapper; import com.msb.pojo.Dept; import com.msb.pojo.Emp; import com.msb.pojo.Projects; import java.util.List; public interface EmpMapper { /** * 實(shí)現(xiàn)根據(jù)項(xiàng)目編號(hào)查看所有參與項(xiàng)目的人員信息 * @param pid 傳入項(xiàng)目號(hào) * @return 返回一個(gè)project的對(duì)象 */ Projects findPiddle(int pid); }
package com.msb.pojo; //一對(duì)一關(guān)系引入 import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor; import java.io.Serializable; @Data @AllArgsConstructor @NoArgsConstructor public class Projectrecord implements Serializable { private int empno; private int pid; //pr和e是一對(duì)一的關(guān)系 private Emp emp; }
package com.msb.pojo; //一對(duì)多關(guān)系實(shí)體類設(shè)計(jì) import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor; import java.io.Serializable; import java.util.List; @NoArgsConstructor @AllArgsConstructor @Data public class Projects implements Serializable { private int pid; private String pname; private int money; //po和pr是一對(duì)多的關(guān)系 List<Projectrecord> projectrecordList; }
package com.msb.pojo; import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor; import java.sql.Date; @Data @AllArgsConstructor @NoArgsConstructor public class Emp { private Integer empno; private String ename; private String job; private Integer mgr; private Date hiredate; private Integer sal; private Integer comm; private Integer deptno; private Dept dept; }
jdbc_driver=com.mysql.cj.jdbc.Driver jdbc_url=jdbc:mysql://127.0.0.1:3306/testtable?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai jdbc_username=root jdbc_password=root
log4j.rootLogger=debug,stdout log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.Target=System.err log4j.appender.stdout.layout=org.apache.log4j.SimpleLayout log4j.appender.logfile=org.apache.log4j.FileAppender log4j.appender.logfile.File=d:/msb.log log4j.appender.logfile.layout=org.apache.log4j.PatternLayout log4j.appender.logfile.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %l %F %p %m%n
<?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="jdbc.properties"></properties> <!--這里是起的別名,前面是名,后面是路徑--> <!--<typeAliases> <typeAlias alias="dept" type="com.msb.pojo.Dept"/> </typeAliases>--> <!--包別名,用到時(shí)候調(diào)用名字小寫即可,就會(huì)掃描msb下的所以實(shí)體類,用的時(shí)候?qū)嶓w類名小寫--> <typeAliases> <package name="com.msb"/> </typeAliases> <environments default="development"> <environment id="development"> <!-- 簡(jiǎn)單使用了 JDBC 的提交和回滾設(shè)置 --> <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> <!--加載mapper映射文件--> <mappers> <package name="com.msb.mapper"/> </mappers> </configuration>
import com.msb.mapper.EmpMapper; import com.msb.pojo.Dept; import com.msb.pojo.Emp; import com.msb.pojo.Projectrecord; import com.msb.pojo.Projects; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import org.junit.After; import org.junit.Before; import org.junit.Test; import java.io.IOException; import java.io.InputStream; import java.util.List; public class Test1 { SqlSession sqlSession = null; EmpMapper mapper =null; @Before public void test1(){ //首先做一個(gè)對(duì)象SqlSessionFactoryBuilder建立一個(gè)繪話 SqlSessionFactoryBuilder ssfb = new SqlSessionFactoryBuilder(); //有一個(gè)文本輸入的io流進(jìn)行讀取操作 InputStream stream = null; try { //這里的路徑直接會(huì)定位到配置文件classes下面;所以這個(gè)文件在次目錄下--編譯和 //-圖紙;對(duì)數(shù)據(jù)庫(kù)文件進(jìn)行讀取,獲取一個(gè)io流,由于配置文件在classes下面,直接寫文件名即可 stream = Resources.getResourceAsStream("sqlMapConfig.xml"); } catch (IOException e) { e.printStackTrace(); } //build需要指向一個(gè)文件進(jìn)行讀取出來--工廠 SqlSessionFactory factory = ssfb.build(stream); //需要用sqlSession去調(diào)用增刪改查--工人去獲取數(shù)據(jù),打開這個(gè)繪話 sqlSession = factory.openSession(); } /*多對(duì)多的查詢*/ @Test public void test7(){ mapper = sqlSession.getMapper(EmpMapper.class); Projects piddle = mapper.findPiddle(1); System.out.println("Pid"); System.out.println(piddle.getPid()); System.out.println("Pname"); System.out.println(piddle.getPname()); System.out.println("Money"); System.out.println(piddle.getMoney()); System.out.println("ProjectrecordList"); List<Projectrecord> projectrecordList = piddle.getProjectrecordList(); projectrecordList.forEach(System.out::println); } @After public void test3(){ if (sqlSession!=null){ sqlSession.close(); } } }
到此這篇關(guān)于解析Mybatis對(duì)sql表的一對(duì)多查詢的文章就介紹到這了,更多相關(guān)Mybatis一對(duì)多查詢內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家!
- 關(guān)于mybatis一對(duì)一查詢一對(duì)多查詢遇到的問題
- MybatisPlus實(shí)現(xiàn)對(duì)象嵌套關(guān)聯(lián)查詢一對(duì)多List集合查詢
- springboot使用mybatis一對(duì)多的關(guān)聯(lián)查詢問題記錄
- 在MyBatis中實(shí)現(xiàn)一對(duì)多查詢和多對(duì)一查詢的方式詳解(各兩種方式)
- 基于mybatis一對(duì)多查詢內(nèi)層排序的問題
- 解決mybatis一對(duì)多查詢r(jià)esultMap只返回了一條記錄問題
- Mybatis一對(duì)多和多對(duì)一處理的深入講解
- springboot整合mybatis實(shí)現(xiàn)簡(jiǎn)單的一對(duì)多級(jí)聯(lián)查詢功能
- MyBatis圖文并茂講解注解開發(fā)一對(duì)多查詢
相關(guān)文章
Navicat連接SQL Server數(shù)據(jù):報(bào)錯(cuò)08001-命名管道提供程序的完美解決方法
小編新安裝了sqlserver用navicat進(jìn)行連接時(shí)出現(xiàn)一系列問題,不知道該怎么解決,小編小編給大家分享一篇教程關(guān)于Navicat連接SQL Server數(shù)據(jù):報(bào)錯(cuò)08001-命名管道提供程序的問題,感興趣的朋友一起看看吧2021-08-08數(shù)據(jù)庫(kù)SQL語句優(yōu)化總結(jié)(收藏)
網(wǎng)上關(guān)于SQL優(yōu)化的教程很多,但是比較雜亂。近日有空整理了一下,寫出來跟大家分享一下,感興趣的朋友參考下2017-03-03SQL行號(hào)排序和分頁(yè)(SQL查詢中插入行號(hào) 自定義分頁(yè)的另類實(shí)現(xiàn))
如何在SQL中對(duì)行進(jìn)行動(dòng)態(tài)編號(hào),加行號(hào)這個(gè)問題,在數(shù)據(jù)庫(kù)查詢中,是經(jīng)典的問題2012-07-07sqlserver還原數(shù)據(jù)庫(kù)的時(shí)候出現(xiàn)提示無法打開備份設(shè)備的解決方法(設(shè)備出現(xiàn)錯(cuò)誤或設(shè)備脫)
今天在恢復(fù)數(shù)據(jù)庫(kù)的時(shí)候,因?yàn)槭钱惖夭糠诌€原,出現(xiàn)提示 無法打開備份設(shè)備 E:\自動(dòng)備份\ufidau8xTmp\UFDATA.BAK 。設(shè)備出現(xiàn)錯(cuò)誤或設(shè)備脫,這里分享一下解決方法,需要的朋友可以參考一下2016-03-03在SQL Server中備份和恢復(fù)數(shù)據(jù)庫(kù)的四種方法
在SQL Server中,創(chuàng)建備份和執(zhí)行還原操作對(duì)于確保數(shù)據(jù)完整性、災(zāi)難恢復(fù)和數(shù)據(jù)庫(kù)維護(hù)至關(guān)重要,本文給大家介紹了備份和恢復(fù)數(shù)據(jù)庫(kù)的最佳方法,需要的朋友可以參考下2023-12-12SQL SERVER備份數(shù)據(jù)庫(kù)存儲(chǔ)過程的方法
這篇文章主要介紹了SQL SERVER備份數(shù)據(jù)庫(kù)存儲(chǔ)過程的方法,需要的朋友可以參考下2015-10-10