<%@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();
	}		
%>
Posted by 0xsecret
: