// kitaplar icin arama metodu
public List<Kitap> selectByKitap(String kriter, String param) {
List<Kitap> kitaplar = new ArrayList<Kitap>();
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
try {
connection = ConnectionConfiguration.getConnection();
preparedStatement =
connection.prepareStatement("SELECT * FROM kitaplar WHERE " + kriter + " LIKE ?");
preparedStatement.setString(1, "%" + param + "%");
resultSet = preparedStatement.executeQuery();
while (resultSet.next()) {
Kitap kitap = new Kitap();
kitap.setId(resultSet.getInt("id"));
kitap.setIsbnno(resultSet.getInt("isbnno"));
kitap.setKitapad(resultSet.getString("kitapad"));
kitap.setYazarid(resultSet.getInt("yazarid"));
kitap.setTur(resultSet.getString("tur"));
kitap.setYayintarihi(resultSet.getString("yayintarihi"));
kitap.setYayinevi(resultSet.getString("yayinevi"));
kitap.setSayfa(resultSet.getInt("sayfa"));
kitaplar.add(kitap);
}
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e.getMessage());
} finally {
kapatici(connection, preparedStatement, resultSet);
}
return kitaplar;
}
