test.java

与传统图书馆信息服务相比

package kjb.main;

import java.lang.*;
import java.util.*;
import java.sql.*;

public class test
{


	public void getTableStruct(String table_schema,String table)
	{
		Vector vect = new Vector();
		try
		{
			
			Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
			Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@10.0.0.94:1521:hg","oaadminuser","lancom4454");
			//Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:kjb","kjb","kjb");
			//Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@@localhost:1521:hg_10.0.0.94","kjb","kjb");



			Statement stm = conn.createStatement();
			ResultSet rs = stm.executeQuery("select * from ZZ_ZWB");
			ResultSetMetaData rmd = rs.getMetaData();
			int cols = rmd.getColumnCount();
			for(int t=1;t<=cols;t++)
			{
				Hashtable hash = new Hashtable();	
				hash.put("TABLE_CAT","null");//表目录，很可能是空值
				hash.put("TABLE_SCHEM","HG");//表所在的库名
				hash.put("TABLE_NAME","ZZ_ZWB");//表名
				hash.put("COLUMN_NAME",rmd.getColumnName(t)+"");//列名
				hash.put("DATA_TYPE",rmd.getColumnType(t)+"");//字段的类型的整型量标识
				hash.put("TYPE_NAME",rmd.getColumnTypeName(t)+"");//字段的类型的名字
				hash.put("COLUMN_SIZE",rmd.getColumnDisplaySize(t)+"");//字段的长度
				hash.put("NULLABLE",rmd.isNullable(t)+"");//字段是否可以为空，以0,1,2标识
				vect.add(hash);
			}			
			rs.close();			
		}
		catch(ClassNotFoundException ec){System.out.println("从自身建立数据库连接时出错;\r\n错误为:"+ec);}
		catch(SQLException e){System.out.println("从自身建立数据库连接时出错;\r\n错误为:"+e);}
		catch(Exception et){System.out.println("从自身建立数据库连接时出错;\r\n错误为:"+et);}
		catch(AbstractMethodError ea){System.out.println("调用DownloadTabInfo.getTableStruct()函数错误:\r\n"+ea);}
		
	}

	public static void main(String args[])
	{
		test t = new test();
		t.getTableStruct("HG","ZZ_ZWB");

	}

}