jdbc mysql user_tab_comments_oracle数据库自动生成数据库表结构文档(亲测有效)

12

3 importjava.awt.Color;4 importjava.io.FileOutputStream;5 importjava.sql.Connection;6 importjava.sql.DriverManager;7 importjava.sql.ResultSet;8 importjava.sql.SQLException;9 importjava.sql.Statement;10 importjava.util.ArrayList;11 importjava.util.HashMap;12 importjava.util.Iterator;13 importjava.util.List;14 importjava.util.Map;15

16 import com.lowagie.text.*;17 importcom.lowagie.text.rtf.RtfWriter2;18 /**

19 * 数据库文档生成器 Oracle版20 * itext-2.1.7.jar21 * itext-rtf-2.1.7.jar22 *@authorcuiyj23 *24 */

25 public classGenerateTableDoc {26 //键类型字典

27 private static Map keyType = new HashMap();28 //需要导出的目标表

29 private static List targetTable = new ArrayList();30 static{31 targetTable.add("COMMON_ADDRESS");//表名

32 targetTable.add("L_USER");33 }34 //初始化jdbc

35 static{36 try{37 keyType.put("ID", "主键");38 //keyType.put("C", "Check");

39 Class.forName("oracle.jdbc.OracleDriver");40 } catch(ClassNotFoundException e) {41 e.printStackTrace();42 }43 }44 //private static String url = "";//链接url

45 private static String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";//链接url

46 private static String username = "user"; //用户名.需要设置默认表空间哈

47 private static String password = "user"; //密码

48 private static String schema = "