本文共 3278 字，大约阅读时间需要 10 分钟。

Oracle??????Java??????

1. Oracle???????

???Oracle???????????????????

1.1 ORACLE_HOME??

ORACLE_HOME = E:\Oracle\product\11.2.0\dbhome_1

?????Oracle????????????E:\Oracle\product\11.2.0\dbhome_1?

1.2 TNS_ADMIN??

TNS_ADMIN = E:\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN

TNS_ADMIN????Oracle Net Manager????????????????

1.3 NLS_LAN??

NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK

????????????????GBK?

1.4 listener??

????????(listener)?????????????

• ????orcl
• IP???192.168.0.101
• ???1521

2. Oracle JDBC??

2.1 Oracle JDBC??

????????Oracle 11g?JDBC????????????

• oracle.jdbc.driver.OracleDriver
• oracle-sqlplus.jar

2.2 JDBC??URL??

jdbc:oracle:thin:@IP:PORT:SERVICE_NAME

??????orcl???

jdbc:oracle:thin:@192.168.0.101:1521:orcl

2.3 Java????

import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class OracleDBConnection {    private static Connection conn = null;    public static Connection getConnection() {        try {            Class.forName("oracle.jdbc.driver.OracleDriver");            String url = "jdbc:oracle:thin:@192.168.0.101:1521:orcl";            String user = "wu";            String password = "123456";                        conn = DriverManager.getConnection(url, user, password);            return conn;        } catch (ClassNotFoundException e) {            e.printStackTrace();            System.exit(0);        } catch (SQLException e) {            e.printStackTrace();            System.exit(0);        }        return conn;    }    public static void closeConnection(Connection conn, Statement st, ResultSet rs) {        try {            if (rs != null) {                rs.close();                rs = null;            }            if (st != null) {                st.close();                st = null;            }            if (conn != null) {                conn.close();                conn = null;            }        } catch (SQLException e) {            e.printStackTrace();        }    }}

3. Oracle SQL Developer??

3.1 ?????

• ?????Oracle SQL Developer?
• ???????????????
  • ????orcl
  • ????wu
  • ???123456
  • ???1521

3.2 ????????

grant dba to scott;revoke dba from scott;create user kang identified by "123456";

4. Java JDBC????

4.1 ???????

import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class JDBC_Test {    public static void main(String[] args) {        // ???????        Connection conn = OracleDBConnection.getConnection();                try {            // ?????            String sql = "select * from user_tab_columns where Table_Name='KANG'";            PreparedStatement ps = conn.prepareStatement(sql);            ResultSet rs = ps.executeQuery();                        while (rs.next()) {                System.out.println("??: " + rs.getString("Table_name") +                                 ", ??: " + rs.getString("Column_name") +                                 ", ??: " + rs.getString("Data_type"));            }                        OracleDBConnection.closeConnection(conn, ps, rs);        } catch (SQLException e) {            System.out.println("???????: " + e.getMessage());        }    }}

5. ????

• ??Oracle????????????
• ?????Oracle JDBC?????
• ???????????????????

????????????Oracle??????????Java????????