How to use

AccountDaoImpl

in

com.account.dao

@Override
public Account update(Account account) {
  assert jdbcTemplate.update("UPDATE accounts SET first_name = ? WHERE last_name = ?",
      account.getFirstName(), account.getLastName()) > 0;
  return getAccountByName(account.getFirstName()).get();
}

@Before
public void setUp() throws Exception {
  // create db for test
  embeddedDatabase = new EmbeddedDatabaseBuilder()
      .addDefaultScripts() // added scripts schema.sql and data.sql
      .setType(EmbeddedDatabaseType.H2)
      .build();
  jdbcTemplate = new JdbcTemplate(embeddedDatabase);
  accountDao = new AccountDaoImpl(jdbcTemplate);
}

@Override
public Account insert(Account account) {
  assert jdbcTemplate.update("INSERT INTO accounts (first_name, middle_name, last_name) VALUES (?, ?, ?);",
      account.getFirstName(), account.getMiddleName(), account.getLastName()) > 0;
  return getAccountByName(account.getFirstName()).get();
}