JDBC_DatabaseMetaData_ResultSetMetaData

    1. DatabaseMetaData

    Class UtiDb

    Class DatMetDat

package JavaJDBC.Chap08.sec01;

import JavaJDBC.util.UtiDb;

import java.sql.Connection;
import java.sql.DatabaseMetaData;

/**
 * Created by linux_ccmj on 16-5-17.
 */
public class DatMetDat {
    public static void main(String[] args) throws Exception{
        // utiDb, Connection
        UtiDb utiDb = new UtiDb();
        Connection con = utiDb.getConFun();
        // DatabaseMetaData
        DatabaseMetaData datMetDat = con.getMetaData();
        // Display database name and version number
        System.out.println("Database name: "+datMetDat.getDatabaseProductName());
        System.out.println("Database version number: "+datMetDat.getDatabaseMajorVersion()+"."+datMetDat.getDatabaseMinorVersion());
        // Close
        con.close();
    }
}

 

 

    2. ResultSetMetaData

    Class UtiDb

    Class ResSetMetDat

package JavaJDBC.Chap08.sec02;

import JavaJDBC.util.UtiDb;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSetMetaData;

/**
 * Created by linux_ccmj on 16-5-17.
 */
public class ResSetMetDat {
    public static void main(String[] args) throws Exception{
        // utiDb, connection
        UtiDb utiDb = new UtiDb();
        Connection con = utiDb.getConFun();
        // sql command string, preparedstatement, ResultSetMetaData
        String strComSql = "select * from t_book2";
        PreparedStatement preSta = con.prepareStatement(strComSql);
        ResultSetMetaData resSetMetDat = preSta.getMetaData();
        // Display
        int num = resSetMetDat.getColumnCount();
        System.out.println("There are "+num+" columns!");
        for (int i=1; i<= num; i++){
            System.out.println(resSetMetDat.getColumnName(i)+","+resSetMetDat.getColumnTypeName(i));
        }
        // Close
        utiDb.clsConFun(preSta, con);
    }
}

 

转载于:https://my.oschina.net/u/2363350/blog/682306