package auktion;
import java.sql.*;

public class Bieter {

  public boolean status;
  public int bnr, privileg;
  public String nachname, vorname, plz, ort, strasse, uid, passwd;

  public Bieter(String uid, String passwd) {
    try {
      Statement s = Verbindung.getConnection().createStatement();
      String sql = "SELECT * FROM Bieter WHERE uid LIKE '" + uid +
                                     "' AND passwd LIKE '" + passwd + "'";
      ResultSet rset = s.executeQuery(sql);
      if (rset.next()) {
        status = true;
        this.uid = uid;
        bnr = rset.getInt("bnr");
        nachname = rset.getString("nachname");
        vorname = rset.getString("vorname");
        plz = rset.getString("plz");
        ort = rset.getString("ort");
        strasse = rset.getString("strasse");
        passwd = rset.getString("passwd");
        privileg = rset.getInt("privileg");
      }
      else status = false;
    }
    catch (Exception ex) { status = false; }
  }
}