use of il.ac.technion.cs.yp.btw.classes.Point 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) {
logger.error("query central location has failed");
}
return centralLocation;
}
use of il.ac.technion.cs.yp.btw.classes.Point in project BTW by TechnionYearlyProject.
the class QueryStreet method arrangeRecievedData.
/*
* @author Sharon Hadar
* @Date 21/01/2018
* construct a street from the result of the data base*/
@Override
public Street arrangeRecievedData(ResultSet resultSet) {
Set<Road> roads = new HashSet();
try {
while (resultSet.next()) {
String nameID = resultSet.getString("nameID");
int cord1x = resultSet.getInt("cord1x");
int cord2x = resultSet.getInt("cord2x");
int cord1y = resultSet.getInt("cord1y");
int cord2y = resultSet.getInt("cord2y");
int length = resultSet.getInt("length");
int secStart = resultSet.getInt("secStart");
int secEnd = resultSet.getInt("secEnd");
long overload = resultSet.getLong("overload");
String myStreet = nameID.split("st")[0];
Point sourceCrossroadId = new PointImpl(cord1x, cord1y);
Point destinationCrossroadId = new PointImpl(cord2x, cord2y);
Road road = new DataRoad(nameID, length, myStreet, sourceCrossroadId, destinationCrossroadId, secStart, secEnd, overload, mapName);
roads.add(road);
}
} catch (SQLException e) {
logger.error("query has failed");
}
return new DataStreet(streetName, roads, mapName);
}
Aggregations