package prj12;

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

import javax.swing.JFrame;
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.*;

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);
       //為表格設置數(shù)據(jù)模式方式
       jTable1.setModel(dt);



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

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