jdbc连接oracle数据库功能实例

www.111cn.net 更新:2017-01-11 编辑:kepeer 来源:转载
这篇文章介绍了jdbc连接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);

 }

}

 

没有了123 下一篇
上一页:没有了      下一页:ORACLE中SELECT TOP N的实现教程

相关内容

    暂无与此文章相关内容