pl.edu.agh.szia.pa.dao.CommonDAO.java Source code

Introduction

Here is the source code for pl.edu.agh.szia.pa.dao.CommonDAO.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package pl.edu.agh.szia.pa.dao;

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.URL;
import java.net.URLEncoder;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.classic.Session;
import org.hibernate.criterion.Restrictions;
import org.json.JSONObject;
import pl.edu.agh.szia.pa.model.common.Address;
import pl.edu.agh.szia.pa.model.common.Town;

/**
 *
 * @author uriel
 */
public class CommonDAO {

    private SessionFactory factory;

    public CommonDAO(SessionFactory factory) {
        this.factory = factory;
    }

    public SessionFactory getFactory() {
        return factory;
    }

    public List<Town> listTowns() {
        Session s = factory.openSession();
        s.beginTransaction();
        List<Town> l = s.createCriteria(Town.class).list();
        s.getTransaction().commit();
        s.close();
        return l;
    }

    private Town getTown(Session s, String name) {

        List<Town> towns = s.createCriteria(Town.class).add(Restrictions.eq("name", name)).list();

        if (towns.size() < 1) {
            Town t = new Town(name);
            s.persist(t);
            return t;
        } else {
            return towns.get(0);
        }
    }

    public Address findAddress(String town, String street, String house) {
        Session s = factory.openSession();
        Transaction t = s.getTransaction();
        t.begin();
        Map<String, String> crit = new HashMap<String, String>();
        crit.put("street", street);
        crit.put("house", house);

        List<Address> l = s.createCriteria(Address.class, "a").add(Restrictions.allEq(crit))
                .createAlias("a.town", "t").add(Restrictions.eq("t.name", town)).list();
        t.commit();
        s.close();

        if (l.size() > 0) {
            return l.get(0);
        } else
            return null;
    }

    public void storeAddress(Address a) throws Exception {

        System.out.println(a);

        Session s = factory.openSession();
        Transaction t = s.getTransaction();

        Town to = getTown(s, a.getTown().getName());
        a.setTown(to);

        geocodeAddress(a);

        t.begin();
        s.persist(a);
        t.commit();
        s.close();
    }

    public void geocodeAddress(Address a) throws Exception {

        StringBuffer sb = new StringBuffer("http://maps.googleapis.com/maps/api/geocode/json?address=");
        sb.append(URLEncoder.encode(a.toString(), "UTF-8"));
        URL url = new URL(sb.toString());

        HttpURLConnection http = (HttpURLConnection) url.openConnection();

        BufferedReader br = new BufferedReader(new InputStreamReader(http.getInputStream()));
        String line;
        StringBuffer result = new StringBuffer();

        while (true) {
            line = br.readLine();
            if (line == null)
                break;
            result.append(line);
        }

        br.close();

        JSONObject obj = new JSONObject(result.toString());

        obj = obj.getJSONArray("results").getJSONObject(0).getJSONObject("geometry").getJSONObject("location");

        a.setLongtitude(obj.getDouble("lng"));
        a.setLatitude(obj.getDouble("lat"));

        if (http.getResponseCode() == HttpURLConnection.HTTP_OK) {

        } else {
            throw new IllegalStateException(http.getResponseMessage());
        }

    }

}