jdbc获取oracle表结构

import java.sql.*;
import java.io.*;
public class getConnAndTableStruct {
	public static void main(String[] args) {
		Connection conn=null;
		DatabaseMetaData m_DBMetaData=null;
		ResultSet tableRet=null;
		ResultSet colRet=null;
		FileWriter fw=null;
		BufferedWriter bw=null;
		try{
			//加载驱动
			Class.forName("oracle.jdbc.driver.OracleDriver");
			//建立连接
			conn=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","scott","tiger");
			
			m_DBMetaData=conn.getMetaData();
			tableRet=m_DBMetaData.getTables(null,"%","%",new String[]{"TABLE"});
			//创建FileWriter对象
			fw=new FileWriter("d:/oracle.txt");    //创建文件，把结果存到d:/oracle.txt
			//缓冲对文件的输出
			bw=new BufferedWriter(fw);             //创建缓存
			
			String columnName=null;
			String columnType=null;
			int i=1;
			String T_NAME=null;
			while