try(Connection conn = ConnectionFactory.getInstance().getConnection()){
            conn.setAutoCommit(false);
            String account_insert = "insert into accounts (TYPE, BALANCE) values (?,?)";
            String junctiontable_insert = "insert into useraccountsjunction (USER_ID, ACCOUNT_ID) values (?,?)";
            PreparedStatement ps1 = conn.prepareStatement(account_insert);
            PreparedStatement ps2 = conn.prepareStatement(junctiontable_insert);
            ps1.setInt(1, account.getAccountType());
            ps1.setDouble(2, account.getBalance());
            int rows = ps1.executeUpdate();
            if(rows != 0) {
                ResultSet pk = ps1.getGeneratedKeys();
                while(pk.next()) {
                    user.setId(pk.getInt(1));
                    System.out.println(pk.getInt(1));
                }
            }
            ps2.setInt(1, user.getId());
            ps2.setInt(2, account.getAccountId());
            ps2.executeUpdate();
            conn.commit();
        }