?? tabledisplay2.java~5~
字號:
/**
* <p>Title: 以表格顯示數據庫查詢結果</p>
* <p>Description: 第五章例子</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 TableDisplay2 extends JFrame {
//數據庫變量定義
private JDBCAdapter adapter;
//GUI變量定義
private JTable table;
private JTextArea inputQuery;
private JButton submitQuery;
public TableDisplay2() {
//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);
table = new JTable();
Container c = getContentPane();
c.setLayout(new BorderLayout());
//將"topPanel"編輯框布置到 "NORTH"
c.add(topPanel, BorderLayout.NORTH);
//將"table"編輯框布置到 "CENTER"
c.add(table, BorderLayout.CENTER);
executeQuery();
setSize(500, 300);
//顯示Form
show();
}
private void executeQuery(){
adapter.executeQuery(inputQuery.getText());
}
public void shutDown() {
try {
//斷開數據庫連接
connection.close();
}
catch (SQLException e) {
System.err.println("無法斷開連接");
e.printStackTrace();
}
}
public static void main(String args[]) {
final TableDisplay2 app =new TableDisplay2();
app.addWindowListener(
new WindowAdapter() {
public void windowClosing(WindowEvent e) {
app.shutDown();
System.exit(0);
}
}
);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -