craigew

<class>com.craigew.entity.Address</class>

craigew

@OneToOne(cascade = CascadeType.ALL, optional=false)
    @JoinColumn(name="RESIDENTIAL_ADDRESS_ID")
    private Address residentialAddress;
    @OneToOne(cascade = CascadeType.ALL, optional=true)
    @JoinColumn(name="POSTAL_ADDRESS_ID")
    private Address postalAddress;

craigew

protected List<T> queryString(String sql){
        EntityManagerFactory factory = Persistence.createEntityManagerFactory("JPAIntroduction");
        EntityManager em = factory.createEntityManager();
        List<T> results= em.createQuery(sql).getResultList();
        em.close();
        factory.close();
        return results;
    }

craigew

    public List<Customer> returnAllCustomers() {
        return queryString("SELECT e FROM Customer e");
    }

    public List<Customer> returnCustomersForACountry(String country) {
        return queryString("SELECT e FROM Customer e WHERE e.residentialAddress.country='" + country + "'");
    }

craigew

package com.craigew.service;


import com.craigew.entity.Address;
import com.craigew.entity.Customer;
import junit.framework.Assert;
import org.junit.Test;

import javax.persistence.EntityNotFoundException;
import java.util.List;