Display ResultSet in Table (JTable) : Table « Swing JFC « Java

1. Java
2. Swing JFC
3. Table

Display ResultSet in Table (JTable)

  
/*
Java Swing, 2nd Edition
By Marc Loy, Robert Eckstein, Dave Wood, James Elliott, Brian Cole
ISBN: 0-596-00408-7
Publisher: O'Reilly 
*/
// DatabaseTest.java
//Let's try to make one of these databases work with a JTable for ouptut.
//

import java.awt.BorderLayout;
import java.awt.GridLayout;
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.ResultSetMetaData;
import java.sql.Statement;
import java.util.Vector;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.AbstractTableModel;

public class DatabaseTest extends JFrame {

  JTextField hostField;

  JTextField queryField;

  QueryTableModel qtm;

  public DatabaseTest() {
    super("Database Test Frame");
    setDefaultCloseOperation(EXIT_ON_CLOSE);
    setSize(350, 200);

    qtm = new QueryTableModel();
    JTable table = new JTable(qtm);
    JScrollPane scrollpane = new JScrollPane(table);
    JPanel p1 = new JPanel();
    p1.setLayout(new GridLayout(3, 2));
    p1.add(new JLabel("Enter the Host URL: "));
    p1.add(hostField = new JTextField());
    p1.add(new JLabel("Enter your query: "));
    p1.add(queryField = new JTextField());
    p1.add(new JLabel("Click here to send: "));

    JButton jb = new JButton("Search");
    jb.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        qtm.setHostURL(hostField.getText().trim());
        qtm.setQuery(queryField.getText().trim());
      }
    });
    p1.add(jb);
    getContentPane().add(p1, BorderLayout.NORTH);
    getContentPane().add(scrollpane, BorderLayout.CENTER);
  }

  public static void main(String args[]) {
    DatabaseTest tt = new DatabaseTest();
    tt.setVisible(true);
  }
}

//QueryTableModel.java
//A basic implementation of the TableModel interface that fills out a Vector of
//String[] structures from a query's result set.
//

class QueryTableModel extends AbstractTableModel {
  Vector cache; // will hold String[] objects . . .

  int colCount;

  String[] headers;

  Connection db;

  Statement statement;

  String currentURL;

  public QueryTableModel() {
    cache = new Vector();
    new gsl.sql.driv.Driver();
  }

  public String getColumnName(int i) {
    return headers[i];
  }

  public int getColumnCount() {
    return colCount;
  }

  public int getRowCount() {
    return cache.size();
  }

  public Object getValueAt(int row, int col) {
    return ((String[]) cache.elementAt(row))[col];
  }

  public void setHostURL(String url) {
    if (url.equals(currentURL)) {
      // same database, we can leave the current connection open
      return;
    }
    // Oops . . . new connection required
    closeDB();
    initDB(url);
    currentURL = url;
  }

  // All the real work happens here; in a real application,
  // we'd probably perform the query in a separate thread.
  public void setQuery(String q) {
    cache = new Vector();
    try {
      // Execute the query and store the result set and its metadata
      ResultSet rs = statement.executeQuery(q);
      ResultSetMetaData meta = rs.getMetaData();
      colCount = meta.getColumnCount();

      // Now we must rebuild the headers array with the new column names
      headers = new String[colCount];
      for (int h = 1; h <= colCount; h++) {
        headers[h - 1] = meta.getColumnName(h);
      }

      // and file the cache with the records from our query. This would
      // not be
      // practical if we were expecting a few million records in response
      // to our
      // query, but we aren't, so we can do this.
      while (rs.next()) {
        String[] record = new String[colCount];
        for (int i = 0; i < colCount; i++) {
          record[i] = rs.getString(i + 1);
        }
        cache.addElement(record);
      }
      fireTableChanged(null); // notify everyone that we have a new table.
    } catch (Exception e) {
      cache = new Vector(); // blank it out and keep going.
      e.printStackTrace();
    }
  }

  public void initDB(String url) {
    try {
      db = DriverManager.getConnection(url);
      statement = db.createStatement();
    } catch (Exception e) {
      System.out.println("Could not initialize the database.");
      e.printStackTrace();
    }
  }

  public void closeDB() {
    try {
      if (statement != null) {
        statement.close();
      }
      if (db != null) {
        db.close();
      }
    } catch (Exception e) {
      System.out.println("Could not close the current connection.");
      e.printStackTrace();
    }
  }
}

           
         
    
  

Related examples in the same category

1.	Creating a JTable Component
2.	Creates tables that allow rows and columns to be added or deleted
3.	Build a table from list data and column names
4.	Getting the Number of Rows and Columns in a JTable Component
5.	Appending a Row to a JTable Component
6.	Add columns to a table through DefaultTableModel
7.	Insert a row to a table through DefaultTableModel
8.	Insert a row to a table through DefaultTableModel at specified row
9.	Scroll Table Sample
10.	Simple demonstration of JTable
11.	Create a table with two dimensional array
12.	Create table with Unicode data
13.	Resize Table
14.	Expense Table
15.	StockTable 6: Action and Dynamic Display
16.	JTable selection events
17.	A table with the ability to play with row and column selections
18.	Table Selection mode
19.	JTable(Table) with JDBC and ResultSet
20.	List UI Properties in a JTable and sortable
21.	Property Table: Use JTable to display and edit properties
22.	Table with tool tips for both cells and column headers
23.	StockTable 4: Table Sorter
24.	JTable sorter:click the table header to sort a column and a table
25.	Creating image out of a JTable
26.	JTable.setSelectionMode(ListSelectionModel.MULTIPLE_INTERVAL_SELECTION);
27.	JTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
28.	JTable.setColumnSelectionAllowed(boolean b);
29.	JTable.setRowSelectionAllowed(boolean b);
30.	JTable.setCellSelectionEnabled(boolean b);
31.	Handle selection and model change events for a JTable.
32.	ListSelectionModel rowSelMod = JTable.getSelectionModel();
33.	ListSelectionModel colSelMod = JTable.getColumnModel().getSelectionModel();
34.	JTree.getModel().addTreeModelListener(new TreeModelListener())
35.	Move the last visible column so it becomes the first visible column
36.	the last column is moved to the first position
37.	Allowing the User to Resize a Column in a JTable Component
38.	Retrieve the value in the visible cell (1,2) in a JTable
39.	Retrieve the value in cell (1,2) from the model
40.	Change a cell in the 2nd visible column
41.	Change a cell in the 3rd column in the model
42.	Showing the Table Header in a Non-Scrollable JTable Component
43.	Changing the Name of a Column in a JTable Component
44.	Displaying an Icon in a Column Head of a JTable Component
45.	Implementing Variable-Height Column Headers in a JTable Component
46.	Removing the Column Headers from a Scrollable in a JTable Component
47.	Creating a Custom Column Header Renderer in a JTable Component
48.	Setting Column Header Tool Tips in a JTable Components
49.	Setting Tool Tips on Cells in a JTable Component
50.	Enable row selection (default) in a JTable
51.	Enable column selection in a JTable
52.	Enable cell selection in a JTable
53.	Get default selection mode:MULTIPLE_INTERVAL_SELECTION
54.	Allow only single a selection
55.	Allow selection to span one contiguous set of rows, visible columns, or block of cells
56.	Allow multiple selections of rows, visible columns, or cell blocks (default)
57.	Select a column - column 0 in a JTable
58.	Select an additional range of columns - columns 1 to 2
59.	Deselect a range of columns - columns 0 to 1
60.	Select a row - row 0
61.	Select an additional range of rows - rows 1 to 2
62.	Deselect a range of rows - rows 0 to 1
63.	Select a cell: cell (2,1)
64.	Extend the selection to include all cells (5,3)
65.	Deselect a cell: cell (3,2), All cells in the row and column containing (3,2) are deselected.
66.	Toggles the selection state, if it were called again, it exactly reverses the first call.
67.	Select all cells
68.	Deselect all cells
69.	Column selection is enabled, get the indices of the selected columns
70.	Row selection is enabled, Get the indices of the selected rows
71.	Get selected row and selected index
72.	Get the min and max ranges of selected cells
73.	Check each cell in the min and max ranges of selected cells
74.	Disabling Selections in a JTable Component
75.	Getting the Anchor Cell in a JTable Component
76.	Creating a Scrollable JTable Component
77.	Disable auto resizing to make the table horizontal scrollable
78.	Determining If a Cell Is Visible in a JTable Component
79.	Making a Cell Visible in a JTable Component
80.	Scrolling a Cell to the Center of a JTable Component
81.	Show both horizontal and vertical grid lines (the default)
82.	Don't show any grid lines
83.	Show only vertical grid lines
84.	Show only horizontal grid lines
85.	Set the grid color
86.	Getting the Gap Size Between Cells in a JTable Component
87.	Add 5 spaces to the left and right sides of a cell.
88.	Increase the row height
89.	Programmatically Starting Cell Editing in a JTable Component
90.	Save the current value in the cell being edited and stops the editing process
91.	Discard any changes made by the user and stops the editing process
92.	Disabling User Edits in a JTable
93.	Disabling User Edits in a JTable with DefaultTableModel
94.	Sorting the Rows in a JTable Component Based on a Column
95.	Sorting a Column in a JTable Component
96.	Listening for Selection Events in a JTable Component
97.	Listening for Changes to the Rows and Columns of a JTable Component
98.	Listening for Column-Related Changes in a JTable Component
99.	Listening for Clicks on a Column Header in a JTable Component
100.	Sorting and Filtering Tables
101.	Use a regexFilter to filter table content
102.	Creating a JTable with rows of variable height
103.	Scroll JTable To Center