public List<AssignmentObj> getAssignmentTable(PreparedStatement pre, boolean inner) {
        List<AssignmentObj> items = new LinkedList<AssignmentObj>();
        try {
            ResultSet rs = pre.executeQuery();
            if (rs != null) {
                while (rs.next()) {
                    AssignmentObj item = new AssignmentObj();
                    item.setAsmId(rs.getInt("asm_id"));
                    item.setTopicId(rs.getInt("topic_id"));
                    item.setClassname(rs.getString("classname"));
                    item.setDeadline(new SimpleDateFormat("dd/MM/yyyy").format(rs.getTimestamp("deadline")));
                    if(inner){
                        item.setName(rs.getString("name"));
                    }
                    items.add(item);
                }
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return items;
    }