metadatatest.java

这是一本描述JDBC数据库的书籍

/*
 * RecordMetaDataTest.java
 *
 * Created on June 11, 2005, 12:03 AM
 *
 * To change this template, choose Tools | Options and locate the template under
 * the Source Creation and Management node. Right-click the template and choose
 * Open. You can then make changes to the template in the Source Editor.
 */

package ch03;
import java.sql.*;
import common.*;

/**
 *
 * @author kevin
 */
public class MetaDataTest {
    
    /** Creates a new instance of RecordMetaDataTest */
    public MetaDataTest() {
    }
    
    public static void main(String[] args){
        Connection conn = null;
        Statement  stmt = null;
        ResultSet  rs = null;
        try{
            conn = ConnectionFactory.getConnectionFactory().getConnection();
            DatabaseMetaData dbmd = conn.getMetaData();
            System.out.println(dbmd.getDatabaseMajorVersion());
            System.out.println(dbmd.getDatabaseMinorVersion());
            System.out.println(dbmd.getDatabaseProductName());
            
            stmt = conn.createStatement();
            rs = stmt.executeQuery("select * from person_tbl");
            ResultSetMetaData rsmd = rs.getMetaData();
            int colNum = rsmd.getColumnCount();
            for(int i = 1; i<= colNum; i++){
                System.out.print(rsmd.getColumnType(i));
                System.out.print("\t" + rsmd.getColumnName(i));
                System.out.println("\t" + rsmd.getColumnLabel(i));
            }
        }catch(SQLException e){
            ExportSQLInfo.showSQLException(e);
        }catch(Exception e){
            e.printStackTrace();
        }finally{
            DBUtils.close(rs, stmt, conn);
        }
    }
}