dbconnection.java

Solaris平台上邮件的定时发送

package com.j2ee.db;

import java.util.*;
import java.sql.*;
import javax.sql.*;
import java.io.*;
import oracle.jdbc.driver.*; 
import javax.naming.*;    

/**
* 获得数据库连接 
*/
public class DbConnection 
{
	private java.sql.Connection conn=null;  
  
	/**
	* 构造器
	*/
	public DbConnection() 
	{
		sConnStr = "jdbc:oracle:thin:@10.1.1.1:1521:ora1";
	}
  
	/**
	* 通过JDBC获得与数据库的连接.
	*/
	public java.sql.Connection connectByJdbc() 
	{	  
		try
		{
			Class.forName(sDBDriver);
			java.sql.Connection conn = DriverManager.getConnection(sConnStr,"user","password");
		    return conn;
		}
		catch (Exception e) 
		{
			System.out.println("DbConnection.connectByJdbc error:"+e.getMessage()); 
			return null;
		} 
	}
}