<%@ page language="java" contentType="text/xml; charset=EUC-KR" pageEncoding="EUC-KR"%>

<%@ page import="java.sql.*, org.jdom.*" %>

<%!

        Connection con;

        Statement stmt;

        ResultSet rs;

%>

<%

        //간혹 Ajax에서는 DB의 자원을 XML형식으로 받아 사용할 때가 있다.

        //그것을 예상하여 emp테이블의 내용을 현 jsp페이지를 통하여 XML형식으로 표현하는 예제이다.

        try{

                Class.forName("oracle.jdbc.driver.OracleDriver");

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

                stmt = con.createStatement();

                rs = stmt.executeQuery("SELECT * FROM emp");

%>

        <total>

<%

                while(rs.next()){

                        String e_num = rs.getString("empno");

                        String e_name = rs.getString("ename");

                        String e_sal = rs.getString("sal");

                        String e_job = rs.getString("job");

%>

                <emp empno="<%=e_num %>">

                        <ename><%=e_name %></ename>

                        <sal><%=e_sal %></sal>

                        <job><%=e_job %></job>

                </emp>

<%

                }

%>

        </total>

<%            

        }catch(Exception e){

                e.printStackTrace();     

        }finally{

                try{

                        if(rs != null) rs.close();

                        if(stmt != null) stmt.close();

                        if(con != null) con.close();

                }catch(Exception e){    

                        e.printStackTrace();

                }

        }

%>