/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package generateurmdp;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JFrame;
import javax.swing.JScrollPane;
import javax.swing.JTable;

/**
 *
 * @author cedrickaiser2
 */
public class AffichageMDP {

    private Connection connec;
    private String nomUser;

    AffichageMDP(String user) {

        nomUser = user;
        affichageTableau();

    }

    public void affichageTableau() {

        JFrame jf = new JFrame();
        jf.dispose();
        jf.setVisible(true);
        jf.setLayout(null);
        jf.setLocation(600, 100);
        jf.setSize(600, 250);

        String requete = "select application, mdp from mdp where idUser = '" + getIdUser() + "' order by application asc";

        ConnectionBDD cbdd = ConnectionBDD.getInstance();
        connec = cbdd.getConnexion();

        int nbr;

        Statement st;
        try {
            st = connec.createStatement();
            ResultSet rs = st.executeQuery(requete);
            System.out.print(st);

            rs.afterLast();
            rs.previous();
            nbr = rs.getRow();
            rs.beforeFirst();

            String[] titres = {"Application", "Mot de passe"};
            String[][] infos = new String[nbr][2];

            JTable tableau = new JTable(infos, titres);
            JScrollPane scroll = new JScrollPane(tableau);

            tableau.setLocation(10, 10);
            tableau.setSize(580, 210);
            jf.getContentPane().add(tableau);
            int i = 0;

            while (rs.next()) {
                String nomApplication = rs.getString("application");
                String mdp = rs.getString("mdp");
                infos[i][0] = nomApplication;
                infos[i][1] = mdp;

                i++;
            }
            JScrollPane scrollpane = new JScrollPane(tableau);
            scrollpane.setBounds(20, 50, 500, 130);

            jf.add(scrollpane);
            
            //scrollpane.repaint();
        } catch (SQLException ex) {
            System.out.println("Erreur de selection de la Base de Données : " + ex.getMessage());
        }
    }

    public int getIdUser() {
        ConnectionBDD cbdd = ConnectionBDD.getInstance();
        connec = cbdd.getConnexion();

        String requete = "select idUser from user where login ='" + nomUser + "' ";

        Statement st;
        try {
            st = connec.createStatement();
            ResultSet rs = st.executeQuery(requete);

            while (rs.next()) {
                return rs.getInt(1);
            }
        } catch (SQLException ex) {
            System.out.println("Erreur d'insertion d'informations dans la Base de Données : " + ex.getMessage());

        }
        return -1;
    }
}