public List<EmailVo> getList() { List<EmailVo> list = new ArrayList<EmailVo>(); ResultSet rs = null; // Connection connection = null; Connection connection = null; Statement stmt = null; // 1.,드라이버 로딩(클래스 로딩) try { Class.forName("oracle.jdbc.driver.OracleDriver"); // 2. db 욘굘 String dbUrl = "jdbc:oracle:thin:@localhost:1521:xe"; connection = DriverManager.getConnection(dbUrl, "webdb", "webdb"); // DriverManager.getConnection(dbUrl,"webdb","webdb"); // 3. statement stmt = connection.createStatement(); // 4. sql // String sql = "select no, first_name, last_name,email from email_list"; String sql = "select * from email_list"; rs = stmt.executeQuery(sql); System.out.println("리스트 겟"); // 5 결과 가져오기 while (rs.next()) { Long no = rs.getLong(1); String firstName = rs.getString(2); String lastName = rs.getString(3); String email = rs.getString(4); EmailVo vo = new EmailVo(); vo.setNo(no); vo.setFirstName(firstName); vo.setLastName(lastName); vo.setEmail(email); list.add(vo); } rs.close(); stmt.close(); connection.close(); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block System.out.println("드라이버 로딩 실패"); } catch (SQLException ex) { System.out.println("에러 - " + ex); } return list; }