10/26 jsp json

<%@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/json; 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="ora_user";

String pass="hong";

String sql="select * from member";

%>

<%

try{

Class.forName("oracle.jdbc.driver.OracleDriver");

conn=DriverManager.getConnection(url,uid,pass);

stmt=conn.createStatement();

rs=stmt.executeQuery(sql);

String output="";

while(rs.next()){

if (output!="")

    {

        output+= ",";//콤마붙이기

    }

    output+="{'name':'"+rs.getString("name")+"','userid':'"+rs.getString("userid")+"','pwd':'"+rs.getString("pwd")+"','email':'"+rs.getString("email")+"','phone':'"+rs.getString("phone")+"','admin':'"+rs.getInt("admin")+"'}";    

}

output="["+output+"]";

out.print(output);

}catch(Exception e){

e.printStackTrace();

}finally{

try{

if(rs!=null) rs.close();

if(stmt!=null) stmt.close();

if(conn!=null) conn.close();

}catch(Exception e){e.printStackTrace();}

}

%>