sqlmetadata.java

来自「java课程的资料以及实验的代码」· Java 代码 · 共 64 行

import java.net.*;
import java.sql.*;
import java.util.*;

class SqlMetaData{
	ResultSet rs,rs1;
	ResultSetMetaData rsmd;
	DatabaseMetaData dbmd;
	Statement stmt;
	Connection con;
	int numCols,i=0;
	SqlMetaData(){
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con=DriverManager.getConnection("jdbc:odbc:Pubs","sa","");
			stmt=con.createStatement();
			
			dbmd=con.getMetaData();
			System.out.println("连接数据源名称："+dbmd.getURL());
			System.out.println("驱动名"+dbmd.getDriverName());
			}
			catch(Exception es)
			{
				es.printStackTrace();
			}
			String[] types=new String[1];
		    System.out.println("--Column Names--");
		   try{
			rs=dbmd.getColumns(null,null,"Authors",null);
			rsmd=rs.getMetaData();
			Vector colHeads=new Vector();
			
			while(rs.next())
			{
				String cname=rs.getString("COLUMN_NAME");
				System.out.print(cname + " ");
				System.out.println();
				colHeads.addElement(cname);
			}
			Enumeration num=colHeads.elements();//这个用枚举输出
			while(num.hasMoreElements())
			{
				String na=(String)num.nextElement();
				System.out.println(na);
			}
			for(int j=0;j<colHeads.size();j++)//这是用向量输出
			{
				String[] name=new String[colHeads.size()];
				name[j]=(String)colHeads.elementAt(j);
				System.out.println(name[j]);
				
			}
			
			
			rs.close();
		}
		catch(Exception e){
			System.out.println(e);
		}
	}
	public static void main(String[] args){
		new SqlMetaData();
	}
}