XML_ex.jsp

<%@ page language="java" contentType="text/html; charset=EUC-KR" pageEncoding="EUC-KR"%> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %> <%@ page import="java.io.*,java.sql.*,java.util.*,java.net.*" %> <% Connection conn = null; PreparedStatement pstmt = null; ResultSet rs = null; String url = "jdbc:oracle:thin:@192.168.0.18:1521:XE"; String user = "dist"; String pass = "1111"; String sql = "SELECT * FROM (SELECT * FROM CMT_DIST_MA ORDER BY SEQ_IDN DESC) WHERE ROWNUM <= 10"; //String state = request.getParameter("state") == null ? "001" : (String)request.getParameter("state"); try { Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection(url, user, pass); pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); %> <?xml version="1.0" encoding="UTF-8" ?> <DISTLIST> <% while (rs.next()) { %> <DISTDATA> <SEQ_IDN><%=rs.getInt("SEQ_IDN") %></SEQ_IDN> <USR_NAM><%=rs.getString("USR_NAM") %></USR_NAM> <USR_REG><%=rs.getString("USR_REG") %></USR_REG> <USR_TEL><%=rs.getString("USR_TEL") %></USR_TEL> <USR_FAX><%=rs.getString("USR_FAX") %></USR_FAX> <USR_ADR><%=rs.getString("USR_ADR") %></USR_ADR> <USR_EML><%=rs.getString("USR_EML") %></USR_EML> <USE_PUR><%=rs.getString("USR_PUR") %></USE_PUR> <USE_AFT><%=rs.getString("USR_AFT") %></USE_AFT> <SRV_TYP><%=rs.getString("SRV_TYP") %></SRV_TYP> <SRV_FMT><%=rs.getString("SRV_FMT") %></SRV_FMT> <SRV_WAY><%=rs.getString("SRV_WAY") %></SRV_WAY> <SRV_NAM><%=rs.getString("SRV_NAM") %></SRV_NAM> <SRV_FEE><%=rs.getString("SRV_FEE") %></SRV_FEE> <SAV_YMD><%=rs.getString("SAV_YMD") %></SAV_YMD> <SRV_RGN><%=rs.getString("SRV_RGN") %></SRV_RGN> </DISTDATA> <% } %> </DISTLIST> <% } catch (SQLException se) { System.err.println("IOException : " + se.getMessage()); se.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } finally { try { pstmt.close(); } catch (Exception e) { } try { conn.close(); } catch (Exception e) { } } %>