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
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Mybatis高级查询(一对一,一对多,多对多)
qq_28603127的博客
10-19 3840
数据准备 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 1842
异常： 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 1640
如果一个数据库操作，出现了异常，我们需要排错，日志就是最好的助手！ 在Mybatis中具体使用哪一个日志实现，在设置中设定。 LOG4J: ●log4j可以控制日志信息输送的目的地是控制台、文件、GUI组件 ●可以控制每一条日志的输出格式 ●通过定义每一条日志信息的级别，能够更加细致地控制日志的生成过程 ●通过一个配置文件来灵活地进行配置，而不需要修改应用的代码 导入LOG4J依赖： <dependencies> <dependency>
mybatis ResolverUtil not a jar死循环
weixin_44679945的博客
04-16 3418
这里写自定义目录标题欢迎使用Markdown编辑器新的改变功能快捷键合理的创建标题，有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列表创建一个表格设定内容居中、居左、居右SmartyPants创建一个自定义列表如何创建一个注脚注释也是必不可少的KaTeX数学公式新的甘特图功能，丰富你的文章UML 图表FLowchart流程图导出与导入导出导入 欢迎使用Ma...
sts安装出现could not find jar:file解决办法
热门推荐
zzf_forgot的博客
03-05 1万+
在eclipse安装spring tool suite过程中，发现从官方下载的文件无法导入，即查找不到文件路径： 如下图所示： 那是因为我们文件下错了，需要下载对应updatesite.zip结尾的包如下图所示: 则可以正常导入插件了 详细可参考 https://blog.csdn.net/weixin_39533410/article/details/80050898 ...
mybatis高级映射一对多查询实现代码
08-30
总结来说，MyBatis的高级映射一对多查询实现主要是通过自定义`ResultMap`，利用`collection`元素映射查询结果中的多条记录到一个集合中，以此来建立Java对象与数据库记录之间的复杂关系。这种方法使得我们可以方便地...
MyBatis高级映射（一对多查询）
04-08
本篇主要探讨的是MyBatis中的高级映射之一——一对多查询。在数据库关系模型中，一对多关系是常见的关联类型，例如一个学生可以对应多个课程，一个部门可以有多个员工等。MyBatis提供了一对多映射功能，使得在Java...
MyBatis高级映射学习教程
09-02
在MyBatis中，高级映射主要涉及一对一、一对多和多对多等复杂关系的映射处理。这些映射在实际开发中非常常见，例如在构建购物车功能时，订单与用户是一对一关系，用户与订单是一对多，而用户与商品则是多对多关系。...
启动项目时出现Not a JAR.......Find JAR........一指循环就是起不来
weixin_33849215的博客
05-25 4176
出现问题原因就是mapper的映射文件有问题，里面的返回类型如是实体找不到或者找重复的就会这样 解决办法就是：确保在用的实体(路径)能找到，切记不能有重名的实体...
jar中资源无法找到报 FileNotFoundException的深度(深入JDK)解析及其终极解决办法
hanghangde的博客
07-29 8736
授之于鱼不如授之于渔今天我就带着大家一起来探寻jar中资源无法找到报 FileNotFoundException 异常现在我手里有一个项目Tank其中有个tank.properties文件存放着 initNum=30及我们坦克初始化的数目模块目录如下我们用IDEA(因为IDEA调试功能比eclipse强大) 有两处需要通过FileOprationTool获取资源new ImageIcon
jar包中File 文件找不到的异常分析与解决
算命de博客
05-25 1193
我们常常在代码中读取一些资源文件(比如图片，音乐，文本等等)。在单独运行的时候这些简单的处理当然不会有问题。但是，如果我们把代码打成一个jar包以后，即使将资源文件一并打包，这些东西也找不出来了。看看下面的代码： //源代码1： package edu.hxraid; import java.io.*; public class Resource { public void getResource() throws IOException{ File fil
URL加载jar
weixin_30508241的博客
03-18 379
　// !/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...
Springmvc+Mybatis（ 配置Conveter转换器 转换工厂 （来转换数据格式）），报错，搞好了
caihorse的专栏
06-03 1024
DEBUG [localhost-startStop-1] - Checking to see if class com.tm.po.ItemsExampleCriterionmatchescriteria[isassignabletoObject]DEBUG[localhost−startStop−1]−Checkingtoseeifclasscom.tm.po.ItemsExampleCriterion matches criteria [is assignable to Object] DEBUG [
mybatis学习笔记(8)-动态sql
brianway
02-29 9360
mybatis核心,对sql语句进行灵活操作，通过表达式进行判断，对sql进行灵活拼接、组装。
mybatis学习之查询缓存
属于Alex的Java小世界
06-24 4508
什么是查询缓存？ mybatis提供查询缓存，用于减轻数据压力，提高数据库性能 mybatis提供一级缓存和二级缓存 一级缓存是SQLSession的缓存 在操作数据库时需要构造SQLSession对象，在对象中有一个数据结构（HashMap）用于存储缓存数据 不同的SQLSession之间的缓存数据区域（HashMap）是互相不影响的 二级缓存是mapper级别的缓存
MyBatis高级映射实战教程：一对一查询解析
"MyBatis高级映射学习教程" 在深入探讨MyBatis的高级映射之前，我们首先需要了解MyBatis的基本概念。MyBatis是一个优秀的持久层框架，它支持定制化SQL、存储过程以及高级映射。它避免了几乎所有的JDBC代码和手动...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值