// On teste un preparestatement mappé sur un type statique (Class famille)
 @Test
 public void testSelectPrimitive2() throws Exception {
   // On crée les données
   createDatas();
   // ----
   final Domain domain = new Domain("DO_LIB", DataType.String);
   final SqlQueryResult result = executeQuery(domain, "select title from movie where id=1");
   Assert.assertEquals(1, result.getSQLRowCount());
   Assert.assertEquals(TITLE_MOVIE_1, result.getValue());
 }
 // On teste un preparestatement mappé sur un type statique (Class famille)
 @Test
 public void testSelectPrimitive() throws Exception {
   // On crée les données
   createDatas();
   // ----
   final Domain domain = new Domain("DO_INTEGER", DataType.Integer);
   final SqlQueryResult result = executeQuery(domain, "select count(*) from movie");
   Assert.assertEquals(1, result.getSQLRowCount());
   Assert.assertEquals(3, result.getValue());
 }
 // On teste un preparestatement mappé sur un type statique (Class famille)
 @Test
 public void testSelectObject() throws Exception {
   // On crée les données
   createDatas();
   // ----
   final Domain domain = Home.getDefinitionSpace().resolve("DO_DT_MOVIE_DTO", Domain.class);
   final SqlQueryResult result = executeQuery(domain, "select * from movie where id=1");
   Assert.assertEquals(1, result.getSQLRowCount());
   final Movie movie = (Movie) result.getValue();
   Assert.assertEquals("citizen kane", movie.getTitle());
 }
  // On teste un preparestatement mappé sur un type dynamique DTList.
  @Test
  public void testDynSelect() throws Exception {
    // On crée les données
    createDatas();
    // ----
    final Domain domain = new Domain("DO_TEST", DataType.DtList);
    final SqlQueryResult result = executeQuery(domain, "select * from movie");

    Assert.assertEquals(3, result.getSQLRowCount());
    final DtList<DtObject> dynMovies = (DtList<DtObject>) result.getValue();
    Assert.assertEquals(3, dynMovies.size());

    for (final DtObject dynMovie : dynMovies) {
      final long id = (Long) getValue(dynMovie, "ID");
      final String title = (String) getValue(dynMovie, "TITLE");
      checkTitle(id, title);
    }
  }
  // On teste un preparestatement mappé sur un type statique (Class famille)
  @Test
  public void testSelectList() throws Exception {
    // On crée les données
    createDatas();
    // ----
    final Domain domain = Home.getDefinitionSpace().resolve("DO_DT_MOVIE_DTC", Domain.class);
    final SqlQueryResult result = executeQuery(domain, "select * from movie");

    Assert.assertEquals(3, result.getSQLRowCount());

    final DtList<Movie> movies = (DtList<Movie>) result.getValue();
    Assert.assertEquals(3, movies.size());

    for (final Movie movie : movies) {
      final long id = movie.getId();
      final String title = movie.getTitle();
      checkTitle(id, title);
    }
  }