import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

public class JDBCTest {
	// 필드에 driver, url, user, password 설정
	private String driver = "oracle.jdbc.driver.OracleDriver";
	private String url = "jdbc:oracle:thin:@localhost:1521:XE";
	private String user = "hr";
	private String password = "hr";

	public JDBCTest() {
		// 1. 드라이버 로딩
		try {
			Class.forName(driver);
			System.out.println("드라이버 로딩 성공.");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	} // JDBCTest()

	public ArrayList<Student> SelectStudent() {
		ArrayList<Student> result = new ArrayList<Student>();
		Student s = null;
		Connection con = null;
		// 2.DB 연결- 각 메소드별로 Connection을 하고 종료.
		try {
			con = DriverManager.getConnection(url, user, password);
			// 3. Statement 객체 생성
			Statement stmt = con.createStatement();
			String sql = "select * from Student";
			// 4. sql문 전송
			ResultSet rs = stmt.executeQuery(sql);
			while (rs.next()) {
				String hakbun = rs.getString("hakbun");
				String name = rs.getString("name");
				int age = rs.getInt("age");
				s = new Student(hakbun, name, age);
				result.add(s);
			} // while
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				if (con != null)
					con.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return result;
	} // SelectStudent()

	public static void main(String[] args) {
		ArrayList<Student> al = new JDBCTest().SelectStudent();
		for (Student s : al) {
			System.out.println(s);
		}
	}
}