本文实例讲述了jdbc链接oracle数据库功能。分享给大家供大家参考,具体如下:
代码如下 | 复制代码 |
packagecom.sefvang.jdbc; importjava.sql.Connection; importjava.sql.DriverManager; importjava.sql.PreparedStatement; importjava.sql.ResultSet; importjava.sql.SQLException; publicclassDb_conn { privatestaticfinalString url ="jdbc:oracle:thin:@localhost:1521:orcl"; privatestaticfinalString name ="system"; privatestaticfinalString passwd ="sefvang"; privatestaticfinalString Db_driver ="oracle.jdbc.OracleDriver"; publicConnection getConnection() { Connection conn =null; try{ Class.forName(Db_driver); conn = DriverManager.getConnection(url, name, passwd); if(conn !=null) { System.out.println("success!!!"); } }catch(ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); }catch(SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } returnconn; } publicvoidclose(Connection conn) { try{ if(conn !=null) { if(!conn.isClosed()) { conn.close(); } } }catch(SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } publicstaticvoidmain(String[] args) { Db_conn conn=newDb_conn(); Connection con = conn.getConnection(); try{ PreparedStatement papt = con.prepareStatement("select tname from text where tid=1"); ResultSet rs = papt.executeQuery(); if(rs.next()) System.out.println(rs.getString(1)); }catch(SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } conn.close(con); } } |