oracle 数据库表中转换成java代码

--数据库中字段java代码

1 hibernate1配置

select col.TABLE_NAME,replace(initcap(col.TABLE_NAME),'_', '')
  , 'private '||decode(k.DATA_TYPE, 'VARCHAR2', 'String', 'NUMBER', 'java.lang.Integer', 'DATE', 'java.sql.Timestamp','CHAR', 'String', k.DATA_TYPE)||' '|| lower(col.COLUMN_NAME)||';//'||com.comments
  , '<property name="'||lower(col.COLUMN_NAME)||'" column="'||lower(col.COLUMN_NAME)||'" type="'
  ||decode(k.DATA_TYPE, 'VARCHAR2', 'java.lang.String', 'NUMBER', 'java.lang.Integer', 'DATE', 'java.sql.Timestamp','CHAR', 'String', k.DATA_TYPE)||'"/>'
  from user_tab_columns k , user_tab_columns col
 inner join user_col_comments com    
   on col.TABLE_NAME = com.TABLE_NAME
   and col.COLUMN_NAME = com.COLUMN_NAME
   and com.table_name like '%T_JC_NEW_ZFCG_%' 
   and replace(initcap(col.TABLE_NAME),'_', '') like '%TJcNewZfcgZjjbxx%'
 where k.TABLE_NAME=col.TABLE_NAME and k.COLUMN_NAME=col.COLUMN_NAME and k.COLUMN_ID=col.COLUMN_ID
 order by col.TABLE_NAME, col.COLUMN_ID

2 hibernate2配置

select
    /*private String busiindexid;*/
    'private '||col_type||' '||java_col||';//'||col_commects
    /*get/set注入*/
    ,col_type||' '||java_col||','
    ,'this.'||java_col||'='||java_col||';'
    /*表列的get、set配置*/
     /*@Column(name = "BUSIINDEXID") public String getBusiindexid() {return this.busiindexid;}*/    
    ,'@Column(name ="'||col_name||'") public '||col_type||' get'||java_col_getSet||'() {return this.'||java_col||';} '
     /*public void setDeptid(String deptid) {this.deptid = deptid;}*/
    ||'public void set'||java_col_getSet||'('||col_type||' '||java_col||' ) {this.'||java_col||'='||java_col||';}'
     /*表的信息*/    
    ,tab.*
from (select col.TABLE_NAME,
   replace(initcap(col.TABLE_NAME), '_', '') as java_tab,
   col.COLUMN_NAME as col_name,
   lower(col.COLUMN_NAME) as java_col,
   replace(initcap(col.COLUMN_NAME), '_', '') as java_col_getSet,
   decode(k.DATA_TYPE,
       'VARCHAR2','String',
       'NUMBER','java.lang.Integer',
       'DATE','java.sql.Date',
       'CHAR','String',
       k.DATA_TYPE) AS col_type,
   com.comments AS col_commects
 from user_tab_columns k, user_tab_columns col
inner join user_col_comments com
  on col.TABLE_NAME = com.TABLE_NAME
 and col.COLUMN_NAME = com.COLUMN_NAME
 and com.table_name = 'T_ZDSX_YW_BASEINFO' /*表的名*/
where k.TABLE_NAME = col.TABLE_NAME
 and k.COLUMN_NAME = col.COLUMN_NAME
 and k.COLUMN_ID = col.COLUMN_ID
order by col.TABLE_NAME, col.COLUMN_ID
) tab