List of usage examples for org.hibernate.cfg Configuration configure
@Deprecated public Configuration configure(org.w3c.dom.Document document) throws HibernateException
From source file:servlet.NewSR.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods./*ww w. ja v a2 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"); try (PrintWriter out = response.getWriter()) { /* TODO output your page here. You may use following sample code. */ out.println("<!DOCTYPE html>"); out.println("<html>"); out.println("<head>"); out.println("<title>Servlet page1</title>"); out.println("</head>"); out.println("<body>"); out.println("<h1>Servlet page1 at " + request.getContextPath() + "</h1>"); try { Configuration configuration = new Configuration(); configuration.configure("hibernate.cfg.xml"); StandardServiceRegistryBuilder ssrb = new StandardServiceRegistryBuilder() .applySettings(configuration.getProperties()); SessionFactory sessionFactory = configuration.buildSessionFactory(ssrb.build()); Session session = sessionFactory.openSession(); Transaction trans = session.beginTransaction(); Query query = session.createQuery("from data.Sc sc where sc.id = :anId"); query.setParameter("anId", Integer.valueOf(request.getParameter("sc_id"))); Sc sc = (Sc) query.uniqueResult(); if (sc == null) { throw new HibernateException(new Throwable("The SC_ID doesn't exist")); } query = session.createQuery("from data.S s where s.id = :anId"); query.setParameter("anId", Integer.valueOf(request.getParameter("s_id"))); S s = (S) query.uniqueResult(); if (sc == null) { throw new HibernateException(new Throwable("The S_ID doesn't exist")); } query = session.createQuery("from data.Sp sp where sp.id = :anId"); query.setParameter("anId", Integer.valueOf(request.getParameter("sp_id"))); Sp sp = (Sp) query.uniqueResult(); if (sp == null) { throw new HibernateException(new Throwable("The SP_ID doesn't exist")); } query = session.createQuery("from data.Qoso qoso where qoso.id = :anId"); query.setParameter("anId", Integer.valueOf(request.getParameter("qoso_id"))); Qoso qoso = (Qoso) query.uniqueResult(); if (qoso == null) { throw new HibernateException(new Throwable("The Qoso_ID doesn't exist")); } Sr sr = new Sr(qoso, s, sc, sp, sc.getName(), s.getName(), request.getParameter("statut")); session.persist(sr); trans.commit(); session.close(); out.println("The creation of this Service Registery has succeded !!<br/>"); } catch (HibernateException he) { out.println(he.getMessage() + "<br/>"); out.println("The creation of this Service Registery has failed...<br/>"); } out.println("</body>"); out.println("</html>"); } }
From source file:servlet.UpdateSRStatut.java
/** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods.//from w w w . j a v a 2 s. 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"); try (PrintWriter out = response.getWriter()) { /* TODO output your page here. You may use following sample code. */ out.println("<!DOCTYPE html>"); out.println("<html>"); out.println("<head>"); out.println("<title>Servlet UpdateSRStatut</title>"); out.println("</head>"); out.println("<body>"); out.println("<h1>Servlet UpdateSRStatut at " + request.getContextPath() + "</h1>"); // No try catch, I suppose the connexion will be okey... Configuration configuration = new Configuration(); configuration.configure("hibernate.cfg.xml"); StandardServiceRegistryBuilder ssrb = new StandardServiceRegistryBuilder() .applySettings(configuration.getProperties()); SessionFactory sessionFactory = configuration.buildSessionFactory(ssrb.build()); Session session = sessionFactory.openSession(); Transaction trans = session.beginTransaction(); try { int sr_id; try { sr_id = Integer.valueOf(request.getParameter("sr_id")); } catch (NumberFormatException ne) { throw new HibernateException(new Throwable("The SR ID isn't a number")); } Query query = session.createQuery("from data.Sr sr where sr.id = :anId"); query.setParameter("anId", sr_id); Sr sr = (Sr) query.uniqueResult(); if (sr == null) { throw new HibernateException(new Throwable("The SR ID doesn't exist")); } sr.setStatus(request.getParameter("statut")); session.persist(sr); trans.commit(); session.close(); out.println("The update of the statut has succeded !!<br/>"); } catch (HibernateException he) { out.println(he.getMessage() + "<br/>"); out.println("The update of the statut has failed...<br/>"); trans.rollback(); session.close(); } out.println("</body>"); out.println("</html>"); } }
From source file:servs.EditRecord.java
protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String param = request.getParameter("action"); switch (param) { case "Update": { try {//from w ww . j a v a 2 s.c o m //=== to update record table int recordid = Integer.parseInt(request.getParameter("recordid")); String recordname = request.getParameter("recordname"); String desc = request.getParameter("desc"); String tags = request.getParameter("tags"); //=== to update address table int addid = Integer.parseInt(request.getParameter("addid")); String street = request.getParameter("street1"); String area = request.getParameter("area"); String landmark = request.getParameter("landmark"); if (landmark == null) { landmark = ""; } String city = request.getParameter("city"); String state = request.getParameter("state"); String country = request.getParameter("country"); String zip = request.getParameter("zip"); String contact1 = request.getParameter("contact1"); if (contact1 == null) { contact1 = ""; } String contact2 = request.getParameter("contact2"); if (contact2 == null) { contact2 = ""; } String contact3 = request.getParameter("contact3"); if (contact3 == null) { contact3 = ""; } //=== to update Email table String email1 = request.getParameter("email1"); String emailid1 = request.getParameter("emailid1"); String email2 = request.getParameter("email2"); String emailid2 = request.getParameter("emailid2"); String email3 = request.getParameter("email3"); String emailid3 = request.getParameter("emailid3"); String website = request.getParameter("website"); String webid = request.getParameter("webid"); System.out.println(email1 + emailid1); System.out.println(email2 + emailid2); System.out.println(email3 + emailid3); System.out.println(website + webid); int count = 0; if (email1 != null) { count = count + 1; } if (email2 != null) { count = count + 1; } if (email3 != null) { count = count + 1; } System.out.println("THIS IS COUNT" + count); //=== to Start Connection Configuration cfg = new Configuration(); SessionFactory sessionFactory = cfg.configure("hibernate.cfg.xml").buildSessionFactory(); Session s = sessionFactory.openSession(); Transaction transaction = s.beginTransaction(); //=== UPDATE RECORD TBL String recsql = "UPDATE bean.Record" + " SET recname=:name," + " description=:descp," + " tags=:tags " + " WHERE recid=:id"; Query q1 = s.createQuery(recsql); q1.setParameter("name", recordname); q1.setParameter("descp", desc); q1.setParameter("tags", tags); q1.setParameter("id", recordid); String addsql = "UPDATE bean.Address" + " SET street=:street," + " area=:area," + " landmark=:landmark," + " city=:city, " + " state=:state," + " zipcode=:zipcode," + " fone1=:fone1," + " fone2=:fone2," + " fone3=:fone3 " + " WHERE addid=:id"; Query q2 = s.createQuery(addsql); q2.setParameter("street", street); q2.setParameter("area", area); q2.setParameter("landmark", landmark); q2.setParameter("city", city); q2.setParameter("state", state); q2.setParameter("zipcode", zip); q2.setParameter("fone1", contact1); q2.setParameter("fone2", contact2); q2.setParameter("fone3", contact3); q2.setParameter("id", addid); if (website != null) { String emailsql1 = "UPDATE bean.Email" + " SET emailadd = :emailadd" + " WHERE emailID = :id"; Query q3 = s.createQuery(emailsql1); q3.setParameter("emailadd", website); q3.setParameter("id", webid); int result = q3.executeUpdate(); q3.executeUpdate(); } switch (count) { case 1: { String emailsql1 = "UPDATE bean.Email" + " SET emailadd = :emailadd" + " WHERE emailID = :id"; Query q3 = s.createQuery(emailsql1); q3.setParameter("emailadd", email1); q3.setParameter("id", emailid1); int result = q3.executeUpdate(); break; } case 2: { String emailsql1 = "UPDATE bean.Email" + " SET emailadd = :emailadd" + " WHERE emailID = :id"; Query q3 = s.createQuery(emailsql1); q3.setParameter("emailadd", email1); q3.setParameter("id", emailid1); String emailsql2 = "UPDATE bean.Email" + " SET emailadd = :emailadd" + " WHERE emailID = :id"; Query q4 = s.createQuery(emailsql2); q4.setParameter("emailadd", email2); q4.setParameter("id", emailid2); q4.executeUpdate(); q3.executeUpdate(); break; } case 3: { String emailsql3 = "UPDATE bean.Email" + " SET emailadd = :emailadd" + " WHERE emailID = :id"; Query q3 = s.createQuery(emailsql3); q3.setParameter("emailadd", email1); q3.setParameter("id", emailid1); String emailsql2 = "UPDATE bean.Email" + " SET emailadd = :emailadd" + " WHERE emailID = :id"; Query q4 = s.createQuery(emailsql2); q4.setParameter("emailadd", email2); q4.setParameter("id", emailid2); String emailsql4 = "UPDATE bean.Email" + " SET emailadd = :emailadd" + " WHERE emailID = :id"; Query q5 = s.createQuery(emailsql4); q5.setParameter("emailadd", email3); q5.setParameter("id", emailid3); q5.executeUpdate(); q4.executeUpdate(); q3.executeUpdate(); break; } } int result1 = q1.executeUpdate(); int result2 = q2.executeUpdate(); if (result1 > 0 && result2 > 0) { System.out.println("Update successfuly"); } transaction.commit(); s.close(); //==== if success then redirect to success page request.getSession(false).setAttribute("info", "Your Record is Updated Successfully"); response.sendRedirect("AdminPanel/AdminPanelSuccess.jsp"); } catch (Exception ex) { System.out.println("Exception is HERE::::" + ex.getMessage()); } break; } case "Update Category": { int recordid = Integer.parseInt(request.getSession(false).getAttribute("recid").toString()); int categoryid = Integer.parseInt(request.getParameter("categorySelect")); try { Configuration cfg = new Configuration(); SessionFactory sessionFactory = cfg.configure("hibernate.cfg.xml").buildSessionFactory(); Session s = sessionFactory.openSession(); Transaction transaction = s.beginTransaction(); String sql = "UPDATE bean.Record" + " SET catid=:catid" + " WHERE recid=:id"; Query query = s.createQuery(sql); query.setParameter("catid", categoryid); query.setParameter("id", recordid); int result = query.executeUpdate(); if (result > 0) { System.out.println("Update successful"); } transaction.commit(); s.close(); //==== if success then redirect to success page request.getSession(false).setAttribute("info", "Your Record is Updated Successfully"); response.sendRedirect("AdminPanel/AdminPanelSuccess.jsp"); } catch (Exception ex) { System.out.println(ex); } break; } case "Submit Email/Website": { int addid = Integer.parseInt(request.getSession(false).getAttribute("addressid").toString()); bean.Email e = new Email(); e.setEmailadd(request.getParameter("email")); try { Configuration cfg = new Configuration(); SessionFactory sessionFactory = cfg.configure("hibernate.cfg.xml").buildSessionFactory(); Session s = sessionFactory.openSession(); Transaction transaction = s.beginTransaction(); } catch (Exception ex) { System.out.println(ex); } break; } case "Delete": { try { Configuration cfg = new Configuration(); SessionFactory sessionFactory = cfg.configure("hibernate.cfg.xml").buildSessionFactory(); Session s = sessionFactory.openSession(); Transaction transaction = s.beginTransaction(); int addid = Integer.parseInt(request.getSession(false).getAttribute("addressid").toString()); String sql = "DELETE FROM bean.Address" + " WHERE addid=:id"; Query query = s.createQuery(sql); query.setParameter("id", addid); int result = query.executeUpdate(); if (result > 0) { System.out.println("Delete successful"); } transaction.commit(); s.close(); //===== Response===== request.getSession(false).setAttribute("info", "Your Record is Deleted Successfully"); response.sendRedirect("AdminPanel/AdminPanelSuccess.jsp"); } catch (Exception ex) { System.out.println(ex.getMessage()); } break; } case "Submit Image": { int recordid = Integer.parseInt(request.getSession(false).getAttribute("recid").toString()); int addid = Integer.parseInt(request.getSession(false).getAttribute("addressid").toString()); String path = ""; String pathfilename = ""; //=== saving image to RecordPhotos folder long filesize = request.getPart("recimage").getSize(); if (filesize > 0) { Part part = request.getPart("recimage"); InputStream is = part.getInputStream(); ImageInputStream iis = ImageIO.createImageInputStream(is); BufferedImage bimg = ImageIO.read(iis); Image scaledimg = null; if (bimg.getHeight() > 350 || bimg.getWidth() > 500) { System.out.println("Scaled"); //===ratio fr 800x600 double ratio = 1.8; int newwidth = (int) (bimg.getWidth() / ratio); int newheight = (int) (bimg.getHeight() / ratio); //=== This function returns an Image object of desired size or ratio scaledimg = bimg.getScaledInstance(newwidth, newheight, Image.SCALE_SMOOTH); //=== draw Image into Buffered Image= BufferedImage bimage = new BufferedImage(scaledimg.getWidth(null), scaledimg.getHeight(null), BufferedImage.TYPE_INT_RGB); Graphics2D g2d = bimage.createGraphics(); g2d.drawImage(scaledimg, 0, 0, null); g2d.dispose(); //=== saving image to folder path = "/home/aa/NetBeansProjects/searchChd/web/RecordPhotos"; pathfilename = path + File.separator + "img_" + recordid + ".jpg"; File f = new File(pathfilename); ImageIO.write(bimage, "jpeg", f); } else { //=== saving image to folder path = "/home/aa/NetBeansProjects/searchChd/web/RecordPhotos"; pathfilename = path + File.separator + "img_" + recordid + ".jpg"; File f = new File(pathfilename); ImageIO.write(bimg, "jpeg", f); } } //==== save imagepath to Address Table try { Configuration cfg = new Configuration(); SessionFactory sessionFactory = cfg.configure("hibernate.cfg.xml").buildSessionFactory(); Session s = sessionFactory.openSession(); Transaction transaction = s.beginTransaction(); String sql = "UPDATE bean.Address" + " SET imagepath=:imgpath" + " WHERE addid=:id"; Query query = s.createQuery(sql); query.setParameter("imgpath", pathfilename); query.setParameter("id", addid); int result = query.executeUpdate(); if (result > 0) { System.out.println("Update successful"); } transaction.commit(); s.close(); //==== if success then redirect to success page request.getSession(false).setAttribute("info", "Your Image is Updated Successfully"); response.sendRedirect("AdminPanel/AdminPanelSuccess.jsp"); } catch (Exception ex) { System.out.println(ex); } break; } } }
From source file:servs.Feedback_Review.java
protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String action = request.getParameter("action"); switch (action) { case "Submit Feedback": { try {//from w ww .j av a2 s.c om String name = request.getParameter("fname"); String subject = request.getParameter("fsub"); String ftext = request.getParameter("ftxt"); bean.Feedback f = new Feedback(); f.setFusr(name); f.setFsub(subject); f.setFtext(ftext); Configuration cfg = new Configuration(); SessionFactory sessionFactory = cfg.configure("hibernate.cfg.xml").buildSessionFactory(); Session s = sessionFactory.openSession(); Transaction transaction = s.beginTransaction(); s.save(f); transaction.commit(); s.close(); sessionFactory.close(); response.getWriter().print("Thankyou for your feedback!"); } catch (Exception ex) { System.out.println(ex); } break; } case "Submit Review": { try { String rtext = request.getParameter("rtext"); int recid = Integer.parseInt(request.getParameter("recid")); String uname = request.getSession(false).getAttribute("wname").toString(); int uid = Integer.parseInt(request.getSession(false).getAttribute("wid").toString()); System.out.println(rtext); bean.Review r = new Review(); r.setRevtext(rtext); r.setRevusrname(uname); r.setRevusr(uid); r.setRecid(recid); Date dateobj = new Date(); r.setPostdate(dateobj); r.setVisible(false); Configuration cfg = new Configuration(); SessionFactory sessionFactory = cfg.configure("hibernate.cfg.xml").buildSessionFactory(); Session s = sessionFactory.openSession(); Transaction transaction = s.beginTransaction(); s.save(r); transaction.commit(); s.close(); sessionFactory.close(); response.getWriter().print("Thankyou for your review!"); } catch (Exception ex) { System.out.println(ex); } break; } } }
From source file:sk.cagani.stuba.bpbp.serverApp.DatabaseConnector.java
public DatabaseConnector() { Configuration configuration = new Configuration(); configuration.configure("hibernate.cfg.xml"); configuration.addJar(new File("/home/debian/BPbp/target/lib/BPbpDatabaseMapper-1.0.jar")); StandardServiceRegistryBuilder ssrb = new StandardServiceRegistryBuilder() .applySettings(configuration.getProperties()); sessionFactory = configuration.buildSessionFactory(ssrb.build()); stats = sessionFactory.getStatistics(); stats.setStatisticsEnabled(true);//from ww w.ja va 2 s. com }
From source file:Tables.SessionFactoryUtil.java
private static SessionFactory configureSessionFactory() throws HibernateException { Configuration configuration = new Configuration(); configuration.configure("/ConfigFiles/hibernate.cfg.xml"); serviceRegistry = new StandardServiceRegistryBuilder().applySettings(configuration.getProperties()).build(); sessionFactory = configuration.buildSessionFactory(serviceRegistry); return sessionFactory; }
From source file:tests.ReadHibernateConfig.java
public static void main(String[] args) { Configuration config = new Configuration(); config.configure("hibernate.cfg.xml"); System.out.println("db username: " + config.getProperty("hibernate.connection.username")); System.out.println("db password: " + config.getProperty("hibernate.connection.password")); System.out.println("url: " + config.getProperty("hibernate.connection.url")); }
From source file:util.HibernateSession.java
private static SessionFactory buildSessionFactory() { Configuration configuration = new Configuration(); configuration.configure("hibernate.cfg.xml"); org.hibernate.service.ServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder() .applySettings(configuration.getProperties()).build(); SessionFactory sessionFactory = configuration.buildSessionFactory(serviceRegistry); return sessionFactory; }
From source file:Utility.HibernateUtility.java
@Override public void contextInitialized(ServletContextEvent sce) { ServletContext sc = sce.getServletContext(); try {//from w w w . ja v a2 s . com System.out.println( "__________________________Going to check config files________________________________________"); Configuration cf = new Configuration(); Configuration cfg = cf.configure("/hbmfolder/hibernate.cfg.xml"); sessionfactory = cfg.buildSessionFactory(); System.out.println("______________________________done______________________________"); sc.setAttribute("sf", sessionfactory); } catch (HibernateException e) { System.out.println(e.getMessage()); } }
From source file:utils.DatabaseConstruction.java
License:Open Source License
/** * The main method./* w w w . java2 s .com*/ * * @param args the arguments */ public static void main(String[] args) { System.out.println("Creating database-structure for AnSoMia"); Configuration configuration = new Configuration(); //add all classes you want to annotate configuration.addAnnotatedClass(Index.class); configuration.addAnnotatedClass(Company.class); configuration.addAnnotatedClass(MarketValue.class); configuration.addAnnotatedClass(KeyPerformanceIndicator.class); configuration.addAnnotatedClass(News.class); configuration.addAnnotatedClass(NewsDetail.class); configuration.addAnnotatedClass(SentenceInformation.class); configuration.addAnnotatedClass(IndustrySector.class); configuration.addAnnotatedClass(CompanyInformation.class); configuration.addAnnotatedClass(EntityInformation.class); configuration.configure("hibernate.cfg.xml"); new SchemaExport(configuration).create(true, true); SaveLoadDatabase sldb = new SaveLoadDatabase(); sldb.loadDataBase(); System.out.println("Finished"); }