// 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;
}
// Kitap guncelleme
public void updateKitap(Kitap kitap, int param) {
Connection connection = null;
PreparedStatement preparedStatement = null;
String updateString =
"UPDATE `kitaplar` SET `isbnno`=?, `kitapad`=?, `yazarid`=?, `tur`=?,`yayintarihi`=?,`yayinevi`=?,`sayfa`=? WHERE `isbnno`=?";
try {
connection = ConnectionConfiguration.getConnection();
preparedStatement = connection.prepareStatement(updateString);
preparedStatement.setInt(1, kitap.getIsbnno());
preparedStatement.setString(2, kitap.getKitapad());
preparedStatement.setInt(3, kitap.getYazarid());
preparedStatement.setString(4, kitap.getTur());
preparedStatement.setString(5, kitap.getYayintarihi());
preparedStatement.setString(6, kitap.getYayinevi());
preparedStatement.setInt(7, kitap.getSayfa());
preparedStatement.setInt(8, param);
preparedStatement.executeUpdate();
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e.getMessage());
} finally {
kapatici(connection, preparedStatement, null);
}
}
// Kitap Kayıt
public void insertKitap(Kitap kitap) {
Connection connection = null;
PreparedStatement preparedStatement = null;
String query =
"INSERT INTO kitaplar (`isbnno`, `kitapad`, `yazarid`, `tur`,`yayintarihi`,`yayinevi`,`sayfa`) VALUES (?,?,?,?,?,?,?)";
try {
connection = ConnectionConfiguration.getConnection();
preparedStatement = connection.prepareStatement(query);
preparedStatement.setInt(1, kitap.getIsbnno());
preparedStatement.setString(2, kitap.getKitapad());
preparedStatement.setInt(3, kitap.getYazarid());
preparedStatement.setString(4, kitap.getTur());
preparedStatement.setString(5, kitap.getYayintarihi());
preparedStatement.setString(6, kitap.getYayinevi());
preparedStatement.setInt(7, kitap.getSayfa());
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);
}
}
