dbconnection.java

网站 JSP 实现的 银行系统 数据库用的ORA啊 功能全

package ly.dbc ;

import java.sql.* ;
public class DBConnection
{
	private String DBDRIVER			= "oracle.jdbc.driver.OracleDriver" ;
	private String DBURL			= "jdbc:oracle:thin:@192.168.1.104:1521:atm" ;
	private String DBUSER			= "system" ;
	private String DBPASSWORD		= "tiger" ;
	private Connection conn			= null ;

	public DBConnection()
	{
		try
		{
			Class.forName(DBDRIVER) ;
			this.conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD) ;
		}
		catch (Exception e)
		{
			e.printStackTrace() ;
		}
	}
	public Connection getConnection()
	{
		return this.conn ;
	}
	public void close()
	{
		try
		{
			this.conn.close() ;
		}
		catch (Exception e)
		{
		}
	}
}