import javax.swing.*;
import javax.swing.table.*;
import java.sql.*;

    // import javax.swing.table.*;
    DefaultTableModel m;
    
    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        if (m == null)
        {
           m = new DefaultTableModel();
           jTable1.setModel (m);
        }
        
        // String [] data = { "abc", "def", "klm" };
        // m.addRow (data);
        
        
        // Services / Java DB / Start Server
        // Project / Libraries / Add JAR
        // c:/Program Files/Java/jdk_1.8.0_25/db/lib/derbyCLIENT.jar
        
        // import java.sql.*;
        String host = 
           "jdbc:derby://localhost:1527/db";
        String user = "app";
        String password = "app";
        
        try 
        {
            Connection conn = 
               DriverManager.getConnection
                   (host, user, password);
            
            Statement stat = 
               conn.createStatement ();
            
            stat.execute ("drop table colors");

            stat.execute
            ("create table colors " +
             "(name varchar(80), red int, green int, blue int)");
            
            stat.execute 
                    ("insert into colors values" +
                      "('modra', 0, 0, 255)");
                    
            PreparedStatement p = conn.prepareStatement 
            ("insert into colors values (?, ?, ?, ?)");
            
            p.setString (1, "blede modra");
            p.setInt    (2, 128);
            p.setInt    (3, 128);
            p.setInt    (4, 255);
            
            p.execute ();

            p.setString (1, "blede zelena");
            p.setInt    (3, 255);
            p.setInt    (4, 128);
            
            p.execute ();

            ResultSet rs =
            stat.executeQuery ("select * from customer");
            
            int cnt = rs.getMetaData().getColumnCount();
            m.setColumnCount (cnt);
            String [] names = new String [cnt];
            for (int i = 1; i <= cnt; i++)
                names [i-1] = 
                     rs.getMetaData().getColumnName(i);
            m.setColumnIdentifiers (names);
            
            
            while (rs.next ())
            {
                String [] data = new String [cnt];
                for (int i = 1; i <= cnt; i++)
                   data[i-1] = rs.getString (i);
                m.addRow (data);

                // m.addRow (new String [] { rs.getString ("name") } );
            }
        } 
        catch (SQLException ex) 
        {
            setTitle (""+ex);
        }
    }