Exemplo n.º 1
0
  public boolean delete(Object[] obj) {
    // TODO Auto-generated method stub
    System.out.println(obj[0] + "  " + obj[1]);
    String sql = "delete from volunteerActive where activeId=? and volunteerId=? ";

    DbManager db = new DbManager();

    return db.execute(sql, obj);
  }
Exemplo n.º 2
0
  public boolean add(Object[] obj) {
    // TODO Auto-generated method stub
    String sql =
        "insert into volunteerActive"
            + " (activeId,volunteerId,"
            + "activeDate,activeContent,activeHours,confirmPeople,evaluation) "
            + "values (?,?,?,?,?,?,?) ";
    DbManager db = new DbManager();

    return db.execute(sql, obj);
  }
Exemplo n.º 3
0
  public boolean update(Object[] obj) {
    // TODO Auto-generated method stub

    // "update active set activeTitle=?,activeContent=?,activePublisher=? where activeId=?";

    // String sql = "update volunteerActive set
    // activeDate='?',activeContent='?',activeHours=?,confirmPeople='?' where activeId=? and
    // volunteerId=?" ;

    String sql =
        "update volunteerActive set activeDate=?,activeContent=?,activeHours=?,confirmPeople=?,evaluation=? where activeId=? and volunteerId=?";

    DbManager db = new DbManager();

    return db.execute(sql, obj);
  }