import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import javax.swing.*;
/**
 *
 * @author Arobavx
 */
public class Db {
    public static void main(String[] args){
     EntornoUsuario Eu= new EntornoUsuario();
    }
///*
// * mysql> select * from datos;
//+--------+------+----------+
//| nombre | id   | password |
//+--------+------+----------+
//| marcos |    2 | constras |
//| maria  |    1 | polaka   |
//| Carmen |    3 | poasdaka |
//| alguie |    4 | pasdt5ka |
//+--------+------+----------+
// */
    public static void realizarpeticion(JTextField tf,String id){
       try
        {
            Class.forName("com.mysql.jdbc.Driver");
            Connection conexion = DriverManager.getConnection ("jdbc:mysql://localhost/info","root", "");
            Statement s = conexion.createStatement();
            ResultSet rs = s.executeQuery ("select nombre from datos where id = '"+id+"'");
            String st = "";
            while (rs.next())
            {
                st += rs.getString(1)+", ";
            }
            tf.setText(st);
            conexion.close();
        } catch (Exception e)
        {
            e.printStackTrace();
        }
    }
     public static JTextField texto;
     public static JTextField id;
    public static class EntornoUsuario extends JFrame{
 
        public EntornoUsuario(){
            this.setSize(300,100);
            this.setDefaultCloseOperation(this.EXIT_ON_CLOSE);
            JPanel panel = new JPanel();
            id = new JTextField();
            texto = new JTextField();
            JButton mostrar = new JButton("Mostrar");
            mostrar.addActionListener(new ActionListener(){
                public void actionPerformed(ActionEvent e ){
                    realizarpeticion(Db.texto, id.getText());
                }
            });
            panel.setLayout(new GridBagLayout());
            panel.add(id,this.asignarPropiedades(0, 0, 1, 1, GridBagConstraints.BOTH,0.1, 0.0));
            panel.add(mostrar,this.asignarPropiedades(3, 0, 2,2, GridBagConstraints.BOTH,0.1, 0.0));
            panel.add(texto,this.asignarPropiedades(0, 3, 5,2, GridBagConstraints.HORIZONTAL,0.1, 0.1));
            this.getContentPane().add(panel);
            this.setVisible(true);
        }
        public  GridBagConstraints asignarPropiedades(int gridx, int gridy,int gridwidth, int gridheight, int fill, double weightx, double weighty){
    	GridBagConstraints constrain = new GridBagConstraints();
    	constrain.gridx = gridx;
        constrain.gridy = gridy;
        constrain.gridwidth = gridwidth;
        constrain.gridheight = gridheight;
        constrain.fill = fill;
        constrain.weighty = weighty;
        constrain.weightx = weightx;
        return constrain;
        }
    }
}