CREATE VIEW `view_rating` AS select `rating`.`id` AS `id`,`rating`.`last_update` AS `last_update`,`casinos`.`name` AS `casino`,`parameters`.`name` AS `parameter`,`rating`.`value` AS `value`,`parameters`.`percent` AS `percent`,((`rating`.`value` / 100) * `parameters`.`percent`) AS `rating_value` from ((`casinos` join `parameters`) join `rating`) where ((`rating`.`casino_id` = `casinos`.`id`) and (`rating`.`parameter_id` = `parameters`.`id`));
Class Transactions:
import org.hibernate.Query;
import org.hibernate.Session;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.AnnotationConfiguration;
public class Transactions {
public static String QUERY_ALL_CASINOS="from view_rating ";
...
Session session;
private static SessionFactory ourSessionFactory;
static {
try {
ourSessionFactory = new AnnotationConfiguration().
configure("hibernate.cfg.xml").
buildSessionFactory();
}
catch (Throwable ex) {
throw new ExceptionInInitializerError(ex);
}
}
public static Session getSession() throws HibernateException {
return ourSessionFactory.openSession();
}
public List executeHQLQuery(String hql) {
session = getSession();
List resultList=null;
try {
session.beginTransaction();
Query q = session.createQuery(hql);
resultList = q.list();
session.getTransaction().commit();
} catch (HibernateException he) {
he.printStackTrace();
}
return resultList;
}
}
JSP Page:
...
<%
Transactions tr = new Transactions();
List resultList = tr.executeHQLQuery(tr.QUERY_ALL_CASINOS);
for(Object o : resultList) {
out.print("<tr>");
ViewRating casino = (ViewRating)o;
out.print("<td>"+casino.getValue()+"</td>");
out.print("</tr>");
}
http://www.discountsvu.com
Login
FAQ
Search