package com.hictc.dao;

import java.sql.*;
import net.sf.json.util.JSONStringer;

public class TestGridDao {

	public JSONStringer getJson()  {
		Connection con = null;
		ResultSet rs = null;
		PreparedStatement pstmt = null;
		JSONStringer js = null;

		StringBuffer sql= new StringBuffer();
		sql.append(" SELECT COMPCD, CONFID, LANGCD, GRUPID, TYPEID, TYPETX, MOVURL, ETTPYN, PAYGBN, IDXKEY FROM PAT0031  ");
		String url ="jdbc:oracle:thin:@localhost:1521:orcl";

		try {//oracle.jdbc.driver.OracleDriver
			Class.forName("oracle.jdbc.driver.OracleDriver");
			con = DriverManager.getConnection(url,"htr", "");
			pstmt = con.prepareStatement(sql.toString());
			rs = pstmt.executeQuery();

			js = new JSONStringer();
			js.array();

			while(rs.next()) {
				js.object()
				.key("COMPCD").value(rs.getString("COMPCD"))
				.key("CONFID").value(rs.getString("CONFID"))
				.key("LANGCD").value(rs.getString("LANGCD"))
				.key("GRUPID").value(rs.getString("GRUPID"))
				.key("TYPEID").value(rs.getString("TYPEID"))
				.key("TYEPTX").value(rs.getString("TYPETX"))
				.key("MOVURL").value(rs.getString("MOVURL"))
				.key("ETTPYN").value(rs.getString("ETTPYN"))
				.key("PAYGBN").value(rs.getString("PAYGBN"))
				.key("IDXKEY").value(rs.getString("IDXKEY"))
				.endObject();

			}
			js.endArray();
			System.out.println(js.toString());

		} catch(SQLException e) {
			System.out.println(e.getMessage());
		} catch(Exception e) {
			System.out.println(e.getMessage());
		} finally {
		  try { if (rs!= null) rs.close();
		        if (pstmt != null) pstmt.close();
		        if (con != null) con.close();
		  } catch(SQLException e) {

		  }
		}
		return js;
	}
}