Java Program to Create Patient Database App Assignment Solution.

ALLERGY HISTORY

import javax.swing.*;

import java.awt.Component;

import java.awt.event.*;

import java.sql.PreparedStatement;

public class AllergyHistoryForm extends JFrame {

private int questionId = 1;

public void start(DBConnection con, int patientId) {

// Create frame

JFrame frame = new JFrame();

// Create labels and textfields

JLabel patientIdLbl = new JLabel("Patient ID");

JLabel allergenQuestionLbl = new JLabel("Allergen");

JLabel allergyStartDateLbl = new JLabel("When did the allergy started?");

JLabel allergyEndDateLbl = new JLabel("When did the allergy ended?");

JLabel allergyDescriptionLbl = new JLabel("Describe the allergy");

JTextField patientIdTxt = new JTextField(String.valueOf(patientId));

JTextField allergenQuestionTxt = new JTextField("");

JTextField allergyStartDateTxt = new JTextField("");

JTextField allergyEndDateTxt = new JTextField("");

JTextArea allergyDescriptionTxt = new JTextArea("");

patientIdLbl.setBounds(20, 20, 100, 20);

patientIdTxt.setBounds(140, 20, 100, 20);

allergenQuestionLbl.setBounds(20, 60, 100, 20);

allergenQuestionTxt.setBounds(140, 60, 100, 20);

allergyStartDateLbl.setBounds(20, 100, 100, 20);

allergyStartDateTxt.setBounds(140, 100, 100, 20);

allergyEndDateLbl.setBounds(260, 100, 100, 20);

allergyEndDateTxt.setBounds(380, 100, 100, 20);

allergyDescriptionLbl.setBounds(20, 140, 100, 20);

allergyDescriptionTxt.setBounds(140, 140, 300, 100);

// next button

JButton nextBtn = new JButton("Start Quiz");

nextBtn.setBounds(560, 280, 120, 20);

// Create nBinary Tree

BinaryTree allergyTree = new BinaryTree();

// add action

nextBtn.addActionListener(new ActionListener() {

@Override

public void actionPerformed(ActionEvent e) {

// Check if a patient is selected from list

setTextFieldsEditable(frame, false);

if(questionId >= 1 && questionId <= 5) {

nextBtn.setText(("Next question"));

}

if(questionId == 1) {

allergenQuestionTxt.setEditable(true);

} else if(questionId == 2) {

// Add the results from question 1

allergyTree.add(allergenQuestionLbl.getText(), allergenQuestionTxt.getText());

allergyStartDateTxt.setEditable(true);

allergyEndDateTxt.setEditable(true);

} else if(questionId == 3) {

// Add the results from question 2

allergyTree.add(allergyStartDateLbl.getText(), allergyStartDateTxt.getText());

allergyTree.add(allergyEndDateLbl.getText(), allergyEndDateTxt.getText());

allergyDescriptionTxt.setEditable(true);

nextBtn.setText("Save");

} else if(questionId == 4) {

// Add the results from question 3

allergyTree.add(allergyDescriptionLbl.getText(), allergyDescriptionTxt.getText());

try {

String query = "INSERT INTO `allergyhistorytable` VALUES (?, ?, ?, ?, ?, ?, ?);";

PreparedStatement prepStatement = con.getConnection().prepareStatement(query);

prepStatement.setInt(1, 0);

prepStatement.setInt(2, patientId);

prepStatement.setString(3, allergenQuestionTxt.getText());

prepStatement.setString(4, allergyStartDateTxt.getText());

prepStatement.setString(5,allergyEndDateTxt.getText());

prepStatement.setString(6, allergyDescriptionTxt.getText());

prepStatement.setInt(7, 0);

prepStatement.execute();

prepStatement.close();

}

catch (Exception ex ){

ex.printStackTrace();

}

frame.setVisible(false);

dispose();

}

questionId++;

}

});

frame.add(nextBtn);

frame.add(patientIdLbl);

frame.add(patientIdTxt);

frame.add(allergenQuestionLbl);

frame.add(allergenQuestionTxt);

frame.add(allergyStartDateLbl);

frame.add(allergyStartDateTxt);

frame.add(allergyEndDateLbl);

frame.add(allergyEndDateTxt);

frame.add(allergyDescriptionLbl);

frame.add(allergyDescriptionTxt);

// Set all fields to readonly

setTextFieldsEditable(frame, false);

frame.setSize(750,350);

frame.setLayout(null);

frame.setVisible(true);

}

public static void setTextFieldsEditable(JFrame frame, boolean editable) {

// Set all textfields as readonly

for (Component component : frame.getContentPane().getComponents()) {

if (component instanceof JTextField) {

((JTextField)component).setEditable(editable);

} else if(component instanceof JTextArea) {

((JTextArea)component).setEditable(editable);

}

}

}

}

GENERAL MEDICAL HISTORY FORM

import javax.swing.*;

import java.awt.Component;

import java.awt.event.*;

import java.sql.PreparedStatement;

public class GeneralMedicalHistoryForm extends JFrame {

private int questionId = 1;

public void start(DBConnection con, int patientId) {

// Create frame

JFrame frame = new JFrame();

// Create labels and textfields

JLabel patientIdLbl = new JLabel("Patient ID");

JLabel tobaccoQuestionLbl = new JLabel("Do you smoke?");

JLabel tobaccoQtyLbl = new JLabel("Quantity");

JLabel alcoholQuestionLbl = new JLabel("Do you drink alcohol?");

JLabel alcoholQtyLbl = new JLabel("Quantity");

JLabel alcoholDurationLbl = new JLabel("Duration");

JLabel drugQuestionLbl = new JLabel("Do you consume drugs?");

JLabel drugTypeLbl = new JLabel("Type");

JLabel drugDurationLbl = new JLabel("Duration");

JLabel bloodTypeLbl = new JLabel("Blood Type");

JLabel rhLbl = new JLabel("Rh");

JTextField patientIdTxt = new JTextField(String.valueOf(patientId));

JTextField tobaccoQuestionTxt = new JTextField("");

JTextField tobaccoQtyTxt = new JTextField("");

JTextField alcoholQuestionTxt = new JTextField("");

JTextField alcoholQtyTxt = new JTextField("");

JTextField alcoholDurationTxt = new JTextField("");

JTextField drugQuestionTxt = new JTextField("");

JTextField drugTypeTxt = new JTextField("");

JTextField drugDurationTxt = new JTextField("");

JTextField bloodTypeTxt = new JTextField();

JTextField rhTxt = new JTextField();

patientIdLbl.setBounds(20, 20, 100, 20);

patientIdTxt.setBounds(140, 20, 100, 20);

tobaccoQuestionLbl.setBounds(20, 60, 100, 20);

tobaccoQuestionTxt.setBounds(140, 60, 100, 20);

tobaccoQtyLbl.setBounds(260, 60, 100, 20);

tobaccoQtyTxt.setBounds(380, 60, 100, 20);

alcoholQuestionLbl.setBounds(20, 100, 100, 20);

alcoholQuestionTxt.setBounds(140, 100, 100, 20);

alcoholQtyLbl.setBounds(260, 100, 100, 20);

alcoholQtyTxt.setBounds(380, 100, 100, 20);

alcoholDurationLbl.setBounds(500, 100, 100, 20);

alcoholDurationTxt.setBounds(620, 100, 100, 20);

drugQuestionLbl.setBounds(20, 140, 100, 20);

drugQuestionTxt.setBounds(140, 140, 100, 20);

drugTypeLbl.setBounds(260, 140, 100, 20);

drugTypeTxt.setBounds(380, 140, 100, 20);

drugDurationLbl.setBounds(500, 140, 100, 20);

drugDurationTxt.setBounds(620, 140, 100, 20);

bloodTypeLbl.setBounds(20, 180, 100, 20);

bloodTypeTxt.setBounds(140, 180, 100, 20);

rhLbl.setBounds(20, 220, 100, 20);

rhTxt.setBounds(140, 220, 100, 20);

// next button

JButton nextBtn = new JButton("Start Quiz");

nextBtn.setBounds(560, 280, 120, 20);

// Create nBinary Tree

BinaryTree generalTree = new BinaryTree();

// add action

nextBtn.addActionListener(new ActionListener() {

@Override

public void actionPerformed(ActionEvent e) {

// Check if a patient is selected from list

setTextFieldsEditable(frame, false);

if(questionId >= 1 && questionId <= 6) {

nextBtn.setText(("Next question"));

}

if(questionId == 1) {

tobaccoQtyTxt.setEditable(true);

tobaccoQuestionTxt.setEditable(true);

} else if(questionId == 2) {

// Add the results from question 1

generalTree.add(tobaccoQuestionLbl.getText(), tobaccoQuestionTxt.getText());

generalTree.add(tobaccoQtyLbl.getText(), tobaccoQtyTxt.getText());

alcoholQuestionTxt.setEditable(true);

alcoholQtyTxt.setEditable(true);

TODO Auto-generated catch block

e1.printStackTrace();

}

}

}

});

frame.add(patientsCB);

frame.add(selectBtn);

frame.setSize(400,250);

frame.setLayout(null);

frame.setVisible(true);

}

}