Package id.keda87.clickrental.utilities

Examples of id.keda87.clickrental.utilities.ConnectionPool

59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
    public List<Film> getAllFilm() {
        List<Film> list = new ArrayList<>();
        try (PreparedStatement stat = cp.getConn().prepareStatement("select * from film order by id")) {
            ResultSet res = stat.executeQuery();
            while (res.next()) {
                Film film = new Film();
                film.setId(res.getInt("id"));
                film.setNamaFilm(res.getString("namafilm"));
                film.setTahunTerbit(res.getString("tahunterbit"));
                film.setProduksi(res.getString("produksi"));
                film.setStatusKembali(res.getString("statuskembali"));
                list.add(film);
            }
        } catch (SQLException ex) {
            Logger.getLogger(ConcreteFilmDao.class.getName()).log(Level.SEVERE, null, ex);
        }
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
            stat.setString(3, "%" + keyword + "%");
            stat.setString(4, "%" + keyword + "%");
            stat.setString(5, "%" + keyword + "%");
            ResultSet res = stat.executeQuery();
            while (res.next()) {
                Film film = new Film();
                film.setId(res.getInt("id"));
                film.setNamaFilm(res.getString("namafilm"));
                film.setTahunTerbit(res.getString("tahunterbit"));
                film.setProduksi(res.getString("produksi"));
                film.setStatusKembali(res.getString("statuskembali"));
                list.add(film);
            }
        } catch (SQLException ex) {
            Logger.getLogger(ConcreteFilmDao.class.getName()).log(Level.SEVERE, null, ex);
        }
View Full Code Here
104
105
106
107
108
109
110
111
112
113
114
115
    public List<Film> getAllNamaFilm() {
        List<Film> namafilm = new ArrayList<>();
        try (PreparedStatement stat = cp.getConn().prepareStatement("select namafilm from film where statuskembali = 'Tersedia'")) {
            ResultSet res = stat.executeQuery();
            while (res.next()) {
                Film namaFilm = new Film();
                namaFilm.setNamaFilm(res.getString("namafilm"));
                namafilm.add(namaFilm);
            }
        } catch (SQLException ex) {
            Logger.getLogger(ConcreteFilmDao.class.getName()).log(Level.SEVERE, null, ex);
        }
View Full Code Here
121
122
123
124
125
126
127
128
129
130
131
132
        List<Film> kodefilm = new ArrayList<>();
        try (PreparedStatement stat = cp.getConn().prepareStatement("select id from film where namafilm = ?")) {
            stat.setString(1, namaFilm);
            ResultSet res = stat.executeQuery();
            if (res.next()) {
                Film kodeFilm = new Film();
                kodeFilm.setId(res.getInt("id"));
                kodefilm.add(kodeFilm);
            }
        } catch (SQLException ex) {
            Logger.getLogger(ConcreteFilmDao.class.getName()).log(Level.SEVERE, null, ex);
        }
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
40
41
42
    public void insert() {
        if (memberview1.getTfidentitas().getText().isEmpty() || memberview1.getTfnama().getText().isEmpty()
                || memberview1.getTfhandphone().getText().isEmpty() || memberview1.getTfalamat().getText().isEmpty()) {
            JOptionPane.showMessageDialog(memberview1, "Form Harap Diisi lengkap & Tidak Kosong.", "Kesalahan", JOptionPane.WARNING_MESSAGE);
        } else {
            Member member = new Member();
            member.setId(memberview1.getTfidentitas().getText().trim());
            member.setNama(memberview1.getTfnama().getText().trim().toUpperCase());
            member.setNomorhandphone(memberview1.getTfhandphone().getText().trim().toUpperCase());
            member.setAlamat(memberview1.getTfalamat().getText().trim().toUpperCase());
            serviceMember.insertMember(member);
            JOptionPane.showMessageDialog(memberview1, "Data Member Berhasil Ditambahkan.", "Tambah Data Berhasil", JOptionPane.INFORMATION_MESSAGE);
        }
    }
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
55
56
57
    public void update() {
        if (memberview2.getTffidentitas().getText().isEmpty() || memberview2.getTffNama().getText().isEmpty() || memberview2.getTffHandpjone().getText().isEmpty()
                || memberview2.getTffAlamat().getText().isEmpty()) {
            JOptionPane.showMessageDialog(memberview2, "Form Harap Diisi lengkap & Tidak Kosong.", "Kesalahan", JOptionPane.WARNING_MESSAGE);
        } else {
            Member member = new Member();
            member.setId(memberview2.getTffidentitas().getText().trim().toUpperCase());
            member.setNama(memberview2.getTffNama().getText().trim().toUpperCase());
            member.setNomorhandphone(memberview2.getTffHandpjone().getText().trim().toUpperCase());
            member.setAlamat(memberview2.getTffAlamat().getText().trim().toUpperCase());
            serviceMember.updateMember(member);
            JOptionPane.showMessageDialog(memberview2, "Data Member Berhasil Disunting.", "Tambah Data Berhasil", JOptionPane.INFORMATION_MESSAGE);
        }
    }
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
    public void isiTable() {
        daftarMember = serviceMember.getAllMember();
        Object[][] data = new Object[daftarMember.size()][4];
        int baris = 0;
        for (Iterator<Member> it = daftarMember.iterator(); it.hasNext();) {
            Member member = it.next();
            data[baris][0] = member.getId();
            data[baris][1] = member.getNama();
            data[baris][2] = member.getNomorhandphone();
            data[baris][3] = member.getAlamat();
            baris++;
        }
        String header[] = {"NOMOR IDENTITAS", "NAMA", "NO. HANDPHONE", "ALAMAT"};
        DefaultTableModel model = new DefaultTableModel(data, header);
        memberview2.getTableMember().setModel(model);
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
    public void Pencarian(String keyword){
        daftarMember = serviceMember.getSearchMember(keyword);
        Object[][] data = new Object[daftarMember.size()][4];
        int baris = 0;
        for (Iterator<Member> it = daftarMember.iterator(); it.hasNext();) {
            Member member = it.next();
            data[baris][0] = member.getId();
            data[baris][1] = member.getNama();
            data[baris][2] = member.getNomorhandphone();
            data[baris][3] = member.getAlamat();
            baris++;
        }
        String header[] = {"NOMOR IDENTITAS", "NAMA", "NO. HANDPHONE", "ALAMAT"};
        DefaultTableModel model = new DefaultTableModel(data, header);
        memberview2.getTableMember().setModel(model);
View Full Code Here
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
    public List getAllMember() {
        List daftarMember = new ArrayList();
        try (PreparedStatement stat = cp.getConn().prepareStatement("select * from member")) {
            ResultSet res = stat.executeQuery();
            while (res.next()) {
                Member member = new Member();
                member.setId(res.getString("id"));
                member.setNama(res.getString("nama"));
                member.setNomorhandphone(res.getString("handphone"));
                member.setAlamat(res.getString("alamat"));
                daftarMember.add(member);
            }
        } catch (SQLException ex) {
            Logger.getLogger(ConcreteMemberDao.class.getName()).log(Level.SEVERE, null, ex);
        }
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
            stat.setString(2, "%" + keyword + "%");
            stat.setString(3, "%" + keyword + "%");
            stat.setString(4, "%" + keyword + "%");
            ResultSet res = stat.executeQuery();
            while (res.next()) {
                Member member = new Member();
                member.setId(res.getString("id"));
                member.setNama(res.getString("nama"));
                member.setNomorhandphone(res.getString("handphone"));
                member.setAlamat(res.getString("alamat"));
                daftarMember.add(member);
            }
        } catch (SQLException ex) {
            Logger.getLogger(ConcreteMemberDao.class.getName()).log(Level.SEVERE, null, ex);
        }
View Full Code Here
TOP

Related Classes of id.keda87.clickrental.utilities.ConnectionPool

  • de.javasoft.plaf.synthetica.SyntheticaAluOxideLookAndFeel
  • id.keda87.clickrental.controller.ControllerFilm
  • id.keda87.clickrental.controller.ControllerMember
  • id.keda87.clickrental.controller.ControllerSettingHarga
  • id.keda87.clickrental.controller.ControllerStaff
  • id.keda87.clickrental.controller.ControllerTransaksi
  • id.keda87.clickrental.dao.ConcreteFilmDao
  • id.keda87.clickrental.dao.ConcreteMemberDao
  • id.keda87.clickrental.dao.ConcreteNominalDao
  • id.keda87.clickrental.dao.ConcreteStaffDao
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.