コード例 #1
0
 @Override
 public List<SmsProveedor> filtrarProveedor(String dato) {
   Session session = null;
   List<SmsProveedor> Proveedores = new ArrayList<>();
   try {
     session = NewHibernateUtil.getSessionFactory().openSession();
     Query query =
         session.createQuery(
             "from SmsProveedor as proveedor left join fetch proveedor.smsUsuario as usuario left join fetch usuario.smsCiudad as ciudad "
                 + "where proveedor.proveedorValorGanancia LIKE '%"
                 + dato
                 + "%' OR usuario.usuarioNombre LIKE '%"
                 + dato
                 + "%' OR usuario.usuarioEmail LIKE '"
                 + dato
                 + "' OR usuario.usuarioNit LIKE '"
                 + dato
                 + "' OR "
                 + "ciudad.ciudadNombre LIKE '"
                 + dato
                 + "'");
     Proveedores = (List<SmsProveedor>) query.list();
   } catch (HibernateException e) {
     e.getMessage();
   } finally {
     if (session != null) {
       session.close();
     }
   }
   return Proveedores;
 }
コード例 #2
0
  /**
   * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
   *
   * @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();

    try {

      String su = request.getParameter("subid");

      int i = 1;

      Session s = NewHibernateUtil.getSessionFactory().openSession();
      Transaction t = s.beginTransaction();

      Criteria cr = s.createCriteria(Subject.class);
      cr.add(Restrictions.eq("idsubject", Integer.parseInt(su)));
      Subject sab = (Subject) cr.uniqueResult();
      Subject subt = (Subject) s.load(Subject.class, sab.getIdsubject());

      Criteria c = s.createCriteria(School.class);
      c.add(Restrictions.eq("subject", subt));

      JSONArray json = new JSONArray();
      Map m = new HashMap();

      List<School> list = c.list();

      for (School school : list) {
        m.put("schoolName", school.getSchoolName());
        m.put("grade11", school.getGrade11());
        m.put("grade10", school.getGrade10());
        m.put("grade9", school.getGrade9());
        m.put("subject", school.getSubject().getSubjectName());

        json.add(m);

        m = null;
        m = new HashMap();

        out.write(json.toJSONString());

        //                out.write("<tr>" + school.getSchoolName() + "</tr>");
        //                out.write("<tr>" + school.getGrade11() + "</tr>");
        //                out.write("<tr>" + school.getGrade10() + "</tr>");
        //                out.write("<tr>" + school.getGrade9() + "</tr>");
        //                out.write("<tr>" + school.getSubject().getSubjectName() + "</tr>");
      }

    } catch (Exception e) {
      throw new ServletException(e);
    }
  }
コード例 #3
0
 @Override
 public void eliminarProveedor(SmsProveedor proveedor) {
   Session session = null;
   try {
     session = NewHibernateUtil.getSessionFactory().openSession();
     session.beginTransaction();
     session.delete(proveedor);
     session.getTransaction().commit();
   } catch (HibernateException e) {
     e.getMessage();
     session.getTransaction().rollback();
   } finally {
     if (session != null) {
       session.close();
     }
   }
 }
コード例 #4
0
 @Override
 public List<SmsProveedor> mostrarProveedores() {
   Session session = null;
   List<SmsProveedor> Proveedores = new ArrayList<>();
   try {
     session = NewHibernateUtil.getSessionFactory().openSession();
     Query query =
         session.createQuery(
             "from SmsProveedor as proveedor left join fetch proveedor.smsUsuario as usuario"
                 + " left join fetch usuario.smsCiudad as ciudad left join fetch usuario.smsRols as roles");
     Proveedores = (List<SmsProveedor>) query.list();
   } catch (HibernateException e) {
     e.getMessage();
   } finally {
     if (session != null) {
       session.close();
     }
   }
   return Proveedores;
 }
コード例 #5
0
 @Override
 public List<SmsProveedor> consultarProveedorUsuario(SmsUsuario usuario) {
   Session session = null;
   List<SmsProveedor> Proveedores = new ArrayList<>();
   try {
     session = NewHibernateUtil.getSessionFactory().openSession();
     Query query =
         session.createQuery(
             "from SmsProveedor as proveedor left join fetch proveedor.smsUsuario as usuario where usuario.idUsuario = '"
                 + usuario.getIdUsuario()
                 + "'");
     Proveedores = (List<SmsProveedor>) query.list();
   } catch (HibernateException e) {
     e.getMessage();
   } finally {
     if (session != null) {
       session.close();
     }
   }
   return Proveedores;
 }
コード例 #6
0
 /** @param args the command line arguments */
 public static void main(String[] args) {
   // TODO code application logic here
   Session session = NewHibernateUtil.getSessionFactory().openSession();
 }
コード例 #7
0
ファイル: GenreHelper.java プロジェクト: snagster/MyVibe
 public GenreHelper() {
   this.session = NewHibernateUtil.getSessionFactory().openSession();
 }