jdbcexample.java~10~

梅花雪树的经典制作

package com.test;

import java.sql.*;

public class JDBCExample {
    public static void main(String args[]) {
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            String url = "jdbc:oracle:thin:@127.0.0.1:1521:lanhai";
            Connection conn = DriverManager.getConnection(url, "wygb", "wygb");
            Statement stmt = conn.createStatement();
            ResultSet rs = null;
            DatabaseMetaData dmd = conn.getMetaData();
            /*if (dmd == null) {
                System.out.println("No Meta available");
            } else {
                System.out.println("数据库名称:" + dmd.getDatabaseProductName());
                System.out.println("数据库版本:" + dmd.getDatabaseProductVersion());
                System.out.println("数据库驱动程序：" + dmd.getDriverName());
                System.out.println("驱动程序版本号：" + dmd.getDriverVersion());
                System.out.println("并发访问的用户个数" + dmd.getMaxConnections());
                System.out.println("数据类型列表：");
                rs = dmd.getTypeInfo();
                while (rs.next()) {
                    System.out.println("\t" + rs.getString(1));
                }
                rs.close();
            }*/

            //PreparedStatement stmt = conn.prepareStatement("select * from mydept");

            rs = stmt.executeQuery("select * from mydept");
            /* while (rs.next()) {
                 System.out.print("mydeptid: " + rs.getInt("mydeptid"));
                 System.out.print("\tdeptname: " + rs.getString("deptname"));
                 System.out.println("\tdescp: " + rs.getString("descp"));
             }*/

            ResultSetMetaData rsm = rs.getMetaData();
            int count = rsm.getColumnCount();
            for (int i = 0; i < count; i++) {
                System.out.println(rsm.getColumnName(i));
            }
            rs.close();
            stmt.close();
            conn.close();
        } catch (ClassNotFoundException e) {
            System.out.println("找不到指定的驱动程序类!");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}