package project;

public class Project {

	public static void main(String[] args) {

//		FrameInput frame = new FrameInput();

		DatabaseQuery query = new DatabaseQuery();
	}

}

----

package project;

import java.awt.BorderLayout;
import java.awt.GridLayout;
import javax.swing.*;

public class FrameInput extends JFrame {
//	behaviours
	private GridLayout layoutPanelInput;
//	panelInput
	private JPanel panelInput;
	private JTextField inputName;
	private JTextField inputPass;
//	other
	private JButton buttonInput;
	private JLabel labelResult;

	public FrameInput() {

		initComponents();

		this.setTitle("window name");
		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		this.setSize(200, 150);
		this.setVisible(true);
	}

	private void initComponents() {

		layoutPanelInput = new GridLayout(2,1);

		panelInput = new JPanel(layoutPanelInput);
		inputName = new JTextField();
		inputPass = new JTextField();
		panelInput.add(inputName);
		panelInput.add(inputPass);

		buttonInput = new JButton("Search");
		labelResult = new JLabel("PLACEHOLDER");

		this.add(labelResult, BorderLayout.PAGE_START);
		this.add(panelInput, BorderLayout.CENTER);
		this.add(buttonInput, BorderLayout.PAGE_END);
	}
}

----

package project;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DatabaseQuery {

	public DatabaseQuery() {

		initLiterals();
		try {
			Class.forName("com.mysql.jdbc.Driver");

			con = DriverManager.getConnection(dbURL, dbUser, dbName);
			System.out.println("Got connection");
		}
		catch(ClassNotFoundException e) {
			System.out.println("ERROR: Driver not found");
			e.printStackTrace(System.out);
		}
		catch(SQLException e) {
			System.out.println("ERROR: Connection not established");
			e.printStackTrace(System.out);
		}
//		finally {
//			try {
//				con.close();
//			}
//			catch(SQLException e) {
//				System.out.println("Task faile successfully");
//				e.printStackTrace(System.out);
//			}
//		}
	}

	private void initLiterals() {
		dbHost = "localhost";
		dbPort = "3306";
		dbName = "new_schema";
		dbURL = "jdbc:mysql://" + dbHost + ":" + dbPort + "/" + dbName;

		dbUser = "root";
		dbPass = "root";
		dbTable = "student";
	}

	String dbUser, dbPass, dbHost, dbPort, dbName, dbURL, dbTable;

	Connection con = null;
}