mybatis以map为参，动态生成表并插入数据

最新推荐文章于 2023-08-24 15:13:49 发布

xiwu

最新推荐文章于 2023-08-24 15:13:49 发布

阅读量3.1k

点赞数

分类专栏： mybatis

mybatis 专栏收录该内容

3 篇文章

订阅专栏

本文介绍使用MyBatis通过传递Map参数的方式，在PostgreSQL中动态创建表并插入数据的方法。该方法允许根据传入的数据结构自动生成表结构。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mybatis以map为参，动态生成表并插入数据，目前仅在PostgreSQL上做了测试

标签： MyBatis iBATIS

代码片段(2)[全屏查看所有代码]

1. [代码]mybatis javabean 映射文件（部分）跳至 [1] [2] [全屏预览]

 
           <
           insert 
            id
           =
           "creatTableAndInsert" 
            parameterType
           =
           "java.util.Map" 
            statementType
           =
           "STATEMENT"
           >
          
 
                   
           create table if not exists ${tablename}
          
 
                   
           <
           foreach 
            collection
           =
           "keys" 
            item
           =
           "k" 
            index
           =
           "index" 
            open
           =
           "(" 
            separator
           =
           "," 
            close
           =
           ");"
           >
          
 
                       
           ${k} varchar(30) not null
          
 
                   
           </
           foreach
           >
          
 
                   
           insert into ${tablename}
          
 
                   
           <
           foreach 
            collection
           =
           "keys" 
            item
           =
           "k" 
            index
           =
           "index" 
            open
           =
           "(" 
            separator
           =
           "," 
            close
           =
           ")"
           >
          
 
                       
           ${k}
          
 
                   
           </
           foreach
           >
          
 
                   
           values
          
 
                   
           <
           foreach 
            collection
           =
           "keys" 
            item
           =
           "k" 
            index
           =
           "index" 
            open
           =
           "(" 
            separator
           =
           "," 
            close
           =
           ")"
           >
          
 
                       
           '${params[k]}'
          
 
                   
           </
           foreach
           >
          
 
               
           </
           insert
           >
          

2. [代码]mybatis中传入的map结构

 
          Map<String, Object> params = 
          new 
           HashMap<>();
         
          params.put(
          "a"
          , 
          "safd"
          );
         
          params.put(
          "b"
          , 
          "dsjaf"
          );
         
          params.put(
          "c"
          , 
          "123456"
          );
         
          params.put(
          "d"
          , 
          "风景的撒娇房顶上经费等快速拉进房间空间上"
          );
         
          String[] keys = 
          new 
           String[params.size()];
         
          Set<String> sset = params.keySet();
         
          int 
           i = 
          0
          ;
         
          for 
           (String os : sset) {
         
          keys[i++] = os;
         
          }
         
          Map map = 
          new 
           HashMap<>();
         
          map.put(
          "tablename"
          , 
          "pay_o_tb"
          );
         
          map.put(
          "keys"
          , keys);
         
          map.put(
          "params"
          , params);
         
          mapper.creatTableAndInsert(map);