//    @Test
 public void testRemoveAll() throws SQLException {
   List<Spread> spreadList = dao.getAllByFlockId(flockId);
   for (Spread g : spreadList) {
     dao.remove(g.getId());
   }
   spreadList = dao.getAllByFlockId(flockId);
   assertEquals(0, spreadList.size());
 }
  //    @Test
  public void testInsert() throws SQLException {
    if (!((CreatebleDao) dao).tableExist()) {
      ((CreatebleDao) dao).createTable();
    }

    spread = new Spread();
    spread.setAmount(Integer.valueOf(500));
    spread.setDate("29/06/2013");
    spread.setFlockId(Long.valueOf(1));
    spread.setNumberAccount(Integer.valueOf(5));
    spread.setPrice(Float.valueOf("12.34"));
    spread.setTotal(Float.valueOf("10.25"));
    dao.insert(spread);
    assertEquals(5, dao.getAllByFlockId(flockId).size());
    List<Spread> spreads = dao.getAllByFlockId(flockId);
    for (Spread g : spreads) {
      System.out.println(g);
    }
  }