/**
* tableInserter insert the values of the list in the table
*
* @param o
*/
public static void tableInserter(Object o) {
Task taskToInsert = null;
if (o instanceof Task) taskToInsert = (Task) o;
try {
Class.forName("org.sqlite.JDBC");
connection = DriverManager.getConnection("jdbc:sqlite:Organizer.db");
connection.setAutoCommit(false);
etat = connection.createStatement();
// queries
String insertQuery =
"INSERT INTO TASK (idTask,idParentProject,idParentWorkspace,taskPositionAL,taskPositionLL,taskName,taskCreationdate,taskDescription,taskTimeSpentOn,taskTimePlanned,taskAdvancement,isCompleted ) "
+ "VALUES ('"
+ taskToInsert.getTaskID()
+ "','"
+ taskToInsert.getParentProject().getProjectID()
+ "','"
+ taskToInsert.getParentProject().getParentWorkspace().getWorkspaceID()
+ "',"
// +
// taskToInsert.getParentProject().getParentWorkspace().getParentUser().getUserID()
// + "',"
+ taskToInsert.getPositionInArrayList()
+ ","
+ taskToInsert.getPositionInTaskList()
+ ",'"
+ taskToInsert.getName()
+ "','"
+ BasicQueryContainer.DateToStringFormat(taskToInsert.getTaskCreationDate())
+ "','"
+ taskToInsert.getTaskDescription()
+ "',"
+ taskToInsert.getTimeSpentWorking()
+ ","
+ taskToInsert.getTimeEstimate()
+ ","
+ taskToInsert.getAdvancement()
+ ",'"
+ taskToInsert.getIsCompleted()
+ "');";
// execution
etat.executeUpdate(insertQuery);
etat.close();
connection.commit();
connection.close();
} catch (Exception e) {
System.err.println(e.getClass().getName() + ": " + e.getMessage());
System.exit(0);
}
System.out.println("Insert operation in table TASK done successfully !!");
}
/** tableExtrator field the list with the value present in the table */
public static void tableExtractor() {
try {
Class.forName("org.sqlite.JDBC");
connection = DriverManager.getConnection("jdbc:sqlite:Organizer.db");
connection.setAutoCommit(false);
etat = connection.createStatement();
ResultSet rs = etat.executeQuery("SELECT * FROM TASK ORDER BY taskPositionLL;");
while (rs.next()) {
// recovery the values of de column in rows
String idTask = rs.getString("idTask");
String idParentProject = rs.getString("idParentProject");
int taskPositionAL = rs.getInt("taskPositionAL");
int taskPositionLL = rs.getInt("taskPositionLL");
String taskName = rs.getString("taskName");
String taskCreationdate = rs.getString("taskCreationdate");
String taskDescription = rs.getString("taskDescription");
int taskTimeSpentOn = rs.getInt("taskTimeSpentOn");
int taskTimePlanned = rs.getInt("taskTimePlanned");
int taskAdvancement = rs.getInt("taskAdvancement");
boolean isCompleted = rs.getBoolean("isCompleted");
// creation of a new task for each rows present in table
Task task =
new Task(
idTask,
idParentProject,
taskPositionAL,
taskPositionLL,
taskName,
BasicQueryContainer.stringToDate(taskCreationdate),
taskDescription,
taskTimeSpentOn,
taskTimePlanned,
taskAdvancement,
isCompleted);
}
System.out.println("The task list was successfully field");
rs.close();
etat.close();
connection.close();
} catch (Exception e) {
System.err.println(e.getClass().getName() + ": " + e.getMessage());
System.exit(0);
}
}
