CustomerSearch.jsp

<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
 pageEncoding="UTF-8"%>
<%!//선언부는 첫 방문자에 의해서 단 한번 수행합니다.
 Connection conn = null;
 Statement stmt = null;
 ResultSet rs = null;
 String url = "jdbc:oracle:thin:@localhost:1521:orcl";
 String uid = "hr";
 String pass = "1234";
 String search;
 String sql;
 %>

  <%
   try {
    Class.forName("oracle.jdbc.driver.OracleDriver");
    conn = DriverManager.getConnection(url, uid, pass);
    stmt = conn.createStatement();
    //get방식으로 넘어오는 search패러미터값을 받음.
    search=request.getParameter("search");
    
    sql= "select * from customer where address like '%"+search+"%'";
    rs = stmt.executeQuery(sql);
    String strJson="";
    strJson="{\"customers\": [";
   
    while(rs.next()) { 
     strJson+="{\"id\":\""+rs.getString("id")
       +"\", \"name\":\""+rs.getString("name")
       +"\", \"address\":\""
       +rs.getString("address")+"\"},";
    }
    strJson=strJson.substring(0,strJson.length()-1);//마지막 쉼표 제거
    strJson+="]}"; 
    out.println(strJson);
   } catch (Exception e) {
    out.println(e.getMessage());
    //e.printStackTrace();
   } finally {
    try {
     if (rs != null)
      rs.close();
     if (stmt != null)
      stmt.close();
     if (conn != null)
      conn.close();
    } catch (Exception e) {
     e.printStackTrace();
    }
   }//finally의 끝
  %>