public List<Spare> getSparesList() {
try {
ResultSet rs = executeQuery("SELECT * FROM spares;");
List list = new ArrayList();
while (rs.next()) {
SpareData spareData = new SpareData();
int id = rs.getInt(1);
int mid = rs.getInt(2);
int sid = rs.getInt(3);
for (int i = 0; i < SpareData.fieldsName.length; i++) {
String fieldValue = rs.getString(SpareData.fieldsName[i]);
spareData.updateByFieldName(SpareData.fieldsName[i], fieldValue);
}
Spare spare = new Spare(spareData);
spare.setId(id);
spare.setMid(mid);
spare.setSid(sid);
list.add(spare);
}
return list;
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
public void addSpareListToDatabase(List<Spare> spares, Service serv) {
Iterator it = spares.iterator();
while (it.hasNext()) {
Spare spare = (Spare) it.next();
int id = getNextId("spares");
String query = "INSERT INTO spares SET id=" + id + ", ";
query = query + "sid=" + serv.getId() + ", mid=" + serv.getMid() + ", ";
for (int i = 0; i < SpareData.fieldsName.length; i++) {
String fieldname = SpareData.fieldsName[i];
String val = spare.getInfoByFieldName(fieldname);
query = query + fieldname + "= \"" + val + "\"";
if (i != SpareData.fieldsName.length - 1) query = query + ", ";
}
query = query + ";";
executeUpdate(query);
spare.setId(id);
spare.setSid(serv.getId());
spare.setMid(serv.getMid());
}
}
public void importDatabase(String filename) {
DatabaseReadFile file = new DatabaseReadFile();
file.open(filename);
List customers = file.readCustomersList();
Iterator it = customers.iterator();
while (it.hasNext()) {
Customer cust = (Customer) it.next();
String query = "INSERT INTO customers SET id=" + cust.getId() + ", ";
for (int i = 0; i < CustomerData.fieldsName.length; i++) {
String fieldname = CustomerData.fieldsName[i];
String val = cust.getInfoByFieldName(fieldname);
query = query + fieldname + "= \"" + val + "\"";
if (i != CustomerData.fieldsName.length - 1) query = query + ", ";
}
query = query + ";";
executeUpdate(query);
}
List machines = file.readMachinesList();
Iterator it2 = machines.iterator();
while (it2.hasNext()) {
Machine mach = (Machine) it2.next();
String query =
"INSERT INTO machines SET id=" + mach.getId() + ", cid=" + mach.getCid() + ", ";
for (int i = 0; i < MachineData.fieldsName.length; i++) {
String fieldname = MachineData.fieldsName[i];
String val = mach.getInfoByFieldName(fieldname);
query = query + fieldname + "= \"" + val + "\"";
if (i != MachineData.fieldsName.length - 1) query = query + ", ";
}
query = query + ";";
executeUpdate(query);
}
List services = file.readServicesList();
Iterator it3 = services.iterator();
while (it3.hasNext()) {
Service serv = (Service) it3.next();
String query =
"INSERT INTO services SET id=" + serv.getId() + ", mid=" + serv.getMid() + ", ";
for (int i = 0; i < ServiceData.fieldsName.length; i++) {
String fieldname = ServiceData.fieldsName[i];
String val = serv.getInfoByFieldName(fieldname);
query = query + fieldname + "= \"" + val + "\"";
if (i != ServiceData.fieldsName.length - 1) query = query + ", ";
}
query = query + ";";
executeUpdate(query);
}
List spares = file.readSparesList();
Iterator it4 = spares.iterator();
while (it4.hasNext()) {
Spare spare = (Spare) it4.next();
String query =
"INSERT INTO spares SET id="
+ spare.getId()
+ ", mid="
+ spare.getMid()
+ ", sid="
+ spare.getSid()
+ ", ";
for (int i = 0; i < SpareData.fieldsName.length; i++) {
String fieldname = SpareData.fieldsName[i];
String val = spare.getInfoByFieldName(fieldname);
query = query + fieldname + "= \"" + val + "\"";
if (i != SpareData.fieldsName.length - 1) query = query + ", ";
}
query = query + ";";
executeUpdate(query);
}
file.close();
}
