### Question:
DbStore implements Store, UserAddressStore { @Override public void add(User user) { try (Connection connect = SOURCE.getConnection(); PreparedStatement st = connect.prepareStatement( PROPS.getProperty("addUser") )) { st.setString(1, user.getName()); st.setString(2, user.getLogin()); st.setString(3, user.getEmail()); st.setTimestamp(4, new Timestamp(user.getCreateDate().getTimeInMillis())); st.setString(5, user.getPassword()); st.setString(6, user.getRole()); st.setString(7, user.getCity()); st.execute(); } catch (SQLException e) { LOG.error(e.getMessage(), e); } } private  DbStore(); static DbStore getInstance(); @Override User findByLogin(String login); @Override void add(User user); @Override void update(User newUser); @Override void delete(int userId); @Override List<User> findAll(); @Override User findById(int id); List<String> findAllCountries(); List<String> findCitiesByCountry(String name);  }### Answer:
@Test public void add() throws SQLException { this.testStore.add(this.first); try (Statement st = this.connect.createStatement(); ResultSet rstSet = st.executeQuery("SELECT * FROM users WHERE name = 'test'")) { rstSet.next(); assertThat(rstSet.getString("name"), is("test")); assertThat(rstSet.getString("login"), is("test")); assertThat(rstSet.getString("email"), is("test")); assertThat(rstSet.getInt("id") > 0, is(true)); assertThat(rstSet.next(), is(false)); } }