Oracle数据库表结构自动生成JavaBean示例

------------------------------ 下列语句反向生成javaBean：-----------------------------------------------------------------------------------------------------------------

select '@FieldDesc("'|| COMMENTS ||'")' || decode(DATATYPE,'NUMBER','private Long ','private String ') || lower(COLUMN_NAME) || ';' from (
   select a.TABLE_NAME,a.COLUMN_NAME,decode(substr(a.DATA_TYPE,1,9),'UNDEFINED','VARCHAR2','NCHAR','CHAR','NVARCHAR2','VARCHAR2','FLOAT','NUMBER','TIMESTAMP','DATE',a.DATA_TYPE) as DATATYPE,
      to_char(decode(a.DATA_LENGTH,0,100,a.DATA_LENGTH)) as DATA_LENGTH,decode(b.COMMENTS,null,a.COLUMN_NAME,b.COMMENTS) as COMMENTS  
      from USER_TAB_COLUMNS a,USER_COL_COMMENTS b 
      where a.TABLE_NAME=b.TABLE_NAME and a.COLUMN_NAME=b.COLUMN_NAME and a.TABLE_NAME=upper('TABLE_NAME') -- 表名
      order by a.COLUMN_ID);

-- （注意：默认生成的java类型都是String的，根据具体的字段类型进行调整）
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------








------------------------------ 下列语句生成insert的前后两段以及update语句：-----------------------------------------------------------------------------------------------

select wmsys.wm_concat(COLUMN_NAME), wmsys.wm_concat('#' || lower(COLUMN_NAME) || '#'), wmsys.wm_concat(COLUMN_NAME  || '=#' || lower(COLUMN_NAME) || '#') from 
   (select COLUMN_NAME from USER_TAB_COLUMNS where TABLE_NAME=upper('TABLE_NAME') order by COLUMN_ID); -- 表名

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------