达梦在mybatis里批量提交问题

为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:8
【操作系统】麒麟
【CPU】:不知
【问题描述】*：是这么个情况，原先是使用mysql，然后在mybatis里面提交创建表的语句，创建表的语句里面直接使用了comment在列定义后面，现在转达梦了，就被迫一个建表语句分成了好几个语句，建表语句以及几个添加comment的语句，现在这几个语句需要在mapper文件里面的<update>标签中一并提交到数据库中执行，提交直接报错

回答 0

暂无回答

水水水

可以用foreach

发布于 2021/07/29 11:41

yyds

BEGIN execute immediate 'CREATE TABLE ${tableName} ( id bigint NOT NULL identity(1,1), field_001 int DEFAULT NULL, field_002 varchar(255) DEFAULT NULL, process_instance_id varchar(64) DEFAULT NULL, user_id varchar(32) DEFAULT NULL, user_name varchar(32) DEFAULT NULL, real_name varchar(32) DEFAULT NULL, last_update_user_id varchar(32) DEFAULT NULL, last_update_user_name varchar(32) DEFAULT NULL, create_time datetime DEFAULT NULL, last_update_time datetime DEFAULT NULL, PRIMARY KEY (id))'; execute immediate 'COMMENT ON COLUMN ${tableName}.field_001 IS ''数字(整型)'''; execute immediate 'COMMENT ON COLUMN ${tableName}.field_002 IS ''网址'''; execute immediate 'COMMENT ON COLUMN ${tableName}.process_instance_id IS ''流程实例Id'''; execute immediate 'COMMENT ON COLUMN ${tableName}.user_id IS ''用户Id'''; execute immediate 'COMMENT ON COLUMN ${tableName}.user_name IS ''用户名'''; execute immediate 'COMMENT ON COLUMN ${tableName}.real_name IS ''用户真实名'''; execute immediate 'COMMENT ON COLUMN ${tableName}.last_update_user_id IS ''最后修改用户Id'''; execute immediate 'COMMENT ON COLUMN ${tableName}.last_update_user_name IS ''最后修改用户名'''; execute immediate 'COMMENT ON COLUMN ${tableName}.create_time IS ''创建时间'''; execute immediate 'COMMENT ON COLUMN ${tableName}.last_update_time IS ''最后修改时间'''; end; 批量提交可以用execute immediate方式

发布于 2024/11/19 11:16

yyds

insert into users(uname,uage) values (#{item.uname},#{item.uage}) 批量插入可以用foreach标签

发布于 2024/11/19 11:17

yyds

微信截图_20241119111737.png 微信截图_20241119111749.png

发布于 2024/11/19 11:18