jdbcexample.java~6~

来自「梅花雪树的经典制作」· JAVA~6~ 代码 · 共 48 行

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();
            while (rs.next()) {
                System.out.print("mydeptid: " + rs.getInt("mydeptid"));
                System.out.print("\tdeptname: " + rs.getString("deptname"));
                System.out.println("\tdescp: " + rs.getString("descp"));
            }
            rs.close();
            stmt.close();
            conn.close();
        } catch (ClassNotFoundException e) {
            System.out.println("找不到指定的驱动程序类!");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}