MAC OSX 에서 Oracle DB 설치하기 (2) OJDBC

public class TestDAO {
	String driver = "oracle.jdbc.driver.OracleDriver";
  String url = "jdbc:oracle:thin:@localhost:49161:xe"; //설정한 포트
	String id = "system"; //연결할 DB 아이디
  String pw = "oracle"; //pw
	DataSource dataSource;
	
	public TestDAO() {
		try {
			Class.forName(driver);
			
		Context context = new InitialContext();
		dataSource = (DataSource)context.lookup("java:comp/env/jdbc/Oracle11g");
		
		} catch (Exception e) {
			e.printStackTrace();
		}
		
	}	
    //TestDTO 형태로 전체 데이터를 받아온은 예시
	public ArrayList<TestDTO> select() {
		
		ArrayList<TestDTO> list = new ArrayList<TestDTO>();
		
		Connection con = null;
		PreparedStatement pstm = null;
		ResultSet res = null;
		
		try {
			Class.forName(driver);
			con = DriverManager.getConnection(url,id,pw);
			
			con = dataSource.getConnection();
			
			String sql = "SELECT * FROM table_name";
			pstm = con.prepareStatement(sql);
			res = pstm.executeQuery();
			
			while(res.next()) {
				int testId = res.getInt("test_id");
				String testName = res.getString("test_name");
				String testLoc = res.getString("test_loc");
				
				TestDTO testDTO = new TestDTO(testId, testName, testLoc);
				list.add(testDTO);
			}
			
			
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				if(res != null) res.close();
				if(pstm != null) pstm.close();
				if(con != null) con.close();
			} catch (Exception e2) {
				e2.printStackTrace();
			}
		}
			
		
		return list;
	}
}