?? productquery.java
字號:
package Manager;
import javax.swing.*;
import com.borland.jbcl.layout.*;
import java.sql.*; //引入包java.sql.*;
import javax.swing.table.*;//引入包sqljavax.swing.table.*;
import java.util.*; //由于會用到Vector對象,引入包java.util.*;
import java.awt.event.*;
public class productQuery extends JFrame {
/**
* <p>Title: 產品信息查詢</p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2008</p>
* <p>Company:南華大學計算機系 </p>
* @author 王云飛
* @version 1.0
*/
private static final long serialVersionUID = 1L;
ResultSet rs; //定義結果集
private DBManager db =new DBManager();
XYLayout xYLayout1 = new XYLayout();
JLabel jLabel1 = new JLabel();
JScrollPane jScrollPane1 = new JScrollPane();
//定義DefaultTableModel模型
DefaultTableModel model =new DefaultTableModel();
//定義JTable為DefaultTableModel的實例model模式
JTable jTable1 = new JTable(model);
public productQuery() {
try {
jbInit();
}
catch(Exception e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
new productQuery();
}
private void jbInit() throws Exception {
jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));
jLabel1.setText("以下為所有商品信息列表");
xYLayout1.setWidth(530);
xYLayout1.setHeight(410);
// model中加入列名
model.addColumn("名稱") ;
model.addColumn("負責人") ;
model.addColumn("部門") ;
model.addColumn("單位") ;
model.addColumn("單價") ;
model.addColumn("描述") ;
this.getContentPane().setLayout(xYLayout1);
this.addWindowListener(new productQuery_this_windowAdapter(this));
jTable1.setFont(new java.awt.Font("Dialog", 0, 16));
jScrollPane1.setFont(new java.awt.Font("Dialog", 0, 16));
this.setTitle("產品信息查詢");
this.getContentPane().add(jLabel1, new XYConstraints(24, 13, 332, 42));
this.getContentPane().add(jScrollPane1, new XYConstraints(24, 63, 476, 300));
jScrollPane1.getViewport().add(jTable1, null);
}
private void getResult(){
//定義臨時集合
Vector<String> tempvector=new Vector<String>(1,1);
String sql;
//查詢語句
sql="select * from productinfo ";
//執行數據庫的查詢操作
rs =db.getResult(sql);
try {
//判斷返回的結果集是否為空,若不為空顯示每條記錄
boolean isexist=false;
try {
isexist = rs.first();
}
catch (SQLException ex1) {
}
//若有數據,顯示
if( isexist)
{
//移動游標到零的位置
rs.beforeFirst();
//逐條將查詢結果顯示在jtable中
while(rs.next() )
{tempvector=new Vector(1,1);
tempvector.add(rs.getString("Name")) ;
tempvector.add(rs.getString("Principal")) ;
tempvector.add(rs.getString("Department")) ;
tempvector.add(rs.getString("Units")) ;
tempvector.add(rs.getString("Unitprice")) ;
tempvector.add(rs.getString("Comment")) ;
model.addRow(tempvector);
}
}
//若無數據,顯示警告對話框
else
{ JOptionPane.showMessageDialog(null,"無紀錄!"); }
}
//若出現異常,彈出警告對話框
catch (SQLException ex) { JOptionPane.showMessageDialog(null,"發生錯誤!");
}
}
//在窗體顯示時運行查詢過程
void this_windowOpened(WindowEvent e) {
getResult();
}
}
class productQuery_this_windowAdapter extends java.awt.event.WindowAdapter {
productQuery adaptee;
productQuery_this_windowAdapter(productQuery adaptee) {
this.adaptee = adaptee;
}
public void windowOpened(WindowEvent e) {
adaptee.this_windowOpened(e);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -