import java.awt.BorderLayout;

import javax.swing.Icon;
import javax.swing.ImageIcon;
import javax.swing.JPanel;
import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.GridBagLayout;
import java.awt.GridBagConstraints;
import java.awt.Image;

import javax.swing.JTextField;
import java.awt.Dimension;
import javax.swing.BorderFactory;
import java.awt.Color;
import java.awt.Insets;
import java.io.File;
import java.io.IOException;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JButton;

import datos.RecuperarImagenesEnDisco;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;

public class VentanaVerMoneda extends JFrame {

    private static final long serialVersionUID = 1L;
    private JPanel jContentPane = null;
    private JLabel jLabelfoto = null;
    private JButton jButtonAnterior = null;
    private JButton jButtonSiguiente = null;

    private int numero=0 ;
    private int numero2=0;

    private JTable jTable = null;
    private JPanel jPanel = null;
    private JPanel jPanel1 = null;
    private JLabel jLabelCodigoMoneda = null;
    private JTextField jTextFieldCodigoMoneda = null;
    private JLabel jLabelEsVariante = null;
    private JTextField jTextFieldEsVariante = null;
    private JLabel jLabelDescripcionError = null;
    private JTextField jTextFieldDescripcionError = null;
    private JLabel jLabelCodigoMolde = null;
    private JTextField jTextFieldCodigoMolde = null;
    private JLabel jLabelNumeroVentas = null;
    private JTextField jTextFieldNumeroVentas = null;
    /**
     * This is the default constructor
     */
    public VentanaVerMoneda() {
        super();
        initialize();
    }

    /**
     * This method initializes this
     *
     * @return void
     */
    private void initialize() {
        this.setSize(627, 314);
        this.setContentPane(getJContentPane());
        this.setTitle("JFrame");
    }

    /**
     * This method initializes jContentPane
     *
     * @return javax.swing.JPanel
     */
    private JPanel getJContentPane() {
        if (jContentPane == null) {
            GridBagConstraints gridBagConstraints10 = new GridBagConstraints();
            gridBagConstraints10.fill = GridBagConstraints.BOTH;
            gridBagConstraints10.gridy = 4;
            gridBagConstraints10.weightx = 1.0;
            gridBagConstraints10.insets = new Insets(0, 5, 5, 0);
            gridBagConstraints10.gridx = 1;
            GridBagConstraints gridBagConstraints9 = new GridBagConstraints();
            gridBagConstraints9.gridx = 0;
            gridBagConstraints9.insets = new Insets(0, 0, 5, 0);
            gridBagConstraints9.gridy = 4;
            GridBagConstraints gridBagConstraints81 = new GridBagConstraints();
            gridBagConstraints81.fill = GridBagConstraints.BOTH;
            gridBagConstraints81.gridy = 3;
            gridBagConstraints81.weightx = 1.0;
            gridBagConstraints81.insets = new Insets(0, 5, 5, 0);
            gridBagConstraints81.gridx = 1;
            GridBagConstraints gridBagConstraints7 = new GridBagConstraints();
            gridBagConstraints7.gridx = 0;
            gridBagConstraints7.insets = new Insets(0, 0, 5, 0);
            gridBagConstraints7.gridy = 3;
            GridBagConstraints gridBagConstraints6 = new GridBagConstraints();
            gridBagConstraints6.fill = GridBagConstraints.BOTH;
            gridBagConstraints6.gridy = 2;
            gridBagConstraints6.weightx = 1.0;
            gridBagConstraints6.insets = new Insets(0, 5, 5, 0);
            gridBagConstraints6.gridx = 1;
            GridBagConstraints gridBagConstraints5 = new GridBagConstraints();
            gridBagConstraints5.gridx = 0;
            gridBagConstraints5.insets = new Insets(0, 0, 5, 0);
            gridBagConstraints5.gridy = 2;
            GridBagConstraints gridBagConstraints4 = new GridBagConstraints();
            gridBagConstraints4.fill = GridBagConstraints.BOTH;
            gridBagConstraints4.gridy = 1;
            gridBagConstraints4.weightx = 1.0;
            gridBagConstraints4.insets = new Insets(0, 5, 5, 0);
            gridBagConstraints4.gridx = 1;
            GridBagConstraints gridBagConstraints3 = new GridBagConstraints();
            gridBagConstraints3.gridx = 0;
            gridBagConstraints3.insets = new Insets(0, 0, 5, 0);
            gridBagConstraints3.gridy = 1;
            GridBagConstraints gridBagConstraints21 = new GridBagConstraints();
            gridBagConstraints21.fill = GridBagConstraints.BOTH;
            gridBagConstraints21.gridy = 0;
            gridBagConstraints21.weightx = 1.0;
            gridBagConstraints21.insets = new Insets(0, 5, 5, 0);
            gridBagConstraints21.gridx = 1;
            GridBagConstraints gridBagConstraints1 = new GridBagConstraints();
            gridBagConstraints1.gridx = 0;
            gridBagConstraints1.insets = new Insets(0, 0, 5, 0);
            gridBagConstraints1.gridy = 0;
            GridBagConstraints gridBagConstraints2 = new GridBagConstraints();
            gridBagConstraints2.gridx = 0;
            gridBagConstraints2.gridy = 0;
            GridBagConstraints gridBagConstraints = new GridBagConstraints();
            gridBagConstraints.fill = GridBagConstraints.BOTH;
            gridBagConstraints.gridy = 0;
            gridBagConstraints.weightx = 1.0;
            gridBagConstraints.weighty = 1.0;
            gridBagConstraints.gridx = 0;
            GridBagConstraints gridBagConstraints12 = new GridBagConstraints();
            gridBagConstraints12.gridx = 2;
            gridBagConstraints12.insets = new Insets(5, 0, 0, 5);
            gridBagConstraints12.anchor = GridBagConstraints.CENTER;
            gridBagConstraints12.gridy = 10;
            GridBagConstraints gridBagConstraints11 = new GridBagConstraints();
            gridBagConstraints11.gridx = 0;
            gridBagConstraints11.insets = new Insets(5, 0, 0, 0);
            gridBagConstraints11.gridy = 10;
            GridBagConstraints gridBagConstraints8 = new GridBagConstraints();
            gridBagConstraints8.gridx = 1;
            gridBagConstraints8.insets = new Insets(5, 0, 0, 0);
            gridBagConstraints8.gridy = 8;
            jContentPane = new JPanel();
            jContentPane.setLayout(new GridBagLayout());
            jContentPane.add(getJLabelfoto(), gridBagConstraints8);
            jContentPane.add(getJButtonAnterior(), gridBagConstraints11);
            jContentPane.add(getJButtonSiguiente(), gridBagConstraints12);
            jContentPane.add(getJLabelCodigoMoneda(), gridBagConstraints1);
            jContentPane.add(getJTextFieldCodigoMoneda(), gridBagConstraints21);
            jContentPane.add(getJLabelEsVariante(), gridBagConstraints3);
            jContentPane.add(getJTextFieldEsVariante(), gridBagConstraints4);
            jContentPane.add(getJLabelDescripcionError(), gridBagConstraints5);
            jContentPane.add(getJTextFieldDescripcionError(), gridBagConstraints6);
            jContentPane.add(getJLabelCodigoMolde(), gridBagConstraints7);
            jContentPane.add(getJTextFieldCodigoMolde(), gridBagConstraints81);
            jContentPane.add(getJLabelNumeroVentas(), gridBagConstraints9);
            jContentPane.add(getJTextFieldNumeroVentas(), gridBagConstraints10);


        }
        return jContentPane;
    }

    /**
     * This method initializes jLabelfoto
     *
     * @return javax.swing.JLabel
     */
    private JLabel getJLabelfoto() {
        if (jLabelfoto == null) {
            jLabelfoto = new JLabel();
            jLabelfoto.setText("");
            jLabelfoto.setPreferredSize(new Dimension(80, 80));
            jLabelfoto.setBorder(BorderFactory.createLineBorder(Color.gray, 5));
        }
        return jLabelfoto;
    }

    /**
     * This method initializes jButtonAnterior
     *
     * @return javax.swing.JButton
     */
    private JButton getJButtonAnterior() {
        if (jButtonAnterior == null) {
            jButtonAnterior = new JButton();
            jButtonAnterior.setText("Anterior");
        }
        return jButtonAnterior;
    }


    /**
     * This method initializes jButtonSiguiente
     *
     * @return javax.swing.JButton
     */
    private JButton getJButtonSiguiente() {
        if (jButtonSiguiente == null) {
            jButtonSiguiente = new JButton();
            jButtonSiguiente.setText("Siguiente");
            jButtonSiguiente.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent e) {



                    //Sacamos la imagen en el jlabel, redimensionando la imagen.
                    //AQui llamamos a las funciones

                        ImageIcon imagen;

                        try {

                            RecuperarImagenesEnDisco ried = new RecuperarImagenesEnDisco();
                            Image i = ried.abrirImagen(numero);
                            imagen = new ImageIcon(i.getScaledInstance(80, 80, Image.SCALE_AREA_AVERAGING));
                            System.out.println("numero "+numero);
                            jLabelfoto.setIcon(imagen);
                            numero++;

                            //Llamamos a la función para recuperar los datos
                            SacarDatos(numero2);
                            System.out.println("numero de los datos"+ numero2);
                            numero2++;


                        } catch (SQLException e1) {
                            // TODO Auto-generated catch block
                            e1.printStackTrace();
                        } catch (IOException e1) {
                            // TODO Auto-generated catch block
                            e1.printStackTrace();
                        }

                }
            });
        }
        return jButtonSiguiente;
    }

protected void SacarDatos(int indice){

    //Aqui hacemos el select de los datos
    try {
        //Muy parecida al de foto, solo que asignando a los campos
        Class.forName("com.mysql.jdbc.Driver");
        Connection conexion = DriverManager.getConnection("jdbc:mysql://localhost:3306/numismatica","root","");
        System.out.println("Conectado Correctamente");
        Statement st = conexion.createStatement();
        ResultSet rs = st.executeQuery("select codigo_moneda,es_variante,descripcion_error,codigo_molde,numero_ventas from moneda_catalogada limit "+ indice +",1;");


    while(rs.next()){
        int codigo = rs.getInt(1);
        String variante = rs.getString(2);
        String descripcion_error = rs.getString(3);
        int molde = rs.getInt(4);
        int ventas = rs.getInt(5);

        /**
         * Asignamos los datos en los jtextfields
         */
        jTextFieldCodigoMoneda.setText(""+codigo);
        jTextFieldEsVariante.setText(variante);
        jTextFieldDescripcionError.setText(descripcion_error);
        jTextFieldCodigoMolde.setText(""+molde);
        jTextFieldNumeroVentas.setText(""+ventas);



    }
    } catch (ClassNotFoundException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

}



    /**
     * This method initializes jLabelCodigoMoneda
     *
     * @return javax.swing.JLabel
     */
    private JLabel getJLabelCodigoMoneda() {
        if (jLabelCodigoMoneda == null) {
            jLabelCodigoMoneda = new JLabel();
            jLabelCodigoMoneda.setText("Código de Moneda:");
        }
        return jLabelCodigoMoneda;
    }

    /**
     * This method initializes jTextFieldCodigoMoneda
     *
     * @return javax.swing.JTextField
     */
    private JTextField getJTextFieldCodigoMoneda() {
        if (jTextFieldCodigoMoneda == null) {
            jTextFieldCodigoMoneda = new JTextField();
            jTextFieldCodigoMoneda.setEditable(false);
        }
        return jTextFieldCodigoMoneda;
    }

    /**
     * This method initializes jLabelEsVariante
     *
     * @return javax.swing.JLabel
     */
    private JLabel getJLabelEsVariante() {
        if (jLabelEsVariante == null) {
            jLabelEsVariante = new JLabel();
            jLabelEsVariante.setText("Variante:");
        }
        return jLabelEsVariante;
    }

    /**
     * This method initializes jTextFieldEsVariante
     *
     * @return javax.swing.JTextField
     */
    private JTextField getJTextFieldEsVariante() {
        if (jTextFieldEsVariante == null) {
            jTextFieldEsVariante = new JTextField();
            jTextFieldEsVariante.setEditable(false);
        }
        return jTextFieldEsVariante;
    }

    /**
     * This method initializes jLabelDescripcionError
     *
     * @return javax.swing.JLabel
     */
    private JLabel getJLabelDescripcionError() {
        if (jLabelDescripcionError == null) {
            jLabelDescripcionError = new JLabel();
            jLabelDescripcionError.setText("Descripción Error:");
        }
        return jLabelDescripcionError;
    }

    /**
     * This method initializes jTextFieldDescripcionError
     *
     * @return javax.swing.JTextField
     */
    private JTextField getJTextFieldDescripcionError() {
        if (jTextFieldDescripcionError == null) {
            jTextFieldDescripcionError = new JTextField();
            jTextFieldDescripcionError.setEditable(false);
        }
        return jTextFieldDescripcionError;
    }

    /**
     * This method initializes jLabelCodigoMolde
     *
     * @return javax.swing.JLabel
     */
    private JLabel getJLabelCodigoMolde() {
        if (jLabelCodigoMolde == null) {
            jLabelCodigoMolde = new JLabel();
            jLabelCodigoMolde.setText("Código de Molde:");
        }
        return jLabelCodigoMolde;
    }

    /**
     * This method initializes jTextFieldCodigoMolde
     *
     * @return javax.swing.JTextField
     */
    private JTextField getJTextFieldCodigoMolde() {
        if (jTextFieldCodigoMolde == null) {
            jTextFieldCodigoMolde = new JTextField();
            jTextFieldCodigoMolde.setEditable(false);
        }
        return jTextFieldCodigoMolde;
    }

    /**
     * This method initializes jLabelNumeroVentas
     *
     * @return javax.swing.JLabel
     */
    private JLabel getJLabelNumeroVentas() {
        if (jLabelNumeroVentas == null) {
            jLabelNumeroVentas = new JLabel();
            jLabelNumeroVentas.setText("Número de Ventas:");
        }
        return jLabelNumeroVentas;
    }

    /**
     * This method initializes jTextFieldNumeroVentas
     *
     * @return javax.swing.JTextField
     */
    private JTextField getJTextFieldNumeroVentas() {
        if (jTextFieldNumeroVentas == null) {
            jTextFieldNumeroVentas = new JTextField();
            jTextFieldNumeroVentas.setEditable(false);
        }
        return jTextFieldNumeroVentas;
    }





}  //  @jve:decl-index=0:visual-constraint="10,10"