"); assertEquals("Merlin(科林·摩根ColinMorgan饰)受母亲的教导从家乡来到宫廷寻找宫廷御医头Gaius学艺，发现了自己身负伟大使命，被收为养子。他还邂逅了深锁于城堡深处的古代巨龙，巨龙便告诉他自身的使命：保护王子Arthur(Bradley James饰)，使Arthur成为未来的国王。为了能在Arthur身边保护他，Merlin成为了Arthur的贴身男仆。但事情并不像Merlin想象得那么顺利，邪恶的女巫Nimueh(Michelle Ryan饰)发现了Merlin身负的伟大使命，便施计企图陷害他。在Merlin的帮助下，Arthur得以重获领地。随着Merlin的能力与身份的逐渐暴露，国王Uther Pendragon(Anthony Head饰)与九魔法师Morgana(Georgia King饰)的仇恨也与日俱增。本剧根据亚瑟王与魔法师梅林的故事改编，由BBC威尔士电视台与Shine影视公司共同出品。也许Merlin不是最出色的男仆，但在面对他的敌人时，他将会面对这一切。Merlin将不顾一切保护Arthur，以免他受到更多的危险。在一次次邪恶的冒险中，Merlin和Arthur的友情也不断被考验，但他们仍然会一起经历更多的冒险。", series.getDescription()); } @Test public void testFindSeriesWithMaxSeasons() { Series series = null; int seasons = 0; String q = "Select s from Series s where s.seasons = (Select max(seasons) from Series)"; TypedQuery query = em.createQuery(q, Series.class); query.setMaxResults(1); series = query.getSingleResult(); seasons = series.getSeasons(); assertEquals("末日孤舰第4季 The Last Ship (Season 4)", series.getName() " (Season " seasons ")"); assertEquals(4, seasons); } @Test public void testFindSeriesWithMaxSeasons2() { Series series = null; int seasons = 0; String q = "Select s from Series s Order by s.seasons DESC"; TypedQuery query = em.createQuery(q, Series.class); query.setMaxResults(1); series = query.getSingleResult(); seasons = series.getSeasons(); assertEquals("末日孤舰第4季 The Last Ship (Season 4)", series.getName() " (Season " seasons ")"); assertEquals(4, seasons); } @Test public void testFindSeriesWithMaxSeasons3() { Series series = null; int seasons = 0; List list = is.getSeriesWithMaxSeasons(); series = list.get(0); seasons = series.getSeasons(); assertEquals("末日孤舰第4季 The Last Ship (Season 4)", series.getName() " (Season " seasons ")"); assertEquals(4, seasons); } @Test public void testFindSeriesWithMaxSeasons4() { Series series = null; int seasons = 0; String q = "Select distinct s from Series s Join s.seasonsObj se where se.season = " "(Select max(season) from s.seasonsObj)"; TypedQuery query = em.createQuery(q,
