package auktion;
import java.sql.*;

public class Bieterkatalog {

  public boolean status;

//========================================================================================
  public ResultSet getBieterkatalog(int bieter) {
    String sql = "SELECT * FROM auktionskatalog,bieterkataloge " +
                 "WHERE snr=item AND bieterkataloge.bieter=" + bieter;
    try {
      Statement s = Verbindung.getConnection().createStatement();
      return s.executeQuery(sql);
    }
    catch (Exception ex) { return null; }
  }
//========================================================================================
  public void setItem(Bieter bieter, String item) {
    String sql = "INSERT INTO bieterkataloge(bieter,item) " +
                 "VALUES(" + bieter.bnr + "," + item + ")";
    try {
      Statement s = Verbindung.getConnection().createStatement();
      s.executeUpdate(sql);
      status = true;
    }
    catch (Exception ex) { status = false; }
  }
//========================================================================================
  public void delItem(Bieter bieter, String item) {
    String sql = "DELETE FROM bieterkataloge " +
                 "WHERE bieter=" + bieter.bnr + " AND item=" + item;
    try {
      Statement s = Verbindung.getConnection().createStatement();
      s.executeUpdate(sql);
      status = true;
    }
    catch (Exception ex) { status = false; }
  }
}