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