做网站难还是app难,推广公司的网站,如何选择徐州网站开发,广告公司网站制作最近在做编程工具#xff0c;便于快速开发程序#xff0c;用过太多框架#xff0c;但是发觉只有自己制作代码工具才开发起来痛快。这个类是用来读取oracle数据库表结构的#xff0c;也包括列的注释#xff0c;对于生成代码有很好的帮助。1.[文件] OracleTable.java ~ 3KB …最近在做编程工具便于快速开发程序用过太多框架但是发觉只有自己制作代码工具才开发起来痛快。这个类是用来读取oracle数据库表结构的也包括列的注释对于生成代码有很好的帮助。1.[文件] OracleTable.java ~ 3KB 下载(72)package db;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;import java.util.HashMap;import java.util.List;/**** 2014-07-21日* oracle数据库 表结构查询 字段信息查询字段注释查询* 表字段查询 all_tab_columns* 表字段注释查询 all_col_comments* author 王华荣**/public class OracleTable {private static final String DRIVER_CLASS oracle.jdbc.driver.OracleDriver;private static final String DATABASE_URL jdbc:oracle:thin:192.168.1.10:1521:orcl;private static final String DATABASE_USER dev;private static final String DATABASE_PASSWORD dev;private static Connection con null;public static Connection getConnection() {try {Class.forName(DRIVER_CLASS);conDriverManager.getConnection(DATABASE_URL,DATABASE_USER,DATABASE_PASSWORD);return con;} catch (Exception ex) {System.out.println(2:ex.getMessage());}return con;}/**** 打印test* throws SQLException*/public static void sysoutStrTablePdmCloumns(String Table,String Owner) throws SQLException{getConnection();List columns new ArrayList();try{Statement stmt con.createStatement();String sqlselect comments as \Name\, a.column_name \Code\, a.DATA_TYPE as \DataType\, b.comments as \Comment\, decode(c.column_name,null,FALSE,TRUE) as \Primary\, decode(a.NULLABLE,N,TRUE,Y,FALSE,) as \Mandatory\, \sequence\ from all_tab_columns a, all_col_comments b, ( select a.constraint_name, a.column_name from user_cons_columns a, user_constraints b where a.constraint_name b.constraint_name and b.constraint_type P and a.table_name Table ) c where a.Table_Nameb.table_Name and a.column_nameb.column_name and a.Table_NameTable and a.ownerb.owner and a.ownerOwner and a.COLUMN_NAME c.column_name() order by a.COLUMN_ID;System.out.println(sql);ResultSet rs stmt.executeQuery(sql);while (rs.next()){HashMap map new HashMap();map.put(Name, rs.getString(Name));map.put(Code, rs.getString(Code));map.put(DataType, rs.getString(DataType));map.put(Comment, rs.getString(Comment));map.put(Primary, rs.getString(Primary));map.put(Mandatory, rs.getString(Mandatory));columns.add(map);}}catch (SQLException e){e.printStackTrace();}finally{con.close();}}public static void main(String[] args) throws SQLException{sysoutStrTablePdmCloumns(CT_INFO_CONTRACT_BORROW,DEV);}}
