abelymiguel.miralaprima.GetMoza.java Source code

Java tutorial

Introduction

Here is the source code for abelymiguel.miralaprima.GetMoza.java

Source

/*
 =============
 This program is free software: you can redistribute it and/or modify
 it under the terms of the GNU Lesser General Public License as published by
 the Free Software Foundation, either version 3 of the License, or
 (at your option) any later version.
    
 This program is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 GNU General Public License for more details.
    
 You should have received a copy of the GNU Lesser General Public License
 along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
package abelymiguel.miralaprima;

import java.io.IOException;
import java.io.PrintWriter;
import java.net.URISyntaxException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.json.JSONArray;

/**
 *
 * @author refusta
 */
public class GetMoza extends HttpServlet {

    private Connection _con;
    private Statement _stmt;
    private ResultSet _rs;

    /**
     * Processes requests for both HTTP
     * <code>GET</code> and
     * <code>POST</code> methods.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response) {
        response.setContentType("text/html;charset=UTF-8");
        try {
            _con = Utils.getConnection();
            _stmt = _con.createStatement();
        } catch (URISyntaxException ex) {
            Logger.getLogger(GetMoza.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(GetMoza.class.getName()).log(Level.SEVERE, null, ex);
        }

        PrintWriter out = null;
        try {
            out = response.getWriter();
        } catch (IOException ex) {
            Logger.getLogger(GetMoza.class.getName()).log(Level.SEVERE, null, ex);
        }
        response.setContentType("text/javascript;charset=UTF-8");

        String country_code;
        int limit;
        String limitStr;
        country_code = request.getParameter("country_code");
        limitStr = request.getParameter("limit");

        if (limitStr != null) {
            limit = Integer.parseInt(limitStr);
        } else {
            limit = -1;
        }

        String json_str;
        JSONArray jsonArray = new JSONArray(this.searchInDB(country_code, limit));
        json_str = jsonArray.toString();

        String jsonpCallback = request.getParameter("callback");
        if (jsonpCallback != null) {
            out.write(jsonpCallback + "(" + json_str + ")");
        } else {
            out.println(json_str);
        }

        try {
            _con.close();
            _stmt.close();
            _rs.close();
        } catch (SQLException ex) {
            Logger.getLogger(GetPrima.class.getName()).log(Level.SEVERE, null, ex);
        }
        out.close();
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP
     * <code>GET</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP
     * <code>POST</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     *
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

    private ArrayList<HashMap<String, Object>> searchInDB(String country, int rows) {

        ArrayList<HashMap<String, Object>> respuestaJson = new ArrayList<HashMap<String, Object>>();
        try {
            String query;
            String randomQuery = " ORDER BY RAND() LIMIT " + rows;
            if (country == null) {
                if (rows != -1) {
                    query = "SELECT url_prima, provider, country_code FROM photos WHERE approved = 1" + randomQuery;
                } else {
                    query = "SELECT url_prima, provider, country_code FROM photos WHERE approved = 1";
                }
            } else {
                if (rows != -1) {
                    query = "SELECT url_prima, provider, country_code FROM photos WHERE approved = 1 AND country_code='"
                            + country + "'" + randomQuery;
                } else {
                    query = "SELECT url_prima, provider, country_code FROM photos WHERE approved = 1 AND country_code='"
                            + country + "'";
                }

            }
            _rs = _stmt.executeQuery(query);

            while (_rs.next()) {
                HashMap<String, Object> objetoJson = new HashMap<String, Object>();
                String url = _rs.getString("url_prima");
                String provider = _rs.getString("provider");
                String country_code = _rs.getString("country_code");
                objetoJson.put("photo_url", url);
                objetoJson.put("provider", provider);
                objetoJson.put("country_code", country_code);
                respuestaJson.add(objetoJson);
            }

            _con.close();
            _stmt.close();
            _rs.close();
        } catch (SQLException ex) {
            Logger.getLogger(GetMoza.class.getName()).log(Level.SEVERE, null, ex);
            HashMap<String, Object> objetoJsonEmergency = new HashMap<String, Object>();
            objetoJsonEmergency.put("photo_url",
                    "http://especiales.fhm.es/galerias/heather_doss/images/heather-doss-2.jpg");
            objetoJsonEmergency.put("provider", "http://especiales.fhm.es/galerias/heather_doss/");
            objetoJsonEmergency.put("country_code", "ALL");
            respuestaJson.add(objetoJsonEmergency);
        }
        return respuestaJson;
    }
}