/* Create a trip task */
public boolean createTripTask(TripTask newTripTask) {
Connection conn = util.getConnection();
PreparedStatement ps = null;
try {
ps = conn.prepareStatement(this.CREATE_NEW_TRIP_TASK_SQL);
ps.setInt(1, newTripTask.getApplicationId());
ps.setInt(2, newTripTask.getDeveloperId());
ps.setInt(3, newTripTask.getStatus());
ps.execute();
return true;
} catch (SQLException e) {
e.printStackTrace();
return false;
} finally {
try {
if (ps != null) ps.close();
if (conn != null) conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
/* Modify the information of trip task */
public boolean tripTaskInfoModify(TripTask tripTask) {
Connection conn = util.getConnection();
PreparedStatement ps = null;
try {
ps = conn.prepareStatement(this.CHANGE_TRIP_TASK_INFO_SQL);
ps.setInt(1, tripTask.getApplicationId());
ps.setInt(2, tripTask.getDeveloperId());
ps.setInt(3, tripTask.getStatus());
ps.setInt(4, tripTask.getId());
ps.execute();
return true;
} catch (SQLException e) {
e.printStackTrace();
return false;
} finally {
try {
if (ps != null) ps.close();
if (conn != null) conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}