dbconnection.java

导库程序

/*
 *@作者：吴玮杰    学号：0461013
 *@创建日期：2006-9-17
 *复旦大学04软件工程
 */
package oracleConn;

import java.sql.*;

/**
* 通过thin方式获得Oracle数据库连接
*/
public class DbConnection 
{
	final static String sDBDriver = "oracle.jdbc.driver.OracleDriver";
	private String sConnStr = "";
	/**
	* 缺省构造器
	*/
	public DbConnection() 
	{
		sConnStr = "jdbc:oracle:thin:@localhost:1521:oradb";
	}
	/**
	* @param ip,serviceName
	*/
	public DbConnection(String ip,String serviceName) 
	{
		sConnStr = "jdbc:oracle:thin:@"+ip+":1521:"+serviceName;
	}
	/**
	* 通过thin方式获得Oracle数据库的连接.
	*/
	public Connection connectDbByThin() 
	{     
		Connection conn=null; 
		try
		{
			Class.forName(sDBDriver);
			conn = DriverManager.getConnection(sConnStr,"system","manager");
		}
		catch (Exception e) 
		{
			System.out.println("ERROR:"+e.getMessage()); 
		} 
		return conn;
	}
	
	/**
	* 通过thin方式获得Oracle数据库的连接.
	* @param userId,password
	*/
	public Connection connectByJdbc(String userId,String password) 
	{     
		Connection conn=null; 
		try
		{
			Class.forName(sDBDriver);
			conn = DriverManager.getConnection(sConnStr,userId,password);
		}
		catch (Exception e) 
		{
			System.out.println("ERROR:"+e.getMessage()); 
		} 
		return conn;
	}
}