mvc

package Model;

public class Family {
	String FamilyID;
	String FamilyName;
	String Address;
	String ContactNumber;
	String Income;
	String Members;
	public String getFamilyID() {
		return FamilyID;
	}
	public void setFamilyID(String familyID) {
		FamilyID = familyID;
	}
	public String getFamilyName() {
		return FamilyName;
	}
	public void setFamilyName(String familyName) {
		FamilyName = familyName;
	}
	public String getAddress() {
		return Address;
	}
	public void setAddress(String address) {
		Address = address;
	}
	public String getContactNumber() {
		return ContactNumber;
	}
	public void setContactNumber(String contactNumber) {
		ContactNumber = contactNumber;
	}
	public String getIncome() {
		return Income;
	}
	public void setIncome(String income) {
		Income = income;
	}
	public String getMembers() {
		return Members;
	}
	public void setMembers(String members) {
		Members = members;
	}

    public Family() {
        super();

    }


}
*******
package Controller;
import java.sql.*;


public class Driver {

    public static Connection getConnection(){

        Connection conn = null;



    try{
        conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/oop","root","");

        System.out.println("CONNECTED");
    }

    catch(Exception a){
        System.out.println("NOT CONNECTED");
    }
    return conn;
    }
}
******
package Controller;

import java.util.*;

import org.eclipse.swt.events.SelectionEvent;

import java.sql.*;
import Model.*;





public class Controller {






	public List <Family> findAll(){
        try{
            List <Family> listFamily = new ArrayList<>();

        PreparedStatement pst = Driver.getConnection().prepareStatement ("Select * from summer");

        ResultSet rs = pst.executeQuery();
        while (rs.next())
        {
            Family e= new Family();
            e.setFamilyID(rs.getString("FamilyId"));
            e.setFamilyName(rs.getString("FamilyName"));
            e.setAddress(rs.getString("Address"));
            e.setContactNumber(rs.getString("ContactNumber"));
            e.setIncome(rs.getString("Income"));
            e.setMembers(rs.getString("Members"));

            listFamily.add(e);


        }

        return listFamily;

        }

        catch(Exception b){
            return null;
        }
}


    public boolean create(Family e){
        try{
            PreparedStatement pst = Driver.getConnection().prepareStatement("insert into summer(FamilyID,FamilyName,Address,ContactNumber,Income,Members)values(?,?,?,?,?,?)");
            pst.setString(1,e.getFamilyID());
            pst.setString(2,e.getFamilyName());
            pst.setString(3,e.getAddress());
            pst.setString(4,e.getContactNumber());
            pst.setString(5,e.getIncome());
            pst.setString(6,e.getMembers());

            System.out.println("RECORDED");
            return pst.executeUpdate()>0;
    }
    catch(Exception c){
        System.out.println("NOT RECORDED");
        return false;
    	}
    }


		public boolean delete(Family e) {
			  try{
	    		  PreparedStatement pst = Driver.getConnection().prepareStatement("delete from summer where familyID =(?)");
	    		  pst.setString(1,e.getFamilyID());
	    		  return pst.executeUpdate() > 0;

	    	  }
	    	  catch (Exception k){
	    		  return false;

	    	  }

		}
    }


******
package View;

import org.eclipse.swt.widgets.Display;
import org.eclipse.swt.widgets.Shell;
import org.eclipse.swt.widgets.Table;

import javax.swing.JOptionPane;

import org.eclipse.swt.SWT;
import org.eclipse.swt.widgets.TableColumn;
import org.eclipse.swt.widgets.TableItem;
import org.eclipse.swt.widgets.Label;
import org.eclipse.swt.widgets.Text;

import Controller.Controller;
import Model.Family;

import org.eclipse.swt.widgets.Button;
import org.eclipse.swt.events.SelectionAdapter;
import org.eclipse.swt.events.SelectionEvent;
import org.eclipse.wb.swt.SWTResourceManager;

public class View {
	Controller c = new Controller();
	protected Shell shlFamily;
	private Table table;
	private Text textId;
	private Text textName;
	private Text textAdd;
	private Text textNum;
	private Text textincome;
	private Text textmem;

	/**
	 * Launch the application.
	 * @param args
	 */
	public static void main(String[] args) {
		try {
			View window = new View();
			window.open();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	   private void fillData(){
	        Controller c = new Controller();

	        for (Family e: c.findAll()){
	            TableItem tableItem = new TableItem (table,SWT.NONE);



	            tableItem.setText(new String []
	                    {String.valueOf (e.getFamilyID()) ,(e.getFamilyName()),(e.getAddress()),(e.getContactNumber()),String.valueOf(e.getIncome()),String.valueOf(e.getMembers())});
	        }
	   }
	/**
	 * Open the window.
	 */
	public void open() {
		Display display = Display.getDefault();
		createContents();
		fillData();
		shlFamily.open();
		shlFamily.layout();
		while (!shlFamily.isDisposed()) {
			if (!display.readAndDispatch()) {
				display.sleep();
			}
		}

	}

	/**
	 * Create contents of the window.
	 */
	protected void createContents() {
		shlFamily = new Shell();
		shlFamily.setBackground(SWTResourceManager.getColor(169, 169, 169));
		shlFamily.setSize(614, 504);
		shlFamily.setText("Family");

		table = new Table(shlFamily, SWT.BORDER | SWT.FULL_SELECTION);
		table.setBackground(SWTResourceManager.getColor(224, 255, 255));
		table.setBounds(0, 0, 605, 251);
		table.setHeaderVisible(true);
		table.setLinesVisible(true);

		TableColumn tblclmnNewColumn = new TableColumn(table, SWT.NONE);
		tblclmnNewColumn.setWidth(100);
		tblclmnNewColumn.setText("Family ID");

		TableColumn tblclmnNewColumn_1 = new TableColumn(table, SWT.NONE);
		tblclmnNewColumn_1.setWidth(100);
		tblclmnNewColumn_1.setText("FamilyName");

		TableColumn tblclmnNewColumn_2 = new TableColumn(table, SWT.NONE);
		tblclmnNewColumn_2.setWidth(83);
		tblclmnNewColumn_2.setText("Address");

		TableColumn tblclmnNewColumn_3 = new TableColumn(table, SWT.NONE);
		tblclmnNewColumn_3.setWidth(111);
		tblclmnNewColumn_3.setText("Contact Number");

		TableColumn tblclmnNewColumn_4 = new TableColumn(table, SWT.NONE);
		tblclmnNewColumn_4.setWidth(100);
		tblclmnNewColumn_4.setText("Income");

		TableColumn tblclmnNewColumn_5 = new TableColumn(table, SWT.NONE);
		tblclmnNewColumn_5.setWidth(100);
		tblclmnNewColumn_5.setText("Members");

		TableItem tableItem = new TableItem(table, SWT.NONE);

		Label lblFamilyId = new Label(shlFamily, SWT.NONE);
		lblFamilyId.setFont(SWTResourceManager.getFont("Segoe UI", 9, SWT.BOLD));
		lblFamilyId.setBackground(SWTResourceManager.getColor(169, 169, 169));
		lblFamilyId.setBounds(15, 268, 55, 15);
		lblFamilyId.setText("Family ID");

		Label lblFamilyName = new Label(shlFamily, SWT.NONE);
		lblFamilyName.setFont(SWTResourceManager.getFont("Segoe UI", 9, SWT.BOLD));
		lblFamilyName.setBackground(SWTResourceManager.getColor(169, 169, 169));
		lblFamilyName.setBounds(10, 300, 71, 15);
		lblFamilyName.setText("Family Name");

		Label lblAddress = new Label(shlFamily, SWT.NONE);
		lblAddress.setFont(SWTResourceManager.getFont("Segoe UI", 9, SWT.BOLD));
		lblAddress.setBackground(SWTResourceManager.getColor(169, 169, 169));
		lblAddress.setBounds(15, 332, 55, 15);
		lblAddress.setText("Address");

		Label lblContactNumber = new Label(shlFamily, SWT.NONE);
		lblContactNumber.setFont(SWTResourceManager.getFont("Segoe UI", 9, SWT.BOLD));
		lblContactNumber.setBackground(SWTResourceManager.getColor(169, 169, 169));
		lblContactNumber.setBounds(264, 268, 98, 15);
		lblContactNumber.setText("Contact Number");

		Label lblIncome = new Label(shlFamily, SWT.NONE);
		lblIncome.setFont(SWTResourceManager.getFont("Segoe UI", 9, SWT.BOLD));
		lblIncome.setBackground(SWTResourceManager.getColor(169, 169, 169));
		lblIncome.setBounds(286, 300, 55, 15);
		lblIncome.setText("Income");

		Label lblMembers = new Label(shlFamily, SWT.NONE);
		lblMembers.setFont(SWTResourceManager.getFont("Segoe UI", 9, SWT.BOLD));
		lblMembers.setBackground(SWTResourceManager.getColor(169, 169, 169));
		lblMembers.setBounds(286, 332, 55, 15);
		lblMembers.setText("Members");

		textId = new Text(shlFamily, SWT.BORDER);
		textId.setBounds(87, 262, 122, 21);

		textName = new Text(shlFamily, SWT.BORDER);
		textName.setBounds(87, 294, 122, 21);

		textAdd = new Text(shlFamily, SWT.BORDER);
		textAdd.setBounds(87, 332, 122, 21);

		textNum = new Text(shlFamily, SWT.BORDER);
		textNum.setBounds(382, 262, 122, 21);

		textincome = new Text(shlFamily, SWT.BORDER);
		textincome.setBounds(382, 300, 122, 21);

		textmem = new Text(shlFamily, SWT.BORDER);
		textmem.setBounds(382, 332, 122, 21);

		Button btnAdd = new Button(shlFamily, SWT.NONE);
		btnAdd.setForeground(SWTResourceManager.getColor(0, 0, 128));
		btnAdd.setToolTipText("Add");
		btnAdd.addSelectionListener(new SelectionAdapter() {
			@Override
			public void widgetSelected(SelectionEvent e) {
			    Family r = new Family();
			    r.setFamilyID(textId.getText());
                r.setFamilyName(textName.getText());
                r.setAddress(textAdd.getText());
                r.setContactNumber(textNum.getText());
                r.setIncome(textincome.getText());
                r.setMembers(textmem.getText());

                if (c.create(r)){
                    JOptionPane.showMessageDialog(null, "ADD NEW FAMILY SUCCESSFUL");
                    fillData();
                }else
                    JOptionPane.showMessageDialog(null, "ADD NEW FAMILY FAILED");

			}
		});
		btnAdd.setBounds(134, 388, 75, 25);
		btnAdd.setText("ADD");

		Button btnDelete = new Button(shlFamily, SWT.NONE);
		btnDelete.setForeground(SWTResourceManager.getColor(0, 0, 128));
		btnDelete.setToolTipText("Delete");
		btnDelete.addSelectionListener(new SelectionAdapter() {
			@Override
			public void widgetSelected(SelectionEvent e) {
				Family f = new Family();
				f.setFamilyID(textId.getText());
			 	f.setFamilyName(textName.getText());
                f.setAddress(textAdd.getText());
                f.setContactNumber(textNum.getText());
                f.setIncome(textincome.getText());
                f.setMembers(textmem.getText());

            if (c.delete(f)){
                JOptionPane.showMessageDialog(null, "Succesfully Deleted ");
                fillData();
            }else
                JOptionPane.showMessageDialog(null, "Failed!");
			}
		});

		btnDelete.setBounds(360, 388, 75, 25);
		btnDelete.setText("DELETE");

	}

	}