211015_db 생성후 JSONObject를 생성해서 json파일 만들기

<%@page import="org.json.simple.JSONObject"%>

<%@page import="org.json.simple.JSONArray"%>

<%@page import="java.sql.SQLException"%>

<%@page import="java.sql.Statement"%>

<%@page import="java.sql.ResultSet"%>

<%@page import="java.sql.Connection"%>

<%@page import="mysql.db.DbConnect"%>

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<% 

DbConnect db=new DbConnect();

Connection conn=db.getConnection();

Statement stmt=null;

ResultSet rs=null;

 

String sql="select * from client order by user_id";

 

try{

stmt=conn.createStatement();

rs=stmt.executeQuery(sql);

 

JSONArray arr=new JSONArray();  //JSONobject가 들어가는 배열

 

while(rs.next()){

String userid=rs.getString("user_id");

String name=rs.getString("name");

String age=rs.getString("age");

String addr=rs.getString("addr");

 

JSONObject ob=new JSONObject();

ob.put("userid", userid);

ob.put("name", name);

ob.put("age", age);

ob.put("addr", addr);

//ket값만 하고싶으면 ob.getkey()

 

//array에 추가

arr.add(ob);

} %>

 

<!-- 표현식 -->

<%=arr.toString() %>

 

<%} catch(SQLException e){

 

} finally{

db.dbClose(rs, stmt, conn);

}

%>