private ProductLine getProductLineFromDBWithChild(Connection con, int id) throws SQLException {
ModuleDAO moduleDao = new ModuleDAO();
ProductLine productLine = null;
try (PreparedStatement prepStatement = con.prepareStatement(selectProductLine)) {
prepStatement.setInt(1, id);
try (ResultSet result = prepStatement.executeQuery()) {
while (result.next()) {
productLine = new ProductLine();
productLine.setId(result.getInt("productline_id"));
productLine.setName(result.getString("name"));
productLine.setDescription(result.getString("description"));
Integer parent = result.getInt("parent_productline");
if (result.wasNull()) {
productLine.setParent(null);
} else {
productLine.setParent(getProductLine(parent, con));
}
}
if (productLine != null) {
productLine.setModules(moduleDao.getModulesWhithChildsByProductLine(productLine, con));
}
}
}
return productLine;
}
private ProductLine[] getProductLinesByParentFromDB(Connection con, int parent_id)
throws ClassNotFoundException, SQLException {
ModuleDAO moduleDao = new ModuleDAO();
ProductLine productLine = null;
try (PreparedStatement prepStatement = con.prepareStatement(selectProductLinesByParent)) {
prepStatement.setInt(1, parent_id);
Set<ProductLine> resultSet = new HashSet<>();
try (ResultSet result = prepStatement.executeQuery()) {
while (result.next()) {
productLine = new ProductLine();
productLine.setId(result.getInt("productline_id"));
productLine.setName(result.getString("name"));
productLine.setDescription(result.getString("description"));
Integer parent = result.getInt("parent_productline");
if (result.wasNull()) {
productLine.setParent(null);
} else {
productLine.setParent(getProductLine(parent, con));
}
productLine.setModules(moduleDao.getModulesWhithChildsByProductLine(productLine, con));
resultSet.add(productLine);
}
}
return resultSet.toArray(new ProductLine[resultSet.size()]);
}
}
public int createAll(ProductLine productLine, Connection connection)
throws ClassNotFoundException, SQLException {
ModuleDAO moduleDao = new ModuleDAO();
int plId = this.save(productLine, connection);
productLine.setId(plId);
moduleDao.createAll(productLine.getModules(), connection);
return plId;
}
public boolean delete(ProductLine p, Connection con) throws SQLException {
ModuleDAO mDao = new ModuleDAO();
for (Module m : p.getModules()) {
mDao.delete(m, con);
}
try (PreparedStatement prepStatement = con.prepareStatement(remove)) {
prepStatement.setLong(1, p.getId());
return prepStatement.execute();
}
}
