import java.awt.*;
import java.util.Scanner;
import java.util.zip.ZipEntry;
import java.util.zip.ZipInputStream;

import javax.swing.*;
import javax.swing.border.LineBorder;

import java.awt.event.*;
import java.io.*;

public class myGUI extends JFrame{
private static final long serialVersionUID = 1L;
private static final int WIDTH = 400;
private static final int HEIGHT = 400;

private JTextField top;
private JTextArea bottom;
private JButton openFile, loadData;

private FileHandler fh;
private DataLoader dl;

private File f;

public myGUI() {
//Set up GUI properties, initialize objects etc
top = new JTextField(30);
top.setEditable(false);
bottom = new JTextArea(14, 30);
bottom.setEditable(false);
bottom.setBorder(new LineBorder(Color.BLACK));
//Add our Buttons
openFile = new JButton("Open a file");
loadData = new JButton("Load the data");
//Add event handlers for the buttons
fh = new FileHandler();
openFile.addActionListener(fh);

dl = new DataLoader();
loadData.addActionListener(dl);

setTitle("Project 1");
//Create and set layout for our GUI
Container c = getContentPane();

c.setLayout(new FlowLayout(1, 50, 25));

bottom.setPreferredSize(new Dimension(50,200));
//Add everything to the frame
c.add(top);
c.add(openFile);
c.add(loadData);
c.add(bottom);

setSize(WIDTH, HEIGHT);
setVisible(true);
setDefaultCloseOperation(EXIT_ON_CLOSE);

}

// Listener for our "Open File" button, opens file explorer, updates top text box, and saves file location
private class FileHandler implements ActionListener {
private final JFileChooser fc = new JFileChooser();

public void actionPerformed(ActionEvent e) {
if (e.getSource() == openFile) {
int val = fc.showOpenDialog(myGUI.this);

if (val == JFileChooser.APPROVE_OPTION) {
f = fc.getSelectedFile();
top.setText(f.toString());
}
}
}
}

// Listener for the "Load Data" button, calls the zipHandler() function
private class DataLoader implements ActionListener{
public void actionPerformed(ActionEvent e) {
if (e.getSource() == loadData) {
zipHandler();
}
}
}

// Function which establishes connection to DB, opens zip file(s), and executes the subsequent SQL queries
private void zipHandler() {
int count;
DBHandler db = new DBHandler();
db.createConnection();
Scanner in;

try {
ZipInputStream zin = new ZipInputStream(new FileInputStream(f));

ZipEntry zent;

while ((zent = zin.getNextEntry()) != null) {
count = 0;
bottom.append("Opening zip entry: " + zent.getName() + "...\n");
System.out.println(zent.getName());

in = new Scanner(zin);

while (in.hasNextLine()) {
String query = in.nextLine();
if (!query.isEmpty()) {
db.execQuery(query);
}
count++;
}

bottom.append("Added " + count + " rows to the database\n");
}
} catch (IOException ex) {
ex.printStackTrace();
}
db.closeDB();
}

}

private void zipHandler() {
int count;
DBHandler db = new DBHandler();
db.createConnection();
Scanner in;

try {
ZipInputStream zin = new ZipInputStream(new FileInputStream(f));

ZipEntry zent;

while ((zent = zin.getNextEntry()) != null) {
count = 0;
bottom.append("Opening zip entry: " + zent.getName() + "...\n");
System.out.println(zent.getName());

in = new Scanner(zin);

while (in.hasNextLine()) {
String query = in.nextLine();
if (!query.isEmpty()) {
db.execQuery(query);
}
count++;
}

bottom.append("Added " + count + " rows to the database\n");
}
} catch (IOException ex) {
ex.printStackTrace();
}
db.closeDB();
}

public class DatabaseQueryExecutor implements Runnable
{
public void run()
{
//code you want run on a seperate thread
}
}

public class GUI
{
//...

private void doDatabaseStuff()
{
DatabaseQueryExecutor dqe = new DatabaseQueryExecutor();

new Thread(dqe).start();

}
}

public class DatabaseQueryExecutor extends Thread
{
public void run()
{
//code you want run on a seperate thread
}
}

public class GUI
{
//...

private void doDatabaseStuff()
{
DatabaseQueryExecutor dqe = new DatabaseQueryExecutor();

dqe.start();

}
}