API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 26th, 2019
85
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 68.56 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. * To change this license header, choose License Headers in Project Properties.
  3. * To change this template file, choose Tools | Templates
  4. * and open the template in the editor.
  5. */
  6.  
  7. /**
  8. *
  9. * @author PAlios Sou
  10. */
  11. import java.sql.*;
  12. import java.util.*;
  13. import java.sql.Connection;
  14. import java.sql.DriverManager;
  15. import java.sql.SQLException;
  16. import java.util.logging.Level;
  17. import java.util.logging.Logger;
  18. import java.util.UUID;
  19. import net.proteanit.sql.DbUtils;
  20.  
  21.  
  22. public class MainMenu extends javax.swing.JFrame {
  23.  
  24. /**
  25. * Creates new form MainMenu
  26. */
  27. public MainMenu() {
  28. initComponents();
  29. }
  30.  
  31. //RANDOM NUMBER GENERATOR USED FOR ID
  32. public static int gen() {
  33. Random r = new Random( System.currentTimeMillis() );
  34. return 10000 + r.nextInt(20000);
  35. }
  36.  
  37.  
  38. private void deleteMember()throws SQLException{
  39. //function to delete records from the database
  40. String connectionURL = "jdbc:derby://localhost:1527/MembersManagement";
  41. String uName = "ael";
  42. String uPass= "ael";
  43.  
  44. String sql = "DELETE FROM AEL.MEMBERS WHERE ID=?";
  45.  
  46. ResultSet rs=null;
  47. Connection conn = DriverManager.getConnection(connectionURL, uName, uPass);
  48. System.out.println("Deleting Record from database...");
  49. PreparedStatement st=conn.prepareStatement(sql);
  50. st.setString(1,deleteTxt.getText());
  51. String message=deleteTxt.getText();
  52. int error = st.executeUpdate();
  53.  
  54. deleteLabel.setText("User Deleted");
  55. refreshTbl();
  56.  
  57.  
  58.  
  59.  
  60. }
  61.  
  62.  
  63.  
  64. public static void registerMember(String ID, String Name, String Surname,String Phone,String Home, String Email,String Address,String PostCode,String Dob,String MemberShip) throws SQLException{
  65.  
  66.  
  67.  
  68. System.out.println("Working");
  69.  
  70. //, String Name, String Surname, String Email, String Address, String PostCode,Integer Phone,Integer Home
  71.  
  72. String connectionURL = "jdbc:derby://localhost:1527/MembersManagement";
  73. String uName = "ael";
  74. String uPass= "ael";
  75.  
  76. Connection conn = DriverManager.getConnection(connectionURL, uName, uPass);
  77. System.out.println("Connect to database...");
  78. String sql = "SELECT * FROM MEMBERS";
  79. Statement st = conn.createStatement();
  80. ResultSet rs=null;
  81. rs=st.executeQuery(sql);
  82.  
  83. sql="INSERT INTO AEL.MEMBERS VALUES ('"+ID+"','"+Name+"','"+Surname+"','"+Email+"','"+Phone+"','"+Home+"','"+PostCode+"','"+Address+"','"+Dob+"','"+MemberShip+"')";
  84.  
  85. st.executeUpdate(sql);
  86.  
  87.  
  88.  
  89.  
  90.  
  91.  
  92. }
  93.  
  94. public void refreshTbl() throws SQLException{
  95. String connectionURL = "jdbc:derby://localhost:1527/MembersManagement";
  96. String uName = "ael";
  97. String uPass= "ael";
  98.  
  99. Connection conn = DriverManager.getConnection(connectionURL, uName, uPass);
  100. System.out.println("Refreshing the table...");
  101.  
  102. String sql="SELECT * FROM MEMBERS";
  103. Statement st = conn.createStatement();
  104. ResultSet rs=null;
  105. rs=st.executeQuery(sql);
  106. MembersTbl.setModel(DbUtils.resultSetToTableModel(rs));
  107.  
  108.  
  109. }
  110. /**
  111. * This method is called from within the constructor to initialize the form.
  112. * WARNING: Do NOT modify this code. The content of this method is always
  113. * regenerated by the Form Editor.+
  114. */
  115. @SuppressWarnings("unchecked")
  116. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  117. private void initComponents() {
  118.  
  119. mainPanel = new javax.swing.JPanel();
  120. buttonspanel = new javax.swing.JPanel();
  121. jButton1 = new javax.swing.JButton();
  122. jButton3 = new javax.swing.JButton();
  123. jButton2 = new javax.swing.JButton();
  124. jPanelIncluding3Panels = new javax.swing.JPanel();
  125. jPanelWelcome = new javax.swing.JPanel();
  126. jLabel1 = new javax.swing.JLabel();
  127. jLabel2 = new javax.swing.JLabel();
  128. jPanel3 = new javax.swing.JPanel();
  129. jPanel4 = new javax.swing.JPanel();
  130. jPanelAddMember = new javax.swing.JPanel();
  131. jLabel3 = new javax.swing.JLabel();
  132. emailTextF = new javax.swing.JTextField();
  133. jLabel4 = new javax.swing.JLabel();
  134. jLabel5 = new javax.swing.JLabel();
  135. jLabel6 = new javax.swing.JLabel();
  136. jLabel7 = new javax.swing.JLabel();
  137. jLabel8 = new javax.swing.JLabel();
  138. membership = new javax.swing.JComboBox();
  139. RegisterButton = new javax.swing.JButton();
  140. ResetButton = new javax.swing.JButton();
  141. addressTextF = new javax.swing.JTextField();
  142. postcodeTextF = new javax.swing.JTextField();
  143. surnameTextF = new javax.swing.JTextField();
  144. nameTextF = new javax.swing.JTextField();
  145. jPanel6 = new javax.swing.JPanel();
  146. jLabel16 = new javax.swing.JLabel();
  147. jLabel17 = new javax.swing.JLabel();
  148. jLabel18 = new javax.swing.JLabel();
  149. homeTextF = new javax.swing.JTextField();
  150. phoneTextF = new javax.swing.JTextField();
  151. dobTextF = new javax.swing.JTextField();
  152. jPanelSearchEditDelete = new javax.swing.JPanel();
  153. bUpdate = new javax.swing.JButton();
  154. DeleteB = new javax.swing.JButton();
  155. resetB = new javax.swing.JButton();
  156. searchButton = new javax.swing.JButton();
  157. jLabel14 = new javax.swing.JLabel();
  158. jScrollPane1 = new javax.swing.JScrollPane();
  159. MembersTbl = new javax.swing.JTable();
  160. jPanel5 = new javax.swing.JPanel();
  161. jLabel15 = new javax.swing.JLabel();
  162. jLabel19 = new javax.swing.JLabel();
  163. jLabel20 = new javax.swing.JLabel();
  164. jLabel21 = new javax.swing.JLabel();
  165. jLabel22 = new javax.swing.JLabel();
  166. jLabel23 = new javax.swing.JLabel();
  167. jLabel24 = new javax.swing.JLabel();
  168. jLabel25 = new javax.swing.JLabel();
  169. jLabel26 = new javax.swing.JLabel();
  170. membershipEditForm = new javax.swing.JComboBox();
  171. idtxt = new javax.swing.JTextField();
  172. surnametxt = new javax.swing.JTextField();
  173. emailtxt = new javax.swing.JTextField();
  174. addresstxt = new javax.swing.JTextField();
  175. postcodetxt = new javax.swing.JTextField();
  176. phonetxt = new javax.swing.JTextField();
  177. hometxt = new javax.swing.JTextField();
  178. dobtxt = new javax.swing.JTextField();
  179. jLabel27 = new javax.swing.JLabel();
  180. nametxt1 = new javax.swing.JTextField();
  181. searchtxt = new javax.swing.JTextField();
  182. jLabel9 = new javax.swing.JLabel();
  183. deleteTxt = new javax.swing.JTextField();
  184. jLabel10 = new javax.swing.JLabel();
  185. deleteLabel = new javax.swing.JLabel();
  186.  
  187. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  188.  
  189. mainPanel.setBackground(new java.awt.Color(204, 204, 204));
  190.  
  191. buttonspanel.setBackground(new java.awt.Color(0, 0, 153));
  192.  
  193. jButton1.setBackground(new java.awt.Color(255, 255, 255));
  194. jButton1.setFont(new java.awt.Font("Arial", 1, 18)); // NOI18N
  195. jButton1.setText("ADD MEMBER");
  196. jButton1.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white));
  197. jButton1.setMaximumSize(new java.awt.Dimension(100, 100));
  198. jButton1.setMinimumSize(new java.awt.Dimension(100, 100));
  199. jButton1.setPreferredSize(new java.awt.Dimension(100, 100));
  200. jButton1.addActionListener(new java.awt.event.ActionListener() {
  201. public void actionPerformed(java.awt.event.ActionEvent evt) {
  202. jButton1ActionPerformed(evt);
  203. }
  204. });
  205.  
  206. jButton3.setFont(new java.awt.Font("Arial", 1, 18)); // NOI18N
  207. jButton3.setText("EXIT");
  208. jButton3.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white));
  209. jButton3.setMaximumSize(new java.awt.Dimension(100, 100));
  210. jButton3.setMinimumSize(new java.awt.Dimension(100, 100));
  211. jButton3.setPreferredSize(new java.awt.Dimension(100, 100));
  212. jButton3.addActionListener(new java.awt.event.ActionListener() {
  213. public void actionPerformed(java.awt.event.ActionEvent evt) {
  214. jButton3ActionPerformed(evt);
  215. }
  216. });
  217.  
  218. jButton2.setBackground(new java.awt.Color(255, 255, 255));
  219. jButton2.setFont(new java.awt.Font("Arial", 1, 18)); // NOI18N
  220. jButton2.setText("SEARCH EDIT DELETE");
  221. jButton2.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white));
  222. jButton2.setMaximumSize(new java.awt.Dimension(100, 100));
  223. jButton2.setMinimumSize(new java.awt.Dimension(100, 100));
  224. jButton2.setPreferredSize(new java.awt.Dimension(100, 100));
  225. jButton2.addActionListener(new java.awt.event.ActionListener() {
  226. public void actionPerformed(java.awt.event.ActionEvent evt) {
  227. jButton2ActionPerformed(evt);
  228. }
  229. });
  230.  
  231. javax.swing.GroupLayout buttonspanelLayout = new javax.swing.GroupLayout(buttonspanel);
  232. buttonspanel.setLayout(buttonspanelLayout);
  233. buttonspanelLayout.setHorizontalGroup(
  234. buttonspanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  235. .addGroup(buttonspanelLayout.createSequentialGroup()
  236. .addContainerGap()
  237. .addGroup(buttonspanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  238. .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 193, javax.swing.GroupLayout.PREFERRED_SIZE)
  239. .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 193, javax.swing.GroupLayout.PREFERRED_SIZE)
  240. .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 189, javax.swing.GroupLayout.PREFERRED_SIZE))
  241. .addContainerGap(20, Short.MAX_VALUE))
  242. );
  243. buttonspanelLayout.setVerticalGroup(
  244. buttonspanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  245. .addGroup(buttonspanelLayout.createSequentialGroup()
  246. .addGap(22, 22, 22)
  247. .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 168, javax.swing.GroupLayout.PREFERRED_SIZE)
  248. .addGap(137, 137, 137)
  249. .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 183, javax.swing.GroupLayout.PREFERRED_SIZE)
  250. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  251. .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 184, javax.swing.GroupLayout.PREFERRED_SIZE)
  252. .addGap(91, 91, 91))
  253. );
  254.  
  255. jPanelIncluding3Panels.setBackground(new java.awt.Color(0, 0, 153));
  256. jPanelIncluding3Panels.setLayout(new java.awt.CardLayout());
  257.  
  258. jPanelWelcome.setBackground(new java.awt.Color(204, 204, 204));
  259. jPanelWelcome.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white));
  260.  
  261. jLabel1.setFont(new java.awt.Font("Cambria Math", 1, 48)); // NOI18N
  262. jLabel1.setText("WELCOME TO THE ");
  263.  
  264. jLabel2.setFont(new java.awt.Font("Cambria Math", 1, 48)); // NOI18N
  265. jLabel2.setText("RECEPTIONIST GUI");
  266.  
  267. jPanel3.setBackground(new java.awt.Color(0, 0, 153));
  268. jPanel3.setForeground(new java.awt.Color(0, 0, 102));
  269.  
  270. javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
  271. jPanel3.setLayout(jPanel3Layout);
  272. jPanel3Layout.setHorizontalGroup(
  273. jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  274. .addGap(0, 817, Short.MAX_VALUE)
  275. );
  276. jPanel3Layout.setVerticalGroup(
  277. jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  278. .addGap(0, 399, Short.MAX_VALUE)
  279. );
  280.  
  281. jPanel4.setBackground(new java.awt.Color(0, 0, 153));
  282. jPanel4.setForeground(new java.awt.Color(0, 0, 102));
  283.  
  284. javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4);
  285. jPanel4.setLayout(jPanel4Layout);
  286. jPanel4Layout.setHorizontalGroup(
  287. jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  288. .addGap(0, 0, Short.MAX_VALUE)
  289. );
  290. jPanel4Layout.setVerticalGroup(
  291. jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  292. .addGap(0, 265, Short.MAX_VALUE)
  293. );
  294.  
  295. javax.swing.GroupLayout jPanelWelcomeLayout = new javax.swing.GroupLayout(jPanelWelcome);
  296. jPanelWelcome.setLayout(jPanelWelcomeLayout);
  297. jPanelWelcomeLayout.setHorizontalGroup(
  298. jPanelWelcomeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  299. .addComponent(jPanel3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  300. .addComponent(jPanel4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  301. .addGroup(jPanelWelcomeLayout.createSequentialGroup()
  302. .addGap(175, 175, 175)
  303. .addGroup(jPanelWelcomeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  304. .addComponent(jLabel2)
  305. .addComponent(jLabel1))
  306. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  307. );
  308. jPanelWelcomeLayout.setVerticalGroup(
  309. jPanelWelcomeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  310. .addGroup(jPanelWelcomeLayout.createSequentialGroup()
  311. .addComponent(jPanel4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  312. .addGap(18, 18, 18)
  313. .addComponent(jLabel1)
  314. .addGap(55, 55, 55)
  315. .addComponent(jLabel2)
  316. .addGap(18, 18, 18)
  317. .addComponent(jPanel3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  318. );
  319.  
  320. jPanelIncluding3Panels.add(jPanelWelcome, "card2");
  321.  
  322. jPanelAddMember.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white));
  323.  
  324. jLabel3.setFont(new java.awt.Font("Arial", 1, 36)); // NOI18N
  325. jLabel3.setText("Name:");
  326.  
  327. emailTextF.addActionListener(new java.awt.event.ActionListener() {
  328. public void actionPerformed(java.awt.event.ActionEvent evt) {
  329. emailTextFActionPerformed(evt);
  330. }
  331. });
  332.  
  333. jLabel4.setFont(new java.awt.Font("Arial", 1, 36)); // NOI18N
  334. jLabel4.setText("Surname:");
  335.  
  336. jLabel5.setFont(new java.awt.Font("Arial", 1, 36)); // NOI18N
  337. jLabel5.setText("E-mail:");
  338.  
  339. jLabel6.setFont(new java.awt.Font("Arial", 1, 36)); // NOI18N
  340. jLabel6.setText("Address:");
  341.  
  342. jLabel7.setFont(new java.awt.Font("Arial", 1, 36)); // NOI18N
  343. jLabel7.setText("Post Code:");
  344.  
  345. jLabel8.setFont(new java.awt.Font("Arial", 1, 36)); // NOI18N
  346. jLabel8.setText("Date Of Birth:");
  347.  
  348. membership.setFont(new java.awt.Font("Arial", 1, 36)); // NOI18N
  349. membership.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Silver Membership", "Platinum Membership", "Gold MemberShip" }));
  350.  
  351. RegisterButton.setFont(new java.awt.Font("Arial", 1, 36)); // NOI18N
  352. RegisterButton.setForeground(new java.awt.Color(0, 255, 0));
  353. RegisterButton.setText("REGISTER");
  354. RegisterButton.addActionListener(new java.awt.event.ActionListener() {
  355. public void actionPerformed(java.awt.event.ActionEvent evt) {
  356. RegisterButtonActionPerformed(evt);
  357. }
  358. });
  359.  
  360. ResetButton.setFont(new java.awt.Font("Arial", 1, 36)); // NOI18N
  361. ResetButton.setForeground(new java.awt.Color(255, 0, 0));
  362. ResetButton.setText("RESET");
  363. ResetButton.addActionListener(new java.awt.event.ActionListener() {
  364. public void actionPerformed(java.awt.event.ActionEvent evt) {
  365. ResetButtonActionPerformed(evt);
  366. }
  367. });
  368.  
  369. addressTextF.addActionListener(new java.awt.event.ActionListener() {
  370. public void actionPerformed(java.awt.event.ActionEvent evt) {
  371. addressTextFActionPerformed(evt);
  372. }
  373. });
  374.  
  375. postcodeTextF.addActionListener(new java.awt.event.ActionListener() {
  376. public void actionPerformed(java.awt.event.ActionEvent evt) {
  377. postcodeTextFActionPerformed(evt);
  378. }
  379. });
  380.  
  381. surnameTextF.addActionListener(new java.awt.event.ActionListener() {
  382. public void actionPerformed(java.awt.event.ActionEvent evt) {
  383. surnameTextFActionPerformed(evt);
  384. }
  385. });
  386.  
  387. nameTextF.addActionListener(new java.awt.event.ActionListener() {
  388. public void actionPerformed(java.awt.event.ActionEvent evt) {
  389. nameTextFActionPerformed(evt);
  390. }
  391. });
  392.  
  393. jPanel6.setBackground(new java.awt.Color(0, 51, 153));
  394.  
  395. jLabel16.setFont(new java.awt.Font("Arial", 1, 36)); // NOI18N
  396. jLabel16.setText("ADD MEMBER");
  397.  
  398. javax.swing.GroupLayout jPanel6Layout = new javax.swing.GroupLayout(jPanel6);
  399. jPanel6.setLayout(jPanel6Layout);
  400. jPanel6Layout.setHorizontalGroup(
  401. jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  402. .addGroup(jPanel6Layout.createSequentialGroup()
  403. .addGap(254, 254, 254)
  404. .addComponent(jLabel16)
  405. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  406. );
  407. jPanel6Layout.setVerticalGroup(
  408. jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  409. .addGroup(jPanel6Layout.createSequentialGroup()
  410. .addGap(44, 44, 44)
  411. .addComponent(jLabel16)
  412. .addContainerGap(68, Short.MAX_VALUE))
  413. );
  414.  
  415. jLabel17.setFont(new java.awt.Font("Arial", 1, 36)); // NOI18N
  416. jLabel17.setText("Home Number:");
  417.  
  418. jLabel18.setFont(new java.awt.Font("Arial", 1, 36)); // NOI18N
  419. jLabel18.setText("Phone Number:");
  420.  
  421. homeTextF.addActionListener(new java.awt.event.ActionListener() {
  422. public void actionPerformed(java.awt.event.ActionEvent evt) {
  423. homeTextFActionPerformed(evt);
  424. }
  425. });
  426.  
  427. phoneTextF.addActionListener(new java.awt.event.ActionListener() {
  428. public void actionPerformed(java.awt.event.ActionEvent evt) {
  429. phoneTextFActionPerformed(evt);
  430. }
  431. });
  432.  
  433. dobTextF.addActionListener(new java.awt.event.ActionListener() {
  434. public void actionPerformed(java.awt.event.ActionEvent evt) {
  435. dobTextFActionPerformed(evt);
  436. }
  437. });
  438.  
  439. javax.swing.GroupLayout jPanelAddMemberLayout = new javax.swing.GroupLayout(jPanelAddMember);
  440. jPanelAddMember.setLayout(jPanelAddMemberLayout);
  441. jPanelAddMemberLayout.setHorizontalGroup(
  442. jPanelAddMemberLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  443. .addComponent(jPanel6, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  444. .addGroup(jPanelAddMemberLayout.createSequentialGroup()
  445. .addContainerGap()
  446. .addGroup(jPanelAddMemberLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  447. .addGroup(jPanelAddMemberLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
  448. .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanelAddMemberLayout.createSequentialGroup()
  449. .addComponent(jLabel18)
  450. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  451. .addComponent(phoneTextF, javax.swing.GroupLayout.PREFERRED_SIZE, 267, javax.swing.GroupLayout.PREFERRED_SIZE))
  452. .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanelAddMemberLayout.createSequentialGroup()
  453. .addComponent(RegisterButton)
  454. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  455. .addComponent(ResetButton))
  456. .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanelAddMemberLayout.createSequentialGroup()
  457. .addGroup(jPanelAddMemberLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  458. .addComponent(jLabel3)
  459. .addComponent(jLabel4)
  460. .addComponent(jLabel6)
  461. .addComponent(jLabel5)
  462. .addComponent(jLabel8)
  463. .addComponent(jLabel7)
  464. .addComponent(jLabel17))
  465. .addGroup(jPanelAddMemberLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  466. .addGroup(jPanelAddMemberLayout.createSequentialGroup()
  467. .addGap(55, 55, 55)
  468. .addGroup(jPanelAddMemberLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  469. .addComponent(nameTextF, javax.swing.GroupLayout.PREFERRED_SIZE, 267, javax.swing.GroupLayout.PREFERRED_SIZE)
  470. .addComponent(surnameTextF, javax.swing.GroupLayout.PREFERRED_SIZE, 267, javax.swing.GroupLayout.PREFERRED_SIZE)
  471. .addComponent(emailTextF, javax.swing.GroupLayout.PREFERRED_SIZE, 267, javax.swing.GroupLayout.PREFERRED_SIZE)
  472. .addComponent(postcodeTextF, javax.swing.GroupLayout.PREFERRED_SIZE, 267, javax.swing.GroupLayout.PREFERRED_SIZE)
  473. .addComponent(addressTextF, javax.swing.GroupLayout.PREFERRED_SIZE, 267, javax.swing.GroupLayout.PREFERRED_SIZE)))
  474. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanelAddMemberLayout.createSequentialGroup()
  475. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  476. .addGroup(jPanelAddMemberLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  477. .addComponent(homeTextF, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 267, javax.swing.GroupLayout.PREFERRED_SIZE)
  478. .addComponent(dobTextF, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 267, javax.swing.GroupLayout.PREFERRED_SIZE))))))
  479. .addComponent(membership, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  480. .addContainerGap(225, Short.MAX_VALUE))
  481. );
  482. jPanelAddMemberLayout.setVerticalGroup(
  483. jPanelAddMemberLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  484. .addGroup(jPanelAddMemberLayout.createSequentialGroup()
  485. .addComponent(jPanel6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  486. .addGap(18, 18, 18)
  487. .addGroup(jPanelAddMemberLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  488. .addComponent(jLabel3)
  489. .addComponent(nameTextF, javax.swing.GroupLayout.PREFERRED_SIZE, 43, javax.swing.GroupLayout.PREFERRED_SIZE))
  490. .addGap(18, 18, 18)
  491. .addGroup(jPanelAddMemberLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  492. .addComponent(jLabel4)
  493. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanelAddMemberLayout.createSequentialGroup()
  494. .addComponent(surnameTextF, javax.swing.GroupLayout.PREFERRED_SIZE, 43, javax.swing.GroupLayout.PREFERRED_SIZE)
  495. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)))
  496. .addGroup(jPanelAddMemberLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  497. .addGroup(jPanelAddMemberLayout.createSequentialGroup()
  498. .addComponent(jLabel5)
  499. .addGap(16, 16, 16)
  500. .addComponent(jLabel6))
  501. .addGroup(jPanelAddMemberLayout.createSequentialGroup()
  502. .addComponent(emailTextF, javax.swing.GroupLayout.PREFERRED_SIZE, 43, javax.swing.GroupLayout.PREFERRED_SIZE)
  503. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  504. .addComponent(addressTextF, javax.swing.GroupLayout.PREFERRED_SIZE, 43, javax.swing.GroupLayout.PREFERRED_SIZE)))
  505. .addGap(18, 18, 18)
  506. .addGroup(jPanelAddMemberLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  507. .addComponent(jLabel7)
  508. .addComponent(postcodeTextF, javax.swing.GroupLayout.PREFERRED_SIZE, 43, javax.swing.GroupLayout.PREFERRED_SIZE))
  509. .addGap(18, 18, 18)
  510. .addGroup(jPanelAddMemberLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  511. .addComponent(jLabel18)
  512. .addComponent(phoneTextF, javax.swing.GroupLayout.PREFERRED_SIZE, 43, javax.swing.GroupLayout.PREFERRED_SIZE))
  513. .addGroup(jPanelAddMemberLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  514. .addGroup(jPanelAddMemberLayout.createSequentialGroup()
  515. .addGap(13, 13, 13)
  516. .addComponent(jLabel17))
  517. .addGroup(jPanelAddMemberLayout.createSequentialGroup()
  518. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  519. .addComponent(homeTextF, javax.swing.GroupLayout.PREFERRED_SIZE, 43, javax.swing.GroupLayout.PREFERRED_SIZE)))
  520. .addGap(18, 18, 18)
  521. .addGroup(jPanelAddMemberLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  522. .addComponent(jLabel8)
  523. .addComponent(dobTextF, javax.swing.GroupLayout.PREFERRED_SIZE, 43, javax.swing.GroupLayout.PREFERRED_SIZE))
  524. .addGap(24, 24, 24)
  525. .addComponent(membership, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  526. .addGap(18, 18, 18)
  527. .addGroup(jPanelAddMemberLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  528. .addComponent(RegisterButton)
  529. .addComponent(ResetButton))
  530. .addContainerGap(98, Short.MAX_VALUE))
  531. );
  532.  
  533. jPanelIncluding3Panels.add(jPanelAddMember, "card2");
  534.  
  535. jPanelSearchEditDelete.setBackground(new java.awt.Color(204, 204, 204));
  536. jPanelSearchEditDelete.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white, java.awt.Color.white));
  537.  
  538. bUpdate.setFont(new java.awt.Font("Arial", 1, 24)); // NOI18N
  539. bUpdate.setText("Update");
  540. bUpdate.addActionListener(new java.awt.event.ActionListener() {
  541. public void actionPerformed(java.awt.event.ActionEvent evt) {
  542. bUpdateActionPerformed(evt);
  543. }
  544. });
  545.  
  546. DeleteB.setFont(new java.awt.Font("Arial", 1, 24)); // NOI18N
  547. DeleteB.setText("Delete");
  548. DeleteB.addActionListener(new java.awt.event.ActionListener() {
  549. public void actionPerformed(java.awt.event.ActionEvent evt) {
  550. DeleteBActionPerformed(evt);
  551. }
  552. });
  553.  
  554. resetB.setFont(new java.awt.Font("Arial", 1, 24)); // NOI18N
  555. resetB.setText("Reset");
  556. resetB.addActionListener(new java.awt.event.ActionListener() {
  557. public void actionPerformed(java.awt.event.ActionEvent evt) {
  558. resetBActionPerformed(evt);
  559. }
  560. });
  561.  
  562. searchButton.setFont(new java.awt.Font("Arial", 1, 24)); // NOI18N
  563. searchButton.setText("Search");
  564. searchButton.addActionListener(new java.awt.event.ActionListener() {
  565. public void actionPerformed(java.awt.event.ActionEvent evt) {
  566. searchButtonActionPerformed(evt);
  567. }
  568. });
  569.  
  570. jLabel14.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
  571. jLabel14.setText("MEMBERS");
  572.  
  573. MembersTbl.setModel(new javax.swing.table.DefaultTableModel(
  574. new Object [][] {
  575.  
  576. },
  577. new String [] {
  578. "Name", "Surname", "Email", "Phone Number", "Home Number", "Post Code", "Address", "Date Of Birth", "Membership"
  579. }
  580. ) {
  581. Class[] types = new Class [] {
  582. java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class
  583. };
  584. boolean[] canEdit = new boolean [] {
  585. false, false, false, false, false, false, false, true, true
  586. };
  587.  
  588. public Class getColumnClass(int columnIndex) {
  589. return types [columnIndex];
  590. }
  591.  
  592. public boolean isCellEditable(int rowIndex, int columnIndex) {
  593. return canEdit [columnIndex];
  594. }
  595. });
  596. jScrollPane1.setViewportView(MembersTbl);
  597. if (MembersTbl.getColumnModel().getColumnCount() > 0) {
  598. MembersTbl.getColumnModel().getColumn(0).setResizable(false);
  599. MembersTbl.getColumnModel().getColumn(1).setResizable(false);
  600. MembersTbl.getColumnModel().getColumn(2).setResizable(false);
  601. MembersTbl.getColumnModel().getColumn(3).setResizable(false);
  602. MembersTbl.getColumnModel().getColumn(4).setResizable(false);
  603. MembersTbl.getColumnModel().getColumn(5).setResizable(false);
  604. MembersTbl.getColumnModel().getColumn(6).setResizable(false);
  605. MembersTbl.getColumnModel().getColumn(7).setResizable(false);
  606. MembersTbl.getColumnModel().getColumn(8).setResizable(false);
  607. }
  608.  
  609. jPanel5.setBackground(new java.awt.Color(0, 51, 153));
  610. jPanel5.setPreferredSize(new java.awt.Dimension(509, 155));
  611.  
  612. jLabel15.setFont(new java.awt.Font("Arial", 1, 36)); // NOI18N
  613. jLabel15.setText("EDIT SEARCH DELETE MEMBER");
  614.  
  615. javax.swing.GroupLayout jPanel5Layout = new javax.swing.GroupLayout(jPanel5);
  616. jPanel5.setLayout(jPanel5Layout);
  617. jPanel5Layout.setHorizontalGroup(
  618. jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  619. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel5Layout.createSequentialGroup()
  620. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  621. .addComponent(jLabel15)
  622. .addGap(118, 118, 118))
  623. );
  624. jPanel5Layout.setVerticalGroup(
  625. jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  626. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel5Layout.createSequentialGroup()
  627. .addContainerGap(57, Short.MAX_VALUE)
  628. .addComponent(jLabel15)
  629. .addGap(55, 55, 55))
  630. );
  631.  
  632. jLabel19.setFont(new java.awt.Font("Arial", 1, 18)); // NOI18N
  633. jLabel19.setText("Name:");
  634.  
  635. jLabel20.setFont(new java.awt.Font("Arial", 1, 18)); // NOI18N
  636. jLabel20.setText("Surname:");
  637.  
  638. jLabel21.setFont(new java.awt.Font("Arial", 1, 18)); // NOI18N
  639. jLabel21.setText("E-mail:");
  640.  
  641. jLabel22.setFont(new java.awt.Font("Arial", 1, 18)); // NOI18N
  642. jLabel22.setText("Address:");
  643.  
  644. jLabel23.setFont(new java.awt.Font("Arial", 1, 18)); // NOI18N
  645. jLabel23.setText("Post Code:");
  646.  
  647. jLabel24.setFont(new java.awt.Font("Arial", 1, 18)); // NOI18N
  648. jLabel24.setText("Phone Number:");
  649.  
  650. jLabel25.setFont(new java.awt.Font("Arial", 1, 18)); // NOI18N
  651. jLabel25.setText("Home Number:");
  652.  
  653. jLabel26.setFont(new java.awt.Font("Arial", 1, 18)); // NOI18N
  654. jLabel26.setText("Date Of Birth:");
  655.  
  656. membershipEditForm.setFont(new java.awt.Font("Arial", 1, 24)); // NOI18N
  657. membershipEditForm.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Silver Membership", "Platinum Membership", "Gold MemberShip" }));
  658.  
  659. idtxt.addActionListener(new java.awt.event.ActionListener() {
  660. public void actionPerformed(java.awt.event.ActionEvent evt) {
  661. idtxtActionPerformed(evt);
  662. }
  663. });
  664.  
  665. jLabel27.setFont(new java.awt.Font("Arial", 1, 18)); // NOI18N
  666. jLabel27.setText("ID:");
  667.  
  668. nametxt1.addActionListener(new java.awt.event.ActionListener() {
  669. public void actionPerformed(java.awt.event.ActionEvent evt) {
  670. nametxt1ActionPerformed(evt);
  671. }
  672. });
  673.  
  674. searchtxt.addActionListener(new java.awt.event.ActionListener() {
  675. public void actionPerformed(java.awt.event.ActionEvent evt) {
  676. searchtxtActionPerformed(evt);
  677. }
  678. });
  679.  
  680. jLabel9.setText("Search by: ID,Email,Phone");
  681.  
  682. jLabel10.setText("TYPE ID TO DELETE RECORD");
  683.  
  684. deleteLabel.setForeground(new java.awt.Color(255, 51, 51));
  685.  
  686. javax.swing.GroupLayout jPanelSearchEditDeleteLayout = new javax.swing.GroupLayout(jPanelSearchEditDelete);
  687. jPanelSearchEditDelete.setLayout(jPanelSearchEditDeleteLayout);
  688. jPanelSearchEditDeleteLayout.setHorizontalGroup(
  689. jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  690. .addComponent(jPanel5, javax.swing.GroupLayout.DEFAULT_SIZE, 817, Short.MAX_VALUE)
  691. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanelSearchEditDeleteLayout.createSequentialGroup()
  692. .addContainerGap(22, Short.MAX_VALUE)
  693. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  694. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanelSearchEditDeleteLayout.createSequentialGroup()
  695. .addComponent(jLabel14, javax.swing.GroupLayout.PREFERRED_SIZE, 95, javax.swing.GroupLayout.PREFERRED_SIZE)
  696. .addGap(1, 1, 1))
  697. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanelSearchEditDeleteLayout.createSequentialGroup()
  698. .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 785, javax.swing.GroupLayout.PREFERRED_SIZE)
  699. .addContainerGap())
  700. .addGroup(jPanelSearchEditDeleteLayout.createSequentialGroup()
  701. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  702. .addGroup(jPanelSearchEditDeleteLayout.createSequentialGroup()
  703. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  704. .addGroup(jPanelSearchEditDeleteLayout.createSequentialGroup()
  705. .addComponent(membershipEditForm, javax.swing.GroupLayout.PREFERRED_SIZE, 380, javax.swing.GroupLayout.PREFERRED_SIZE)
  706. .addGap(18, 18, 18))
  707. .addGroup(jPanelSearchEditDeleteLayout.createSequentialGroup()
  708. .addComponent(bUpdate, javax.swing.GroupLayout.PREFERRED_SIZE, 156, javax.swing.GroupLayout.PREFERRED_SIZE)
  709. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  710. .addComponent(resetB, javax.swing.GroupLayout.PREFERRED_SIZE, 156, javax.swing.GroupLayout.PREFERRED_SIZE)
  711. .addGap(37, 37, 37)))
  712. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  713. .addComponent(searchButton, javax.swing.GroupLayout.DEFAULT_SIZE, 167, Short.MAX_VALUE)
  714. .addComponent(DeleteB, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
  715. .addGroup(jPanelSearchEditDeleteLayout.createSequentialGroup()
  716. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  717. .addComponent(jLabel19)
  718. .addComponent(jLabel20)
  719. .addComponent(jLabel23)
  720. .addComponent(jLabel24)
  721. .addComponent(jLabel25)
  722. .addComponent(jLabel26)
  723. .addComponent(jLabel27)
  724. .addComponent(jLabel21)
  725. .addComponent(jLabel22))
  726. .addGap(35, 35, 35)
  727. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  728. .addComponent(idtxt)
  729. .addComponent(surnametxt)
  730. .addComponent(emailtxt)
  731. .addComponent(addresstxt)
  732. .addComponent(postcodetxt)
  733. .addComponent(phonetxt)
  734. .addComponent(hometxt)
  735. .addComponent(dobtxt)
  736. .addComponent(nametxt1, javax.swing.GroupLayout.PREFERRED_SIZE, 207, javax.swing.GroupLayout.PREFERRED_SIZE))))
  737. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  738. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  739. .addComponent(jLabel10)
  740. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  741. .addComponent(jLabel9)
  742. .addComponent(searchtxt, javax.swing.GroupLayout.DEFAULT_SIZE, 204, Short.MAX_VALUE)
  743. .addComponent(deleteTxt))
  744. .addComponent(deleteLabel))
  745. .addGap(0, 0, Short.MAX_VALUE))))
  746. );
  747. jPanelSearchEditDeleteLayout.setVerticalGroup(
  748. jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  749. .addGroup(jPanelSearchEditDeleteLayout.createSequentialGroup()
  750. .addComponent(jPanel5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  751. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  752. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  753. .addComponent(jLabel27)
  754. .addComponent(idtxt, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  755. .addGap(3, 3, 3)
  756. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  757. .addComponent(jLabel19)
  758. .addComponent(nametxt1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  759. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  760. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  761. .addComponent(jLabel20)
  762. .addComponent(surnametxt, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  763. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  764. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  765. .addComponent(jLabel21)
  766. .addComponent(emailtxt, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  767. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  768. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  769. .addComponent(jLabel22)
  770. .addComponent(addresstxt, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  771. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  772. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  773. .addComponent(jLabel23)
  774. .addComponent(postcodetxt, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  775. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  776. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  777. .addComponent(jLabel24)
  778. .addComponent(phonetxt, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  779. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  780. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  781. .addComponent(jLabel25)
  782. .addComponent(hometxt, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  783. .addGap(11, 11, 11)
  784. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  785. .addComponent(jLabel26)
  786. .addComponent(dobtxt, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  787. .addComponent(jLabel9))
  788. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  789. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  790. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  791. .addComponent(membershipEditForm, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  792. .addComponent(searchButton))
  793. .addComponent(searchtxt, javax.swing.GroupLayout.PREFERRED_SIZE, 37, javax.swing.GroupLayout.PREFERRED_SIZE))
  794. .addGap(1, 1, 1)
  795. .addComponent(jLabel10)
  796. .addGap(3, 3, 3)
  797. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  798. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  799. .addComponent(bUpdate)
  800. .addComponent(deleteTxt, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 37, javax.swing.GroupLayout.PREFERRED_SIZE))
  801. .addGroup(jPanelSearchEditDeleteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  802. .addComponent(resetB)
  803. .addComponent(DeleteB)))
  804. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  805. .addComponent(deleteLabel)
  806. .addGap(64, 64, 64)
  807. .addComponent(jLabel14)
  808. .addGap(18, 18, 18)
  809. .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 185, Short.MAX_VALUE)
  810. .addGap(53, 53, 53))
  811. );
  812.  
  813. jPanelIncluding3Panels.add(jPanelSearchEditDelete, "card2");
  814.  
  815. javax.swing.GroupLayout mainPanelLayout = new javax.swing.GroupLayout(mainPanel);
  816. mainPanel.setLayout(mainPanelLayout);
  817. mainPanelLayout.setHorizontalGroup(
  818. mainPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  819. .addGroup(mainPanelLayout.createSequentialGroup()
  820. .addComponent(buttonspanel, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  821. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  822. .addComponent(jPanelIncluding3Panels, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  823. );
  824. mainPanelLayout.setVerticalGroup(
  825. mainPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  826. .addGroup(mainPanelLayout.createSequentialGroup()
  827. .addGroup(mainPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
  828. .addComponent(buttonspanel, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  829. .addGroup(javax.swing.GroupLayout.Alignment.LEADING, mainPanelLayout.createSequentialGroup()
  830. .addContainerGap()
  831. .addComponent(jPanelIncluding3Panels, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
  832. .addGap(0, 0, Short.MAX_VALUE))
  833. );
  834.  
  835. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  836. getContentPane().setLayout(layout);
  837. layout.setHorizontalGroup(
  838. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  839. .addComponent(mainPanel, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  840. );
  841. layout.setVerticalGroup(
  842. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  843. .addComponent(mainPanel, javax.swing.GroupLayout.PREFERRED_SIZE, 864, javax.swing.GroupLayout.PREFERRED_SIZE)
  844. );
  845.  
  846. pack();
  847. }// </editor-fold>
  848.  
  849. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  850. // TODO add your handling code here:
  851.  
  852. //removing panel
  853. jPanelIncluding3Panels.removeAll();
  854. jPanelIncluding3Panels.repaint();
  855. jPanelIncluding3Panels.revalidate();
  856.  
  857. //adding panels
  858. jPanelIncluding3Panels.add(jPanelAddMember);
  859. jPanelIncluding3Panels.repaint();
  860. jPanelIncluding3Panels.revalidate();
  861.  
  862. }
  863.  
  864. private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
  865. // TODO add your handling code here:
  866. System.exit(0);
  867. }
  868.  
  869. private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
  870. //removing panel
  871. jPanelIncluding3Panels.removeAll();
  872. jPanelIncluding3Panels.repaint();
  873. jPanelIncluding3Panels.revalidate();
  874.  
  875. //adding panels
  876. jPanelIncluding3Panels.add(jPanelSearchEditDelete);
  877. jPanelIncluding3Panels.repaint();
  878. jPanelIncluding3Panels.revalidate();
  879. // TODO add your handling code here:
  880. try {
  881. refreshTbl();
  882. } catch (SQLException ex) {
  883. Logger.getLogger(MainMenu.class.getName()).log(Level.SEVERE, null, ex);
  884. }
  885.  
  886.  
  887.  
  888. }
  889.  
  890. private void emailTextFActionPerformed(java.awt.event.ActionEvent evt) {
  891. // TODO add your handling code here:
  892. }
  893.  
  894. private void addressTextFActionPerformed(java.awt.event.ActionEvent evt) {
  895. // TODO add your handling code here:
  896. }
  897.  
  898. private void postcodeTextFActionPerformed(java.awt.event.ActionEvent evt) {
  899. // TODO add your handling code here:
  900. }
  901.  
  902. private void surnameTextFActionPerformed(java.awt.event.ActionEvent evt) {
  903. // TODO add your handling code here:
  904. }
  905.  
  906. private void nameTextFActionPerformed(java.awt.event.ActionEvent evt) {
  907. // TODO add your handling code here:
  908. }
  909.  
  910. private void RegisterButtonActionPerformed(java.awt.event.ActionEvent evt) {
  911.  
  912. // TODO add your handling code here:
  913. Integer uniqueID= MainMenu.gen();
  914. String ID=String.valueOf(uniqueID);
  915. String name=nameTextF.getText();
  916. String surname=surnameTextF.getText();
  917. String address=addressTextF.getText();
  918. String postcode=postcodeTextF.getText();
  919. String email=emailTextF.getText();
  920. String dob=dobTextF.getText();
  921.  
  922. String home=homeTextF.getText();
  923.  
  924.  
  925. String phone=phoneTextF.getText();
  926.  
  927.  
  928. Object mmembership=membership.getSelectedItem();
  929. String Memb= String.valueOf(mmembership);
  930.  
  931.  
  932.  
  933.  
  934.  
  935.  
  936. try {
  937. MainMenu.registerMember(ID,name,surname,phone,home,email,address,postcode,dob,Memb);
  938. //Calling the register function
  939. } catch (SQLException ex) {
  940. Logger.getLogger(MainMenu.class.getName()).log(Level.SEVERE, null, ex);
  941. }
  942.  
  943.  
  944. }
  945.  
  946. private void homeTextFActionPerformed(java.awt.event.ActionEvent evt) {
  947. // TODO add your handling code here:
  948. }
  949.  
  950. private void phoneTextFActionPerformed(java.awt.event.ActionEvent evt) {
  951. // TODO add your handling code here:
  952. }
  953.  
  954. private void dobTextFActionPerformed(java.awt.event.ActionEvent evt) {
  955. // TODO add your handling code here:
  956. }
  957.  
  958. private void ResetButtonActionPerformed(java.awt.event.ActionEvent evt) {
  959. // TODO add your handling code here:
  960. nameTextF.setText("");
  961. surnameTextF.setText("");
  962. emailTextF.setText("");
  963. phoneTextF.setText("");
  964. homeTextF.setText("");
  965. postcodeTextF.setText("");
  966. addressTextF.setText("");
  967. dobTextF.setText("");
  968.  
  969.  
  970.  
  971.  
  972. }
  973.  
  974. private void searchtxtActionPerformed(java.awt.event.ActionEvent evt) {
  975. try {
  976. // TODO add your handling code here:
  977.  
  978. String connectionURL = "jdbc:derby://localhost:1527/MembersManagement";
  979. String uName = "ael";
  980. String uPass= "ael";
  981.  
  982. Connection conn = DriverManager.getConnection(connectionURL, uName, uPass);
  983. System.out.println("Refreshing the table...");
  984.  
  985. String sql="SELECT * FROM MEMBERS where NAME=?";
  986.  
  987.  
  988.  
  989. PreparedStatement st = null;
  990. try {
  991. st = conn.prepareStatement(sql);
  992. } catch (SQLException ex) {
  993. Logger.getLogger(MainMenu.class.getName()).log(Level.SEVERE, null, ex);
  994. }
  995. st.setString(1,searchtxt.getText());
  996. ResultSet rs = st.executeQuery();
  997. rs=st.executeQuery(sql);
  998. if(rs.next()){
  999. String add1=rs.getString("ID");
  1000. searchtxt.setText(add1);
  1001. String add2=rs.getString("NAME");
  1002. searchtxt.setText(add2);
  1003. String add3=rs.getString("EMAIL");
  1004. searchtxt.setText(add3);
  1005. String add4=rs.getString("PHONENUMBER");
  1006. searchtxt.setText(add4);
  1007. String add5=rs.getString("HOMENUMBER");
  1008. searchtxt.setText(add5);
  1009.  
  1010.  
  1011. }
  1012. MembersTbl.setModel(DbUtils.resultSetToTableModel(rs));
  1013.  
  1014.  
  1015.  
  1016.  
  1017.  
  1018. } catch (SQLException ex) {
  1019. Logger.getLogger(MainMenu.class.getName()).log(Level.SEVERE, null, ex);
  1020. }
  1021.  
  1022.  
  1023.  
  1024.  
  1025.  
  1026. }
  1027.  
  1028. private void nametxt1ActionPerformed(java.awt.event.ActionEvent evt) {
  1029. // TODO add your handling code here:
  1030. }
  1031.  
  1032. private void idtxtActionPerformed(java.awt.event.ActionEvent evt) {
  1033. // TODO add your handling code here:
  1034. }
  1035.  
  1036. private void bUpdateActionPerformed(java.awt.event.ActionEvent evt) {
  1037. // TODO add your handling code here
  1038. String ID=idtxt.getText();
  1039. String name=nametxt1.getText();
  1040. String surname=surnametxt.getText();
  1041. String email=emailtxt.getText();
  1042. String address=addresstxt.getText();
  1043. String postcode=postcodetxt.getText();
  1044. String phone=phonetxt.getText();
  1045. String home=hometxt.getText();
  1046. String dob=dobtxt.getText();
  1047. Object membershp=membershipEditForm.getSelectedItem();
  1048. String Memb= String.valueOf(membershp);
  1049.  
  1050. try {
  1051. String connectionURL = "jdbc:derby://localhost:1527/MembersManagement";
  1052. String uName = "ael";
  1053. String uPass= "ael";
  1054. Connection conn;
  1055.  
  1056. conn = DriverManager.getConnection(connectionURL, uName, uPass);
  1057.  
  1058. String sql="UPDATE MEMBERS SET NAME='"+name+"',SURNAME='"+surname+"',EMAIL='"+email+"',PHONENUMBER='"+phone+"',HOMENUMBER='"+home+"',POSTCODE='"+postcode+"',ADDRESS='"+address+"',DATEOFBIRTH='"+dob+"',MEMBERSHIP='"+Memb+"' WHERE ID='"+ID+"' ";
  1059. System.out.println("Updating the table...");
  1060. PreparedStatement st = null;
  1061. st = conn.prepareStatement(sql);
  1062. Object rs = null;
  1063. rs=st.executeUpdate();
  1064. refreshTbl();
  1065. } catch (SQLException ex) {
  1066. Logger.getLogger(MainMenu.class.getName()).log(Level.SEVERE, null, ex);
  1067. }
  1068.  
  1069.  
  1070.  
  1071.  
  1072. }
  1073.  
  1074. private void searchButtonActionPerformed(java.awt.event.ActionEvent evt) {
  1075.  
  1076.  
  1077. // TODO add your handling code here:
  1078. String sql ="select * from AEL.MEMBERS WHERE ID=?";
  1079. String sql1 ="select * from AEL.MEMBERS WHERE EMAIL=?";
  1080. String sql2 ="select * from AEL.MEMBERS WHERE PHONENUMBER=?";
  1081. String sql3 ="select * from AEL.MEMBERS WHERE HOMENUMBER=?";
  1082.  
  1083. try {
  1084. String connectionURL = "jdbc:derby://localhost:1527/MembersManagement";
  1085. String uName = "ael";
  1086. String uPass= "ael";
  1087. ResultSet rs=null;
  1088.  
  1089. Connection conn = DriverManager.getConnection(connectionURL, uName, uPass);
  1090.  
  1091. PreparedStatement st=conn.prepareStatement(sql);
  1092. st.setString(1,searchtxt.getText());
  1093. rs=st.executeQuery();
  1094. if (rs.next());
  1095. emailtxt.setText(rs.getString("EMAIL"));
  1096. nametxt1.setText(rs.getString("NAME"));
  1097. surnametxt.setText(rs.getString("SURNAME"));
  1098. idtxt.setText(rs.getString("ID"));
  1099. hometxt.setText(rs.getString("HOMENUMBER"));
  1100. phonetxt.setText(rs.getString("PHONENUMBER"));
  1101. postcodetxt.setText(rs.getString("NAME"));
  1102. dobtxt.setText(rs.getString("DATEOFBIRTH"));
  1103. addresstxt.setText(rs.getString("ADDRESS"));
  1104.  
  1105.  
  1106. } catch (SQLException ex) {
  1107. Logger.getLogger(MainMenu.class.getName()).log(Level.SEVERE, null, ex);
  1108. }
  1109.  
  1110.  
  1111. try {
  1112. String connectionURL = "jdbc:derby://localhost:1527/MembersManagement";
  1113. String uName = "ael";
  1114. String uPass= "ael";
  1115. ResultSet rs=null;
  1116. Connection conn = DriverManager.getConnection(connectionURL, uName, uPass);
  1117.  
  1118. PreparedStatement st=conn.prepareStatement(sql1);
  1119. st.setString(1,searchtxt.getText());
  1120. rs=st.executeQuery();
  1121. if (rs.next());
  1122. emailtxt.setText(rs.getString("EMAIL"));
  1123. nametxt1.setText(rs.getString("NAME"));
  1124. surnametxt.setText(rs.getString("SURNAME"));
  1125. idtxt.setText(rs.getString("ID"));
  1126. hometxt.setText(rs.getString("HOMENUMBER"));
  1127. phonetxt.setText(rs.getString("PHONENUMBER"));
  1128. postcodetxt.setText(rs.getString("NAME"));
  1129. dobtxt.setText(rs.getString("DATEOFBIRTH"));
  1130. addresstxt.setText(rs.getString("ADDRESS"));
  1131. } catch (SQLException ex) {
  1132. Logger.getLogger(MainMenu.class.getName()).log(Level.SEVERE, null, ex);
  1133. }
  1134.  
  1135.  
  1136.  
  1137.  
  1138. try {
  1139. String connectionURL = "jdbc:derby://localhost:1527/MembersManagement";
  1140. String uName = "ael";
  1141. String uPass= "ael";
  1142. ResultSet rs=null;
  1143. Connection conn = DriverManager.getConnection(connectionURL, uName, uPass);
  1144. PreparedStatement st=conn.prepareStatement(sql2);
  1145. st.setString(1,searchtxt.getText());
  1146. rs=st.executeQuery();
  1147. if (rs.next());
  1148. emailtxt.setText(rs.getString("EMAIL"));
  1149. nametxt1.setText(rs.getString("NAME"));
  1150. surnametxt.setText(rs.getString("SURNAME"));
  1151. idtxt.setText(rs.getString("ID"));
  1152. hometxt.setText(rs.getString("HOMENUMBER"));
  1153. phonetxt.setText(rs.getString("PHONENUMBER"));
  1154. postcodetxt.setText(rs.getString("NAME"));
  1155. dobtxt.setText(rs.getString("DATEOFBIRTH"));
  1156. addresstxt.setText(rs.getString("ADDRESS"));
  1157. } catch (SQLException ex) {
  1158. Logger.getLogger(MainMenu.class.getName()).log(Level.SEVERE, null, ex);
  1159. }
  1160.  
  1161.  
  1162.  
  1163.  
  1164.  
  1165. try {
  1166. String connectionURL = "jdbc:derby://localhost:1527/MembersManagement";
  1167. String uName = "ael";
  1168. String uPass= "ael";
  1169. ResultSet rs=null;
  1170. Connection conn = DriverManager.getConnection(connectionURL, uName, uPass);
  1171. PreparedStatement st=conn.prepareStatement(sql3);
  1172. st.setString(1,searchtxt.getText());
  1173. rs=st.executeQuery();
  1174. if (rs.next());
  1175. emailtxt.setText(rs.getString("EMAIL"));
  1176. nametxt1.setText(rs.getString("NAME"));
  1177. surnametxt.setText(rs.getString("SURNAME"));
  1178. idtxt.setText(rs.getString("ID"));
  1179. hometxt.setText(rs.getString("HOMENUMBER"));
  1180. phonetxt.setText(rs.getString("PHONENUMBER"));
  1181. postcodetxt.setText(rs.getString("NAME"));
  1182. dobtxt.setText(rs.getString("DATEOFBIRTH"));
  1183. addresstxt.setText(rs.getString("ADDRESS"));
  1184. } catch (SQLException ex) {
  1185. Logger.getLogger(MainMenu.class.getName()).log(Level.SEVERE, null, ex);
  1186. }
  1187.  
  1188.  
  1189.  
  1190.  
  1191.  
  1192.  
  1193.  
  1194.  
  1195.  
  1196.  
  1197.  
  1198.  
  1199.  
  1200. }
  1201.  
  1202. private void resetBActionPerformed(java.awt.event.ActionEvent evt) {
  1203. // TODO add your handling code here:
  1204. idtxt.setText("");
  1205. nametxt1.setText("");
  1206. surnametxt.setText("");
  1207. emailtxt.setText("");
  1208. phonetxt.setText("");
  1209. hometxt.setText("");
  1210. postcodetxt.setText("");
  1211. addresstxt.setText("");
  1212. dobtxt.setText("");
  1213.  
  1214.  
  1215.  
  1216.  
  1217.  
  1218. }
  1219.  
  1220. private void DeleteBActionPerformed(java.awt.event.ActionEvent evt) {
  1221. try {
  1222. // TODO add your handling code here:
  1223.  
  1224. deleteMember();
  1225. } catch (SQLException ex) {
  1226. Logger.getLogger(MainMenu.class.getName()).log(Level.SEVERE, null, ex);
  1227. }
  1228.  
  1229.  
  1230.  
  1231.  
  1232. }
  1233.  
  1234. /**
  1235. * @param args the command line arguments
  1236. */
  1237. public static void main(String args[]) {
  1238. /* Set the Nimbus look and feel */
  1239. //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  1240. /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
  1241. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  1242. */
  1243. try {
  1244. for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  1245. if ("Nimbus".equals(info.getName())) {
  1246. javax.swing.UIManager.setLookAndFeel(info.getClassName());
  1247. break;
  1248. }
  1249. }
  1250. } catch (ClassNotFoundException ex) {
  1251. java.util.logging.Logger.getLogger(MainMenu.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  1252. } catch (InstantiationException ex) {
  1253. java.util.logging.Logger.getLogger(MainMenu.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  1254. } catch (IllegalAccessException ex) {
  1255. java.util.logging.Logger.getLogger(MainMenu.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  1256. } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  1257. java.util.logging.Logger.getLogger(MainMenu.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  1258. }
  1259. //</editor-fold>
  1260.  
  1261. /* Create and display the form */
  1262. java.awt.EventQueue.invokeLater(new Runnable() {
  1263. public void run() {
  1264. new MainMenu().setVisible(true);
  1265. }
  1266. });
  1267. }
  1268.  
  1269. // Variables declaration - do not modify
  1270. private javax.swing.JButton DeleteB;
  1271. private javax.swing.JTable MembersTbl;
  1272. private javax.swing.JButton RegisterButton;
  1273. private javax.swing.JButton ResetButton;
  1274. private javax.swing.JTextField addressTextF;
  1275. private javax.swing.JTextField addresstxt;
  1276. private javax.swing.JButton bUpdate;
  1277. private javax.swing.JPanel buttonspanel;
  1278. private javax.swing.JLabel deleteLabel;
  1279. private javax.swing.JTextField deleteTxt;
  1280. private javax.swing.JTextField dobTextF;
  1281. private javax.swing.JTextField dobtxt;
  1282. private javax.swing.JTextField emailTextF;
  1283. private javax.swing.JTextField emailtxt;
  1284. private javax.swing.JTextField homeTextF;
  1285. private javax.swing.JTextField hometxt;
  1286. private javax.swing.JTextField idtxt;
  1287. private javax.swing.JButton jButton1;
  1288. private javax.swing.JButton jButton2;
  1289. private javax.swing.JButton jButton3;
  1290. private javax.swing.JLabel jLabel1;
  1291. private javax.swing.JLabel jLabel10;
  1292. private javax.swing.JLabel jLabel14;
  1293. private javax.swing.JLabel jLabel15;
  1294. private javax.swing.JLabel jLabel16;
  1295. private javax.swing.JLabel jLabel17;
  1296. private javax.swing.JLabel jLabel18;
  1297. private javax.swing.JLabel jLabel19;
  1298. private javax.swing.JLabel jLabel2;
  1299. private javax.swing.JLabel jLabel20;
  1300. private javax.swing.JLabel jLabel21;
  1301. private javax.swing.JLabel jLabel22;
  1302. private javax.swing.JLabel jLabel23;
  1303. private javax.swing.JLabel jLabel24;
  1304. private javax.swing.JLabel jLabel25;
  1305. private javax.swing.JLabel jLabel26;
  1306. private javax.swing.JLabel jLabel27;
  1307. private javax.swing.JLabel jLabel3;
  1308. private javax.swing.JLabel jLabel4;
  1309. private javax.swing.JLabel jLabel5;
  1310. private javax.swing.JLabel jLabel6;
  1311. private javax.swing.JLabel jLabel7;
  1312. private javax.swing.JLabel jLabel8;
  1313. private javax.swing.JLabel jLabel9;
  1314. private javax.swing.JPanel jPanel3;
  1315. private javax.swing.JPanel jPanel4;
  1316. private javax.swing.JPanel jPanel5;
  1317. private javax.swing.JPanel jPanel6;
  1318. private javax.swing.JPanel jPanelAddMember;
  1319. private javax.swing.JPanel jPanelIncluding3Panels;
  1320. private javax.swing.JPanel jPanelSearchEditDelete;
  1321. private javax.swing.JPanel jPanelWelcome;
  1322. private javax.swing.JScrollPane jScrollPane1;
  1323. private javax.swing.JPanel mainPanel;
  1324. private javax.swing.JComboBox membership;
  1325. private javax.swing.JComboBox membershipEditForm;
  1326. private javax.swing.JTextField nameTextF;
  1327. private javax.swing.JTextField nametxt1;
  1328. private javax.swing.JTextField phoneTextF;
  1329. private javax.swing.JTextField phonetxt;
  1330. private javax.swing.JTextField postcodeTextF;
  1331. private javax.swing.JTextField postcodetxt;
  1332. private javax.swing.JButton resetB;
  1333. private javax.swing.JButton searchButton;
  1334. private javax.swing.JTextField searchtxt;
  1335. private javax.swing.JTextField surnameTextF;
  1336. private javax.swing.JTextField surnametxt;
  1337. // End of variables declaration
  1338. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!