马上要换工作,手头的系统要进行交接。要写很多交接文档,单单数据字典就要花很多时间,就想到用简单的方法把数据字典导出到WORD里,效率快很多。我一直认为生产力是因为人的惰性才提高的。
package mytest;
import java.io.*;
import java.sql.*;
public class DatabaseDictionary {
public static void main(String[] args) {
try {
FileOutputStream fileOut = new FileOutputStream("c://数据字典.txt");
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection(
"jdbc:oracle:thin:@192.168.132.33:1521:rnd", "user", "password");
Statement stmt = con.createStatement();
StringBuffer strbuf = new StringBuffer();
strbuf.append("SELECT A.*,B.comments");
strbuf.append(" FROM all_tab_columns A,DBA_COL_COMMENTS B");
strbuf.append(" WHERE A.owner=B.owner");
strbuf.append(" AND A.table_name=B.table_na