Package club.beans

Examples of club.beans.MembershipTypeBean

35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
        try {
            conn = ConnectDB.connectMSDB();
            stmt = conn.createStatement();
            rs = stmt.executeQuery(query);
            while (rs.next()) {
                MembershipTypeBean membership = new MembershipTypeBean();
                membership.setMembershipTypeID(rs.getInt("MembershipTypeID"));
                membership.setTypeName(rs.getNString("TypeName"));
                membership.setFee(rs.getDouble("Fee"));
                membership.setMin_Attendance(rs.getInt("Min_Attendance"));
                membership.setMain_Duty(rs.getNString("Main_Duty"));
                membership.setDiscount(rs.getInt("Discount"));
                list.add(membership);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
View Full Code Here
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
        if (selectedRow == -1) {
            JOptionPane.showMessageDialog(rootPane, "You must chose one membership type first!", "Error!", JOptionPane.ERROR_MESSAGE);
        } else {
            int id = (int) tblMembership.getModel().getValueAt(selectedRow, 0);
            DataMembership dataMembership = new DataMembership();
            MembershipTypeBean bean = dataMembership.getTypeByID(id);
            txtTypeName.setText(bean.getTypeName());
            txtMainDuty.setText(bean.getMain_Duty());
            spinFee.setValue(bean.getFee());
            spinMinAttendance.setValue(bean.getMin_Attendance());
            spinDiscount.setValue(bean.getDiscount());
            txtHiddenID.setText(String.valueOf(bean.getMembershipTypeID()));
            panelForm.setVisible(true);
            this.setSize(this.getWidth(), 450);
            actionFlag = "Update";
        }
    }//GEN-LAST:event_btn_UpdateActionPerformed
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
        }
        return model;
    }

    public MembershipTypeBean getTypeByID(int id) {
        MembershipTypeBean bean = null;
        String query = "SELECT * FROM MembershipType"
                + " WHERE MembershipTypeID=" + id;
        try {
            conn = ConnectDB.connectMSDB();
            stmt = conn.createStatement();
            rs = stmt.executeQuery(query);
            if (rs.next()) {
                bean = new MembershipTypeBean();
                bean.setMembershipTypeID(rs.getInt("MembershipTypeID"));
                bean.setTypeName(rs.getNString("TypeName"));
                bean.setFee(rs.getDouble("Fee"));
                bean.setMin_Attendance(rs.getInt("Min_Attendance"));
                bean.setMain_Duty(rs.getNString("Main_Duty"));
                bean.setDiscount(rs.getInt("Discount"));
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
View Full Code Here
TOP

Related Classes of club.beans.MembershipTypeBean

  • club.data.DataMembership
  • club.ui.MembershipDialog
    • 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.