List of usage examples for org.hibernate Session createQuery
@Override org.hibernate.query.Query createQuery(CriteriaDelete deleteQuery);
From source file:DbConnectionJUnitTest.java
@Test(expected = IllegalArgumentException.class) public void TestReadException02() { Session session = sessionFctry.openSession(); Transaction tx = null;//from ww w.j a v a 2 s.c o m tx = session.beginTransaction(); List students = session.createQuery("FROMasdasd Students").list(); tx.commit(); session.close(); }
From source file:DbConnectionJUnitTest.java
@Test(expected = IllegalArgumentException.class) public void TestReadException03() { Session session = sessionFctry.openSession(); Transaction tx = null;/*w w w . j a v a 2 s . co m*/ tx = session.beginTransaction(); List students = session.createQuery("23").list(); tx.commit(); session.close(); }
From source file:submitaction.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods./*from w ww. java 2 s . c o 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:$.AbstractHibernateDaoImpl.java
License:Apache License
@SuppressWarnings({ "unchecked", "rawtypes" }) public void deleteAll() { getHibernateTemplate().execute(new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException { String hqlDelete = "delete " + domainClass.getName(); @SuppressWarnings("unused") int deletedEntities = session.createQuery(hqlDelete).executeUpdate(); return null; }/*from ww w .j a va 2 s. c om*/ }); }
From source file:a.A.java
/** * @param args the command line arguments */// w ww . j av a2s .co m public static void main(String[] args) { // TODO code application logic here String URL = "jdbc:mysql://localhost/MyBD"; String USER = "root"; String PASSWORD = "root"; String DRIVER_CLASS = "com.mysql.jdbc.Driver"; try { Class.forName(DRIVER_CLASS); } catch (ClassNotFoundException e) { e.printStackTrace(); } Connection connection = null; try { connection = DriverManager.getConnection(URL, USER, PASSWORD); } catch (SQLException e) { System.out.println("ERROR: Unable to Connect to Database."); } Configuration cfg = new Configuration(); cfg.configure("a/hibernate.cfg.xml");//populates the data of the configuration file //creating seession factory object ServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder().applySettings(cfg.getProperties()) .build(); SessionFactory factory = cfg.buildSessionFactory(serviceRegistry); String line; String csv = "C:\\Users\\hp\\Desktop\\GeoLiteCity-Location.csv"; try (BufferedReader br = new BufferedReader(new FileReader(csv))) { count = 0; City e1 = new City(); while ((line = br.readLine()) != null) { if (count > 1) { Session session = factory.openSession(); // creating transaction object Transaction t = session.beginTransaction(); System.out.println(line); String[] s = line.split("[,]"); System.out.println(s[0]); System.out.println(s[1]); System.out.println(Float.parseFloat(s[5])); System.out.println(Float.parseFloat(s[6])); e1.setId(Integer.parseInt(s[0])); e1.setName(s[1]); e1.setC(s[3]); e1.setlat(Float.parseFloat(s[5])); e1.setlon(Float.parseFloat(s[6])); session.save(e1); t.commit();//transaction is commited session.close(); } else { count++; } } // Session currentSession = factory.openSession(); // List <City> list=null; // // while(list==null){ // list = currentSession.createCriteria(City.class) // .add(Restrictions.eq("Name", "NL")) // .list(); // for(int i=0;i<list.size();i++){ // // System.out.println(list.get(i)); // } } catch (IOException e) { e.printStackTrace(); } String a, b; float lats = 0; float lats2 = 0; float longs = 0; float longs2 = 0; System.out.print("Enter name of first city"); Distance d1 = new Distance(); Scanner scanner = new Scanner(System.in); a = scanner.nextLine(); a = "\"" + a + "\""; System.out.print("Enter name of second city"); //Scanner scanner=new Scanner(System.in); b = scanner.nextLine(); b = "\"" + b + "\""; Transaction tx; Session session = factory.openSession(); try { // int index=0; tx = session.beginTransaction(); List employees = session.createQuery("FROM City").list(); for (Iterator iterator = employees.iterator(); iterator.hasNext();) { City c = (City) iterator.next(); if (a.contentEquals(c.getC())) { System.out.print("Name: " + c.getName()); System.out.print(" City: " + c.getC()); lats = c.getlon(); longs = c.getlat(); System.out.print(" Longitude: " + c.getlon()); System.out.println(" Latitude: " + c.getlat()); break; } } List<String> citynames = new ArrayList<String>(); List<Double> doubleList = new ArrayList<Double>(); System.out.println("Enter number of cities"); Scanner s = new Scanner(System.in); int num = Integer.parseInt(s.nextLine()); Distance obj = new Distance(); int i = 0; for (Iterator iterator = employees.iterator(); iterator.hasNext();) { City c = (City) iterator.next(); if (i < num) { doubleList.add(obj.GreatD(lats, longs, c.getlat(), c.getlon())); citynames.add(c.getC()); i++; } else { //get max value from list Integer j = 0, maxIndex = -1; Double max = null; for (Double x : doubleList) { if ((x != null) && ((max == null) || (x > max))) { max = x; maxIndex = j; } j++; } double dare = obj.GreatD(lats, longs, c.getlat(), c.getlon()); if (dare < max) { citynames.set(maxIndex, c.getC()); doubleList.set(maxIndex, dare); //list } } // For first n values add to list } for (int k = 0; k < citynames.size(); k++) { System.out.println(citynames.get(k)); } // int check = 0; for (Iterator iterator = employees.iterator(); iterator.hasNext();) { City c = (City) iterator.next(); if (check == 2) { break; } else { if (b.contentEquals(c.getC())) { System.out.print("Name: " + c.getName()); System.out.print(" City: " + c.getC()); longs = c.getlon(); lats = c.getlat(); System.out.print(" Longitude: " + c.getlon()); System.out.println(" Latitude: " + c.getlat()); check++; } if (a.contentEquals(c.getC())) { System.out.print("Name: " + c.getName()); System.out.print(" City: " + c.getC()); longs2 = c.getlon(); lats2 = c.getlat(); System.out.print(" Longitude: " + c.getlon()); System.out.println(" Latitude: " + c.getlat()); check++; } } } System.out.println(d1.GreatD(lats, longs, lats2, longs2)); tx.commit(); return; } catch (Exception e) { e.printStackTrace(); } }
From source file:A.NET.DAO.IMPL.UsuarioDaoImpl.java
@Override public Usuario validarusuario(String usuario, String password) { Usuario user = null;//from w w w . j av a 2 s . c om Session session = null; SessionFactory sf = null; try { sf = HibernateUtil.getSessionFactory(); session = sf.openSession(); Query query = session.createQuery( "from Usuario where usuario='" + usuario + "' and password='" + password + "' and estado='1'"); user = (Usuario) query.uniqueResult(); session.close(); } catch (Exception e) { System.out.println("Error!!!!!:" + e.getMessage()); e.printStackTrace(); session.close(); } return user; }
From source file:A.NET.DAO.IMPL.VentaDaoImpl.java
@Override public Persona buscarPersona(String dni) { Persona persona = null;//from w w w . j ava2 s. c om SessionFactory sf = null; Session session = null; try { sf = HibernateUtil.getSessionFactory(); session = sf.openSession(); Query query = session.createQuery("from Persona where nro_d='" + dni + "'"); persona = (Persona) query.uniqueResult(); session.close(); } catch (Exception e) { e.printStackTrace(); session.close(); } return persona; }
From source file:abd.p1.bd.UserDAO.java
public List<Usuario> findByName(String name) { Session s = sf.openSession(); Transaction tr = s.beginTransaction(); List<Usuario> userList = s .createQuery("from " + Usuario.class.getName() + " as user where user.nombre like :name") .setString("name", '%' + name + '%').list(); tr.commit();//w w w. ja va 2 s . c o m s.close(); return userList; }
From source file:abd.p1.bd.UserDAO.java
public List<Usuario> findAll() { Session s = sf.openSession(); Transaction tr = s.beginTransaction(); List<Usuario> userList = s.createQuery("from " + Usuario.class.getName()).list(); tr.commit();// www.ja va2 s . co m s.close(); return userList; }
From source file:abd.p1.bd.UserDAO.java
public List<Usuario> findNearest(Double lat, Double lng) { Session s = sf.openSession(); Transaction tr = s.beginTransaction(); List<Usuario> userList = s.createQuery("from " + Usuario.class.getName() + " as user" + " order by (user.latitud - :lat) * (user.latitud - :lat) + (user.longitud - :lng) * (user.longitud - :lng)") .setDouble("lat", lat).setDouble("lng", lng).setMaxResults(20).list(); tr.commit();//from ww w.ja v a 2 s. c o m s.close(); return userList; }