Code
1 package com.jdbc.OracleTest;
2 import java.sql.DatabaseMetaData;
3 import java.sql.DriverManager;
4 import java.sql.SQLException;
5 import java.sql.Statement;
6 import java.sql.Connection;
7 import java.sql.ResultSet;
8 import java.sql.ResultSetMetaData;
9
10 public class MetaDataTest {
11
12 /**
13 * 元数据
14 * @param args
15 */
16 public static void main(String[] args) {
17
18
19 try {
20 Class.forName("oracle.jdbc.driver.OracleDriver");
21 String url="jdbc:oracle:thin:@localhost:1521:ora92";
22 try {
23 Connection conn = DriverManager.getConnection(url,"scott","1234");
24 ResultSet rs = null;
25
26 DatabaseMetaData dmd = conn.getMetaData();
27 //数据库名:
28 System.out.println("数据库名 :"+dmd.getDatabaseProductName());
29 //数据库版本号:
30 System.out.println("数据库版本号 ::"+dmd.getDatabaseProductVersion());
31 //驱动程序
32 System.out.println("驱动程序 :"+dmd.getDriverName());
33
34 //驱动版本
35 System.out.println("驱动版本 :"+dmd.getDriverVersion());
36
37 //数据库的数据类型列表
38 rs = dmd.getTypeInfo();
39 System.out.println("数据类型列表");
40 while(rs.next())
41 {
42 System.out.println(rs.getString(1));
43 }
44
45 Statement stmt = conn.createStatement();
46 rs = stmt.executeQuery("select * from emp");
47 ResultSetMetaData rsm = rs.getMetaData();
48
49 for(int i =1;i<rsm.getColumnCount();i++)
50 {
51 System.out.println("列名 : "+rsm.getColumnName(i)+" 列类型 : " + rsm.getColumnTypeName(i));
52 }
53
54 //输出信息
55 while(rs.next())
56 {
57 System.out.println(rs.getString(rsm.getColumnName(1))+" "+rsm.getColumnName(2));
58
59 }
60
61 } catch (SQLException e) {
62 // TODO Auto-generated catch block
63 e.printStackTrace();
64 }
65 } catch (ClassNotFoundException e) {
66 // TODO Auto-generated catch block
67 e.printStackTrace();
68 }
69
70
71 }
72
73 }
74
75
1 package com.jdbc.OracleTest;
2 import java.sql.DatabaseMetaData;
3 import java.sql.DriverManager;
4 import java.sql.SQLException;
5 import java.sql.Statement;
6 import java.sql.Connection;
7 import java.sql.ResultSet;
8 import java.sql.ResultSetMetaData;
9
10 public class MetaDataTest {
11
12 /**
13 * 元数据
14 * @param args
15 */
16 public static void main(String[] args) {
17
18
19 try {
20 Class.forName("oracle.jdbc.driver.OracleDriver");
21 String url="jdbc:oracle:thin:@localhost:1521:ora92";
22 try {
23 Connection conn = DriverManager.getConnection(url,"scott","1234");
24 ResultSet rs = null;
25
26 DatabaseMetaData dmd = conn.getMetaData();
27 //数据库名:
28 System.out.println("数据库名 :"+dmd.getDatabaseProductName());
29 //数据库版本号:
30 System.out.println("数据库版本号 ::"+dmd.getDatabaseProductVersion());
31 //驱动程序
32 System.out.println("驱动程序 :"+dmd.getDriverName());
33
34 //驱动版本
35 System.out.println("驱动版本 :"+dmd.getDriverVersion());
36
37 //数据库的数据类型列表
38 rs = dmd.getTypeInfo();
39 System.out.println("数据类型列表");
40 while(rs.next())
41 {
42 System.out.println(rs.getString(1));
43 }
44
45 Statement stmt = conn.createStatement();
46 rs = stmt.executeQuery("select * from emp");
47 ResultSetMetaData rsm = rs.getMetaData();
48
49 for(int i =1;i<rsm.getColumnCount();i++)
50 {
51 System.out.println("列名 : "+rsm.getColumnName(i)+" 列类型 : " + rsm.getColumnTypeName(i));
52 }
53
54 //输出信息
55 while(rs.next())
56 {
57 System.out.println(rs.getString(rsm.getColumnName(1))+" "+rsm.getColumnName(2));
58
59 }
60
61 } catch (SQLException e) {
62 // TODO Auto-generated catch block
63 e.printStackTrace();
64 }
65 } catch (ClassNotFoundException e) {
66 // TODO Auto-generated catch block
67 e.printStackTrace();
68 }
69
70
71 }
72
73 }
74
75