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

public class HowToUseTable {

    public static void main (String[] args){
              ShowForm();
         }

   public static void ShowForm(){
             ConnectToBase();

  JFrame frame1=new JFrame("БД");
    frame1.setSize( 400 , 300 );
    frame1.setLocationRelativeTo(null);//...центр экрана
    frame1.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    frame1.setVisible(true);
    }

    public static void ConnectToBase() {
        try{
             Class.forName(DBConnection.drv);
                     System.out.println("Драйвер загружен...");
        Connection conn=DriverManager.getConnection(DBConnection.dsn,DBConnection.user, DBConnection.psw);
       System.out.println("Подключились...");

             JTable table=new JTable();
            String[] tableColumnsName = {"col 1"};
            DefaultTableModel aModel = (DefaultTableModel) table.getModel();
            aModel.setColumnIdentifiers(tableColumnsName);

       Statement stmt= conn.createStatement();
          ResultSet rs=  stmt.executeQuery("select COF_NAME from COFFEES");

// Loop through the ResultSet and transfer in the Model
                java.sql.ResultSetMetaData rsmd = rs.getMetaData();
                int colNo = rsmd.getColumnCount();

                while(rs.next()){
                 Object[] objects = new Object[colNo];
                 for(int i= 0 ;i<colNo;i++){

                  objects[i]=rs.getObject(i);
                     System.out.println(rs.getObject(i));
                  }
                 aModel.addRow(objects);
                }
              table.setModel(aModel);

                }
        catch (ClassNotFoundException e) {
            System.out.println("Ошибка:"+e.getMessage());
        } catch (SQLException e) {
            System.out.println("Ошибка:"+e.getMessage());
        }
     }
}