Example usage for org.hibernate Query list

List of usage examples for org.hibernate Query list

Introduction

In this page you can find the example usage for org.hibernate Query list.

Prototype

List<R> list();

Source Link

Document

Return the query results as a List.

Usage

From source file:JefeDeObra.java

public static List queryJefeDeObra(PersistentSession session, String condition, String orderBy,
         org.hibernate.LockMode lockMode) throws PersistentException {
     StringBuffer sb = new StringBuffer("From JefeDeObra as JefeDeObra");
     if (condition != null)
         sb.append(" Where ").append(condition);
     if (orderBy != null)
         sb.append(" Order By ").append(orderBy);
     try {/*w w w.j a  v a  2  s .c  o m*/
         Query query = session.createQuery(sb.toString());
         query.setLockMode("JefeDeObra", lockMode);
         return query.list();
     } catch (Exception e) {
         e.printStackTrace();
         throw new PersistentException(e);
     }
 }

From source file:PersonaDAO.java

public static List queryPersona(PersistentSession session, String condition, String orderBy)
        throws PersistentException {
    StringBuffer sb = new StringBuffer("From Persona as Persona");
    if (condition != null)
        sb.append(" Where ").append(condition);
    if (orderBy != null)
        sb.append(" Order By ").append(orderBy);
    try {//from ww w .  ja v  a 2  s .  co m
        Query query = session.createQuery(sb.toString());
        return query.list();
    } catch (Exception e) {
        e.printStackTrace();
        throw new PersistentException(e);
    }
}

From source file:PersonaDAO.java

public static List queryPersona(PersistentSession session, String condition, String orderBy,
        org.hibernate.LockMode lockMode) throws PersistentException {
    StringBuffer sb = new StringBuffer("From Persona as Persona");
    if (condition != null)
        sb.append(" Where ").append(condition);
    if (orderBy != null)
        sb.append(" Order By ").append(orderBy);
    try {//w w w  .  j  ava2s  .co m
        Query query = session.createQuery(sb.toString());
        query.setLockMode("Persona", lockMode);
        return query.list();
    } catch (Exception e) {
        e.printStackTrace();
        throw new PersistentException(e);
    }
}

From source file:StartProgram.java

public void SearchByLocId(int locId) {
    Session sess = null;/*from   www. ja v  a  2 s.c  o  m*/
    City city = new City();
    try {
        sess = NewHibernateUtil.currentSession();
        Transaction tx = sess.beginTransaction();
        //sql statement to select all the rows
        String hql = "select * FROM Country";
        Query query = sess.createSQLQuery(hql).addEntity(City.class);

        List results = query.list();
        if (results.size() > 0) {
            CatalogueAdder adder = new CatalogueAdder();
            //start reading from csv and adding data into MYSQL
            adder.startProgram();
            CitySearch instance = new CitySearch();
            instance.findCityByLocId(locId);
        } else {
            CitySearch instance = new CitySearch();
            instance.findCityByLocId(locId);
        }
        tx.commit();

    } catch (Exception e) {
        e.printStackTrace();
    }

}

From source file:StartProgram.java

public void SearchNearestCities(double lat, double lng) {

    Session sess = null;/*from w w w .  j a  v a  2  s  . c  o m*/
    City city = new City();
    try {
        sess = NewHibernateUtil.currentSession();
        Transaction tx = sess.beginTransaction();
        //sql statement to select all the rows
        String hql = "select * FROM Country";
        Query query = sess.createSQLQuery(hql).addEntity(City.class);

        List results = query.list();
        if (results.size() > 0) {
            CatalogueAdder adder = new CatalogueAdder();
            //start reading from csv and adding data into MYSQL
            adder.startProgram();
            CitySearch instance = new CitySearch();
            instance.SearchNearestCities(lat, lng);
        } else {
            CitySearch instance = new CitySearch();
            instance.SearchNearestCities(lat, lng);
        }
        tx.commit();

    } catch (Exception e) {
        e.printStackTrace();
    }
}

From source file:AdministrativoManoDeObra.java

public static List queryAdministrativoManoDeObra(PersistentSession session, String condition, String orderBy)
         throws PersistentException {
     StringBuffer sb = new StringBuffer("From AdministrativoManoDeObra as AdministrativoManoDeObra");
     if (condition != null)
         sb.append(" Where ").append(condition);
     if (orderBy != null)
         sb.append(" Order By ").append(orderBy);
     try {/*  w w  w.j a  va  2  s  .c om*/
         Query query = session.createQuery(sb.toString());
         return query.list();
     } catch (Exception e) {
         e.printStackTrace();
         throw new PersistentException(e);
     }
 }

From source file:AdministrativoManoDeObra.java

public static List queryAdministrativoManoDeObra(PersistentSession session, String condition, String orderBy,
         org.hibernate.LockMode lockMode) throws PersistentException {
     StringBuffer sb = new StringBuffer("From AdministrativoManoDeObra as AdministrativoManoDeObra");
     if (condition != null)
         sb.append(" Where ").append(condition);
     if (orderBy != null)
         sb.append(" Order By ").append(orderBy);
     try {//from  w ww. j  a  va  2  s.  com
         Query query = session.createQuery(sb.toString());
         query.setLockMode("AdministrativoManoDeObra", lockMode);
         return query.list();
     } catch (Exception e) {
         e.printStackTrace();
         throw new PersistentException(e);
     }
 }

From source file:submitaction.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods.//from w  ww.  j a va  2s.co  m
 *
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    response.setContentType("text/html;charset=UTF-8");
    PrintWriter out = response.getWriter();

    String username = (String) session.getAttribute("username");
    String dpimage = (String) session.getAttribute("dpimage");

    if (username == null)
        response.sendRedirect("login.jsp");
    else {

        String problemcode = (String) request.getParameter("q");
        String contestcode = (String) request.getParameter("c");
        String contestpath = Path.getArgPath("contests", contestcode);
        String userpath = Path.getArgPath("users", username);

        /* =========================== user not registered : redirect to index page ====================*/
        Connection con = null;
        Config c = new Config();
        int check = 0;
        Timestamp sdate = null, edate = null, ts = null;
        try {

            con = c.getcon();
            Statement stmt7 = con.createStatement();
            Statement stmt8 = con.createStatement();

            String sq = "Select count(*) as col from " + contestcode + "ranking where userid='" + username
                    + "'";
            String sq2 = "Select * from ContestInfo where contestcode='" + contestcode + "'";
            ResultSet rs8 = stmt8.executeQuery(sq2);
            if (rs8.next()) {
                sdate = rs8.getTimestamp("starttime");
                edate = rs8.getTimestamp("endtime");
            }
            java.util.Date date = new java.util.Date();
            ts = new Timestamp(date.getTime());

            //out.println(sq);
            ResultSet rs7 = stmt7.executeQuery(sq);
            if (rs7.next())
                check = Integer.parseInt(rs7.getString("col"));

        } catch (Exception e) {
        }

        if (!(ts.compareTo(sdate) > 0 && ts.compareTo(edate) < 0))
            response.sendRedirect("contestshow.jsp?c=PRACTICE");
        else if (check == 0)
            response.sendRedirect("index.jsp?register=True");
        else {
            /* ========================== get browsefile or editorfile  ==================== */

            Part filePart = null;
            String browsefile = null, ext = null, editorfile = null, language = null;
            int l = 0;
            try {
                MultipartRequest m = new MultipartRequest(request, userpath);
                filePart = request.getPart("test2");
                browsefile = (String) m.getFilesystemName("test2");

                editorfile = (String) m.getParameter("test1");

                language = (String) m.getParameter("language");

                HashMap<String, String> map = new HashMap<String, String>();
                map.put("AWK", "awk");
                map.put("Bash", "sh");
                map.put("C++", "cpp");
                map.put("C", "c");
                map.put("C#", "cs");
                map.put("Java", "java");
                map.put("Haskell", "hs");
                map.put("Perl", "pl");
                map.put("Pike", "pike");
                map.put("Python2.7", "py");
                map.put("Python3", "py");
                map.put("PHP", "php");
                map.put("Pascal", "pas");
                map.put("Ruby", "rb");
                ext = (String) map.get(language);
                l = editorfile.length();
            } catch (Exception e) {
                out.print("hi");
                out.flush();
            }

            if (l == 0 && browsefile == null) {
                //no file selected 
                response.sendRedirect("submit.jsp?q=" + problemcode + "&c=" + contestcode);
            } else {

                BufferedReader br = null;
                BufferedWriter bout = null;

                SessionFactory factory = new ConnectionProvider().getSessionFactory();
                Session s = factory.openSession();
                String id = "", st = "";
                Query q = null;
                Object[] ob = null;
                Transaction t = null;
                /* ==================== unique name : get from id table ============= */

                try {

                    st = "FROM Id id";
                    q = s.createQuery(st);
                    List<Id> users = q.list();
                    ob = users.toArray();
                    int preid = ((Id) ob[0]).getId();
                    id = "" + (preid + 1);
                    t = s.beginTransaction();
                    s.delete((Id) ob[0]);
                    s.saveOrUpdate(new Id(preid + 1));
                    t.commit();
                } catch (Exception e) {
                }

                /* ================== rename filenames and create folder and copy files in env =========== */
                //out.print(browsefile);out.flush();
                String browsefilepath = userpath + browsefile;
                String problempath = Path.getArgPath("contests", contestcode, problemcode); // for stdin.txt

                String codefilename = "Main" + id;

                //       rename procedure
                File file = new File(browsefilepath);
                // File (or directory) with new name
                File file2 = new File(userpath + codefilename + "." + ext);
                // Rename file (or directory)
                boolean success = file.renameTo(file2);

                //creating new folder for each sumission in env dir.

                String envPath = Path.getArgPath("env", codefilename);
                File dir = new File(envPath);
                if (!dir.exists()) {
                    dir.mkdir();
                }

                // copy file to env folder inside mkdir folder
                String userfilepath = userpath + codefilename + "." + ext;
                envPath = envPath + ("Main" + id + "." + ext);

                try {

                    if (editorfile.length() != 0) {
                        //out.print("this running");
                        bout = new BufferedWriter(new FileWriter(userfilepath), 10000);
                        bout.write(editorfile);
                        bout.close();

                        bout = new BufferedWriter(new FileWriter(envPath), 10000);
                        bout.write(editorfile);
                        bout.close();

                    } else {
                        br = new BufferedReader(new FileReader(userfilepath));
                        bout = new BufferedWriter(new FileWriter(envPath), 10000);
                        String line = "";
                        while ((line = br.readLine()) != null) {
                            bout.write(line + "\n");
                            bout.flush();
                        }
                        bout.flush();
                        bout.close();
                        br.close();
                    }

                } catch (Exception e) {
                }

                /* ======================= Running judge now  | ranking update  | status update ============ */

                // out.print((String)m.getParameter("language"));out.flush();
                Problems now = null;
                Date d = null;
                try {
                    st = "FROM Problems S WHERE S.problemcode='" + (String) request.getParameter("q") + "'";
                    q = s.createQuery(st);
                    List<Problems> ques = q.list();
                    ob = ques.toArray();
                    now = (Problems) ob[0];
                    d = new Date();
                    //out.print(now.toString());out.flush();

                } catch (Exception e) {
                    out.print("msg1=" + e.getMessage());
                }

                try {
                    Timestamp tmp = new Timestamp(d.getTime());

                    //out.println(language);
                    Q queue = new Q(codefilename, username, language, ext, problempath, "unjudge",
                            Double.parseDouble(now.getTimelimit()), "null", tmp, 0, 0, contestcode, 0,
                            problemcode, now.getTestfiles());
                    //do the judge work ;
                    t = s.beginTransaction();
                    s.saveOrUpdate(queue);
                    t.commit();
                } catch (Exception ex) {
                    out.print("msg2=" + ex.getMessage());
                } finally {
                    s.close();
                    factory.close();
                }

                // Show exit code of process
                //         out.println("Procefdsfdsfdsss exited with code = ");
                try {

                    //judge the solution         
                    //out.print("judge process starts "); out.flush();
                    final String[] cmd = { "/bin/bash", "-c", "cd " + Path.getPath() + " ; python judge.py" };
                    Runtime.getRuntime().exec(cmd);
                    //p.waitFor();

                    // inner class to run process without wait  outside main thread
                    /*  new Thread(new Runnable() {
                           public void run() {
                             try
                             {
                                 Runtime.getRuntime().exec(cmd);
                                 //p.waitFor();
                             }catch(Exception e){}
                       }
                     }).start(); 
                            
                    */
                    String problemid = (String) request.getParameter("q");
                    response.sendRedirect(
                            "status.jsp?q=" + problemid + "&c=" + contestcode + "&code=" + codefilename);
                    /* int chk = 0;   
                     while(chk == 0)
                     {
                            Thread.sleep(1);   
                            String query="Select count(*) as ch , status from " + contestcode+"submissions where username='"+username + "' and codefilename='"+codefilename+"'";
                            //out.println(query);
                                   
                            String pid = ""+problemid.charAt(problemid.length()-1);
                            //out.println(query);
                            ResultSet rs = stmt.executeQuery(query);
                            if(rs.next()){
                                chk = Integer.parseInt(rs.getString("ch"));
                                if(chk == 0)
                                 continue;
                                        
                                out.print("<style>#loading{visibility: hidden;</style>");              
                                out.println(rs.getString("status"));
                                        
                                if(rs.getString("status").compareTo("Accepted")==0)
                                {
                                    String sq = "Select * from "+contestcode+"ranking where userid='"+username+"'";
                                    //out.println(sq);
                                    ResultSet rs6 = stmt6.executeQuery(sq);
                                    if(rs6.next())
                                    {
                                        //out.println("hhhdsffsdkbhn");
                                        if(rs6.getString(pid+"score").compareTo("0") == 0)
                                        {
                    query = "UPDATE "+contestcode+"ranking SET "+pid+"score=100.0, "+pid+"time="+tc+" where userid='"+username+"'"; 
                    //out.println(query);
                    stmt2.executeUpdate(query);
                                        }
                                    }
                                }
                                else{
                                    String sql = "Select * from "+contestcode+"ranking where userid='"+username+"'";
                                    //out.println(sql);
                                    ResultSet rs3 = stmt2.executeQuery(sql);
                                    if(rs3.next())
                                    {
                                        //out.println("hhhdsffsdkbhn");
                                        if(rs3.getString(pid+"score").compareTo("0") == 0)
                                        {
                    int penalty = Integer.parseInt(rs3.getString(pid+"penalty"));
                    penalty += 1;
                    query = "UPDATE "+contestcode+"ranking SET "+pid+"penalty="+penalty+" where userid='"+username+"'";
                     //out.println(query);
                    stmt3.executeUpdate(query);
                                        }
                                    }
                                                
                                }
                                        
                                String sql = "Select * from "+contestcode+"ranking where userid='"+username+"'";
                                ResultSet rs5 = stmt5.executeQuery(sql);
                                //out.println("hi"+nop);
                                int total_penalty = 0;
                                Double total_score=0.0;
                                long total_time = 0;
                                char ch='A';
                                if(rs5.next())
                                {
                                    //out.println(rs5.getString("Apenalty"));
                            
                                    for(int i=0;i<nop;i++,ch++)
                                    {
                                        //out.println(ch);
                                        total_penalty += Integer.parseInt(rs5.getString(ch+"penalty"));
                                        total_score += Double.parseDouble(rs5.getString(ch+"score"));
                                        total_time += Long.parseLong(rs5.getString(ch+"time"));
                                        //out.println(total_penalty+" "+total_score+" "+total_time);
                                    }
                                    //out.println("hello");
                                    total_time += total_penalty * 20000*60;
                                    //Timestamp nt = new Timestamp(total_time);
                                    query = "UPDATE "+contestcode+"ranking SET penalty="+total_penalty+", score="+total_score+", time="+total_time+" where userid='"+username+"'";
                                    //out.println(query);
                                    stmt4.executeUpdate(query);
                                    out.flush();
                                }
                            }
                     }//while
                    */
                    con.close();
                    //  response.sendRedirect("index.jsp");
                } catch (Exception e) {
                } finally {
                    out.close();
                }

                /*
                        
                    out.print("<style>#loading{visibility: hidden;</style>");
                }
                          
                */
            }
        } //inner else due to sendRedirect
    } //else due to sendRedirect
}

From source file:aa.PersonDog.dao.AbstractDao.java

protected List findAll(Class clazz) {
    List objects = null;/*from w ww.  ja  va 2s .co m*/
    try {
        startOperation();
        Query query = session.createQuery("from " + clazz.getName());
        objects = query.list();
        commit();
    } catch (HibernateException e) {
        handleException(e);
    } finally {
        HibernateFactory.close(session);
    }
    return objects;
}

From source file:abd.p1.bd.UsuarioDAO.java

public boolean comprobarUsuario(String user, String password) {
    String sql = "SELECT * FROM usuarios WHERE correo = " + user + " AND contrasena = " + password;
    Session session = sf.openSession();/*from w ww . j a  va2s .c  om*/
    Query query = session.createQuery(sql);
    List<Usuario> users = (List<Usuario>) query.list();
    if (users.isEmpty())
        return false;
    else
        return true;
}