Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * To change this template, choose Tools | Templates
- * and open the template in the editor.
- */
- package camp;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.sql.ResultSet;
- import javax.swing.JOptionPane;
- /**
- *
- * @author ST.NICHOLAS
- */
- public class mainApp extends javax.swing.JPanel {
- Connection con;
- Statement stmt;
- ResultSet rs;
- /**
- * Creates new form mainApp
- */
- public mainApp() {
- initComponents();
- DoConnect();
- }
- public void DoConnect() {
- try {
- //Connect to the database
- String host = "jdbc:derby://localhost:1527/camp";
- String uName = "admin";
- String uPass = "admin";
- con= DriverManager.getConnection(host, uName, uPass);
- //Execute some SQL and load the records into the Resultet
- stmt = con.createStatement();
- String sql = "SELECT *FROM mainApp";
- rs = stmt.executeQuery(sql);
- //Move the Cursor The first period and get the data
- rs.next();
- int id_col = rs.getInt("ID");
- String id = Integer.toString(id_col);
- String name = rs.getstring("Full_Name");
- String age = rs.getstring("Age");
- String date = rs.getstring("Date_of_Birth");
- String church = rs.getstring("Church");
- String food = rs.getstring("Food");
- String medicalreason = rs.getstring("Medical Reason");
- String specifymedical = rs.getstring("Specify_Medical");
- }
- }
- /**
- * This method is called from within the constructor to initialize the form.
- * WARNING: Do NOT modify this code. The content of this method is always
- * regenerated by the Form Editor.
- */
- @SuppressWarnings("unchecked")
- // <editor-fold defaultstate="collapsed" desc="Generated Code">
- private void initComponents() {
- buttonGroup1 = new javax.swing.ButtonGroup();
- buttonGroup2 = new javax.swing.ButtonGroup();
- buttonGroup3 = new javax.swing.ButtonGroup();
- lbl_name = new javax.swing.JLabel();
- lbl_age = new javax.swing.JLabel();
- lbl_date = new javax.swing.JLabel();
- lbl_gender = new javax.swing.JLabel();
- txt_name = new javax.swing.JTextField();
- txt_age = new javax.swing.JTextField();
- txt_date = new javax.swing.JTextField();
- chk_male = new javax.swing.JCheckBox();
- chk_female = new javax.swing.JCheckBox();
- lbl_assa = new javax.swing.JLabel();
- lbl_application = new javax.swing.JLabel();
- lbl_theme = new javax.swing.JLabel();
- lbl_church = new javax.swing.JLabel();
- jLabel9 = new javax.swing.JLabel();
- txt_church = new javax.swing.JTextField();
- lbl_food = new javax.swing.JLabel();
- jScrollPane1 = new javax.swing.JScrollPane();
- txt_food = new javax.swing.JTextArea();
- lbl_treatment = new javax.swing.JLabel();
- chk_yes = new javax.swing.JCheckBox();
- chk_no = new javax.swing.JCheckBox();
- lbl_medicalreason = new javax.swing.JLabel();
- txt_medicalreason = new javax.swing.JTextField();
- lbl_specifymedical = new javax.swing.JLabel();
- jScrollPane2 = new javax.swing.JScrollPane();
- txt_specifymedical = new javax.swing.JTextArea();
- lbl_activities = new javax.swing.JLabel();
- lbl_juniors = new javax.swing.JLabel();
- lbl_seniors = new javax.swing.JLabel();
- jLabel17 = new javax.swing.JLabel();
- radio_craft = new javax.swing.JRadioButton();
- radio_drama = new javax.swing.JRadioButton();
- radio_music = new javax.swing.JRadioButton();
- radio_beads = new javax.swing.JRadioButton();
- radio_drum = new javax.swing.JRadioButton();
- radio_baloon = new javax.swing.JRadioButton();
- add = new javax.swing.JButton();
- lbl_name.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
- lbl_name.setText("NAME");
- lbl_age.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
- lbl_age.setText("AGE");
- lbl_date.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
- lbl_date.setText("DATE");
- lbl_gender.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
- lbl_gender.setText("GENDER");
- chk_male.setText("male");
- chk_female.setText("female");
- lbl_assa.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
- lbl_assa.setText("ANGLICAN SUNDAY SCHOOL ASSOCIATION (ASSA)");
- lbl_application.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
- lbl_application.setText("STUDY CAMP 2012 APPLICATION FORM");
- lbl_theme.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
- lbl_theme.setText("THEME : \"KNOWING CHRIST AND MAKING HIM KNOWN\" . PHILIPPIANS 3:10");
- lbl_church.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
- lbl_church.setText("NAME OF CHURCH");
- lbl_food.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
- lbl_food.setText("FOODS YOU DO NOT EAT - PLEASE SPECIFY");
- txt_food.setColumns(20);
- txt_food.setRows(5);
- jScrollPane1.setViewportView(txt_food);
- lbl_treatment.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
- lbl_treatment.setText("ARE YOU CURRENTLY UNDERGOING ANY MEDICAL TREATMENT?");
- chk_yes.setText("yes");
- chk_no.setText("no");
- lbl_medicalreason.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
- lbl_medicalreason.setText("IF YES PLEASE SPECIFY");
- lbl_specifymedical.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
- lbl_specifymedical.setText("SPECIFY ANY MEDICAL ATTENTION NEEDED AT CAMP");
- txt_specifymedical.setColumns(20);
- txt_specifymedical.setRows(5);
- jScrollPane2.setViewportView(txt_specifymedical);
- lbl_activities.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
- lbl_activities.setText("EXTRA CURRICULUM ACTIVITIES");
- lbl_juniors.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
- lbl_juniors.setText("JUNIORS");
- lbl_seniors.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
- lbl_seniors.setText("SENIORS");
- radio_craft.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
- radio_craft.setText("CRAFT WORK");
- radio_drama.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
- radio_drama.setText("DRAMA & DANCE");
- radio_music.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
- radio_music.setText("MUSIC");
- radio_beads.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
- radio_beads.setText("BEADS ARRANGEMENT");
- radio_drum.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
- radio_drum.setText("DRAMA & DANCE");
- radio_baloon.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
- radio_baloon.setText("BALOON & RIBBON DECORATION");
- add.setText("ADD CAMPER");
- add.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- addActionPerformed(evt);
- }
- });
- javax.swing.GroupLayout layout = new javax.swing.GroupLayout(this);
- this.setLayout(layout);
- layout.setHorizontalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addGap(48, 48, 48)
- .addComponent(lbl_juniors)
- .addGap(123, 123, 123)
- .addComponent(lbl_seniors, javax.swing.GroupLayout.PREFERRED_SIZE, 57, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addComponent(jLabel17)
- .addGap(83, 83, 83))
- .addGroup(layout.createSequentialGroup()
- .addGap(23, 23, 23)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
- .addGroup(layout.createSequentialGroup()
- .addComponent(chk_yes)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(chk_no))
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
- .addComponent(jScrollPane1, javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
- .addGap(118, 118, 118)
- .addComponent(txt_church, javax.swing.GroupLayout.PREFERRED_SIZE, 337, javax.swing.GroupLayout.PREFERRED_SIZE))))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addComponent(jLabel9))
- .addGroup(layout.createSequentialGroup()
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(lbl_theme)
- .addComponent(lbl_age)
- .addComponent(lbl_church)
- .addGroup(layout.createSequentialGroup()
- .addComponent(lbl_name)
- .addGap(18, 18, 18)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addComponent(txt_age, javax.swing.GroupLayout.PREFERRED_SIZE, 66, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGap(27, 27, 27)
- .addComponent(lbl_date)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
- .addComponent(txt_date, javax.swing.GroupLayout.PREFERRED_SIZE, 133, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGap(30, 30, 30)
- .addComponent(lbl_gender)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(chk_female)
- .addComponent(chk_male)))
- .addComponent(txt_name, javax.swing.GroupLayout.PREFERRED_SIZE, 363, javax.swing.GroupLayout.PREFERRED_SIZE)))
- .addComponent(lbl_food)
- .addComponent(lbl_treatment)
- .addComponent(lbl_specifymedical)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
- .addComponent(jScrollPane2, javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
- .addComponent(lbl_medicalreason)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
- .addComponent(txt_medicalreason, javax.swing.GroupLayout.PREFERRED_SIZE, 313, javax.swing.GroupLayout.PREFERRED_SIZE))))
- .addGap(0, 0, Short.MAX_VALUE)))
- .addContainerGap())
- .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
- .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
- .addComponent(lbl_assa)
- .addGap(98, 98, 98))
- .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
- .addComponent(lbl_application)
- .addGap(128, 128, 128))))
- .addGroup(layout.createSequentialGroup()
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addGap(40, 40, 40)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(radio_craft)
- .addComponent(radio_drama)
- .addComponent(radio_music))
- .addGap(77, 77, 77)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(radio_baloon)
- .addComponent(radio_drum)
- .addComponent(radio_beads)))
- .addGroup(layout.createSequentialGroup()
- .addGap(164, 164, 164)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(lbl_activities)
- .addGroup(layout.createSequentialGroup()
- .addGap(29, 29, 29)
- .addComponent(add)))))
- .addContainerGap())
- );
- layout.setVerticalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addComponent(lbl_assa)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(lbl_application)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(lbl_theme)
- .addGap(47, 47, 47)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(lbl_name)
- .addComponent(txt_name, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addGap(18, 18, 18)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
- .addComponent(lbl_age)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(txt_age, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(lbl_date)
- .addComponent(txt_date, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(chk_male)
- .addComponent(lbl_gender)))
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addGap(26, 26, 26)
- .addComponent(jLabel9))
- .addGroup(layout.createSequentialGroup()
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(chk_female)))
- .addGap(16, 16, 16)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
- .addComponent(lbl_church)
- .addComponent(txt_church, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addGap(18, 18, 18)
- .addComponent(lbl_food)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 37, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(lbl_treatment)
- .addComponent(chk_yes)
- .addComponent(chk_no))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
- .addComponent(lbl_medicalreason)
- .addComponent(txt_medicalreason, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
- .addComponent(lbl_specifymedical)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
- .addComponent(lbl_activities)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(lbl_juniors)
- .addComponent(lbl_seniors)
- .addComponent(jLabel17))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(radio_craft)
- .addComponent(radio_beads))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(radio_drama)
- .addComponent(radio_drum))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(radio_music)
- .addComponent(radio_baloon))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 16, Short.MAX_VALUE)
- .addComponent(add)
- .addContainerGap())
- );
- }// </editor-fold>
- private void addActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- // Variables declaration - do not modify
- private javax.swing.JButton add;
- private javax.swing.ButtonGroup buttonGroup1;
- private javax.swing.ButtonGroup buttonGroup2;
- private javax.swing.ButtonGroup buttonGroup3;
- private javax.swing.JCheckBox chk_female;
- private javax.swing.JCheckBox chk_male;
- private javax.swing.JCheckBox chk_no;
- private javax.swing.JCheckBox chk_yes;
- private javax.swing.JLabel jLabel17;
- private javax.swing.JLabel jLabel9;
- private javax.swing.JScrollPane jScrollPane1;
- private javax.swing.JScrollPane jScrollPane2;
- private javax.swing.JLabel lbl_activities;
- private javax.swing.JLabel lbl_age;
- private javax.swing.JLabel lbl_application;
- private javax.swing.JLabel lbl_assa;
- private javax.swing.JLabel lbl_church;
- private javax.swing.JLabel lbl_date;
- private javax.swing.JLabel lbl_food;
- private javax.swing.JLabel lbl_gender;
- private javax.swing.JLabel lbl_juniors;
- private javax.swing.JLabel lbl_medicalreason;
- private javax.swing.JLabel lbl_name;
- private javax.swing.JLabel lbl_seniors;
- private javax.swing.JLabel lbl_specifymedical;
- private javax.swing.JLabel lbl_theme;
- private javax.swing.JLabel lbl_treatment;
- private javax.swing.JRadioButton radio_baloon;
- private javax.swing.JRadioButton radio_beads;
- private javax.swing.JRadioButton radio_craft;
- private javax.swing.JRadioButton radio_drama;
- private javax.swing.JRadioButton radio_drum;
- private javax.swing.JRadioButton radio_music;
- private javax.swing.JTextField txt_age;
- private javax.swing.JTextField txt_church;
- private javax.swing.JTextField txt_date;
- private javax.swing.JTextArea txt_food;
- private javax.swing.JTextField txt_medicalreason;
- private javax.swing.JTextField txt_name;
- private javax.swing.JTextArea txt_specifymedical;
- // End of variables declaration
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement