
<%@page pageEncoding="UTF-8" contentType="text/html; charset=UTF-8"%>
<%@ page errorPage="ErrorPage.jsp" %>

<%

	String action = ( (HttpServletRequest)request ).getParameter("action");
	
	String driver_classname = "org.gjt.mm.mysql.Driver";
	String server_url = "jdbc:mysql://localhost:3306/world";
	String login_id = "root";
	String login_pw = "admin";
	
	
    java.lang.Class.forName( driver_classname );
	java.sql.Connection con = java.sql.DriverManager.getConnection( server_url, login_id, login_pw );	
	java.sql.PreparedStatement stmt = null;
	java.sql.ResultSet rs = null;
		
	con.setAutoCommit(false);
	
	String backend_sql_string = "select name "
								+ "from city where countrycode = 'chn' limit 100 ";
	
	stmt = con.prepareStatement( backend_sql_string );
					
	rs = stmt.executeQuery();
	
	// Test purpose
	/*
	String objectToReturn = "[" +
                    "{\"param1\":\"value1\",\"param2\":\"value2\"}," +
                    "{\"param1\":\"value3\",\"param2\":\"value4\"}" +
                    "]";	
	*/
	
	String objectToReturn = "[";
	
	int cnt = 0;
	
	while ( rs.next() )
	{		
		cnt = cnt + 1;
		
		String val = "{\"name\":\"" + rs.getString(1) + "\"}";
		
		if ( cnt == 1 )
		{
			objectToReturn = objectToReturn + val;
		}
		else
		{
			objectToReturn = objectToReturn + "," + val;
		}			
	}
	
	objectToReturn =objectToReturn + "]";
	
	
    String sendFormat = "application/json;charset=utf-8";
	response.setContentType(sendFormat);
	response.setHeader("Cache-Control", "no-cache");
					
	response.getWriter().write(objectToReturn);
   
	response.getWriter().flush();
	
%>