JSONArray DB 연결

[sj_bomber]

package pack;

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import org.json.simple.*;

public class JsonSang extends HttpServlet {
 Connection conn;
 PreparedStatement pstmt;
 ResultSet rs;

 public void init() throws ServletException {
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   conn = DriverManager.getConnection(
     "jdbc:oracle:thin:@localhost:1521:java", "scott", "tiger");
  } catch (Exception e) {
   System.out.println("DB 연결 실패 :" + e);
  }
 }

 protected void doGet(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {

  JSONObject obj1 = new JSONObject();
  JSONArray array = new JSONArray();

  try {
   String sql = "select * from sangdata";
   pstmt = conn.prepareStatement(sql);
   rs = pstmt.executeQuery();
   while (rs.next()) {
    JSONObject obj = new JSONObject();
    obj.put("code", rs.getString("code"));
    obj.put("sang", rs.getString("sang"));
    obj.put("su", rs.getString("su"));
    obj.put("dan", rs.getString("dan"));
    array.add(obj);
   }
   obj1.put("sangpum", array);
   System.out.println(obj1.toString());
   response.setContentType("text/xml; charset=euc-kr");
   response.setHeader("Cache-control", "no-cache");
   response.getWriter().write(obj1.toString());
  } catch (Exception e) {
   System.out.println("SQL 오류");
  } finally {
   try {
    rs.close();
    pstmt.close();
    conn.close();
   } catch (Exception e) {
   }
  }
 }
}