### Question:
HJABirdsongDAO extends HJABirdsongParentDAO { public static HJABirdSong selectSingle(int bagid) { Object[] params = new Object[] { bagid }; String SELECT_SINGLE = "SELECT * FROM BIRD_SONGS WHERE bagid = ?"; return Yank.queryBean(SELECT_SINGLE, HJABirdSong.class, params); }  static int dropTable(); static int createTable(); static int insert(HJABirdSong hJABirdSong); static HJABirdSong selectSingle(int bagid); static long selectCount();  }### Answer:
@Test public void testSelect() throws SQLException { HJABirdSong hJABirdSong = HJABirdsongDAO.selectSingle(3); assertThat(hJABirdSong.getBagid(), equalTo(3)); assertThat(hJABirdSong.getLabels(), equalTo("1,3")); assertThat(hJABirdSong.getLabelsAsArray().get(0), equalTo(1)); assertThat(hJABirdSong.getLabelsAsArray().get(1), equalTo(3)); assertThat(hJABirdSong.getWavfilename(), equalTo("PC13_20090531_050000_10.wav")); }