@Entity
@Table(name = "ORDER_TMP")
public class OrderFormTep implements java.io.Serializable {
private int orderTmplateId;
private OrderTeplate orderTeplate;
private String productName;
private String productSize;
private Integer productPrice;
private String status;
private Integer createdUser;
private Integer createdDate;
private Integer createdTime;
private Set<SaleProduct> saleProducts = new HashSet<SaleProduct>(0);
public OrderFormTep() {
}
@Id
@Column(name = "ORDER_TMP_PRODUCT_ID", unique = true, nullable = false)
@GeneratedValue(strategy=GenerationType.IDENTITY)
public int orderTmplateId() {
return this.orderTmplateId;
}
public void setOrderTmplateId(int orderTmplateId) {
this.orderTmplateId= orderTmplateId;
}
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "ORDER_TEPLATE_ID", nullable = false)
public OrderTeplate getOrderTeplate() {
return orderTeplate;
}
public void setOrderTeplate(OrderTeplate orderTeplate) {
this.orderTeplate = orderTeplate;
}
@OneToMany(fetch = FetchType.LAZY, mappedBy = "orderFormTep")
public Set<SaleProduct> getsaleProducts() {
return saleProducts;
}
public void setSaleProducts(
Set<SaleProduct> saleProducts) {
this.saleProducts = saleProducts;
}
// more set get ........
}
以上再使用Hql語法
String hql = " Select orderTmplateId,productName, "
+ " from OrderFormTep m where and m.createdDate >= ? and m.createdDate <= ? ";
或
String hql = " from OrderFormTep m "
+ " where m.createdDate >= ? and m.createdDate <= ?";
Object[] parameters = new Object[] {startDate,endData};
@SuppressWarnings("unchecked")
List<OrderFormTep> retList = this.getHibernateTemplate().find(hql,
parameters);
return retList;
我們在下hql的語法上，已經是對物件了，而不是資料庫所定義了欄位
這樣假設我們的搜尋全部資料只需要from OrderFormTep m 就可以了
而連帶關聯的OrderTeplate 及 SaleProduct 都會顯示所接收的 "List<OrderFormTep> retList" 內
全站熱搜
留言列表
{{ article.title }}