package login;

import java.awt.Dialog;
import javax.swing.*;

import java.awt.*;
import java.awt.event.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;

public class ShowData extends Dialog implements ActionListener{
	public JPanel mainPanel, centerPanel, bottomPanel;
	JButton btnData;
	
	public ShowData(Frame owner, String title, boolean modal){
		super(owner, title, modal);
		
		btnData = new JButton("調用數據庫開始");
		this.add(btnData, BorderLayout.NORTH);
		centerPanel = new JPanel();
		this.add(centerPanel, BorderLayout.CENTER);
		bottomPanel = new JPanel();
		this.add(bottomPanel, BorderLayout.SOUTH);
	}
	
	public void actionPerformed(ActionEvent e) {
		Vector headers = null;
		Vector datas = null;
		if(e.getSource() == btnData){
			centerPanel.removeAll();
			bottomPanel.removeAll();
			
			try{
				headers = new Vector();
				headers.add("客戶ID");
				headers.add("客戶姓名");
				headers.add("客戶年齡");
				headers.add("客戶信息");
				
				datas = new Vector();
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
				String url="jdbc:odbc:login"; 
				Connection connection=DriverManager.getConnection(url); 
				Statement statement = connection.createStatement(); 
				String sql = "SELECT * FROM infor"; 
				ResultSet rs = statement.executeQuery(sql); 
				while(rs.next()){
					Vector temp = new Vector();
					temp.add(rs.getString("ID"));
					temp.add(rs.getString("name"));
					temp.add(rs.getString("age"));
					temp.add(rs.getString("information"));
					datas.add(temp);
				}
				rs.close();
				connection.close();
			}
			catch(SQLException ex){
				System.out.println("Error Code: " + ex.getErrorCode());
				System.out.println("Message: " + ex.getMessage());
				System.exit(0);
			}
			catch(Exception ep){
				ep.printStackTrace();
			}
		}
		JTable table = new JTable(datas, headers);
		table.setAutoResizeMode(JTable.AUTO_RESIZE_LAST_COLUMN);
		centerPanel.add(table);
	}
}