package quanquanqi;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.sql.SQLException;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.AbstractTableModel;

public class TableBrowser {

	//private GeneralAggregateVO gvo;

	//private GeneralDAO gdo;

	private String query = "select * from alarm";

	private JFrame f;

	private JButton Original_Database;

	private JButton Updating_Database;

	private JPanel buttonPanel;

	private JPanel contentPanel;

	private JTable table;

	dataTableModel dtModel = null;

	Original_Alarm oa = new Original_Alarm();

	public static void main(String[] args) {
		TableBrowser tablebrowser = new TableBrowser();
		tablebrowser.getData();
		tablebrowser.buildGUI();
	}

	void getData() {
		//gdo = ;
		try {
			oa.gdao.executeQuery(query);
		} catch (SQLException e) {
			// TODO 自動生成 catch 塊
			e.printStackTrace();
		}		
	}

	void buildGUI() {
		f = new JFrame("Updating Database");
		contentPanel = new JPanel(new BorderLayout());
		f.setContentPane(contentPanel);
		dtModel = this.new dataTableModel();
		table = new JTable(dtModel);
		JScrollPane scrollpane = new JScrollPane(table);
		scrollpane.setPreferredSize(new Dimension(1000, 618));
		f.addWindowListener(new WindowAdapter() {
			public void windowClosing(WindowEvent e) {
				try {
					oa.gdao.con.close();
				} catch (SQLException e1) {
					// TODO 自動生成 catch 塊
					e1.printStackTrace();
				}
				System.exit(0);
			}
		});
		Original_Database = new JButton("Reset_Database");
		Original_Database.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				oa.resetAlarms();				
				dtModel.fireTableDataChanged();				
				dtModel.fireTableStructureChanged();
			}
		});
		Updating_Database = new JButton("Updating_Database");
		Updating_Database.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				oa.slidewindow_updating(100);				
				dtModel.fireTableDataChanged();
				dtModel.fireTableStructureChanged();
			}
		});
		buttonPanel = new JPanel();
		buttonPanel.add(Original_Database);
		buttonPanel.add(Updating_Database);
		contentPanel.add(scrollpane, BorderLayout.NORTH);
		contentPanel.add(buttonPanel, BorderLayout.SOUTH);
		f.pack();
		f.setVisible(true);
	}

	class dataTableModel extends AbstractTableModel {
		boolean updateFlag = false;

		public int getColumnCount() {
			return oa.gdao.gvo.getColumnCount();
		}

		public int getRowCount() {
			return oa.gdao.gvo.getRowCount();
		}

		public Object getValueAt(int row, int col) {
			oa.gdao.gvo.absolute(row);
			return oa.gdao.gvo.getObject(col);
		}

		public String getColumnName(int col) {
			return oa.gdao.gvo.getColumnName(col);
		}

		public boolean isCellEditable(int row, int col) {
			return true;
		}

		public Class getcolumnClass(int col) {
			return new Object().getClass();
		}

		public void setValueAt(Object value, int row, int col) {
			updateFlag = true;
			oa.gdao.gvo.absolute(row);
			oa.gdao.gvo.updateObject(col, value);
			fireTableCellUpdated(row, col);
		}
	}

}