Example of jdbc connecting to oracle database functionality

  • 2020-05-27 05:38:37
  • OfStack

This article illustrates an example of jdbc linking oracle databases. I will share it with you for your reference as follows:


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);
 }
}

I hope this article has been helpful to you in java programming.


Related articles: