java当中JDBC当中请给出一个Oracle DataSource and SingleTon例子

[学习笔记]

6.oracle datasource and singleton：　

import oracle.jdbc.pool.oracledatasource;
import java.sql.connection;
import java.sql.*;

public class oraclesingletondatasource {
  static private oracledatasource ods;
  private oraclesingletondatasource() {
    try{
        ods = new oracledatasource();
        ods.seturl("jdbc:oracle:thin:@localhost:1521:qixy");
        ods.setuser("scott");
        ods.setpassword("tiger");
            }catch(exception e){
            e.printstacktrace();
            }
  }
  public static connection getconnection() throws exception {
    if (ods==null)
       {
           new oraclesingletondatasource();
          // ods.getconnection();

      }
      connection con =null;
      try {
          con = ods.getconnection();
      } catch (sqlexception ex) {
        ex.printstacktrace();
      }
       return  con;
      }

}

文章转载自原文：