@Override
    public void newAccount(Account account, User user) {
        try(Connection conn = ConnectionFactory.getInstance().getConnection()){
            conn.setAutoCommit(false);
            String account_insert = "insert into accounts (TYPE, BALANCE) values (?,?)";
            String returnedCol[] = { "ACCOUNT_ID" };
            PreparedStatement ps1 = conn.prepareStatement(account_insert, returnedCol);
            ps1.setInt(1, account.getAccountType());
            ps1.setDouble(2, account.getBalance());
            int affectedrows = ps1.executeUpdate();
            if(affectedrows!=0) {
                ResultSet pk = ps1.getGeneratedKeys();
                if (pk.next()) {
                    account.setAccountId((pk.getInt(1)));
                } else {
                    throw new SQLException("Creating account failed, no ID obtained.");
                }
            }
            conn.commit();
            conn.close();
            insertToJunction(account,user);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }