package day02;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import day01.DBUtil2;
/**
* 取得结果集中的元数据ResultSetMetaData--接口
*/
public class JDBCDemo7 {
public static void main(String[] args) {
try {
Connection conn = DBUtil2.getConnection();
Statement state = conn.createStatement();
String sql = "SELECT * FROM emp";
//执行sql语句获取结果集
ResultSet rs = state.executeQuery(sql);
/**
* 元数据在结果集中
* 可以通过结果集获取元数据
*/
ResultSetMetaData rsmt = rs.getMetaData();
/**
* 获取结果集中有多少列(字段)
*/
int col = rsmt.getColumnCount();
System.out.println(col);//8(从1开始)
for(int i=1;i<=col;i++){
//获取结果集中第i列的名字
String colName = rsmt.getColumnName(i);
String type = rsmt.getColumnTypeName(i);
System.out.println(colName+","+type);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil2.closeConnection();
}
}
}
测试结果为:
8
EMPNO,NUMBER
ENAME,VARCHAR2
JOB,VARCHAR2
MGR,NUMBER
HIREDATE,DATE
SAL,NUMBER
COMM,NUMBER
DEPTNO,NUMBER
转载请注明原文地址: https://ju.6miu.com/read-36629.html
