import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;



public class aggiungi  implements ActionListener {

    public Statement cmd = null;
    public Vector colonne,righe = null;
    public ResultSet rs = null;
    @SuppressWarnings("unchecked")
    public void actionPerformed(ActionEvent e) {

            try {
                Class.forName("com.mysql.jdbc.Driver");
                Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/db", "root", "telecaster" );
                cmd = con.createStatement();
                String query = "SELECT * FROM `table`" ;
                System.out.println(query);
                rs = cmd.executeQuery(query);
                colonne = new Vector();
                colonne.addElement("nome");
                colonne.addElement("cognome");
                colonne.addElement("numero");
                righe = new Vector();
                while (rs.next()) {
                Vector vett = new Vector();
                vett.addElement(rs.getString("nome"));
                vett.addElement(rs.getString("cognome"));
                vett.addElement(rs.getString("numero"));
                righe.addElement(vett);
                }
                } catch (ClassNotFoundException e1) {
                } catch (SQLException e2) {
                }

        }
}