写一个
java
转换程序读表
t_cms_user
的数据,并且导入
PostgreSQL
数据库。
写一个
java
转换程序读表
itask_detail
的数据,并且导入
oracle
数据库
oracle数据库与PostgreSQL数据库相互转化的java程序
t_cms_user表
create table T_CMS_USER
(
USER_ID VARCHAR2(20) not null,
ROLE_ID VARCHAR2(20) not null,
DEPARTMENT_ID VARCHAR2(14),
CATALOG_ID VARCHAR2(4000),
LOGINNAME VARCHAR2(20),
PASSWORD VARCHAR2(256),
REALNAME VARCHAR2(50),
SEX VARCHAR2(6),
TELEPHONE VARCHAR2(30),
MOBILE VARCHAR2(30),
EMAIL VARCHAR2(100),
ADDRESS VARCHAR2(200),
REMARK VARCHAR2(500),
STATUS VARCHAR2(6),
CREATEDATE DATE
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table T_CMS_USER
add constraint PK_T_CMS_USER_1_1 primary key (USER_ID)
using index
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
task_detail表
CREATE TABLE itask_task_detail
(
task_id character varying(16) NOT NULL,
task_pid character varying(16),
task_name character varying(200),
task_content text,
task_type character varying(3),
task_urg character varying(1),
task_sec character varying(1),
task_pbegin timestamp without time zone,
task_pend timestamp without time zone,
task_rbegin timestamp without time zone,
task_rend timestamp without time zone,
task_time timestamp without time zone,
task_sender character varying(8),
task_exec text,
task_score numeric(9,2),
task_status character varying(1),
care_person text,
task_order numeric(9),
task_sec_prop text,
task_path character varying(2000),
son_flag character varying(1),
key_word character varying(200),
modify_time timestamp without time zone,
link_task character varying(2000),
task_leader text,
task_helper text,
CONSTRAINT pk_tsk_detail PRIMARY KEY (task_id)
)
WITH (OIDS=FALSE);
ALTER TABLE itask_task_detail OWNER TO postgres;
主要是数据类型的转换。
DataBase.java
Oracle_JDBC.java
PostGreSQL_JDBC.java
CopyData.java