opendb.java

来自「在eclispe下写的电子务平台」· Java 代码 · 共 47 行

package dlut;

import java.sql.*;

public class OpenDB
{ 
	
	String userName="webshop";
	
	String userPassword="test";
	
	String url="jdbc:oracle:thin:@localhost:1521:ORCL";
	
	Connection dbConn;   
	
	String errDesc;
	
	
	public OpenDB()
	{
		errDesc="";
		dbConn=null;
	}
	
	
	public Connection getConn()
	{   	
		try
		{ 
			Class.forName("oracle.jdbc.driver.OracleDriver");
			dbConn= DriverManager.getConnection(url,userName,userPassword);			
		}
		catch(Exception ex)
		{	   		
			dbConn = null;
			errDesc=ex.toString();	   		
		}
		return dbConn;
	}
	
	
	public String getErrDesc()
	{
		return errDesc;	
	}	
}