一个JAVA连接ORACLE的例子

发表于:2007-06-22来源:作者:点击数: 标签:
例子: package .net .abc.admin; import java .io.*; import java. sql .*; import java.util.*; public class ConnectionBean { private static Connection conn = null; public static Connection getConnection() { if (conn == null) { try { DriverMan

   
  例子:
  
  package.net.abc.admin;
  
  import java.io.*;
  import java.sql.*;
  import java.util.*;
  
  public class ConnectionBean
  {

  private static Connection conn = null;
  
  public static Connection getConnection()
  {
  if (conn == null)
  {
  try
  {
  DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
  conn = DriverManager.getConnection("jdbc:oracle:thin:@"+hostname+":"+port+":"+dbSID,username,password);
  } catch(SQLException e)
  {
  e.printStackTrace();
  }
  // if(conn == null)
  // System.out.println("database connection error");
  }
  return conn;
  }
  }

原文转自:http://www.ltesting.net