最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
jdbc连接oracle数据库功能实例
时间:2017-01-11 编辑:简简单单 来源:一聚教程网
本文实例讲述了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); } } |
相关文章
- MySQL登录、访问及退出操作解析 10-18
- sql语句 update字段null不能用is null问题解析 09-28
- SQL Server ISNULL 不生效原因及解决分析 09-28
- 关于if exists的用法及说明分析 09-28
- Access数据库日常维护方法 09-28
- Oracle 删除大量表记录操作介绍 09-27