public List getRateByCdate(String cdate,String lotteryType){
  Vector my_vec=new Vector();
      SQLQuery query=null;
   Session session9null;
   Transaction tx=null;
   session =HibernateUtil.currentSession(); 
   tx=session.beginTransaction();  
   StringBuffer queryStr = new StringBuffer();  ?
   queryStr.append(" select  ");  
   queryStr.append(" avg(rightnum)  mo ");  
   queryStr.append(" from combuyinfo  com ")  
                 .append(" where  ")             
                 .append(" com.cdate like '"+cdate+"%'") 
                 .append(" and  com.psd like '%"+lotteryType+"%' ") 
                 .append(" group by com.uid  order by mo desc");  
   query = session.createSQLQuery(queryStr.toString()); 
   
      query.addScalar("mo", new org.hibernate.type.StringType());  
           // query.addScalar("uid", new org.hibernate.type.IntegerType());  
                  
   
  tx.commit();
  session.close(); 
  return query.list();
  
 }