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