Search in sources :

Example 1 with DataCentralLocation

use of il.ac.technion.cs.yp.btw.db.DataObjects.DataCentralLocation in project BTW by TechnionYearlyProject.

the class QueryAllCentralLocations method arrangeRecievedData.

/*
    * @author Sharon Hadar
     * @Date 21/01/2018
     * get the results fro the data base and construct the match centeral locations
     * */
@Override
public Set<CentralLocation> arrangeRecievedData(ResultSet resultSet) {
    Set<CentralLocation> centralLocations = new HashSet();
    try {
        while (resultSet.next()) {
            String nameID = resultSet.getString("nameID");
            String street = resultSet.getString("street");
            int cord1x = resultSet.getInt("cord1x");
            int cord2x = resultSet.getInt("cord2x");
            int cord3x = resultSet.getInt("cord3x");
            int cord4x = resultSet.getInt("cord4x");
            int cord1y = resultSet.getInt("cord1y");
            int cord2y = resultSet.getInt("cord2y");
            int cord3y = resultSet.getInt("cord3y");
            int cord4y = resultSet.getInt("cord4y");
            Set<Point> points = new HashSet<Point>();
            points.add(new PointImpl(cord1x, cord1y));
            points.add(new PointImpl(cord2x, cord2y));
            points.add(new PointImpl(cord3x, cord3y));
            points.add(new PointImpl(cord4x, cord4y));
            CentralLocation centralLocation = new DataCentralLocation(points, nameID, street, mapName);
            centralLocations.add(centralLocation);
        }
    } catch (SQLException e) {
        System.out.println("query has failed");
    }
    return centralLocations;
}
Also used : DataCentralLocation(il.ac.technion.cs.yp.btw.db.DataObjects.DataCentralLocation) SQLException(java.sql.SQLException) CentralLocation(il.ac.technion.cs.yp.btw.classes.CentralLocation) DataCentralLocation(il.ac.technion.cs.yp.btw.db.DataObjects.DataCentralLocation) Point(il.ac.technion.cs.yp.btw.classes.Point) Point(il.ac.technion.cs.yp.btw.classes.Point) PointImpl(il.ac.technion.cs.yp.btw.classes.PointImpl) HashSet(java.util.HashSet)

Example 2 with DataCentralLocation

use of il.ac.technion.cs.yp.btw.db.DataObjects.DataCentralLocation in project BTW by TechnionYearlyProject.

the class QueryCentralLocation method arrangeRecievedData.

/*
     * @author Sharon Hadar
     * @Date 21/01/2018
     * construct a centeral location from the data base results*/
@Override
public CentralLocation arrangeRecievedData(ResultSet resultSet) {
    CentralLocation centralLocation = null;
    try {
        // check if it is necessary.
        resultSet.next();
        String nameID = resultSet.getString("nameID");
        String street = resultSet.getString("street");
        double cord1x = resultSet.getDouble("cord1x");
        double cord2x = resultSet.getDouble("cord2x");
        double cord3x = resultSet.getDouble("cord3x");
        double cord4x = resultSet.getDouble("cord4x");
        double cord1y = resultSet.getDouble("cord1y");
        double cord2y = resultSet.getDouble("cord2y");
        double cord3y = resultSet.getDouble("cord3y");
        double cord4y = resultSet.getDouble("cord4y");
        Set<Point> points = new HashSet<Point>();
        points.add(new PointImpl(cord1x, cord1y));
        points.add(new PointImpl(cord2x, cord2y));
        points.add(new PointImpl(cord3x, cord3y));
        points.add(new PointImpl(cord4x, cord4y));
        centralLocation = new DataCentralLocation(points, nameID, street, mapName);
    } catch (SQLException e) {
        System.out.println("query has failed");
    }
    return centralLocation;
}
Also used : DataCentralLocation(il.ac.technion.cs.yp.btw.db.DataObjects.DataCentralLocation) SQLException(java.sql.SQLException) CentralLocation(il.ac.technion.cs.yp.btw.classes.CentralLocation) DataCentralLocation(il.ac.technion.cs.yp.btw.db.DataObjects.DataCentralLocation) Point(il.ac.technion.cs.yp.btw.classes.Point) PointImpl(il.ac.technion.cs.yp.btw.classes.PointImpl) HashSet(java.util.HashSet)

Example 3 with DataCentralLocation

use of il.ac.technion.cs.yp.btw.db.DataObjects.DataCentralLocation in project BTW by TechnionYearlyProject.

the class TestDataCentralLocation method testCentralLocation.

/*
     * @author Sharon Hadar
     * @Date 21/01/2018*/
@Test
public void testCentralLocation() {
    Point a = new PointImpl(3, 4);
    Point b = new PointImpl(1, 2);
    Set<Point> points = new HashSet<Point>();
    points.add(a);
    points.add(b);
    CentralLocation cl = new DataCentralLocation(points, "Bank", "Namir", "try");
    String s = cl.toString();
    String sn = cl.getName();
    Assert.assertTrue(s.contains(sn));
}
Also used : DataCentralLocation(il.ac.technion.cs.yp.btw.db.DataObjects.DataCentralLocation) CentralLocation(il.ac.technion.cs.yp.btw.classes.CentralLocation) DataCentralLocation(il.ac.technion.cs.yp.btw.db.DataObjects.DataCentralLocation) Point(il.ac.technion.cs.yp.btw.classes.Point) PointImpl(il.ac.technion.cs.yp.btw.classes.PointImpl) HashSet(java.util.HashSet) Test(org.junit.Test)

Aggregations

CentralLocation (il.ac.technion.cs.yp.btw.classes.CentralLocation)3 Point (il.ac.technion.cs.yp.btw.classes.Point)3 PointImpl (il.ac.technion.cs.yp.btw.classes.PointImpl)3 DataCentralLocation (il.ac.technion.cs.yp.btw.db.DataObjects.DataCentralLocation)3 HashSet (java.util.HashSet)3 SQLException (java.sql.SQLException)2 Test (org.junit.Test)1