public static void main(String[] args) {
DBService dbService = new DBService();
System.out.println("Status: " + dbService.getLocalStatus());
// dbService.save(new CityDataSet("Lol1"));
// dbService.save(new CityDataSet("Lol2"));
//
// CityDataSet dataSet = dbService.read(1);
// System.out.println(dataSet);
//
// dataSet = dbService.readByName("Moscow");
// System.out.println(dataSet);
//
// List<CityDataSet> dataSets = dbService.readAll();
// for (CityDataSet cityDataSet : dataSets) {
// System.out.println(cityDataSet);
// }
// dbService.update("Lol1", "Karaganda");
// dbService.delete("tully23");
List<RefereeDataSet> list = dbService.readCityByRefereeId("Karaganda");
System.out.print(list);
// dbService.callCityProc(3, "Korolev");
dbService.shutdown();
}
/** @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("application/json");
ArrayList<JSONObject> jList = DBService.getJSONStudents();
PrintWriter out = response.getWriter();
out.print("[");
int x = jList.size() - 1;
for (JSONObject o : jList) {
out.print(o);
if (x > 0) {
out.print(",");
x--;
}
}
out.print("]");
out.flush();
}
