JdbcSwingTable.java

package com.godoro.samples.jdbc;

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

public class JdbcSwingTable {

  public static void main(String[] args)
    throws Exception
  { 
    String driverClass="sun.jdbc.odbc.JdbcOdbcDriver";     
    Class.forName(driverClass);       
    String url="jdbc:odbc:mydatasource";     
    String username="sa";
    String password="godoro";
    Connection connection = DriverManager.getConnection(url,username,password);
    System.out.println("Connected to database");                
    String sql="select * from BankAccount";
    Statement stmt=connection.createStatement();
    ResultSet rs=stmt.executeQuery(sql);
    ResultSetTableModel model=new ResultSetTableModel(rs);
    
    JFrame frame=new JFrame();
    JTable table=new JTable(model);
    JScrollPane scroll=new JScrollPane(table);
    frame.getContentPane().add(scroll);
    frame.setBounds(100,100,400, 300);
    frame.setVisible(true);

      
      
  }
    
}