Prikaz sadrzaja neke baze u jTable?

Code:

private void jButton1MouseClicked(java.awt.event.MouseEvent evt) {
PreparedStatement i_PreparedStatement = null;
        ResultSet i_ResultSet = null;
        Connection conn = null;
        try {
               Class.forName("org.postgresql.Driver");
               conn =   DriverManager.getConnection("jdbc:postgresql://127.0.0.1:5432/probna" , "postgres", "");
                if( conn != null ) {
                JOptionPane.showMessageDialog(null, "Konektovali smo se na Bazu!" );
                i_PreparedStatement = conn.prepareStatement("SELECT * FROM table");
                i_ResultSet = i_PreparedStatement.executeQuery();
                while(i_ResultSet.next()){
                    
                   
                   
                }
            }
            conn.close();
        }catch (Exception sqlEx) {
            System.out.println("Konekcija nije moguca, a evo i zasto (stack trace): ");
            sqlEx.printStackTrace();
            System.exit(1);
        }
    }

Code:

Vecor data= new Vector();

while(i_ResultSet.next()){
                    Vector rowData = new Vector();

                    data.add(rowData);

                    rowData.add(i_ResultSet.getString("username"));           
                    rowData.add(i_ResultSet.getString("pass"));           
                    rowData.add(i_ResultSet.getInt("id"));           
                    
                   
                   
}

Vector colNames = new Vector();

colNames.add("username");
colNames.add("pass");
colNames.add("id");

JTable table = new JTable(data,colNames);
panel.add(table);
table.setVisible(true);

Code:

/*
 * Imenik.java
 *
 * Created on October 7, 2005, 9:28 AM
 */

package imenik;
import java.util.*;
import javax.swing.*;
import javax.swing.table.DefaultTableModel;

import java.awt.BorderLayout;
import java.sql.*;

/**
 *
 * @author  Administrator
 */
public class Imenik extends javax.swing.JFrame {
    
    /** Creates new form Imenik */
    public Imenik() {
        initComponents();

    }
    
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    // <editor-fold defaultstate="collapsed" desc=" Generated Code ">//GEN-BEGIN:initComponents
    private void initComponents() {
        
        jScrollPane1 = new javax.swing.JScrollPane(jTable1);
        jScrollPane1.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
        jScrollPane1.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS);
 
        
        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  
        setPrikaz();
        setIzlaz();
        
        getContentPane().setLayout(new BorderLayout());
        getContentPane().add(Prikaz, BorderLayout.NORTH);
        getContentPane().add(Izlaz, BorderLayout.SOUTH);
        getContentPane().add(jScrollPane1, BorderLayout.CENTER);

       
        pack();
    }
    // </editor-fold>//GEN-END:initComponents

    private void setIzlaz() {
        Izlaz.setText("Izlaz");
        Izlaz.setMaximumSize(new java.awt.Dimension(73, 23));
        Izlaz.setMinimumSize(new java.awt.Dimension(73, 23));
        Izlaz.setPreferredSize(new java.awt.Dimension(73, 23));
        Izlaz.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                IzlazMouseClicked(evt);
            }
        });
    }

    private void setPrikaz() {
        Prikaz.setText("Prikaz");
        Prikaz.setMaximumSize(new java.awt.Dimension(73, 23));
        Prikaz.setMinimumSize(new java.awt.Dimension(73, 23));
        Prikaz.setPreferredSize(new java.awt.Dimension(73, 23));
        Prikaz.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                PrikazMouseClicked(evt);
            }
        });
    }
       
    private void IzlazMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_IzlazMouseClicked
        System.exit(0);
    }//GEN-LAST:event_IzlazMouseClicked
    
//                          P R I K A Z     P O D A T A K A
    
    private void PrikazMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_PrikazMouseClicked
        
        Vector            columnNames         = new Vector();
        Vector            data                = new Vector();       
        
        try {
            JOptionPane.showMessageDialog(null, "Konektovali smo se na Bazu!" );

            Class.forName(driverName2);
            Connection conn = DriverManager.getConnection(dbURL2 , user2, pass);
            
            
            //ovde se nalaza kolone username,id i phone... 
            //ako je tebi drugacije izmeni
            PreparedStatement ps  = conn.prepareStatement("SELECT * FROM imenik");
            ResultSet         res = ps.executeQuery();
            
            ResultSetMetaData md = res.getMetaData();
            int columns = md.getColumnCount();
            
            //  Get column names
            
            for (int i = 1; i <= columns; i++) {
                columnNames.addElement( md.getColumnName(i) );
            }
            
            //  Get row data
            
            while(res.next()){
                Vector row = new Vector();
            
                row.add(res.getInt("id"));
                row.add(res.getString("username") );
                row.add(res.getInt("phone"));
                
                data.add(row);
            }
                
            conn.close();
        }catch (Exception sqlEx) {
            sqlEx.printStackTrace();
        }
        
        //  Create table with database data
        
        jTable1.setModel( new DefaultTableModel(data, columnNames));
        jTable1.validate();
        validate();

 
    }//GEN-LAST:event_PrikazMouseClicked
    
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new Imenik().setVisible(true);
            }
        });
    }
    
    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JButton Izlaz   = new javax.swing.JButton();
    private javax.swing.JButton Prikaz  = new javax.swing.JButton();
    private javax.swing.JTable  jTable1 = new javax.swing.JTable();;
    
    private javax.swing.JScrollPane jScrollPane1;
    // End of variables declaration//GEN-END:variables
    

    private String driverName  = "org.postgresql.Driver";
    private String dbURL       = "jdbc:postgresql://127.0.0.1:5432/probna";
    private String user        = "postgres";
    private String pass        = "";


    private String dbURL2      = "jdbc:mysql://localhost/probna";
    private String user2       = "root";
    private String driverName2 = "com.mysql.jdbc.Driver";
}

Code:

                while(i_ResultSet.next()){
                    Vector row = new Vector(columns);
                                                           
                    for (int i = 1; i <= columns ;i++)
                   {    
                        row.add(i_ResultSet.getString(i) );                      
                    }
                    data.add( row );
                    if (row.size()<=64) {  // broj celija
                        for(int j=columns; j<=18;j++){
                            row.add(j, " ");
                            data.add(row);
                        }
                        
                    } 

Code:

                while(i_ResultSet.next()){
                    Vector row = new Vector(columns);
                                                           
                    for (int i = 1; i <= columns ;i++){    
                        row.add(i_ResultSet.getString(i) );                      
                    }

                    if (row.size()<=64) {  // broj celija
                        for(int j=columns; j<=18;j++){
                            row.add(j, " ");
                        }
                    } 
                    data.add(row);
                }    

Code:
row.add(j, " "); 

Code:
while(i_ResultSet.next())

Code:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Kernel {
    private Connection veza;
    private String host;
    private String baza;
    private String user;
    private String password;
    
    public Kernel(String host, String baza, String user, String password) throws NeuspesnaKonekcija {
          this.host=host;
          this.baza=baza;
          this.user=user;
          this.password=password;
          try {
            System.out.print("Ucitavanje Driver-a .............. ");
            Class.forName("org.gjt.mm.mysql.Driver").newInstance();
          } catch (Exception e) {
            e.printStackTrace();
            System.out.println("Nije ucitan Driver");
            throw new NeuspesnaKonekcija("Nije ucitan Driver.");
        }
        System.out.println("OK");
        
        try{
            String urlBaze="jdbc:mysql://"+host+"/"+baza+"?user="+user+"&password="+password;
            System.out.print("Kreiranje konekcije .............. ");
            veza=DriverManager.getConnection(urlBaze);
            System.out.println("OK");            
        } catch (SQLException sqle) {
            sqle.printStackTrace();
            throw new NeuspesnaKonekcija("Neuspesno uspostavljanje konekcije sa bazom");
        }
        System.out.println("Veza sa bazom uspostavljena");
    }
    
    public ResultSet upitSelekcije(String upit) {
        ResultSet tabela=null;
        try {
            Statement statement=veza.createStatement();
            tabela=statement.executeQuery(upit);
        } catch (SQLException sqle) { sqle.printStackTrace(); } 
        return tabela;
    }
    
    public int upitIzmene(String upit) {
        int kod=-1;
        try {
            Statement statement=veza.createStatement();
            kod=statement.executeUpdate(upit);
        } catch (SQLException sqle) { sqle.printStackTrace(); }
        return kod;
    }
    
    public int brRedova(ResultSet rs) {
        int i=0;
        try {
            while (rs.next()) i++;
            rs.beforeFirst();
        } catch (SQLException sqle) { sqle.printStackTrace(); }
        return i;
    }
    
    
    public void zatvoriKonekciju() {
        if (veza!=null) {
            try {
                veza.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

Code:

String urlBaze="jdbc:mysql://"+host+"/"+baza+"?user="+user+"&password="+password;