package prj12;

import java.awt.BorderLayout;
import java.awt.Dimension;

import javax.swing.*;
import javax.swing.JPanel;
import javax.swing.JTable;
import javax.swing.table.JTableHeader;
import java.awt.Color;
import javax.swing.table.DefaultTableModel;
import db.DbConnectio;
import java.util.*;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;

public class FrameTable extends JFrame {
    JPanel contentPane;
    DbConnectio db=new DbConnectio();
    //表頭
  //  String [] name={"學號","姓名","成績"};
    //數(shù)據(jù)
   // Object [][] data={{new Integer(1),"a",new Integer(60)},{new Integer(2),"b",new Integer(70)},{new Integer(3),"c",new Integer(80)}};

  /// DefaultTableModel dt=new DefaultTableModel()
    BorderLayout borderLayout1 = new BorderLayout();
    JTable jTable1 = new JTable();
    JTableHeader jTableHeader1 = jTable1.getTableHeader();
    public FrameTable() {
        try {
            setDefaultCloseOperation(EXIT_ON_CLOSE);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    /**
     * Component initialization.
     *
     * @throws java.lang.Exception
     */
    private void jbInit() throws Exception {
        contentPane = (JPanel) getContentPane();
        contentPane.setLayout(borderLayout1);
        setSize(new Dimension(400, 300));
        setTitle("表格");
        DbConnectio db=new DbConnectio();
       Vector vdata= db.getData();
       Vector vname=db.getColumnNames();
       //創(chuàng)建一個數(shù)據(jù)模式類對象
       DefaultTableModel dt=new DefaultTableModel(vdata,vname);
       jTable1.setCellSelectionEnabled(true);
       //為表格設置數(shù)據(jù)模式方式
       jTable1.setModel(dt);
        jTable1.addMouseListener(new FrameTable_jTable1_mouseAdapter(this));

        jTableHeader1.setForeground(Color.red);
        jTable1.setGridColor(Color.black);

        contentPane.add(jTable1, java.awt.BorderLayout.CENTER);
        contentPane.add(jTableHeader1, java.awt.BorderLayout.NORTH);
    }

    public void jTable1_mouseClicked(MouseEvent e) {
        //獲取行號
        int row=jTable1.getRowCount();
        //獲取列號
        int col=jTable1.getColumnCount();
        String s=(String)jTable1.getValueAt(row,col);
        JOptionPane.showMessageDialog(this,s);


    }
}


class FrameTable_jTable1_mouseAdapter extends MouseAdapter {
    private FrameTable adaptee;
    FrameTable_jTable1_mouseAdapter(FrameTable adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.jTable1_mouseClicked(e);
    }
}