Conditional query with hibernate Composite(key) Object?

Up vote 0 down vote favorite share g+ share fb share tw.

CREATE TABLE ratecodes ( roomId int(11) NOT NULL DEFAULT '0', date date NOT NULL DEFAULT '0000-00-00', ..., PRIMARY KEY (roomId,date)) hbm. Xml I want to query HibernateUtil. GetCurrentSession().

CreateQuery("from RateCode where (RatecodeId (between| :fromDate and date RoomId = roomId; this. Date = date; } public int getRoomId() { return this. RoomId; } public void setRoomId(int roomId) { this.

RoomId = roomId; } public Date getDate() { return this. Date; } public void setDate(Date date) { this. Date = date; } public boolean equals(Object other) { if ((this == other)) { return true; } if ((other == null)) { return false; } if (!(other instanceof RateCodeId)) { return false; } RateCodeId castOther = (RateCodeId) other; return (this.getRoomId() == castOther.getRoomId()) && ((this.getDate() == castOther.getDate()) || (this.getDate()!

= null && castOther.getDate()! = null && this.getDate(). Equals(castOther.getDate()))); } public int hashCode() { int result = 17; result = 37 * result + this.getRoomId(); result = 37 * result + (getDate() == null?

0 : this.getDate().hashCode()); return result; } } how to set FromDate and Todate in Object and do condition of RateCodeID hibernate link|improve this question asked Feb 21 '11 at 8:13Ravi Parekh518214 86% accept rate.

String hql = "from RateCode rc where rc.id" rel="nofollow">rc.id" rel="nofollow">rc.id" rel="nofollow">rc.id. RoomId = 3000" + " and rc.id" rel="nofollow">rc.id" rel="nofollow">rc.id" rel="nofollow">rc.id. Date > :fromDate" + " and rc.id" rel="nofollow">rc.id" rel="nofollow">rc.id" rel="nofollow">rc.id.

Date SetParameter("toDate", theToDate).

Thanx buddy. And tell me how to vote you . – Ravi Parekh Feb 21 '11 at 8:33.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.