DbDemo.java

Go to the documentation of this file.

package cedar.hepdata.webapp;

import cedar.hepdata.model.*;
import cedar.hepdata.xml.*;
import cedar.hepdata.db.*;
import org.hibernate.Query;

import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class DbDemo extends HttpServlet {

    public String getServletInfo() {
        return "Demonstrate object model and persistency.";
    }


    public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();

        try {
            out.println("<h1>Model-db demo</h1>");
            DbUtils.beginTransaction();
            String qstr = "select distinct p from Paper as p";
            qstr += " left join fetch p._datasets as d";
            //qstr += " join fetch d._xAxes as xax";
            //qstr += " join fetch xax._bins as bin";
            //qstr += " join fetch d._yAxes as yax";
            //qstr += " join fetch yax._points as pt";
            //qstr += " join fetch pt._errors as pterr";
            Query q = DbUtils.createQuery(qstr);
            List results = q.list();
            if (results != null) {
                for (Object result : results) {
                    Paper p = (Paper) result;
                    out.println("<div style=\"background:#c6deff; border:#82cafa 1px solid; margin:2em 1em; padding:1em; width:80%;\">");
                    out.println("<h2>" + p.getSpiresId().toString() + "</h2>");
                    out.println("<pre style=\"background:#ffc; border:#fc3 1px solid; padding:1em; overflow:hidden; \">" + p.toString() + "</pre>");
                    out.println("<pre style=\"background:#ffc; border:#fc3 1px solid; padding:1em;\">" + XMLUtils.makeHepMLString(p) + "</pre>");
                    out.println("</div>");
                }
            }
            DbUtils.endTransaction();

        } catch (Exception e) {
            out.println("Exception: " + e.toString());
        }

    }
}

---