package login;

import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JTable;

public class FrameData extends JFrame implements ActionListener{
	public JPanel mainPanel, centerPanel, bottomPanel;
	public JButton btnData;
	
	public static void main(String[] agrs){
		System.out.println("Starting FrameData...");
		FrameData fData = new FrameData();
		fData.setSize(500, 500);
		fData.setTitle("數據顯示");
		fData.setVisible(true);
	}
	
	public FrameData(){
		btnData = new JButton("調用數據庫開始");
		getContentPane().add(btnData, BorderLayout.NORTH);
		centerPanel = new JPanel();
		getContentPane().add(centerPanel, BorderLayout.CENTER);
		bottomPanel = new JPanel();
		getContentPane().add(bottomPanel, BorderLayout.SOUTH);
		
		btnData.addActionListener(this);
		
	}
	
	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, BorderLayout.CENTER);
		getContentPane().add(centerPanel);
		this.repaint();
		System.out.println("0000000000");
	}

}