예제 #1
0
  public boolean deleteTourentag(Tourentag tourentag) throws SQLException, ClassNotFoundException {
    if (tourentag == null || tourentag.getTour() == null) {
      return false;
    }

    Connection c = PostgreSQL_DAOFactory.getConnection();
    Statement s = c.createStatement();
    StringBuffer deleteSql = new StringBuffer();
    deleteSql.append("delete from ");
    deleteSql.append(TABLE_NAME);
    deleteSql.append(" where ");
    deleteSql.append(COLUMN_ID_TOUR);
    deleteSql.append(" = ");
    deleteSql.append(tourentag.getTour().getId());

    s.execute(deleteSql.toString());

    s.close();

    return true;
  }
예제 #2
0
  public int insertTourentag(Tourentag tag) throws SQLException, ClassNotFoundException {
    Connection c = PostgreSQL_DAOFactory.getConnection();
    PreparedStatement ps = null;

    StringBuffer insert = new StringBuffer("insert into ");
    insert.append(TABLE_NAME);
    insert.append(" (");
    insert.append(COLUMN_ID_TOUR);
    insert.append(", ");
    insert.append(COLUMN_TAG);
    insert.append(", ");
    insert.append(COLUMN_BESCHREIBUNG);
    insert.append(", ");
    insert.append(COLUMN_DATUM);
    insert.append(", ");
    insert.append(COLUMN_REGION);
    insert.append(", ");
    insert.append(COLUMN_HMAUFSTIEG);
    insert.append(", ");
    insert.append(COLUMN_HMABSTIEG);
    insert.append(", ");
    insert.append(COLUMN_GEHZEIT);
    insert.append(", ");
    insert.append(COLUMN_SCHWIERIGKT);
    insert.append(", ");
    insert.append(COLUMN_BILDDATEI);
    insert.append(", ");
    insert.append(COLUMN_BILTITEL);
    insert.append(") values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ");

    System.out.println(insert);

    ps = c.prepareStatement(insert.toString());

    ps.setInt(1, tag.getTour().getId());
    ps.setInt(2, tag.getTag());
    ps.setString(3, tag.getBeschreibung());
    ps.setDate(4, tag.getDate());
    ps.setInt(5, tag.getRegion().getId());
    if (tag.getHmAufstieg() != null) {
      ps.setInt(6, tag.getHmAufstieg());
    } else {
      ps.setNull(6, Types.NULL);
    }
    if (tag.getHmAbstieg() != null) {
      ps.setInt(7, tag.getHmAbstieg());
    } else {
      ps.setNull(7, Types.NULL);
    }
    if (tag.getGehzeit() != null) {
      ps.setDouble(8, tag.getGehzeit());
    } else {
      ps.setNull(8, Types.NULL);
    }
    ps.setString(9, tag.getSchwierigkeiten());
    ps.setString(10, tag.getBilddatei());
    ps.setString(11, tag.getBildttitel());

    ps.execute();
    ps.close();

    return 0;
  }
예제 #3
0
  public boolean updateTourentag(Tourentag tag) throws SQLException, ClassNotFoundException {
    Connection c = PostgreSQL_DAOFactory.getConnection();
    PreparedStatement ps = null;

    StringBuffer updateSql = new StringBuffer("update ");
    updateSql.append(TABLE_NAME);
    updateSql.append(" set ");
    updateSql.append(COLUMN_DATUM);
    updateSql.append(" = ?, ");
    updateSql.append(COLUMN_BESCHREIBUNG);
    updateSql.append(" = ?, ");
    updateSql.append(COLUMN_HMAUFSTIEG);
    updateSql.append(" = ?, ");
    updateSql.append(COLUMN_HMABSTIEG);
    updateSql.append(" = ?, ");
    updateSql.append(COLUMN_GEHZEIT);
    updateSql.append(" = ?, ");
    updateSql.append(COLUMN_SCHWIERIGKT);
    updateSql.append(" = ?, ");
    updateSql.append(COLUMN_BILDDATEI);
    updateSql.append(" = ?, ");
    updateSql.append(COLUMN_BILTITEL);
    updateSql.append(" = ?, ");
    updateSql.append(COLUMN_REGION);
    updateSql.append(" = ? ");
    updateSql.append(" where ");
    updateSql.append(COLUMN_ID_TOUR);
    updateSql.append(" = ?");
    updateSql.append(" and ");
    updateSql.append(COLUMN_TAG);
    updateSql.append(" = ?");

    System.out.println(updateSql);

    ps = c.prepareStatement(updateSql.toString());

    ps.setDate(1, tag.getDate());
    ps.setString(2, tag.getBeschreibung());
    if (tag.getHmAufstieg() != null) {
      ps.setInt(3, tag.getHmAufstieg());
    } else {
      ps.setNull(3, Types.NULL);
    }
    if (tag.getHmAbstieg() != null) {
      ps.setInt(4, tag.getHmAbstieg());
    } else {
      ps.setNull(4, Types.NULL);
    }
    if (tag.getGehzeit() != null) {
      ps.setDouble(5, tag.getGehzeit());
    } else {
      ps.setNull(5, Types.NULL);
    }
    ps.setString(6, tag.getSchwierigkeiten());
    ps.setString(7, tag.getBilddatei());
    ps.setString(8, tag.getBildttitel());
    ps.setInt(9, tag.getRegion().getId());
    ps.setInt(10, tag.getTour().getId());
    ps.setInt(11, tag.getTag());

    ps.execute();
    ps.close();

    return true;
  }