package Listado;

import java.awt.EventQueue;

import javax.swing.JFrame;
import java.awt.FlowLayout;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.io.BufferedReader;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import javax.swing.JList;
import javax.swing.JTextField;
import javax.swing.DefaultListModel;
import javax.swing.JButton;
import java.awt.BorderLayout;
import javax.swing.JPanel;
import javax.swing.ListSelectionModel;


public class principal {

    private JFrame frame;
    private JTextField text;
    private JList<String> list;

    /**
     * Launch the application.
     */
    public static void main(String[] args) {
        EventQueue.invokeLater(new Runnable() {
            public void run() {
                try {
                    principal window = new principal();
                    window.frame.setVisible(true);
                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
        });
    }

    /**
     * Create the application.
     */
    public principal() {
        initialize();
    }

    /**
     * Initialize the contents of the frame.
     */
    private void initialize() {
        frame = new JFrame();
        frame.setBounds(100, 100, 658, 300);
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        frame.getContentPane().setLayout(new BorderLayout(0, 0));

        list = new JList<String>();
        list.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
        list.addMouseListener(new MouseAdapter() {
            @Override
            public void mouseClicked(MouseEvent e) {
                listSelected();
            }
        });
        DefaultListModel<String> model = new DefaultListModel<String>();
        list.setModel(model);

        frame.getContentPane().add(list, BorderLayout.CENTER);

        JPanel panel = new JPanel();
        frame.getContentPane().add(panel, BorderLayout.SOUTH);
        panel.setLayout(new FlowLayout(FlowLayout.CENTER, 5, 5));

        JButton Delete = new JButton("Borrar seleccionado");
        Delete.addMouseListener(new MouseAdapter() {
            @Override
            public void mouseClicked(MouseEvent arg0) {
                deleteElement();
            }
        });
        panel.add(Delete);

        JButton SaveDisk = new JButton("Guardar en disco");
        SaveDisk.addMouseListener(new MouseAdapter() {
            @Override
            public void mouseClicked(MouseEvent e) {
                saveDisk();
            }
        });
        panel.add(SaveDisk);

        JButton LoadDisk = new JButton("Cargar de disco");
        LoadDisk.addMouseListener(new MouseAdapter() {
            @Override
            public void mouseClicked(MouseEvent e) {
                loadDisk();
            }
        });
        panel.add(LoadDisk);

        JButton SaveDB = new JButton("Guardar en BD");
        SaveDB.addMouseListener(new MouseAdapter() {
            @Override
            public void mouseClicked(MouseEvent arg0) {
                saveDB();
            }
        });
        panel.add(SaveDB);

        JButton LoadDB = new JButton("Cargar de BD");
        panel.add(LoadDB);

        JPanel panel_1 = new JPanel();
        frame.getContentPane().add(panel_1, BorderLayout.WEST);
        panel_1.setLayout(new FlowLayout(FlowLayout.CENTER, 5, 5));

        text = new JTextField();
        panel_1.add(text);
        text.setColumns(10);

        JButton Add = new JButton("A\u00F1adir");
        Add.addMouseListener(new MouseAdapter() {
            @Override
            public void mouseClicked(MouseEvent e) {
                addElement();
            }
        });
        panel_1.add(Add);

        JButton Edit = new JButton("Actualizar");
        Edit.addMouseListener(new MouseAdapter() {
            @Override
            public void mouseClicked(MouseEvent e) {
                modifyElement();
            }
        });
        panel_1.add(Edit);
    }

    private void deleteElement() {
        String selectedValue = list.getSelectedValue();
        DefaultListModel<String> model = (DefaultListModel<String>) list.getModel();
        model.removeElement(selectedValue);
    }

    private void addElement() {
        String value = text.getText();
        DefaultListModel<String> model = (DefaultListModel<String>) list.getModel();
        model.addElement(value);
    }

    private void listSelected() {
        String selectedValue = list.getSelectedValue();
        text.setText(selectedValue);

    }

    private void modifyElement() {
        String value = text.getText();
        DefaultListModel<String> model = (DefaultListModel<String>) list.getModel();
        model.setElementAt(value, list.getSelectedIndex());

    }

    public JList<String> getList() {
        return list;
    }

    private void saveDisk() {
        FileWriter fw = null;
        PrintWriter pw = null;
        try {
            fw = new FileWriter("fichero.txt");
            pw = new PrintWriter(fw);
            DefaultListModel<String> model = (DefaultListModel<String>) list.getModel();
            int size = model.getSize();
            for (int i = 0; i < size; i++) {
                pw.println(model.getElementAt(i));
            }

        } catch (IOException e) {
            System.out.println("Fallo en el acceso al fichero. " + e.getStackTrace());
        } finally {
            try {
                if (fw != null) {
                    fw.close();
                }
                if (fw != null) {
                    pw.close();
                }
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }

    private void loadDisk() {
        FileReader fr = null;
        BufferedReader br = null;
        try {
            fr = new FileReader("fichero.txt");
            br = new BufferedReader(fr);
            String line;
            DefaultListModel<String> model = (DefaultListModel<String>) list.getModel();
            model.removeAllElements();
            while ((line = br.readLine()) != null) {
                model.addElement(line);
            }
            br.readLine();

        } catch (IOException e) {
            System.out.println("Fallo en el acceso al fichero. " + e.getStackTrace());
        } finally {
            try {
                if (fr != null) {
                    fr.close();
                }
                if (br != null) {
                    br.close();
                }
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }
    private void saveDB(){
        String sURL="jdbc:mysql://localhost:3306/lista";
        String user="root";
        String pass="admin";
        String sDriver="com.mysql.jdbc.Driver";
        Connection con=null;

        try {
            Class.forName(sDriver).newInstance();
        } catch (InstantiationException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (IllegalAccessException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        try {
            con = DriverManager.getConnection(sURL,user,pass);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

    }
}