oracledaofactory.java

实现统一的人员日志管理系统管理后台

package com.tb.log.factory;

import java.sql.*;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.*;

import com.tb.log.model.dao.DAOFactory;
import com.tb.log.model.dao.idao.IDeptDAO;
import com.tb.log.model.dao.idao.ILogDAO;
import com.tb.log.model.dao.idao.IProDAO;
import com.tb.log.model.dao.idao.IRoleDAO;
import com.tb.log.model.dao.idao.IUserDAO;
import com.tb.log.model.dao.impl.DeptDAO;
import com.tb.log.model.dao.impl.LogDAO;
import com.tb.log.model.dao.impl.ProDAO;
import com.tb.log.model.dao.impl.RoleDAO;
import com.tb.log.model.dao.impl.UserDAO;
import com.tb.log.system.SystemException;

public class OracleDAOFactory extends DAOFactory{
	private static final String DRIVER = "oracle.jdbc.driver.OracleDriver";
	private static final String USERNAME = "scott";
	private static final String PASSWORD = "tiger";
	private static final String URL = "jdbc:oracle:thin:@localhost:1521:ORCL";

	/**	用于连接ORACLE数据库
	 * @return Connection
	 */
	public static Connection getConnection(){
		Connection conn = null;
		
		try {
			Class.forName(DRIVER);
			conn = DriverManager.getConnection(URL,USERNAME,PASSWORD);
			//conn.setAutoCommit(false);
		}catch(Exception e){
			String err = "Exception in OracleDAOFactory:getConnection()---"+e;
			System.out.println(err);
		}
	//	System.out.println(conn);
		return conn;
	}

/*	
	public static Connection getConnection() {
		Connection conn = null;
		 Context initCtx;
		try {
			initCtx = new InitialContext();
			 Context ctx = (Context) initCtx.lookup("java:comp/env"); 
			 Object obj = (Object) ctx.lookup("jdbc/oracle"); 
			 DataSource ds = (javax.sql.DataSource)obj; 
			 conn = ds.getConnection();
			 
			 Statement st=conn.createStatement();      
		        String   sql="select   *   from   emp";    
		       ResultSet   rs=st.executeQuery(sql);    
		     while(rs.next())   {   
		    System.out.println("您的第一个字段内容为："+rs.getString(1) );  
		     }
	
		} catch (NamingException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} 

		return conn;
	}
	 */
	
	public IUserDAO getUserDAO(){
		return new UserDAO();
	}
	
	public IDeptDAO getDeptDAO(){
		return new DeptDAO();
	}
	
	public IProDAO getProDAO(){
		return new ProDAO();
	}
	
	public ILogDAO getLogDAO(){
		return new LogDAO();
	}
	
	@Override
	public IRoleDAO getRoleDAO() {
		// TODO Auto-generated method stub
		return new RoleDAO();
	}
	
	
	public static void main(String[] args) {
		//System.out.println(new OracleDAOFactory().getConnection());
	}


}