import java.awt.BorderLayout;
import java.awt.EventQueue;
import java.util.ArrayList;

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import javax.swing.JList;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.JTextArea;
import javax.swing.DefaultListModel;
import javax.swing.JButton;
import javax.swing.JLabel;
import java.sql.*;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import javax.swing.event.ListSelectionListener;
import javax.swing.event.ListSelectionEvent;


public class Main extends JFrame {
	private JPanel contentPane;
	private JTextField fromTextField;
	private JTextField toTextField;
	JList list;
	JTextArea textArea;
	ArrayList<String> text = new ArrayList<>();
	ArrayList<String> from = new ArrayList<>();
	ArrayList<String> to = new ArrayList<>();
	Connection con;
	String name;

	public static void main(String[] args) {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				try {
					String login = JOptionPane.showInputDialog("Введите логин:");
					Main frame = new Main(login);
					frame.setVisible(true);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		});
	}

	void load_data() {
		try {
			Statement stm = con.createStatement();
			ResultSet res = stm.executeQuery(
					"select * from message where `to` = '" + name + "'");
			text.clear();
			from.clear();
			to.clear();
			while (res.next()) {
				text.add(res.getString("text"));
				from.add(res.getString("from"));
				to.add(res.getString("to"));
			}
			DefaultListModel<String> model = new DefaultListModel<>();
			for (int i = 0; i < text.size(); ++i) {
				model.addElement(from.get(i));
			}
			list.setModel(model);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public Main(String login) {
		name = login;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager.getConnection(
					"jdbc:mysql://localhost/chat", "root", "");
		} catch (ClassNotFoundException | SQLException e) {
			e.printStackTrace();
			JOptionPane.showMessageDialog(null, "Нет подключения");
			System.exit(0);
		}
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(100, 100, 436, 293);
		contentPane = new JPanel();
		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
		setContentPane(contentPane);
		contentPane.setLayout(null);

		list = new JList();
		list.addListSelectionListener(new ListSelectionListener() {
			public void valueChanged(ListSelectionEvent arg0) {
				int n = list.getSelectedIndex();

				fromTextField.setText(from.get(n));
				toTextField.setText(to.get(n));
				textArea.setText(text.get(n));

				fromTextField.setEditable(false);
				toTextField.setEditable(false);
				textArea.setEditable(false);
			}
		});
		list.setBounds(10, 11, 162, 198);
		contentPane.add(list);

		fromTextField = new JTextField();
		fromTextField.setBounds(249, 11, 133, 20);
		contentPane.add(fromTextField);
		fromTextField.setColumns(10);

		toTextField = new JTextField();
		toTextField.setBounds(249, 42, 133, 20);
		contentPane.add(toTextField);
		toTextField.setColumns(10);

		textArea = new JTextArea();
		textArea.setBounds(182, 73, 224, 136);
		contentPane.add(textArea);

		JButton checkButton = new JButton("\u041F\u0440\u043E\u0432\u0435\u0440\u0438\u0442\u044C");
		checkButton.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				load_data();
			}
		});
		checkButton.setBounds(10, 221, 162, 23);
		contentPane.add(checkButton);

		JButton createButton = new JButton("\u041D\u043E\u0432\u043E\u0435 \u043F\u0438\u0441\u044C\u043C\u043E");
		createButton.setBounds(182, 221, 110, 23);
		contentPane.add(createButton);

		JButton sendButton = new JButton("\u041E\u0442\u043F\u0440\u0430\u0432\u0438\u0442\u044C");
		sendButton.setBounds(296, 221, 114, 23);
		contentPane.add(sendButton);

		JLabel lblNewLabel = new JLabel("\u041E\u0442:");
		lblNewLabel.setBounds(213, 12, 46, 14);
		contentPane.add(lblNewLabel);

		JLabel lblNewLabel_1 = new JLabel("\u041A\u043E\u043C\u0443:");
		lblNewLabel_1.setBounds(213, 45, 46, 14);
		contentPane.add(lblNewLabel_1);
	}

}