tabledisplay3.java~6~

数据库查询结果表格输出实例

/**
 * <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);
      }
    }
    );
  }
}