<%@page import="java.net.URLEncoder"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"%>
<%@ page import="java.sql.*"%>
<%
String DB_URL = "jdbc:oracle:thin:@127.0.0.1:1521:XE";
String DB_USER = "system";
String DB_PASSWORD = "xxxx";
String sql = null;
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
System.out.println("드라이버 로딩 성공");
conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);
System.out.println("접속 성공");
stmt = conn.createStatement();
if(request.getParameter("name") != null)
{
//한글 입력 문제로 UTF-8로 인코딩 한 문자열을 받아옴.
request.setCharacterEncoding("UTF-8");
String name = new String(request.getParameter("name").getBytes("8859_1"),"UTF-8");
String age = new String(request.getParameter("age").getBytes("8859_1"),"UTF-8");
sql = String.format("INSERT INTO XMLTEST(NAME, AGE) values('%s', %s)", name, age);
System.out.print(sql);
stmt.executeUpdate(sql);
System.out.println("추가 성공");
}
//xml로 oracle에서 db 읽어오는 부분
sql = "SELECT dbms_xmlgen.getxml('select * FROM XMLTEST') xml FROM dual";
rs = stmt.executeQuery(sql);
rs.next();
String output = rs.getString("XML");
output = URLEncoder.encode(output, "UTF-8");
out.print(output);
} catch (Exception e) {
e.printStackTrace();
}
%>