jdbc连接oracle数据库功能示例
时间:02月19日

本文实例讲述了jdbc链接oracle数据库功能。分享给大家供大家参考,具体如下:

package com.sefvang.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class Db_conn {
 private static final String url = "jdbc:oracle:thin:@localhost:1521:orcl";
 private static final String name = "system";
 private static final String passwd = "sefvang";
 private static final String Db_driver = "oracle.jdbc.OracleDriver";
 public Connection 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();
  }
  return conn;
 }
 public void close(Connection conn) {
  try {
   if (conn != null) {
    if (!conn.isClosed()) {
     conn.close();
    }
   }
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 }
 public static void main(String[] args) {
  Db_conn conn=new Db_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);
 }
}

希望本文所述对大家java程序设计有所帮助。

最新动态
大家感兴趣的内容
关于我们 - 广告合作 - 联系我们 - 免责声明 - 网站地图 - 投诉建议 - 在线投稿
严禁网站镜像,否则追究法律责任 CopyRight © 2015-2018 诺心网络 All Rights Reserved.
地址:杭州拱墅区祥园路38号浙报理想祥园创意园东区A319
电话:18958065710 微信:Evtailun 邮箱:476565345@qq.com
网站备案号:浙ICP备15017827号-1