jdbc链接oracle数据库_jdbc连接oracle数据库功能实例

时间:2021-05-19  来源:Oracle教程  阅读:

本文实例讲述了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);

 }

}

 

jdbc链接oracle数据库_jdbc连接oracle数据库功能实例

http://m.bbyears.com/shujuku/118590.html

推荐访问:oracle jdbc连接
相关阅读 猜你喜欢
本类排行 本类最新