if (rs.getString(1).equals("Au11")){
                            termtitle = "Autumn Term 2011";
                        }
                        if (rs.getString(1).equals("Sp12")){
                            termtitle = "Spring Term 2012";
                        }
                        if (rs.getString(1).equals("Su12")){
                            termtitle = "Summer Term 2012";
                        }
                        if (rs.getString(1).equals("Au12")){
                            termtitle = "Autumn Term 2012";
                        }
                        if (rs.getString(1).equals("Sp13")){
                            termtitle = "Spring Term 2013";
                        }
                        if (rs.getString(1).equals("Su13")){
                            termtitle = "Summer Term 2013";
                        }
                        if (rs.getString(1).equals("Au13")){
                            termtitle = "Autumn Term 2013";
                        }
                        if (rs.getString(1).equals("Sp14")){
                            termtitle = "Spring Term 2014";
                        }
                        if (rs.getString(1).equals("Su14")){
                            termtitle = "Summer Term 2014";
                        }
                        if (rs.getString(1).equals("Au14")){
                            termtitle = "Autumn Term 2014";
                        }
                        if (rs.getString(1).equals("Sp15")){
                            termtitle = "Spring Term 2015";
                        }
                        if (rs.getString(1).equals("Su15")){
                            termtitle = "Summer Term 2015";
                        }
                        if (rs.getString(1).equals("Au15")){
                            termtitle = "Autumn Term 2015";
                        }
                        if (rs.getString(1).equals("Sp16")){
                            termtitle = "Spring Term 2016";
                        }