oracledaofactory.java

中国移动系统 给了前台了

package db;

import java.sql.*;

public class OracleDAOFactory extends DAOFactory
{
    	public static String serverName = "localhost";
	public static String sDBDriver = "oracle.jdbc.driver.OracleDriver";
	public static String dbInstance = "nitpro";
	public static String sConnStr = "jdbc:oracle:thin:@"+serverName+":1521:"+dbInstance;
	
	public static String dbUser = "system";
	public static String userPwd = "manager";
	/**
	*返回一个OracleOperatorDAO对象
	*@return OperatorDAO类型对象，此处实际是OracleOperatorDAO对象
	*/
	public OperatorDAO getOperatorDAO()
    	{
        	return new OracleOperatorDAO();
   	}
    	/**
	*得到一个Connection对象
	*@return java.sql.Connection
	*/
    public static Connection getConnection()
    {
        Connection conn = null;
        try {
            //For Oracle            
		Class.forName(sDBDriver); 
            	conn = DriverManager.getConnection(sConnStr, dbUser, userPwd);     
	}		
	catch(ClassNotFoundException e) {
		e.printStackTrace();
	}		
	catch(SQLException e1)
	{
		e1.printStackTrace();
	}
	return conn;
    }
    /**
    *关闭指定的结果集
    *@param rs 要关闭的结果集
    */
    public static void closeResultSet(ResultSet rs)
    {
         if( rs != null)
    	 {
    	    try
    	    {
    	        rs.close();
    	    }
    	    catch(SQLException e)
    	    {    	            
    	    }
    	 }	    
    }
    /**
    *关闭指定的Statement
    *@param stmt 要关闭的Statement
    */
    public static void closeStatement(Statement stmt)
    {        
    	    if( stmt != null)
    	    {
    	        try
    	        {
    	            stmt.close();
    	        }
    	        catch(SQLException e)
    	        { 
    	        }
    	    }	
    }
    /**
    *关闭连接
    *@param conn 要关闭的连接
    */
    public static void closeConnection(Connection conn)
    {
	if( conn != null)
    	{
		try
	    	{
	    		conn.close();
	    	}
	    	catch(SQLException e)
	    	{
	    	}
    	}
    }
}