/** * <p>Title: 實現表格能按列排序</p> * <p>Description: 第五章例子3</p> * <p>Copyright: Copyright (c) 2006</p> * <p>Company: </p> * @author 蘇年樂 * @version 1.0 */import java.sql.*;import javax.swing.*;import java.awt.*;import java.awt.event.*;import java.util.*;public class TableDisplay3 extends JFrame {  //數據庫變量定義  private JDBCAdapter adapter;  private TableSorter sorter;  //GUI變量定義  private JTable table;  private JTextArea inputQuery;  private JButton submitQuery;  private JScrollPane scrollpane;  public TableDisplay3() {    //Form的標題    super("輸入SQL語句，按提交按鈕查看結果。");    //url中指定ODBC中設置的DSN名稱    String url = "jdbc:odbc:Person";    String driverName="sun.jdbc.odbc.JdbcOdbcDriver";    String username = "";    String password = "";    adapter=new JDBCAdapter(url,driverName,username,password);    //如果數據庫連接成功，則建立GUI    //SQL語句    String test = "SELECT * FROM Person";    inputQuery = new JTextArea(test, 4, 30);    submitQuery = new JButton("查詢");    //Button事件    submitQuery.addActionListener(        new ActionListener() {      public void actionPerformed(ActionEvent e) {        executeQuery();      }    }    );    JPanel topPanel = new JPanel();    topPanel.setLayout(new BorderLayout());    //將"輸入查詢"編輯框布置到 "CENTER"    topPanel.add(new JScrollPane(inputQuery), BorderLayout.CENTER);    //將"提交查詢"按鈕布置到 "SOUTH"    topPanel.add(submitQuery, BorderLayout.SOUTH);    sorter=new TableSorter(adapter);    sorter.addMouseListenerToHeaderInTable(table);    table = new JTable(sorter);    Container c = getContentPane();    c.setLayout(new BorderLayout());    //將"topPanel"編輯框布置到 "NORTH"    c.add(topPanel, BorderLayout.NORTH);    //將"table"編輯框布置到 "CENTER"    scrollpane=new JScrollPane(table);    c.add(scrollpane, BorderLayout.CENTER);    executeQuery();    setSize(500, 300);    //顯示Form    show();  }  private void executeQuery(){    adapter.executeQuery(inputQuery.getText());  }  public static void main(String args[]) {    final TableDisplay3 app =new TableDisplay3();    app.addWindowListener(        new WindowAdapter() {      public void windowClosing(WindowEvent e) {        System.exit(0);      }    }    );  }}