dydatasource.java

java 数据库连接通用源码 java 数据库连接通用源码

/* 
* DataSource bean 	ver 1.01   beginner 0.9
* author :zhanghan             
* write-time :2001.2.12
* debug-time: 2001.7.24
* write for dyit-bsjs com
* function : set the datasource at beginning of service start (middle-tier)
	      supply data connection	
* debug:0.91: url changed
*             add a new constructor
*	0.92: package changed ; publiced class
*	0.93: change the name
*       1.01  change package
*/
package com.dyit.sql;

import java.io.*;
import java.util.*;
import java.sql.*;
import javax.sql.*;
import java.lang.*;
import oracle.jdbc.pool.*;
/** 实现对数据库访问的封装, 支持Oracle数据库
 @author   zhanghan
*/
public class DYDataSource  {
	/**提供数据库访问地址*/
	protected final static String strUrl = "jdbc:oracle:thin:@192.168.5.80:1521:wzgl"; 
	/**用户名*/
	protected static String strUser = "oa_test";
	/**密码*/
	protected static String strPsw = "oa_test";
	private OracleDataSource ods ;
	//Oracle实现DataSource接口的类对象

/**通用构建器
	*@param sDBserver  数据库访问用url
	*@param sUser 用户名
	*@param sPsw  密码
	*/
public DYDataSource(String sDBserver,String sUser,String sPsw){
	//普遍的数据库Url
	
	long lstart = System.currentTimeMillis();
	strUser = sUser;
	strPsw = sPsw;
	try{
	ods = new OracleDataSource();
	ods.setURL(sDBserver);
	Connection con = ods.getConnection(sUser,sPsw);
	con.close();
	}
	catch(SQLException e){
		System.out.println("SQLException :"+e.toString());
		}
	
	long ltime = System.currentTimeMillis()-lstart;
	System.out.println("init connect time"+ltime);
 	}
/**用户名、密码固定的构建*/
public DYDataSource(String sDBserver){
	this(sDBserver,strUser,strPsw);
	 
	}
public DYDataSource(){	
	this(strUrl);
}
/**取得连接
	*@param sUser 用户名
	*@param sPsw  密码
	*@return Connection 数据库连接
	*/
public Connection getConnection(String sUser,String sPsw)
	throws SQLException{
	return ods.getConnection(sUser,sPsw);
}
/**取得连接
*@return Connection 数据库连接
*/
public Connection getConnection()
	throws SQLException{
	return ods.getConnection(strUser,strPsw);
}
/**取得数据源
*@return OracleDataSource Oracle数据源
*/
public OracleDataSource getDataSource(){return ods;}
}