Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package Database;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.util.ArrayList;
- import java.util.List;
- import domain.Kunde;
- public class KundeSøgning {
- // private TableView<KundeSøgning> TW;
- // private ObservableList data;
- public List<Kunde> SøgKunde(Kunde kunde) {
- List<Kunde> list = new ArrayList<>();
- try (Connection connection = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/mydb", "SA", "");
- PreparedStatement statement = connection.prepareStatement("SELECT navn,adresse,telefonnummer, cpr_cvr, kundeid from kundeoplysninger");) {
- ResultSet rs = statement.executeQuery();
- while (rs.next()) {
- Kunde k = new Kunde();
- k.setNavn(rs.getString("navn"));
- k.setAdresse(rs.getString("adresse"));
- k.setTelefon(rs.getString("telefonnummer"));
- k.setCpr_cvr(rs.getString("cpr_cvr"));
- k.setKundeid(rs.getString("kundeid"));
- list.add(k);
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return list;
- }
- }
- package BankLogik;
- import java.util.List;
- import Database.KundeSøgning;
- import Database.KundeVedligehold;
- import domain.Kunde;
- public class BankImpl {
- private KundeVedligehold kundedata = new KundeVedligehold();
- public void opretKunde(Kunde kunde) {
- kundedata.Opretkunde(kunde);
- }
- private KundeSøgning søgning = new KundeSøgning();
- public List<Kunde> søgKunde(Kunde kunde) {
- return søgning.SøgKunde(kunde);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement