mybatis学习之高级映射中的一对一查询

最新推荐文章于 2022-04-23 15:10:02 发布
最新推荐文章于 2022-04-23 15:10:02 发布
阅读量758 收藏
点赞数
分类专栏： mybatis 文章标签： mybatis web框架 Java EE sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/fjnmbb12/article/details/73611213
版权

1 一对一查询

      1.1 需求
              查询订单信息，关联查询创建订单的用户信息
      1.2 resultType
              1.2.1 sql语句 
                    确定要查询的主表：订单表 order
                    再确定要查询的关联表： 用户表 user 
SELECT orders.*,user.`username`,user.`sex`,user.`address` FROM orders,USER WHERE orders.`user_id` = user.`id`
1.2.2 创建pojo对象
将上面的sql查询结果映射到pojo中，pojo要包含sql查询的所有字段
原始的pojo不能映射全部字段，需要新创建pojo
创建一个pojo继承包括查询字段较多的pojo类
1.2.3 mapper.xml 
    <!-- 查询订单 关联查询用户 -->
    <select id="findOrderUser" resultType="pojo.OrderCustom">
        SELECT orders.*,user.username,user.sex,user.address FROM orders,USER WHERE orders.user_id = user.id
    </select>


1.2.4 mapper.java
    //查询订单关联查询用户
    public List<OrderCustom> findOrderUser() throws Exception;
1.2.5 测试代码
    @Test
    public void  testFindOrderUser() throws Exception{
        SqlSession sqlSession = sqlSessionFactory.openSession();
        //创建代理对象
        OrderMapperCustom orderMapperCustom = sqlSession.getMapper(OrderMapperCustom.class);
        //调用mapper的方法
        List<OrderCustom> list = orderMapperCustom.findOrderUser();
        System.out.println(list);
    }

1.2.6执行结果
DEBUG [main] - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
DEBUG [main] - Class not found: org.jboss.vfs.VFS
DEBUG [main] - JBoss 6 VFS API is not available in this environment.
DEBUG [main] - Class not found: org.jboss.vfs.VirtualFile
DEBUG [main] - VFS implementation org.apache.ibatis.io.JBoss6VFS is not valid in this environment.
DEBUG [main] - Using VFS adapter org.apache.ibatis.io.DefaultVFS
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo
DEBUG [main] - Reader entry: Order.class
DEBUG [main] - Reader entry: OrderCustom.class
DEBUG [main] - Reader entry: User.class
DEBUG [main] - Reader entry: UserCustom.class
DEBUG [main] - Reader entry: UserQueryVo.class
DEBUG [main] - Listing file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/Order.class
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/Order.class
DEBUG [main] - Reader entry: ����   4 L
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/OrderCustom.class
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/OrderCustom.class
DEBUG [main] - Reader entry: ����   4 "
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/User.class
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/User.class
DEBUG [main] - Reader entry: ����   4 L
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/UserCustom.class
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/UserCustom.class
DEBUG [main] - Reader entry: ����   4 
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/UserQueryVo.class
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/UserQueryVo.class
DEBUG [main] - Reader entry: ����   4 %
DEBUG [main] - Checking to see if class pojo.Order matches criteria [is assignable to Object]
DEBUG [main] - Checking to see if class pojo.OrderCustom matches criteria [is assignable to Object]
DEBUG [main] - Checking to see if class pojo.User matches criteria [is assignable to Object]
DEBUG [main] - Checking to see if class pojo.UserCustom matches criteria [is assignable to Object]
DEBUG [main] - Checking to see if class pojo.UserQueryVo matches criteria [is assignable to Object]
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper
DEBUG [main] - Reader entry: OrderMapperCustom.class
DEBUG [main] - Reader entry: OrderMapperCustom.xml
DEBUG [main] - Reader entry: UserMapper.class
DEBUG [main] - Reader entry: UserMapper.xml
DEBUG [main] - Listing file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper/OrderMapperCustom.class
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper/OrderMapperCustom.class
DEBUG [main] - Reader entry: ����   4    
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper/OrderMapperCustom.xml
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper/OrderMapperCustom.xml
DEBUG [main] - Reader entry: <?xml version="1.0" encoding="UTF-8" ?>
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper/UserMapper.class
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper/UserMapper.class
DEBUG [main] - Reader entry: ����   4    findUserByIdResultMap (I)Lpojo/User; 
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper/UserMapper.xml
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper/UserMapper.xml
DEBUG [main] - Reader entry: <?xml version="1.0" encoding="UTF-8" ?>
DEBUG [main] - Checking to see if class mapper.OrderMapperCustom matches criteria [is assignable to Object]
DEBUG [main] - Checking to see if class mapper.UserMapper matches criteria [is assignable to Object]
DEBUG [main] - Opening JDBC Connection
DEBUG [main] - Created connection 1227074340.
DEBUG [main] - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@4923ab24]
DEBUG [main] - ==>  Preparing: SELECT orders.*,user.username,user.sex,user.address FROM orders,USER WHERE orders.user_id = user.id 
DEBUG [main] - ==> Parameters: 
DEBUG [main] - <==      Total: 4
[Order{id=6, userId=null, number='3', createtime=Thu Jun 22 21:30:02 CST 2017, note='null'}, Order{id=7, userId=null, number='6', createtime=Thu Jun 22 21:30:12 CST 2017, note='null'}, Order{id=8, userId=null, number='9', createtime=Thu Jun 22 21:30:22 CST 2017, note='null'}, Order{id=9, userId=null, number='11', createtime=Thu Jun 22 21:30:33 CST 2017, note='null'}]

Process finished with exit code 0

注意：在此处，没有在mapper.xml里配置输入参数类型，因为我们只要结果数据，所以没有配置，sql语句也是原封不动的sql查询语句，不需要传入参数所以不要更改，只需
需要创建与输出结果字段相匹配的pojo扩展类


      1.3 resultMap
                1.3.1 sql语句 
          SELECT orders.*,user.`username`,user.`sex`,user.`address` FROM orders,USER WHERE orders.`user_id` = user.`id`

                1.3.2 使用resultMap进行映射的思路
                    使用resultMap将查询的结果的订单信息映射至Order对象中,在Order类中添加User属性，将关联查询出来的用户信息映射到Order对象的User对象属性中
                1.3.3 在Order类中添加User属性
                      
    //用户信息
    private User user;
                    同时生成get和set方法
                 1.3.4 mapper.xml
                    定义resultMap 
    <!-- 查询订单关联查询用户ResultMap -->
    <resultMap id="OrderUserResultMap" type="Order">

        <!-- 配置要映射的订单信息 -->
        <id column="id" property="id" />
        <result column="user_id" property="userId" />
        <result column="number" property="number" />
        <result column="createtime" property="createtime" />
        <result column="note" property="note" />
        <!-- 配置要映射的用户信息 -->

        <!--
         association：用户映射关联查询单个对象的信息
         property:要降关联查询的用户信息映射到order中的哪个属性
         javaType:pojo对象路径 可用别名
         -->
        <association property="user" javaType="User">

            <!--
            关联查询用户的唯一标识
             column：用于唯一标识user信息的列
             property:映射到user的哪个属性
             -->
            <id column="user_id" property="id"  />
            <result column="username" property="username" />
            <result column="sex" property="sex" />
            <result column="address" property="address" />
        </association>
    </resultMap>
                    定义statement
    <!-- 查询订单 关联查询用户 使用resultMap -->
    <select id="findOrderUserResultMap" resultMap="OrderUserResultMap">
        SELECT orders.*,user.username,user.sex,user.address FROM orders,USER WHERE orders.user_id = user.id
    </select>

                 1.3.5 mapper.java
                     
    //查询订单关联查询用户使用resultMap
    public List<Order> findOrderUserResultMap() throws Exception;
                 1.3.6 测试代码
    @Test
    public void testFindOrderUserResultMap() throws Exception{
        SqlSession sqlSession = sqlSessionFactory.openSession();
        OrderMapperCustom orderMapperCustom = sqlSession.getMapper(OrderMapperCustom.class);
        List<Order> list = orderMapperCustom.findOrderUserResultMap();
        System.out.println(list);
    }
                 1.3.7 输出结果 
DEBUG [main] - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
DEBUG [main] - Class not found: org.jboss.vfs.VFS
DEBUG [main] - JBoss 6 VFS API is not available in this environment.
DEBUG [main] - Class not found: org.jboss.vfs.VirtualFile
DEBUG [main] - VFS implementation org.apache.ibatis.io.JBoss6VFS is not valid in this environment.
DEBUG [main] - Using VFS adapter org.apache.ibatis.io.DefaultVFS
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo
DEBUG [main] - Reader entry: Order.class
DEBUG [main] - Reader entry: OrderCustom.class
DEBUG [main] - Reader entry: User.class
DEBUG [main] - Reader entry: UserCustom.class
DEBUG [main] - Reader entry: UserQueryVo.class
DEBUG [main] - Listing file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/Order.class
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/Order.class
DEBUG [main] - Reader entry: ����   4 T
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/OrderCustom.class
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/OrderCustom.class
DEBUG [main] - Reader entry: ����   4 "
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/User.class
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/User.class
DEBUG [main] - Reader entry: ����   4 L
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/UserCustom.class
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/UserCustom.class
DEBUG [main] - Reader entry: ����   4 
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/UserQueryVo.class
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/UserQueryVo.class
DEBUG [main] - Reader entry: ����   4 %
DEBUG [main] - Checking to see if class pojo.Order matches criteria [is assignable to Object]
DEBUG [main] - Checking to see if class pojo.OrderCustom matches criteria [is assignable to Object]
DEBUG [main] - Checking to see if class pojo.User matches criteria [is assignable to Object]
DEBUG [main] - Checking to see if class pojo.UserCustom matches criteria [is assignable to Object]
DEBUG [main] - Checking to see if class pojo.UserQueryVo matches criteria [is assignable to Object]
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper
DEBUG [main] - Reader entry: OrderMapperCustom.class
DEBUG [main] - Reader entry: OrderMapperCustom.xml
DEBUG [main] - Reader entry: UserMapper.class
DEBUG [main] - Reader entry: UserMapper.xml
DEBUG [main] - Listing file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper/OrderMapperCustom.class
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper/OrderMapperCustom.class
DEBUG [main] - Reader entry: ����   4  
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper/OrderMapperCustom.xml
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper/OrderMapperCustom.xml
DEBUG [main] - Reader entry: <?xml version="1.0" encoding="UTF-8" ?>
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper/UserMapper.class
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper/UserMapper.class
DEBUG [main] - Reader entry: ����   4    findUserByIdResultMap (I)Lpojo/User; 
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper/UserMapper.xml
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper/UserMapper.xml
DEBUG [main] - Reader entry: <?xml version="1.0" encoding="UTF-8" ?>
DEBUG [main] - Checking to see if class mapper.OrderMapperCustom matches criteria [is assignable to Object]
DEBUG [main] - Checking to see if class mapper.UserMapper matches criteria [is assignable to Object]
DEBUG [main] - Opening JDBC Connection
DEBUG [main] - Created connection 1227074340.
DEBUG [main] - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@4923ab24]
DEBUG [main] - ==>  Preparing: SELECT orders.*,user.username,user.sex,user.address FROM orders,USER WHERE orders.user_id = user.id 
DEBUG [main] - ==> Parameters: 
DEBUG [main] - <==      Total: 4
[Order{id=6, userId=28, number='3', createtime=Thu Jun 22 21:30:02 CST 2017, note='null'}, Order{id=7, userId=29, number='6', createtime=Thu Jun 22 21:30:12 CST 2017, note='null'}, Order{id=8, userId=30, number='9', createtime=Thu Jun 22 21:30:22 CST 2017, note='null'}, Order{id=9, userId=31, number='11', createtime=Thu Jun 22 21:30:33 CST 2017, note='null'}]

Process finished with exit code 0


           1.4 resultType和resultMap实现一对一查询小结
                 实现一对一查询：

                      resultType： 使用resultType实现较为简单，如果pojo中没有包括查询的列名，需要增加对应pojo属性，即可完成映射
                       如果没有查询结果的特殊要求没建议使用resultType

                      resultMap： 使用resultMap，实现比较麻烦，如果对于查询结果有特殊的要求，可以使用resultMap完成将关联查询结果映射到pojo属性中去。
                       resultMap可以实现延迟加载，resultType 
Alex_Ricardo
关注
专栏目录
Mybatis高级查询(一对一,一对多,多对多)
qq_28603127的博客
10-19 3843
数据准备 CREATE TABLE `student_info` ( `classes` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `student_numer` int(11) DEFAULT NULL, `subject` varchar(255) DEFAULT NULL, `score` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSER
Caused by: org.apache.ibatis.type.TypeException
qq_56637516的博客
10-14 1847
异常： Files\Java\jdk1.8.0_131\jre\lib\charsets.jar;D:\Program Files\Java\jdk1.8.0_131\jre\lib\deploy.jar;D:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\access-bridge-64.jar;D:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\cldrdata.jar;D:\Program Files\Java\j
【MyBatis笔记】日志
暮色年华的博客
04-23 1642
如果一个数据库操作，出现了异常，我们需要排错，日志就是最好的助手！ 在Mybatis中具体使用哪一个日志实现，在设置中设定。 LOG4J: ●log4j可以控制日志信息输送的目的地是控制台、文件、GUI组件 ●可以控制每一条日志的输出格式 ●通过定义每一条日志信息的级别，能够更加细致地控制日志的生成过程 ●通过一个配置文件来灵活地进行配置，而不需要修改应用的代码 导入LOG4J依赖： <dependencies> <dependency>
Mybatis源码阅读(二)
srs1995的博客
11-27 614
本文主要介绍Java中，不使用XML和使用XML构建SqlSessionFactory，通过SqlSessionFactory 中获取SqlSession的方法，使用SqlsessionManager管理Sqlsession复用等等..以及相关的示例代码 SqlSession SqlSessions 是由 SqlSessionFactory 实例创建的。SqlSessionFactory 对象包含创建 SqlSession 实例的各种方法。而 SqlSessionFactory 本身是由 SqlSessi
jar包中File 文件找不到的异常分析与解决
算命de博客
05-25 1196
我们常常在代码中读取一些资源文件(比如图片，音乐，文本等等)。在单独运行的时候这些简单的处理当然不会有问题。但是，如果我们把代码打成一个jar包以后，即使将资源文件一并打包，这些东西也找不出来了。看看下面的代码： //源代码1： package edu.hxraid; import java.io.*; public class Resource { public void getResource() throws IOException{ File fil
mybatis高级映射一对多查询实现代码
08-30
总结来说，MyBatis的高级映射一对多查询实现主要是通过自定义`ResultMap`，利用`collection`元素映射查询结果中的多条记录到一个集合中，以此来建立Java对象与数据库记录之间的复杂关系。这种方法使得我们可以方便地...
MyBatis高级映射（一对多查询）
04-08
本篇主要探讨的是MyBatis中的高级映射之一——一对多查询。在数据库关系模型中，一对多关系是常见的关联类型，例如一个学生可以对应多个课程，一个部门可以有多个员工等。MyBatis提供了一对多映射功能，使得在Java...
MyBatis高级映射学习教程
09-02
在MyBatis中，高级映射主要涉及一对一、一对多和多对多等复杂关系的映射处理。这些映射在实际开发中非常常见，例如在构建购物车功能时，订单与用户是一对一关系，用户与订单是一对多，而用户与商品则是多对多关系。...
URL加载jar
weixin_30508241的博客
03-18 380
　// !/test.xml 是表示jar中的test.xml文件 final URL jarUrl = new URL("jar:file:/C:/proj/parser/jar/parser.jar!/test.xml"); final JarURLConnection connection = (JarURLConnection) jarUrl.openConn...
.PersistenceException: ### Error querying database.Cause: java.lang.NullPointerException
编程学习集装箱
07-24 4868
错误 [org.apache.ibatis.io.ResolverUtil]-Checking to see if class com.wei.mapper.UserMapper matches criteria [is assignable to Object] [org.apache.ibatis.transaction.jdbc.JdbcTransaction]-Opening JDBC Connection org.apache.ibatis.exceptions.PersistenceExcep
mysql mybatis 缓存_mybatis的二级缓存
weixin_29083475的博客
02-07 625
二级缓存：1、需要在SqlMapper.xml里配置二级缓存总开关"lazyLoadingEnabled" value="true"/>"aggressiveLazyLoading" value="false"/>"cacheEnabled" value="true"/>2、在UserMapper.xml里配置"120000">3、在结果映射的pojo中还包括了pojo...
MyBatis的日志工厂 | MyBatis系列（五）
大鱼的博客
07-22 985
文章目录相关文章前言一、STDOUT_LOGGING 日志二、LOG4J 日志①、MyBatis中使用②、正常项目中业务层使用③、log4j.properties配置文件配置详细解释 相关文章 MyBatis系列汇总：MyBatis系列 前言 在实际开发中，项目上线之后，如果发生问题，我们定位问题不可能一直去看控制台日志（即nohup文件），正确的做法当然是看日志啦！ logImpl 指定 MyBatis 所用日志的具体实现，未指定时将自动查找。 SLF4J | LOG4J | LOG
mybatis学习之查询缓存
属于Alex的Java小世界
06-24 4510
什么是查询缓存？ mybatis提供查询缓存，用于减轻数据压力，提高数据库性能 mybatis提供一级缓存和二级缓存 一级缓存是SQLSession的缓存 在操作数据库时需要构造SQLSession对象，在对象中有一个数据结构（HashMap）用于存储缓存数据 不同的SQLSession之间的缓存数据区域（HashMap）是互相不影响的 二级缓存是mapper级别的缓存
mybatis学习笔记(8)-动态sql
brianway
02-29 9365
mybatis核心,对sql语句进行灵活操作，通过表达式进行判断，对sql进行灵活拼接、组装。
mybatis学习之高级映射中的一对多查询
属于Alex的Java小世界
06-23 988
一对多查询 1、需求 查询订单及订单明细的信息 2 、sql语句 确定主查询表：订单表 order 确定关联查询表： 订单明细表 orderdetail 在一对一查询的基础上，添加订单明细表的关联即可 SELECT orders.*,user.`username`,user.`sex`,user.`address` , orderdetail.`id` orderde
MyBatis高级映射实战教程：一对一查询解析
"MyBatis高级映射学习教程" 在深入探讨MyBatis的高级映射之前，我们首先需要了解MyBatis的基本概念。MyBatis是一个优秀的持久层框架，它支持定制化SQL、存储过程以及高级映射。它避免了几乎所有的JDBC代码和手动...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值