// Uye güncelleme
  public void updateUye(Uyeler uye, String param) {
    Connection connection = null;
    PreparedStatement preparedStatement = null;
    String updateString =
        "UPDATE `uyeler` SET `tc`=?, `ad`=?, `soyad`=?, `meslek`=?,`adres`=?,`telefon`=?,`mail`=?,`kullaniciadi`=?,`sifre`=? WHERE `tc`=?";

    try {
      connection = ConnectionConfiguration.getConnection();
      preparedStatement = connection.prepareStatement(updateString);

      preparedStatement.setString(1, uye.getTc());
      preparedStatement.setString(2, uye.getAd());
      preparedStatement.setString(3, uye.getSoyad());
      preparedStatement.setString(4, uye.getMeslek());
      preparedStatement.setString(5, uye.getAdres());
      preparedStatement.setString(6, uye.getTelefon());
      preparedStatement.setString(7, uye.getMail());
      preparedStatement.setString(8, uye.getKullaniciadi());
      preparedStatement.setString(9, uye.getSifre());
      preparedStatement.setString(10, param);
      preparedStatement.executeUpdate();

      JOptionPane.showMessageDialog(null, "Successful UPDATE");

    } catch (Exception e) {
      JOptionPane.showMessageDialog(null, e.getMessage());
    } finally {
      kapatici(connection, preparedStatement, null);
    }
  }
  // Uye Kayıt
  public void insertUye(Uyeler uye) {
    Connection connection = null;
    PreparedStatement preparedStatement = null;
    String query =
        "INSERT INTO uyeler (`tc`, `ad`, `soyad`, `meslek`,`adres`,`telefon`,`mail`,`kullaniciadi`,`sifre`) VALUES (?,?,?,?,?,?,?,?,?)";
    try {
      connection = ConnectionConfiguration.getConnection();
      preparedStatement = connection.prepareStatement(query);
      preparedStatement.setString(1, uye.getTc());
      preparedStatement.setString(2, uye.getAd());
      preparedStatement.setString(3, uye.getSoyad());
      preparedStatement.setString(4, uye.getMeslek());
      preparedStatement.setString(5, uye.getAdres());
      preparedStatement.setString(6, uye.getTelefon());
      preparedStatement.setString(7, uye.getMail());
      preparedStatement.setString(8, uye.getKullaniciadi());
      preparedStatement.setString(9, uye.getSifre());
      preparedStatement.executeUpdate();

      JOptionPane.showMessageDialog(null, "Successful INSERT INTO");

    } catch (Exception e) {
      JOptionPane.showMessageDialog(null, "Kayıtta hata oluştu \n" + e.getMessage());
    } finally {
      kapatici(connection, preparedStatement, null);
    }
  }
  // Uyeler icin arama metodu
  public List<Uyeler> selectByUye(String kriter, String param) {
    List<Uyeler> uyeler = new ArrayList<Uyeler>();
    Connection connection = null;
    PreparedStatement preparedStatement = null;
    ResultSet resultSet = null;

    try {
      connection = ConnectionConfiguration.getConnection();
      preparedStatement =
          connection.prepareStatement("SELECT * FROM uyeler WHERE " + kriter + " LIKE ?");
      preparedStatement.setString(1, "%" + param + "%");
      resultSet = preparedStatement.executeQuery();
      while (resultSet.next()) {
        Uyeler uye = new Uyeler();
        uye.setId(resultSet.getInt("id"));
        uye.setTc(resultSet.getString("tc"));
        uye.setAd(resultSet.getString("ad"));
        uye.setSoyad(resultSet.getString("soyad"));
        uye.setMeslek(resultSet.getString("meslek"));
        uye.setAdres(resultSet.getString("adres"));
        uye.setTelefon(resultSet.getString("telefon"));
        uye.setMail(resultSet.getString("mail"));
        uye.setKullaniciadi(resultSet.getString("kullaniciadi"));
        uye.setSifre(resultSet.getString("sifre"));

        uyeler.add(uye);
      }
    } catch (Exception e) {
      JOptionPane.showMessageDialog(null, e.getMessage());
    } finally {
      kapatici(connection, preparedStatement, resultSet);
    }
    return uyeler;
  }