jeecgboot积木报表（jimuReport）Oracle切换

准备数据库

执行Oracle SQL（网友分享），或使用MySQL的SQL代码创建库后，使用DBeaver或navicat等工具转换为Oracle库（官方最新）

修改数据库链接字符串

url: jdbc:oracle:thin:@192.168.1.1:1521:ORCL
username: root
password: root
driver-class-name: oracle.jdbc.OracleDriver

数据库脚本

CREATE TABLE jimu_dict  (
  id varchar2(32)  NOT NULL,
  dict_name nvarchar2(100)  NULL,
  dict_code varchar2(100)  NULL,
  description nvarchar2(255)  NULL,
  del_flag number(1) NULL,
  create_by varchar2(32)  NULL ,
  create_time DATE NULL ,
  update_by varchar2(32)  NULL  ,
  update_time DATE NULL ,
  type number(1)  NULL  ,
  PRIMARY KEY (ID)
); 

COMMENT ON COLUMN jimu_dict.dict_name IS '字典名称';
COMMENT ON COLUMN jimu_dict.dict_code IS '字典编码';
COMMENT ON COLUMN jimu_dict.description IS '描述';
COMMENT ON COLUMN jimu_dict.del_flag IS '删除状态';
COMMENT ON COLUMN jimu_dict.type IS '字典类型0为string,1为number';

CREATE TABLE  JIMU_DICT_ITEM(
	ID VARCHAR(32) NOT NULL,
	DICT_ID VARCHAR(32),
	ITEM_TEXT NVARCHAR2(100) NOT NULL,
	ITEM_VALUE NVARCHAR2(100) NOT NULL,
	DESCRIPTION NVARCHAR2(255),
	SORT_ORDER DECIMAL,
	STATUS DECIMAL,
	CREATE_BY VARCHAR(32),
	CREATE_TIME DATE,
	UPDATE_BY VARCHAR(32),
	UPDATE_TIME DATE,
	PRIMARY KEY (ID)
);

CREATE TABLE "JIMU_REPORT" 
   (	"ID" VARCHAR2(32), 
	"CODE" VARCHAR2(50), 
	"NAME" VARCHAR2(50), 
	"NOTE" VARCHAR2(255), 
	"STATUS" VARCHAR2(10), 
	"TYPE" VARCHAR2(10), 
	"JSON_STR" CLOB, 
	"API_URL" VARCHAR2(255), 
	"THUMB" VARCHAR2(4000), 
	"CREATE_BY" VARCHAR2(50), 
	"CREATE_TIME" TIMESTAMP (6), 
	"UPDATE_BY" VARCHAR2(50), 
	"UPDATE_TIME" TIMESTAMP (6), 
	"DEL_FLAG" NUMBER(3,0), 
	"API_METHOD" VARCHAR2(255), 
	"API_CODE" VARCHAR2(255), 
	"TEMPLATE" NUMBER(3,0), 
	"VIEW_COUNT" NUMBER(19,0)
   )  ;
ALTER TABLE JIMU_REPORT ADD (css_str nclob);
COMMENT ON COLUMN JIMU_REPORT.css_str IS 'css增强';
ALTER TABLE JIMU_REPORT ADD (js_str nclob);
COMMENT ON COLUMN JIMU_REPORT.js_str IS 'js增强';   

CREATE TABLE "JIMU_REPORT_DATA_SOURCE" 
   (	"ID" VARCHAR2(36), 
	"NAME" VARCHAR2(100), 
	"REPORT_ID" VARCHAR2(100), 
	"CODE" VARCHAR2(100), 
	"REMARK" VARCHAR2(200), 
	"DB_TYPE" VARCHAR2(10), 
	"DB_DRIVER" VARCHAR2(100), 
	"DB_URL" VARCHAR2(500), 
	"DB_USERNAME" VARCHAR2(100), 
	"DB_PASSWORD" VARCHAR2(100), 
	"CREATE_BY" VARCHAR2(50), 
	"CREATE_TIME" TIMESTAMP (6), 
	"UPDATE_BY" VARCHAR2(50), 
	"UPDATE_TIME" TIMESTAMP (6)
   )  ;
ALTER TABLE jimu_report_data_source ADD (connect_times integer);
COMMENT ON COLUMN jimu_report_data_source.connect_times IS '连接失败次数';   

CREATE TABLE "JIMU_REPORT_DB" 
   (	"ID" VARCHAR2(36), 
	"JIMU_REPORT_ID" VARCHAR2(32), 
	"CREATE_BY" VARCHAR2(50), 
	"UPDATE_BY" VARCHAR2(50), 
	"CREATE_TIME" TIMESTAMP (6), 
	"UPDATE_TIME" TIMESTAMP (6), 
	"DB_CODE" VARCHAR2(32), 
	"DB_CH_NAME" VARCHAR2(50), 
	"DB_TYPE" VARCHAR2(32), 
	"DB_TABLE_NAME" VARCHAR2(32), 
	"DB_DYN_SQL" VARCHAR2(4000), 
	"DB_KEY" VARCHAR2(32), 
	"TB_DB_KEY" VARCHAR2(32), 
	"TB_DB_TABLE_NAME" VARCHAR2(32), 
	"JAVA_TYPE" VARCHAR2(32), 
	"JAVA_VALUE" VARCHAR2(255), 
	"API_URL" VARCHAR2(255), 
	"API_METHOD" VARCHAR2(255), 
	"IS_LIST" NUMBER(10,0), 
	"IS_PAGE" VARCHAR2(10), 
	"DB_SOURCE" VARCHAR2(255), 
	"DB_SOURCE_TYPE" VARCHAR2(50)
   )  ;
ALTER TABLE jimu_report_db ADD (api_convert varchar2(255));
COMMENT ON COLUMN jimu_report_db.api_convert IS 'api转换器';   

CREATE TABLE "JIMU_REPORT_DB_FIELD" 
   (	"ID" VARCHAR2(36), 
	"CREATE_BY" VARCHAR2(50), 
	"CREATE_TIME" TIMESTAMP (6), 
	"UPDATE_BY" VARCHAR2(50), 
	"UPDATE_TIME" TIMESTAMP (6), 
	"JIMU_REPORT_DB_ID" VARCHAR2(32), 
	"FIELD_NAME" VARCHAR2(80), 
	"FIELD_TEXT" VARCHAR2(50), 
	"WIDGET_TYPE" VARCHAR2(50), 
	"WIDGET_WIDTH" NUMBER(10,0), 
	"ORDER_NUM" NUMBER(10,0), 
	"SEARCH_FLAG" NUMBER(10,0), 
	"SEARCH_MODE" NUMBER(10,0), 
	"DICT_CODE" VARCHAR2(255)
   )   ;
ALTER TABLE jimu_report_db_field ADD (search_format varchar2(50));
COMMENT ON COLUMN jimu_report_db_field.search_format IS '查询时间格式化表达式';

ALTER TABLE jimu_report_db_field ADD (ext_json nclob);
COMMENT ON COLUMN jimu_report_db_field.ext_json IS '参数配置';   

CREATE TABLE "JIMU_REPORT_DB_PARAM" 
   (	"ID" VARCHAR2(36), 
	"JIMU_REPORT_HEAD_ID" VARCHAR2(36), 
	"PARAM_NAME" VARCHAR2(32), 
	"PARAM_TXT" VARCHAR2(32), 
	"PARAM_VALUE" VARCHAR2(32), 
	"ORDER_NUM" NUMBER(10,0), 
	"CREATE_BY" VARCHAR2(50), 
	"CREATE_TIME" TIMESTAMP (6), 
	"UPDATE_BY" VARCHAR2(50), 
	"UPDATE_TIME" TIMESTAMP (6)
   )  ;

ALTER TABLE jimu_report_db_param ADD (search_flag NUMBER(1));
COMMENT ON COLUMN jimu_report_db_param.search_flag IS '查询标识0否1是 默认0';

ALTER TABLE jimu_report_db_param ADD (widget_type varchar2(50));
COMMENT ON COLUMN jimu_report_db_param.widget_type IS '查询控件类型';

ALTER TABLE jimu_report_db_param ADD (search_mode NUMBER(1));
COMMENT ON COLUMN jimu_report_db_param.search_mode IS '查询模式1简单2范围';

ALTER TABLE jimu_report_db_param ADD (dict_code varchar2(255));
COMMENT ON COLUMN jimu_report_db_param.dict_code IS '字典';

ALTER TABLE jimu_report_db_param ADD (search_format varchar2(50));
COMMENT ON COLUMN jimu_report_db_param.search_format IS '查询时间格式化表达式';

ALTER TABLE jimu_report_db_param ADD (ext_json nclob);
COMMENT ON COLUMN jimu_report_db_param.ext_json IS '参数配置';



ALTER TABLE jimu_report_link ADD (link_chart_id varchar2(50));
COMMENT ON COLUMN jimu_report_link.link_chart_id IS '联动图表的ID';

ALTER TABLE jimu_report_link ADD (expression varchar2(255));
COMMENT ON COLUMN jimu_report_link.expression IS '表达式';

ALTER TABLE jimu_report_link ADD (requirement varchar2(255));
COMMENT ON COLUMN jimu_report_link.requirement IS '条件';

CREATE TABLE "JIMU_REPORT_MAP" 
   (	"ID" VARCHAR2(64), 
	"LABEL" VARCHAR2(125), 
	"NAME" VARCHAR2(125), 
	"data" CLOB, 
	"CREATE_BY" VARCHAR2(32), 
	"CREATE_TIME" TIMESTAMP (6), 
	"UPDATE_BY" VARCHAR2(32), 
	"UPDATE_TIME" TIMESTAMP (6), 
	"DEL_FLAG" VARCHAR2(1), 
	"SYS_ORG_CODE" VARCHAR2(64)
   ) ;   
   
CREATE TABLE JIMU_REPORT_SHARE (
	ID VARCHAR2(32),
	REPORT_ID VARCHAR2(32),
	PREVIEW_URL VARCHAR2(1000),
	PREVIEW_LOCK VARCHAR2(4),
	LAST_UPDATE_TIME DATE,
	TERM_OF_VALIDITY VARCHAR2(1),
	STATUS VARCHAR2(1)
);
COMMENT ON COLUMN JIMU_REPORT_SHARE.report_id IS '在线excel设计器id';
COMMENT ON COLUMN JIMU_REPORT_SHARE.preview_url IS '预览地址';
COMMENT ON COLUMN JIMU_REPORT_SHARE.preview_lock IS '密码锁';
COMMENT ON COLUMN JIMU_REPORT_SHARE.last_update_time IS '最后更新时间';
COMMENT ON COLUMN JIMU_REPORT_SHARE.term_of_validity IS '有效期(0:永久有效，1:1天，2:7天)';
COMMENT ON COLUMN JIMU_REPORT_SHARE.status IS '是否过期(0未过期，1已过期)';