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;
}
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;
}
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));
}
Aggregations