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