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;
}
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;
}
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;
}