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