使用ORACLE的视图user_tab_columns,查得表的column_name和data_type,然后再根据需求操作吧。。 select c.COLUMN_NAME,c.DATA_TYPE From user_tab_columns c where c.TABLE_NAME='YOURTABLENAME'(大写)
谢谢楼上两位,不过还有问题。 我操作的是三个表: create table DM.HQ_INT_CODE_TABLE ( ICT_ID VARCHAR2(100) not null, ICT_CODE VARCHAR2(100), ICT_NAME VARCHAR2(100), primary key (ICT_ID) );comment on table DM.HQ_INT_CODE_TABLE is '总部接口编码表定义'; comment on column DM.HQ_INT_CODE_TABLE.ICT_ID is '编码表ID'; comment on column DM.HQ_INT_CODE_TABLE.ICT_CODE is '编码表编码'; comment on column DM.HQ_INT_CODE_TABLE.ICT_NAME is '编码表名称';create table DM.HQ_INT_CODE_TSTRUCTURE ( ICT_ID VARCHAR2(100) not null, FLD_CODE VARCHAR2(30) not null, FLD_NAME VARCHAR2(50) not null, IS_PK NUMBER not null, IS_MANDATORY NUMBER not null, WIDGET_TYPE VARCHAR2(10) not null, DISPLAY_ORDER NUMBER not null, primary key (ICT_ID, FLD_CODE) );comment on table DM.HQ_INT_CODE_TSTRUCTURE is '总部接口编码表结构'; comment on column DM.HQ_INT_CODE_TSTRUCTURE.ICT_ID is '编码表ID'; comment on column DM.HQ_INT_CODE_TSTRUCTURE.FLD_CODE is '字段编码'; comment on column DM.HQ_INT_CODE_TSTRUCTURE.FLD_NAME is '字段名称'; comment on column DM.HQ_INT_CODE_TSTRUCTURE.IS_PK is '是否主键'; comment on column DM.HQ_INT_CODE_TSTRUCTURE.IS_MANDATORY is '是否必填'; comment on column DM.HQ_INT_CODE_TSTRUCTURE.WIDGET_TYPE is '控件类型'; comment on column DM.HQ_INT_CODE_TSTRUCTURE.DISPLAY_ORDER is '显示顺序';create table BOOKS ( MONTH_ID VARCHAR2(8), PROV_ID VARCHAR2(3), books_id VARCHAR2(10), books_desc VARCHAR2(20), publish_Id VARCHAR2(10), publish_desc VARCHAR2(20), COMMENTS VARCHAR2(1000), INSERT_TIME DATE ) pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ) ;comment on table BOOKS is '书籍编码映射表';comment on column BOOKS.MONTH_ID is '月份'; comment on column BOOKS.PROV_ID is '省分编码'; comment on column BOOKS.books_id is '书籍编码'; comment on column BOOKS.books_desc is '书籍编码描述'; comment on column BOOKS.publish_Id is '出版社编码'; comment on column BOOKS.publish_desc is '出版社描述'; comment on column BOOKS.COMMENTS is '备注'; comment on column BOOKS.INSERT_TIME is '入库时间';还有很多类似于第三个的表,这三个表如何关联?如何在jsp页面中点击‘编码表名称’后就会显示相应的表格记录。
From user_tab_columns c
where c.TABLE_NAME='YOURTABLENAME'(大写)
我操作的是三个表:
create table DM.HQ_INT_CODE_TABLE
(
ICT_ID VARCHAR2(100) not null,
ICT_CODE VARCHAR2(100),
ICT_NAME VARCHAR2(100),
primary key (ICT_ID)
);comment on table DM.HQ_INT_CODE_TABLE is
'总部接口编码表定义';
comment on column DM.HQ_INT_CODE_TABLE.ICT_ID is
'编码表ID';
comment on column DM.HQ_INT_CODE_TABLE.ICT_CODE is
'编码表编码';
comment on column DM.HQ_INT_CODE_TABLE.ICT_NAME is
'编码表名称';create table DM.HQ_INT_CODE_TSTRUCTURE
(
ICT_ID VARCHAR2(100) not null,
FLD_CODE VARCHAR2(30) not null,
FLD_NAME VARCHAR2(50) not null,
IS_PK NUMBER not null,
IS_MANDATORY NUMBER not null,
WIDGET_TYPE VARCHAR2(10) not null,
DISPLAY_ORDER NUMBER not null,
primary key (ICT_ID, FLD_CODE)
);comment on table DM.HQ_INT_CODE_TSTRUCTURE is
'总部接口编码表结构';
comment on column DM.HQ_INT_CODE_TSTRUCTURE.ICT_ID is
'编码表ID';
comment on column DM.HQ_INT_CODE_TSTRUCTURE.FLD_CODE is
'字段编码';
comment on column DM.HQ_INT_CODE_TSTRUCTURE.FLD_NAME is
'字段名称';
comment on column DM.HQ_INT_CODE_TSTRUCTURE.IS_PK is
'是否主键';
comment on column DM.HQ_INT_CODE_TSTRUCTURE.IS_MANDATORY is
'是否必填';
comment on column DM.HQ_INT_CODE_TSTRUCTURE.WIDGET_TYPE is
'控件类型';
comment on column DM.HQ_INT_CODE_TSTRUCTURE.DISPLAY_ORDER is
'显示顺序';create table BOOKS (
MONTH_ID VARCHAR2(8),
PROV_ID VARCHAR2(3),
books_id VARCHAR2(10),
books_desc VARCHAR2(20),
publish_Id VARCHAR2(10),
publish_desc VARCHAR2(20),
COMMENTS VARCHAR2(1000),
INSERT_TIME DATE
)
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
)
;comment on table BOOKS is
'书籍编码映射表';comment on column BOOKS.MONTH_ID is
'月份';
comment on column BOOKS.PROV_ID is
'省分编码';
comment on column BOOKS.books_id is
'书籍编码';
comment on column BOOKS.books_desc is
'书籍编码描述';
comment on column BOOKS.publish_Id is
'出版社编码';
comment on column BOOKS.publish_desc is
'出版社描述';
comment on column BOOKS.COMMENTS is
'备注';
comment on column BOOKS.INSERT_TIME is
'入库时间';还有很多类似于第三个的表,这三个表如何关联?如何在jsp页面中点击‘编码表名称’后就会显示相应的表格记录。