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

public class DbTest2 {
	public static void main(String[] args) {
		Connection con = null;
		Statement stmt = null;
		ResultSet rs = null;

		try{
			Class.forName("oracle.jdbc.OracleDriver");

			con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "1111");

			//사번, 이름, 급여, 업무를 조회 단, 사번으로 내림차순
			String sql = "select empno, ename, sal, job from emp order by empno desc";

			stmt = con.createStatement();
			rs = stmt.executeQuery(sql);

			while(rs.next()){
				System.out.println(rs.getInt(1));
				System.out.println(rs.getString("ename"));
				System.out.println(rs.getInt("sal"));
				System.out.println(rs.getString("job"));
				System.out.println();
			}
		}
		catch(ClassNotFoundException err){
			err.printStackTrace();
		}
		catch(SQLException err){
			err.printStackTrace();
		}
		finally{
			try{
				rs.close();
				stmt.close();
				con.close();
			}
			catch(Exception err){}
		}
	}
}