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