本文实例讲述了 JDBC 链接 Oracle 数据库功能。分享给大家供大家参考 , : :
Paket com.sefvang.jdbc; import java.sql.connection; import java.sql.driverManager; import java.sql.preparedstatement; import java.sql.resultset; import java.sql.sqlexception; Kelas publik DB_Conn {STRIM STRIGA = STRIGL.SQL.SQLEXCEPTION; Kelas Publik DB_CONN {STREATCON { "jdbc: oracle: tipis: @localhost: 1521: orcl"; name string final statis pribadi = "sistem"; Private Static Final String PassWD = "Sefvang"; string final statis pribadi db_driver = "oracle.jdbc.oracledriver"; koneksi publik getConnection () {connection conn = null; coba {class.forname (db_driver); conn = driverManager.getConnection (url, name, passwd); if (conn! = null) {System.out.println ("Success !!!"); }} catch (ClassNotFoundException e) {// TODO AUTO-ENCOMEERATED Catch Block E.PrintStackTrace (); } catch (sqlexception e) {// TODO Auto-Eynerated Catch Block E.PrintStackTrace (); } return conn; } public void tutup (koneksi conn) {coba {if (conn! = null) {if (! conn.isclosed ()) {conn.close (); }}} catch (sqlexception e) {// todo auto-generated catch block e.printstacktrace (); }} public static void main (string [] args) {db_conn conn = db_conn () baru; Koneksi con = conn.getConnection (); coba {preparedStatement papt = con.preparestatement ("Pilih tname dari teks di mana tid = 1"); Hasil rs = papt.executeQuery (); if (rs.next ()) system.out.println (rs.getString (1)); } catch (sqlexception e) {// TODO Auto-Eynerated Catch Block E.PrintStackTrace (); } conn.close (con); }}希望本文所述对大家 Java 程序设计有所帮助。