hql 小技巧

String hql = "select new com.nba.dto.bean.CompetitionBean(c.modififdGrade,c.winSide.leagueTeamId,c.id,c.ATeam.leagueTeamId,c.ATeam.name,c.moneyGrade,c.status) from GameLeagueTeamChallenge c where " +
  " c.BTeam.leagueTeamId = ?  and c.status in (0,1,2,5) and (c.week = ? or c.week = ?)order by c.createTime desc";

 

public CompetitionBean( Long cid,Long teamId,String teamName,Long targetTeamId,String targetTeamName,Long money,String scoreA,String scoreB,Long status)
     { 
      this.cid = cid;
      this.money = money;
      this.scoreA = scoreA;
      this.scoreB = scoreB;
      this.status = status;
      this.teamId = teamId;
      this.teamName = teamName;
      this.targetTeamId = targetTeamId;
      this.targetTeamName = targetTeamName;

     }

 

select v.*,
         decode(vot.vote_note_id, null, 'F', 'T') as flag 　from ecc_note.vote_note v,
         (select vo.vote_note_id
            from ecc_note.vote_note vo
           where vo.begin_date < sysdate
             and vo.end_date > sysdate) vot
   where v.vote_note_id = vot.vote_note_id(+) where v.vote_note_id='';