Simple registration service using a JDBI Transaction.

RegistrationExampleService.java

import com.example.exceptions.RegistrationException;
import com.example.User;
import com.example.UserRole;
import com.example.AccountDAO;
import com.example.UserDAO;
import com.example.UserRoleDAO;
import org.skife.jdbi.v2.sqlobject.CreateSqlObject;
import org.skife.jdbi.v2.sqlobject.Transaction;

/**
 * Simple registration service using a JDBI Transaction.
 */
public abstract class RegistrationExampleService {

    @CreateSqlObject
    abstract AccountDAO accountDAO();

    @CreateSqlObject
    abstract UserDAO userDAO();

    @CreateSqlObject
    abstract UserRoleDAO userRoleDAO();

    @Transaction
    public User createUser(String website, String email, String password) throws RegistrationException {

        User user = userDAO().getByEmail(email);

        if (user != null) {
            throw new RegistrationException("Email already exists");
        }

        Account account = new Account(website);
        user = new User(email, password, account.getId());

        account.setOwnerId(user.getId());
        accountDAO().insert(account);
        userDAO().insert(user);
        userRoleDAO().insert(user.getId(), UserRole.ACCOUNT_ADMIN);

        return user;
    }

}