Java EntityUtils类代码示例

import org.springframework.samples.petclinic.util.EntityUtils; //导入依赖的package包/类
@Override
public Pet findById(int id) throws DataAccessException {
    JdbcPet pet;
    try {
        Map<String, Object> params = new HashMap<>();
        params.put("id", id);
        pet = this.namedParameterJdbcTemplate.queryForObject(
            "SELECT id, name, birth_date, type_id, owner_id FROM pets WHERE id=:id",
            params,
            new JdbcPetRowMapper());
    } catch (EmptyResultDataAccessException ex) {
        throw new ObjectRetrievalFailureException(Pet.class, id);
    }
    Owner owner = this.ownerRepository.findById(pet.getOwnerId());
    owner.addPet(pet);
    pet.setType(EntityUtils.getById(findPetTypes(), PetType.class, pet.getTypeId()));

    List<Visit> visits = this.visitRepository.findByPetId(pet.getId());
    for (Visit visit : visits) {
        pet.addVisit(visit);
    }
    return pet;
}
 

import org.springframework.samples.petclinic.util.EntityUtils; //导入依赖的package包/类
@Test
@Transactional
public void shouldInsertPetIntoDatabaseAndGenerateId() {
    Owner owner6 = this.clinicService.findOwnerById(6);
    int found = owner6.getPets().size();

    Pet pet = new Pet();
    pet.setName("bowser");
    Collection<PetType> types = this.clinicService.findPetTypes();
    pet.setType(EntityUtils.getById(types, PetType.class, 2));
    pet.setBirthDate(new LocalDate());
    owner6.addPet(pet);
    assertThat(owner6.getPets().size()).isEqualTo(found + 1);

    this.clinicService.savePet(pet);
    this.clinicService.saveOwner(owner6);

    owner6 = this.clinicService.findOwnerById(6);
    assertThat(owner6.getPets().size()).isEqualTo(found + 1);
    // checks that id has been generated
    assertThat(pet.getId()).isNotNull();
}
 

import org.springframework.samples.petclinic.util.EntityUtils; //导入依赖的package包/类
@Test
@Transactional
public void shouldInsertPetIntoDatabaseAndGenerateId() {
    Owner owner6 = this.clinicService.findOwnerById(6);
    int found = owner6.getPets().size();

    Pet pet = new Pet();
    pet.setName("bowser");
    Collection<PetType> types = this.clinicService.findPetTypes();
    pet.setType(EntityUtils.getById(types, PetType.class, 2));
    pet.setBirthDate(new Date());
    owner6.addPet(pet);
    assertThat(owner6.getPets().size()).isEqualTo(found + 1);

    this.clinicService.savePet(pet);
    this.clinicService.saveOwner(owner6);

    owner6 = this.clinicService.findOwnerById(6);
    assertThat(owner6.getPets().size()).isEqualTo(found + 1);
    // checks that id has been generated
    assertThat(pet.getId()).isNotNull();
}
 

import org.springframework.samples.petclinic.util.EntityUtils; //导入依赖的package包/类
@Transactional(readOnly = true)
public Pet loadPet(int id) throws DataAccessException {
	JdbcPet pet;
	try {
		pet = this.simpleJdbcTemplate.queryForObject(
				"SELECT id, name, birth_date, type_id, owner_id FROM pets WHERE id=?",
				new JdbcPetRowMapper(),
				id);
	}
	catch (EmptyResultDataAccessException ex) {
		throw new ObjectRetrievalFailureException(Pet.class, new Integer(id));
	}
	Owner owner = loadOwner(pet.getOwnerId());
	owner.addPet(pet);
	pet.setType(EntityUtils.getById(getPetTypes(), PetType.class, pet.getTypeId()));
	loadVisits(pet);
	return pet;
}
 

import org.springframework.samples.petclinic.util.EntityUtils; //导入依赖的package包/类
public void testGetVets() {
	Collection<Vet> vets = this.clinic.getVets();
	// Use the inherited countRowsInTable() convenience method (from
	// AbstractTransactionalDataSourceSpringContextTests) to verify the
	// results.
	assertEquals("JDBC query must show the same number of vets", super.countRowsInTable("VETS"), vets.size());
	Vet v1 = EntityUtils.getById(vets, Vet.class, 2);
	assertEquals("Leary", v1.getLastName());
	assertEquals(1, v1.getNrOfSpecialties());
	assertEquals("radiology", (v1.getSpecialties().get(0)).getName());
	Vet v2 = EntityUtils.getById(vets, Vet.class, 3);
	assertEquals("Douglas", v2.getLastName());
	assertEquals(2, v2.getNrOfSpecialties());
	assertEquals("dentistry", (v2.getSpecialties().get(0)).getName());
	assertEquals("surgery", (v2.getSpecialties().get(1)).getName());
}
 

import org.springframework.samples.petclinic.util.EntityUtils; //导入依赖的package包/类
@Test
public void getVets() {
	Collection<Vet> vets = this.clinic.getVets();
	// Use the inherited countRowsInTable() convenience method (from
	// AbstractTransactionalJUnit4SpringContextTests) to verify the results.
	assertEquals("JDBC query must show the same number of vets", super.countRowsInTable("VETS"), vets.size());
	Vet v1 = EntityUtils.getById(vets, Vet.class, 2);
	assertEquals("Leary", v1.getLastName());
	assertEquals(1, v1.getNrOfSpecialties());
	assertEquals("radiology", (v1.getSpecialties().get(0)).getName());
	Vet v2 = EntityUtils.getById(vets, Vet.class, 3);
	assertEquals("Douglas", v2.getLastName());
	assertEquals(2, v2.getNrOfSpecialties());
	assertEquals("dentistry", (v2.getSpecialties().get(0)).getName());
	assertEquals("surgery", (v2.getSpecialties().get(1)).getName());
}
 

import org.springframework.samples.petclinic.util.EntityUtils; //导入依赖的package包/类
@Test
public void insertPet() {
	Owner o6 = this.clinic.loadOwner(6);
	int found = o6.getPets().size();
	Pet pet = new Pet();
	pet.setName("bowser");
	Collection<PetType> types = this.clinic.getPetTypes();
	pet.setType(EntityUtils.getById(types, PetType.class, 2));
	pet.setBirthDate(new Date());
	o6.addPet(pet);
	assertEquals(found + 1, o6.getPets().size());
	// both storePet and storeOwner are necessary to cover all ORM tools
	this.clinic.storePet(pet);
	this.clinic.storeOwner(o6);
	// assertTrue(!pet.isNew()); -- NOT TRUE FOR TOPLINK (before commit)
	o6 = this.clinic.loadOwner(6);
	assertEquals(found + 1, o6.getPets().size());
}
 

import org.springframework.samples.petclinic.util.EntityUtils; //导入依赖的package包/类
public void loadPetsAndVisits(final Owner owner) {
    Map<String, Object> params = new HashMap<String, Object>();
    params.put("id", owner.getId().intValue());
    final List<JdbcPet> pets = this.namedParameterJdbcTemplate.query(
            "SELECT id, name, birth_date, type_id, owner_id FROM pets WHERE owner_id=:id",
            params,
            new JdbcPetRowMapper()
    );
    for (JdbcPet pet : pets) {
        owner.addPet(pet);
        pet.setType(EntityUtils.getById(getPetTypes(), PetType.class, pet.getTypeId()));
        List<Visit> visits = this.visitRepository.findByPetId(pet.getId());
        for (Visit visit : visits) {
            pet.addVisit(visit);
        }
    }
}
 

import org.springframework.samples.petclinic.util.EntityUtils; //导入依赖的package包/类
@Override
public Pet findById(int id) throws DataAccessException {
    JdbcPet pet;
    try {
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("id", id);
        pet = this.namedParameterJdbcTemplate.queryForObject(
                "SELECT id, name, birth_date, type_id, owner_id FROM pets WHERE id=:id",
                params,
                new JdbcPetRowMapper());
    } catch (EmptyResultDataAccessException ex) {
        throw new ObjectRetrievalFailureException(Pet.class, new Integer(id));
    }
    Owner owner = this.ownerRepository.findById(pet.getOwnerId());
    owner.addPet(pet);
    pet.setType(EntityUtils.getById(findPetTypes(), PetType.class, pet.getTypeId()));

    List<Visit> visits = this.visitRepository.findByPetId(pet.getId());
    for (Visit visit : visits) {
        pet.addVisit(visit);
    }
    return pet;
}
 

import org.springframework.samples.petclinic.util.EntityUtils; //导入依赖的package包/类
@Test
@Transactional
public void shouldInsertPetIntoDatabaseAndGenerateId() {
    Owner owner6 = this.clinicService.findOwnerById(6);
    int found = owner6.getPets().size();
    
    Pet pet = new Pet();
    pet.setName("bowser");
    Collection<PetType> types = this.clinicService.findPetTypes();
    pet.setType(EntityUtils.getById(types, PetType.class, 2));
    pet.setBirthDate(new DateTime());
    owner6.addPet(pet);
    assertThat(owner6.getPets().size()).isEqualTo(found + 1);
    
    this.clinicService.savePet(pet);
    this.clinicService.saveOwner(owner6);
    
    owner6 = this.clinicService.findOwnerById(6);
    assertThat(owner6.getPets().size()).isEqualTo(found + 1);
    // checks that id has been generated
    assertThat(pet.getId()).isNotNull();
}
 

import org.springframework.samples.petclinic.util.EntityUtils; //导入依赖的package包/类
@Override
public Pet findById(int id) throws DataAccessException {
    JdbcPet pet;
    try {
        Map<String, Object> params = new HashMap<>();
        params.put("id", id);
        pet = this.namedParameterJdbcTemplate.queryForObject(
                "SELECT id, name, birth_date, type_id, owner_id FROM pets WHERE id=:id",
                params,
                new JdbcPetRowMapper());
    } catch (EmptyResultDataAccessException ex) {
        throw new ObjectRetrievalFailureException(Pet.class, id);
    }
    Owner owner = this.ownerRepository.findById(pet.getOwnerId());
    owner.addPet(pet);
    pet.setType(EntityUtils.getById(findPetTypes(), PetType.class, pet.getTypeId()));

    List<Visit> visits = this.visitRepository.findByPetId(pet.getId());
    for (Visit visit : visits) {
        pet.addVisit(visit);
    }
    return pet;
}
 

import org.springframework.samples.petclinic.util.EntityUtils; //导入依赖的package包/类
@Test
@Transactional
public void insertPet() {
    Owner owner6 = this.clinicService.findOwnerById(6);
    int found = owner6.getPets().size();
    Pet pet = new Pet();
    pet.setName("bowser");
    Collection<PetType> types = this.clinicService.findPetTypes();
    pet.setType(EntityUtils.getById(types, PetType.class, 2));
    pet.setBirthDate(new DateTime());
    owner6.addPet(pet);
    assertEquals(found + 1, owner6.getPets().size());
    // both storePet and storeOwner are necessary to cover all ORM tools
    this.clinicService.savePet(pet);
    this.clinicService.saveOwner(owner6);
    owner6 = this.clinicService.findOwnerById(6);
    assertEquals(found + 1, owner6.getPets().size());
    assertNotNull("Pet Id should have been generated", pet.getId());
}
 

import org.springframework.samples.petclinic.util.EntityUtils; //导入依赖的package包/类
/**
 * Refresh the cache of Vets that the ClinicService is holding.
 */
@Override
public Collection<Vet> findAll() throws DataAccessException {
    List<Vet> vets = new ArrayList<>();
    // Retrieve the list of all vets.
    vets.addAll(this.jdbcTemplate.query(
        "SELECT id, first_name, last_name FROM vets ORDER BY last_name,first_name",
        BeanPropertyRowMapper.newInstance(Vet.class)));

    // Retrieve the list of all possible specialties.
    final List<Specialty> specialties = this.jdbcTemplate.query(
        "SELECT id, name FROM specialties",
        BeanPropertyRowMapper.newInstance(Specialty.class));

    // Build each vet's list of specialties.
    for (Vet vet : vets) {
        final List<Integer> vetSpecialtiesIds = this.jdbcTemplate.query(
            "SELECT specialty_id FROM vet_specialties WHERE vet_id=?",
            new BeanPropertyRowMapper<Integer>() {
                @Override
                public Integer mapRow(ResultSet rs, int row) throws SQLException {
                    return rs.getInt(1);
                }
            },
            vet.getId());
        for (int specialtyId : vetSpecialtiesIds) {
            Specialty specialty = EntityUtils.getById(specialties, Specialty.class, specialtyId);
            vet.addSpecialty(specialty);
        }
    }
    return vets;
}
 

import org.springframework.samples.petclinic.util.EntityUtils; //导入依赖的package包/类
public void loadPetsAndVisits(final Owner owner) {
    Map<String, Object> params = new HashMap<>();
    params.put("id", owner.getId());
    final List<JdbcPet> pets = this.namedParameterJdbcTemplate.query(
        "SELECT pets.id, name, birth_date, type_id, owner_id, visits.id as visit_id, visit_date, description, pet_id FROM pets LEFT OUTER JOIN visits ON  pets.id = pet_id WHERE owner_id=:id",
        params,
        new JdbcPetVisitExtractor()
    );
    Collection<PetType> petTypes = getPetTypes();
    for (JdbcPet pet : pets) {
        pet.setType(EntityUtils.getById(petTypes, PetType.class, pet.getTypeId()));
        owner.addPet(pet);
    }
}
 

import org.springframework.samples.petclinic.util.EntityUtils; //导入依赖的package包/类
@Test
public void shouldFindAllPetTypes() {
    Collection<PetType> petTypes = this.clinicService.findPetTypes();

    PetType petType1 = EntityUtils.getById(petTypes, PetType.class, 1);
    assertThat(petType1.getName()).isEqualTo("cat");
    PetType petType4 = EntityUtils.getById(petTypes, PetType.class, 4);
    assertThat(petType4.getName()).isEqualTo("snake");
}