本文實例講述了jdbc鏈接甲骨文數據庫功能。分享給大家供大家參考,具體如下::
軟件包com.sefvang.jdbc; import java.sql.connection; import java.sql.drivermanager; import java.sql.sql.preparedstatement; import java.sql.Sql.Resultset; import Java java java java java.sqlempection; “ JDBC:Oracle:Thin:@localhost:1521:ORCL”;私有靜態最終字符串名稱=“系統”;私有靜態最終字符串passwd =“ sefvang”;私有靜態最終字符串db_driver =“ oracle.jdbc.oracledriver”; public Connection getConnection(){連接conn = null;嘗試{class.forname(db_driver); conn = drivermanager.getConnection(url,name,passwd);如果(conn!= null){system.out.println(“成功!!!”); }} catch(classNotFoundException e){// todo自動生成的捕獲塊e.printstacktrace(); } catch(sqlexception e){// todo自動生成的捕獲塊e.printstacktrace(); }返回conn; } public void Close(connection conn){嘗試{if(conn!= null){if(!conn.isclosed()){conn.close(); }}} catch(sqlexception e){// todo自動生成的捕獲塊e.printstacktrace(); }} public static void main(string [] args){db_conn conn = new db_conn();連接con = conn.getConnection();嘗試{regardstatement papt = con.preparestatement(“從文本中選擇tname where tid = 1”); Resultset RS = papt.executequery(); if(rs.Next())system.out.println(rs.getString(1)); } catch(sqlexception e){// todo自動生成的捕獲塊e.printstacktrace(); } conn.close(con); }}}希望本文所述對大家爪哇程序設計有所幫助。