oracleconn.java

一个简单的数据连接例子

package com.smartjavaer.ckgl;

public class OracleConn {

        private java.sql.Connection conn = null;
        private final String url = "jdbc:oracle:thin:@";
        private final String serverName = "192.168.10.114";
        private final String portNumber = "1521";
        private final String databasesid = "oracle";
        private final String userName = "hr";
        private final String password = "hr";

        public OracleConn() {
        }

        private String getOracleUrl() {
            String oracleurl = 
                url + serverName + ":" + portNumber + ":" + databasesid;
            return oracleurl;
        }

        public java.sql.Connection getOracleConnection() {
            try {
                // A. 注册 Oracle JDBC 驱动程序
                Class.forName("oracle.jdbc.driver.OracleDriver");
                // B. 创建新数据库连接
                conn = 
    java.sql.DriverManager.getConnection(getOracleUrl(), userName, password);
                if (conn != null)
                    System.out.println("Oracle Connection Successful!");
            } catch (Exception e) {
                e.printStackTrace();
                System.out.println("Error Oracle Trace in getConnection() : " + 
                                   e.getMessage());
            }
            return conn;
        }

        public void closeOracleConn() {
            try {
                if (conn != null)
                    conn.close();
                conn = null;
            } catch (Exception e) {
                e.printStackTrace();
            }
        }

        public static void main(String[] args) {
            OracleConn con = new OracleConn();
            con.getOracleConnection();
        }
}