package com.blogspot.na5cent.api.repository;
import java.util.List;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import com.blogspot.na5cent.basicmodel.readonly.Hospital;
import com.blogspot.na5cent.basicmodel.readonly.Province;
/**
*
* @author redcrow
*/
public interface HospitalRepository extends JpaRepository<Hospital, String>{
@Query("SELECT hp FROM InHospital inHp INNER JOIN inHp.hospital hp WHERE hp.province = ?1")
public List<Hospital> findByProvince(Province province);
}
Hospital.java
...
...
...
@Entity
@Table(name = "hospital")
@ReadOnly
public class Hospital implements Serializable {
@Id
@Column(nullable = false, length = 5)
private String hcode;
@Column(nullable = false, length = 250)
private String hname;
@ManyToOne
@JoinColumn(name = "province_id", nullable = false)
private Province province;
...
...
...
}
InHospital.java
...
...
...
@Entity
@Table(name = "in_hospital")
public class InHospital implements Serializable {
@Id
@Column(name = "hcode", length = 9)
private String hcode;
@Version
private Integer version;
@OneToOne
@JoinColumn(name = "hcode", insertable = false, updatable = false)
private Hospital hospital;
....
....
....
}
package com.blogspot.na5cent.web.repository;
import java.util.List;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import com.blogspot.na5cent.api.model.RecordItem;
/**
*
* @author redcrow
*/
public interface RecordItemRepository extends JpaRepository<RecordItem, Integer> {
@Query(value = "SELECT item FROM RecordItem item WHERE item.recoredId IN ?1") //*****
public List<RecordItem> findInRecordIds(List<Integer> recordIds);
}
...
import javax.persistence.Basic;
...
...
...
@Entity
@Table(name = "Staff")
public class Staff implements Serializable{
....
....
....
@Lob
@Basic(fetch = FetchType.LAZY) //****
private byte[] image;
}
package com.blogspot.na5cent.model;
import java.io.Serializable;
import javax.persistence.Column;
import javax.persistence.Embeddable;
/**
*
* @author Redcrow
*/
@Embeddable //บอกว่าเป็น embeded
public class DocumentSequencePK implements Serializable {
@Column(name = "SEQUENCE_NUMBER_MAJOR", nullable = false)
private Long sequenceNumberMajor;
@Column(name = "SEQUENCE_NUMBER_MINOR", nullable = false)
private Integer sequenceNumberMinor;
@Column(name = "FISCAL_YEAR", nullable = false)
private Integer fiscalYear;
public DocumentSequencePK() {
}
public DocumentSequencePK(Long sequenceNumberMajor, Integer sequenceNumberMinor, Integer fiscalYear) {
this.sequenceNumberMajor = sequenceNumberMajor;
this.sequenceNumberMinor = sequenceNumberMinor;
this.fiscalYear = fiscalYear;
}
public Long getSequenceNumberMajor() {
return sequenceNumberMajor;
}
public Integer getSequenceNumberMinor() {
return sequenceNumberMinor;
}
public Integer getFiscalYear() {
return fiscalYear;
}
@Override
public int hashCode() {
int hash = 5;
hash = 41 * hash + (this.sequenceNumberMajor != null ? this.sequenceNumberMajor.hashCode() : 0);
hash = 41 * hash + (this.sequenceNumberMinor != null ? this.sequenceNumberMinor.hashCode() : 0);
hash = 41 * hash + (this.fiscalYear != null ? this.fiscalYear.hashCode() : 0);
return hash;
}
@Override
public boolean equals(Object obj) {
if (obj == null) {
return false;
}
if (getClass() != obj.getClass()) {
return false;
}
final DocumentSequencePK other = (DocumentSequencePK) obj;
if (this.sequenceNumberMajor != other.sequenceNumberMajor && (this.sequenceNumberMajor == null || !this.sequenceNumberMajor.equals(other.sequenceNumberMajor))) {
return false;
}
if (this.sequenceNumberMinor != other.sequenceNumberMinor && (this.sequenceNumberMinor == null || !this.sequenceNumberMinor.equals(other.sequenceNumberMinor))) {
return false;
}
if (this.fiscalYear != other.fiscalYear && (this.fiscalYear == null || !this.fiscalYear.equals(other.fiscalYear))) {
return false;
}
return true;
}
}
... SELECT FISCALYEAR, SEQUENCENUMBER FROM DOCUMENT_SEQUENCE ORDER BY FISCALYEAR DESC, SEQUENCENUMBER DESC ...repository
...
...
public interface DocumentSequenceRepo extends JpaRepository<DocumentSequence, DocumentSequencePK> {
@Query("SELECT ds.id FROM DocumentSequence ds")
public Page<DocumentSequencePK> findLatestSequence(Pageable page);
}
service
...
...
@Override
public DocumentSequencePK findLatestSequence() {
String[] sortBy = {"id.fiscalYear", "id.sequenceNumber"}; //**************
PageRequest pageRequest = new PageRequest(0, 1, Sort.Direction.DESC, sortBy);
Page<DocumentSequencePK> pk = documentSequenceRepository.findLatestSequence(pageRequest);
if (pk.getTotalElements() == 0) {
return new DocumentSequencePK(1L, DateUtils.getFiscalYear(new Date()));
} else {
return pk.getContent().get(0);
}
}
...
...
...
...
...
@Table(name = "USER_FORUM")
@Entity
public class UserForum implements Serializable {
@Id
@TableGenerator(name = "UserForum_GEN", table = "WEBBOARD_SEQ", pkColumnName = "NAME", valueColumnName = "VALUE", pkColumnValue = "USER_FORUM")
@GeneratedValue(generator = "UserForum_GEN", strategy = GenerationType.TABLE)
@Column(name = "USER_FORUM_ID")
private Integer id;
@Version
private Integer version;
//information
private String userName;
private String password;
private String fullName;
private String email;
private String image;
@Temporal(javax.persistence.TemporalType.TIMESTAMP)
private Date joinDate;
//join
@ManyToMany
@JoinTable(name = "ANSWER",
joinColumns = {
@JoinColumn(name = "USER_FORUM", referencedColumnName = "USER_FORUM_ID")},
inverseJoinColumns = {
@JoinColumn(name = "CATEGORY", referencedColumnName = "CATEGORY_ID")})
private List<Category> categories;
@OneToMany(mappedBy = "owner")
private List<Post> posts;
@OneToMany(mappedBy = "owner")
private List<Comment> comments;
...
...
...
}
..
..
..
@Table(name="COMMENT")
@Entity
public class Comment implements Serializable{
@Id
@TableGenerator(name = "Comment_GEN", table = "WEBBOARD_SEQ", pkColumnName = "NAME", valueColumnName = "VALUE", pkColumnValue = "COMMENT")
@GeneratedValue(generator = "Comment_GEN", strategy = GenerationType.TABLE)
@Column(name = "COMMENT_ID")
private Integer id;
@Version
private Integer version;
//information
...
...
...
}
SELECT s
FROM Staff s
WHERE s.staffId NOT IN(
SELECT u.staffId
FROM User u
WHERE u.disabled = false
)
Specification
package com.blogspot.na5cent.services;
import java.util.List;
import com.blogspot.na5cent.model.Project;
import com.blogspot.na5cent.model.User;
public interface UserService{
public List<User> findUserByProject(Project project);
...
...
}
Service Implementation
package com.blogspot.na5cent.services.impl;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.transaction.annotation.Propagation;
import com.blogspot.na5cent.repositories.UserRepositories;
import com.blogspot.na5cent.services.UserService;
import com.blogspot.na5cent.model.Project;
import com.blogspot.na5cent.model.User;
...
...
@Service
@Transactional(propagation = Propagation.REQUIRED)
public Class UserServiceImpl implements UserService{
@Autowired
private UserRepositories userRepo;
private List<User> findUserByProject(Project project){
return userRepo.findByProject(project);
}
...
...
}
Repositories
package com.blogspot.na5cent.repositories;
import java.util.List;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import com.blogspot.na5cent.model.Project;
import com.blogspot.na5cent.model.User;
...
...
public interface UserRepositories extends JpaRepository<User, Integer>, JpaSpecificationExecutor {
@Query("SELECT u FROM Project p JOIN p.users u WHERE p = ?1")
public List<User> findByProject(Project project);
...
...
}
... ... <jpa:repositories base-package="com.na5cent.blogspot.base.repositories"/> <jpa:repositories base-package="com.na5cent.blogspot.senddata.repositories" /> ... ...การใช้ tag เดียว แล้วเขียนต่อกันดังต่อไปนี้ไม่ถูกต้องน่ะครับ โปรแกรมจะ run ไม่ผ่าน และจะไม่สามารถสร้าง repositories ได้
... ... <jpa:repositories base-package="com.na5cent.blogspot.base.repositories, com.na5cent.blogspot.senddata.repositories"/> ... ...