package 类集;

import java.sql.Connection ;

import java.sql.DriverManager ;

import java.sql.SQLException ;

import java.sql.DatabaseMetaData ;

import java.sql.ResultSet ;

public class DatabaseMetaDataDemo{

    // 定义MySQL的数据库驱动程序

    public static final String DBDRIVER = "org.gjt.mm.mysql.Driver" ;

    // 定义MySQL数据库的连接地址

    public static final String DBURL = "jdbc:mysql://localhost:3306/sys" ;

    // MySQL数据库的连接用户名

    public static final String DBUSER = "root" ;

    // MySQL数据库的连接密码

    public static final String DBPASS = "aaaaaa" ;

    public static void main(String args[]) throws Exception{    // 所有异常抛出

        Connection conn = null ;        // 数据库连接

        DatabaseMetaData dmd = null ;        // 数据库元数据

        ResultSet rs = null ;

        Class.forName(DBDRIVER) ;    // 加载驱动程序

        conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS) ;

        dmd = conn.getMetaData() ;    // 实例化对象

        System.out.println("数据库名称：" + dmd.getDatabaseProductName() ) ;

        System.out.println("数据库版本：" + dmd.getDatabaseMajorVersion() + "."//分别得到主版本号和次版本号

            + dmd.getDatabaseMinorVersion()) ;

        rs = dmd.getPrimaryKeys(null,null,"user") ;    // 取得user表的主键

        while(rs.next()){

            System.out.println("表类别：" + rs.getString(1)) ;

            System.out.println("表模式：" + rs.getString(2)) ;

            System.out.println("表名称：" + rs.getString(3)) ;

            System.out.println("列名称：" + rs.getString(4)) ;

            System.out.println("主键序列号：" + rs.getString(5)) ;

            System.out.println("主键名称：" + rs.getString(6)) ;

        }

        conn.close() ;            // 数据库关闭

    }

};

Sun Apr 23 12:42:47 CST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

数据库名称：MySQL

数据库版本：5.7

表类别：sys

表模式：null

表名称：user

列名称：age

主键序列号：1

主键名称：PRIMARY

package 类集;

import java.sql.Connection ;

import java.sql.DriverManager ;

import java.sql.SQLException ;

import java.sql.ResultSetMetaData ;

import java.sql.PreparedStatement ;

public class ResultSetMetaDataDemo{

    // 定义MySQL的数据库驱动程序

    public static final String DBDRIVER = "org.gjt.mm.mysql.Driver" ;

    // 定义MySQL数据库的连接地址

    public static final String DBURL = "jdbc:mysql://localhost:3306/sys" ;

    // MySQL数据库的连接用户名

    public static final String DBUSER = "root" ;

    // MySQL数据库的连接密码

    public static final String DBPASS = "aaaaaa" ;

    public static void main(String args[]) throws Exception{    // 所有异常抛出

        Connection conn = null ;        // 数据库连接

        ResultSetMetaData rsmd = null ;        // 数据库元数据

        PreparedStatement pstmt = null ;

        Class.forName(DBDRIVER) ;    // 加载驱动程序

        conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS) ;

        String sql = "SELECT name,age,birthday FROM user" ;

       pstmt = conn.prepareStatement(sql) ;    // 实例化对象

        rsmd = pstmt.getMetaData() ;　　　　//注意，这里没有进行pstmt进行语句执行。

        System.out.println("一共返回" + rsmd.getColumnCount() + "条数据。") ;

        if(rsmd.isAutoIncrement(1) ){

            System.out.println(rsmd.getColumnName(1)+"列是自动增长的。") ;

        }

        conn.close() ;            // 数据库关闭

    }

};

Sun Apr 23 12:56:59 CST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

一共返回3条数据。