Beispiel #1
0
 @Override
 public ArrayList<TareaBean> getPage(
     int intRegsPerPag,
     int intPage,
     ArrayList<FilterBeanHelper> hmFilter,
     HashMap<String, String> hmOrder,
     Integer expand)
     throws Exception {
   strSQL += SqlBuilder.buildSqlWhere(hmFilter);
   strSQL += SqlBuilder.buildSqlOrder(hmOrder);
   strSQL += SqlBuilder.buildSqlLimit(oMysql.getCount(strSQL), intRegsPerPag, intPage);
   ArrayList<TareaBean> arrTarea = new ArrayList<>();
   try {
     ResultSet oResultSet = oMysql.getAllSql(strSQL);
     if (oResultSet != null) {
       while (oResultSet.next()) {
         TareaBean oTareaBean = new TareaBean();
         arrTarea.add(oTareaBean.fill(oResultSet, oConnection, expand));
       }
     }
   } catch (Exception ex) {
     ExceptionBooster.boost(
         new Exception(this.getClass().getName() + ":getPage ERROR: " + ex.getMessage()));
   }
   return arrTarea;
 }
 public ArrayList<ComentarioBean> getPagexidusuario(
     int id_usuario,
     int intRegsPerPag,
     int intPage,
     ArrayList<FilterBeanHelper> hmFilter,
     HashMap<String, String> hmOrder,
     Integer expand)
     throws Exception {
   // strSQL += SqlBuilder.buildSqlWhere(hmFilter);
   // strSQL += SqlBuilder.buildSqlOrder(hmOrder);
   strSQL =
       "select comentario.id, comentario.texto, comentario.fecha, comentario.id_amistad from comentario, amistad, usuario where ( usuario.id= amistad.id_usuario2) AND amistad.id = comentario.id_amistad AND usuario.id="
           + id_usuario;
   strSQL += SqlBuilder.buildSqlLimit(oMysql.getCount(strSQL), intRegsPerPag, intPage);
   ArrayList<ComentarioBean> arrComentario = new ArrayList<>();
   try {
     ResultSet oResultSet = oMysql.getAllSql(strSQL);
     if (oResultSet != null) {
       while (oResultSet.next()) {
         ComentarioBean oComentarioBean = new ComentarioBean();
         arrComentario.add(oComentarioBean.fill(oResultSet, oConnection, expand));
       }
     }
   } catch (Exception ex) {
     ExceptionBooster.boost(
         new Exception(this.getClass().getName() + ":getPage ERROR: " + ex.getMessage()));
   }
   return arrComentario;
 }
 public ArrayList<ComentarioBean> getAllporusuario(
     int id_usuario,
     ArrayList<FilterBeanHelper> alFilter,
     HashMap<String, String> hmOrder,
     Integer expand)
     throws Exception {
   strSQL =
       "SELECT comentario.* from comentario, amistad where comentario.id_amistad= amistad.id and amistad.id_usuario2="
           + id_usuario;
   strSQL += SqlBuilder.buildSqlOrder(hmOrder);
   ArrayList<ComentarioBean> arrComentario = new ArrayList<>();
   try {
     ResultSet oResultSet = oMysql.getAllSql(strSQL);
     if (oResultSet != null) {
       while (oResultSet.next()) {
         ComentarioBean oComentarioBean = new ComentarioBean();
         arrComentario.add(oComentarioBean.fill(oResultSet, oConnection, expand));
       }
     }
   } catch (Exception ex) {
     ExceptionBooster.boost(
         new Exception(this.getClass().getName() + ":getPage ERROR: " + ex.getMessage()));
   }
   return arrComentario;
 }
Beispiel #4
0
 @Override
 public Integer remove(Integer id) throws Exception {
   int result = 0;
   try {
     result = oMysql.removeOne(id, strTable);
   } catch (Exception ex) {
     ExceptionBooster.boost(
         new Exception(this.getClass().getName() + ":remove ERROR: " + ex.getMessage()));
   }
   return result;
 }
Beispiel #5
0
 @Override
 public int getCount(ArrayList<FilterBeanHelper> hmFilter) throws Exception {
   strSQL += SqlBuilder.buildSqlWhere(hmFilter);
   int pages = 0;
   try {
     pages = oMysql.getCount(strSQL);
   } catch (Exception ex) {
     ExceptionBooster.boost(
         new Exception(this.getClass().getName() + ":getCount ERROR: " + ex.getMessage()));
   }
   return pages;
 }
Beispiel #6
0
  public Integer removeOnCascade(Integer id) throws Exception {
    int result = 0;
    String strSQLUsuarioTarea = "DELETE FROM usuariotarea WHERE usuariotarea.id_tarea=" + id;

    try {
      result = oMysql.removeOnCascade(strSQLUsuarioTarea);

    } catch (Exception ex) {
      ExceptionBooster.boost(
          new Exception(this.getClass().getName() + ":remove ERROR: " + ex.getMessage()));
    }
    return result;
  }
Beispiel #7
0
  @Override
  public Integer set(TareaBean oTareaBean) throws Exception {
    Integer iResult = null;
    try {
      if (oTareaBean.getId() == 0) {
        strSQL = "INSERT INTO " + strTable + " ";
        strSQL += "(" + oTareaBean.getColumns() + ")";
        strSQL += "VALUES(" + oTareaBean.getValues() + ")";
        iResult = oMysql.executeInsertSQL(strSQL);
      } else {
        strSQL = "UPDATE " + strTable + " ";
        strSQL += " SET " + oTareaBean.toPairs();
        strSQL += " WHERE id=" + oTareaBean.getId();
        iResult = oMysql.executeUpdateSQL(strSQL);
      }

    } catch (Exception ex) {
      ExceptionBooster.boost(
          new Exception(this.getClass().getName() + ":set ERROR: " + ex.getMessage()));
    }
    return iResult;
  }
 public int getCountxidusuario(int id_usuario, ArrayList<FilterBeanHelper> hmFilter)
     throws Exception {
   // strSQL += SqlBuilder.buildSqlWhere(hmFilter);
   int pages = 0;
   try {
     pages =
         oMysql.getCount(
             "select comentario.id, comentario.texto, comentario.fecha, comentario.id_amistad from comentario, amistad, usuario where (usuario.id= amistad.id_usuario OR usuario.id= amistad.id_usuario2) AND amistad.id = comentario.id_amistad AND usuario.id="
                 + id_usuario);
   } catch (Exception ex) {
     ExceptionBooster.boost(
         new Exception(this.getClass().getName() + ":getCount ERROR: " + ex.getMessage()));
   }
   return pages;
 }
Beispiel #9
0
 public ArrayList<TareaBean> getAllTareaXCurso(Integer intTarea, Integer expand) throws Exception {
   strSQL += " AND tarea.id_asignaturaevaluacion = " + intTarea;
   ArrayList<TareaBean> arrTarea = new ArrayList<>();
   try {
     ResultSet oResultSet = oMysql.getAllSql(strSQL);
     if (oResultSet != null) {
       while (oResultSet.next()) {
         TareaBean oTareaBean = new TareaBean();
         arrTarea.add(oTareaBean.fill(oResultSet, oConnection, expand));
       }
     }
   } catch (Exception ex) {
     ExceptionBooster.boost(
         new Exception(this.getClass().getName() + ":getPage ERROR: " + ex.getMessage()));
   }
   return arrTarea;
 }
Beispiel #10
0
 @Override
 public TareaBean get(TareaBean oTareaBean, Integer expand) throws Exception {
   if (oTareaBean.getId() > 0) {
     try {
       ResultSet oResultSet = oMysql.getAllSql(strSQL + " And id= " + oTareaBean.getId() + " ");
       if (oResultSet != null) {
         while (oResultSet.next()) {
           oTareaBean = oTareaBean.fill(oResultSet, oConnection, expand);
         }
       }
     } catch (Exception ex) {
       ExceptionBooster.boost(
           new Exception(this.getClass().getName() + ":get ERROR: " + ex.getMessage()));
     }
   } else {
     oTareaBean.setId(0);
   }
   return oTareaBean;
 }
  public int getAmistad(int id_usuario, int id_usuario2) throws Exception {
    int num = 0;

    String consulta =
        "select * from amistad where (id_usuario="
            + id_usuario
            + " and id_usuario2="
            + id_usuario2
            + ")";

    ResultSet oResultSet = oMysql.getAllSql(consulta);

    if (oResultSet != null) {
      while (oResultSet.next()) {
        num = oResultSet.getInt("id");
      }
    }
    return num;
  }
  public int getmensajesnuevos(int id_usuario) throws Exception {

    int num = 0;

    strSQL =
        "select count(*) as total from comentario, amistad, usuario where usuario.id= amistad.id_usuario AND amistad.id = comentario.id_amistad AND amistad.id_usuario2="
            + id_usuario
            + " and comentario.leido=0";
    try {
      ResultSet oResultSet = oMysql.getAllSql(strSQL);
      if (oResultSet != null) {
        while (oResultSet.next()) {
          num = oResultSet.getInt("total");
        }
      }
    } catch (Exception ex) {
      ExceptionBooster.boost(
          new Exception(this.getClass().getName() + ":getPage ERROR: " + ex.getMessage()));
    }
    return num;
  }