%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="EUC-KR"%>
<%@ page import="java.sql.*" %>
<%
ResultSet rs = null;
try {
// 1. JDBC ¶óÀ̺귯¸® ·Îµå
Class.forName("oracle.jdbc.driver.OracleDriver");
// 2. DB ¼¹ö ¿¬°á
String conUrl = "jdbc:oracle:thin:@localhost:1521:xe";
Connection con = DriverManager.getConnection(conUrl, "system", "1111");
// 3. SQL ¹®Àå
String sql = "select * from member";
PreparedStatement pstmt = con.prepareStatement(sql);
//int result = pstmt.executeUpdate(); -> insert, update, delete
rs = pstmt.executeQuery(); // -> select
/* while(rs.next()) {
out.print(rs.getString("id"));
out.print(rs.getString("gender"));
out.print(rs.getString("address"));
out.print(rs.getString("regdate"));
} */
} catch(ClassNotFoundException e) {
out.print("ClassNotFound!");
} catch(SQLException e) {
out.print("SQLException!");
}
%>
<%
String strJson="";
strJson="{\"customers\": [";
while(rs.next()) {
strJson+="{\"name\":\""+rs.getString("id")+"\", \"address\":\""+rs.getString("address")+"\"},";
}
strJson=strJson.substring(0,strJson.length()-1);
strJson+="]}";
out.println(strJson);
%>