Bind data to JTable

[Ahmed Osama]

I'm using NetBeans 5.5

First :I want to bind data from table from MS Access DB into JTable .

Second: Is there any other component in java to do the previous action(e.g. DataGrid )

[Ahmed Osama]

I'm using NetBeans 5.5 :

How could I bind data from table from MS Access DB into JTable,is there in java smth like DataGrid ?!!

N.P. : I've made an application which reads data from the DB & use

System.out.append(rs.getString("Blob") 

to show the data .
Now I want to display the data using some GUI .

[r035198x]

I'm using NetBeans 5.5 :

How could I bind data from table from MS Access DB into JTable,is there in java smth like DataGrid ?!!

N.P. : I've made an application which reads data from the DB & use

System.out.append(rs.getString("Blob") 

to show the data .
Now I want to display the data using some GUI .

I suppose you've read about how to create a basic swing application?

[r035198x]

I've also merged your threads since they are dealing with basically the same problem.

[Ahmed Osama]

Thanks for reply :) .

After searching , frankly I couldn't make my DB to show it's info. in JTable.
However , I've made my application to use some GUI but shows the data using
"System.out.printIn("") "

that's my code :

 import javax.swing.*;
   import java.sql.*;
   import javax.swing.event.TableModelListener;
   import javax.swing.table.TableModel;
 
 
public class MyConnection {
 
    public MyConnection() {
 
    }
 
      public static Connection getConnection() throws Exception {
      Driver d = (Driver)Class.forName
     ("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
    Connection c = DriverManager.getConnection(
     "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/Inventory.mdb"
      );
    return c;
 
    }
 
      //******************************************
 
 
 
      static Connection theConn;
     // public static String sql;
      public void retrieveData(String sql )
      {
 
                   try {
 
      // connection to an ACCESS MDB
      theConn = MyConnection.getConnection();
 
      ResultSet rs;
      Statement stmt;      
 
      stmt = theConn.createStatement();
      rs = stmt.executeQuery(sql);
      boolean FirstLoop=true;
      boolean DataExisted=false;
 
      while (rs.next())
      {
          if(FirstLoop==true)
          {
                 System.out.append("ID");
                 System.out.append("\t");                 
                          System.out.append("Product_Name");
                          System.out.append("\t");
                                    System.out.append("Product_Price");
                                    System.out.append("\t");
                                                System.out.append("Amount_In_Stock");
                                                System.out.append("\t");
 
                                                System.out.println("");
                                                FirstLoop=false;
                                                DataExisted=true;
          }
 
           System.out.append(rs.getString("ID"));
           System.out.append("\t\t");
           System.out.append(rs.getString("Product_Name"));
           System.out.append("\t\t");
           System.out.append(rs.getString("Product_Price"));
           System.out.append("\t\t");
           System.out.println(rs.getString("Amount_In_Stock"));
 
 
 
      }   
 
      if(DataExisted==false)
          System.out.println("No Result is found ");
      System.out.println("__________________________________________________________________");
      System.out.println("__________________________________________________________________");
      rs.close();
      stmt.close();
    }
    catch (Exception e) {
        e.printStackTrace();
    }
    finally {
      try {
        if (theConn != null) theConn.close();
      }
      catch (Exception e) {
      }
    }
      }
}

[r035198x]

Now that's a huge step forward. Realize now that a GUI is just a bunch of components which takes data in various forms (images, Strings, e.t.c) and just displays them. If you have data printed to console, all you need now is to redirect that to a GUI. I suppose you've read the swing tutorial?