<%@page import="java.net.URLEncoder"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"%>
<%@ page import="java.sql.*"%>
<%@ page import="org.json.simple.*"%>
<%
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)
{
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("추가 성공");
}
sql = "SELECT * FROM XMLTEST";
rs = stmt.executeQuery(sql);
JSONArray arr = new JSONArray();
while(rs.next())
{
String name = URLEncoder.encode(rs.getString("name"), "UTF-8");
String age = URLEncoder.encode(rs.getString("age"), "UTF-8");
JSONObject obj = new JSONObject();
obj.put("name", name);
obj.put("age", age);
if(obj != null)
arr.add(obj);
}
out.print(arr);
} catch (Exception e) {
System.out.println("접속 실패");
e.printStackTrace();
}
%>