元数据

数据库元数据：

import org.junit.Test;

import java.sql.*;
public class Demo1 {
    @Test
    public void test1() throws SQLException {

        Connection connection = JdbcUtil.getConnection();

        //数据库的元数据
        DatabaseMetaData metaData = connection.getMetaData();

        System.out.println(metaData.getDriverName());

        System.out.println(metaData.getDriverVersion());

        System.out.println(metaData.getURL());

        JdbcUtil.close(connection);
    }
   }

参数元数据：

@Test
    public void test2() throws SQLException {
        //参数元数据比较重要，获取参数的个数，遍历来用
        Connection connection = JdbcUtil.getConnection();

        String sql = "insert into student(name,age,info) values(?,?,?)";

        PreparedStatement preparedStatement = connection.prepareStatement(sql);

        //通过预处理的搬运工对象获取参数的元数据
        ParameterMetaData parameterMetaData = preparedStatement.getParameterMetaData();

        //通过这个对象可以获取参数的个数
        int parameterCount = parameterMetaData.getParameterCount();

        System.out.println(parameterCount);

    }

结果集元数据：

//结果集元数据
    @Test
    public void test3() throws SQLException {
        Connection connection = JdbcUtil.getConnection();

        String sql = "select * from student";

        PreparedStatement preparedStatement = connection.prepareStatement(sql);

        ResultSet resultSet = preparedStatement.executeQuery();

        //获取结果集元数据
        ResultSetMetaData metaData = preparedStatement.getMetaData();

        //获取字段的个数
        int columnCount = metaData.getColumnCount();
        System.out.println(columnCount);

        while (resultSet.next()) {
            for (int i = 1; i <= columnCount ; i++) {
                System.out.print(resultSet.getObject(metaData.getColumnName(i)));
            }
            System.out.println();
        }
    }