@Override
public OrtDTO createPoint(OrtDTO dto) throws SQLException {
PreparedStatement preparedStatement = null;
Connection connection = daoFactory.getConnection();
preparedStatement =
DaoUtil.prepareStatement(
connection,
CREATEPOINT,
false,
new Object[] {dto.getPointX(), dto.getPointY(), dto.getDescription()});
preparedStatement.executeUpdate();
return findPointByAxis(dto.getPointX(), dto.getPointY());
}
@Override
public OrtDTO findPointByAxis(int punktX, int punktY) throws SQLException {
OrtDTO ort = new OrtDTO();
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
Connection connection = daoFactory.getConnection();
preparedStatement =
DaoUtil.prepareStatement(connection, FINDPOINTBYAXIS, false, new Object[] {punktX, punktY});
resultSet = preparedStatement.executeQuery();
while (resultSet.next()) {
ort.setPointId(resultSet.getLong("id"));
ort.setPointX(resultSet.getInt("xAxis"));
ort.setPointY(resultSet.getInt("yAxis"));
ort.setDescription(resultSet.getString("name"));
}
return ort;
}
@Override
public void deletePoint(OrtDTO dto) throws SQLException {
PreparedStatement preparedStatement = null;
Connection connection = daoFactory.getConnection();
preparedStatement =
DaoUtil.prepareStatement(
connection, DELETEPOINTBYID, false, new Object[] {dto.getPointId()});
preparedStatement.executeUpdate();
}
@Override
public List<OrtDTO> findAllPoints() throws SQLException {
List<OrtDTO> retVal = new ArrayList<OrtDTO>();
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
Connection connection = daoFactory.getConnection();
preparedStatement = DaoUtil.prepareStatement(connection, FINDALLPOINTS, false, new Object[0]);
resultSet = preparedStatement.executeQuery();
while (resultSet.next()) {
OrtDTO ort = new OrtDTO();
ort.setPointId(resultSet.getLong("id"));
ort.setPointX(resultSet.getInt("xAxis"));
ort.setPointY(resultSet.getInt("yAxis"));
ort.setDescription(resultSet.getString("name"));
retVal.add(ort);
}
return retVal;
}