mytablemodel.java

实现JTable与Excel之间的数据交换

import java.util.Calendar;
import java.util.GregorianCalendar;
import javax.swing.table.AbstractTableModel;
import java.util.Date;


class MyTableModel extends AbstractTableModel {

    public final static boolean GENDER_MALE=true;
    public final static boolean GENDER_FEMALE=false;

    public final static String[] columnNames={"姓 名","籍 贯",
         "出生年月 ","入学总分","性别"};
    public Object [][] values={
         {
             "黄淑玲","安阳",new GregorianCalendar(1977,Calendar.FEBRUARY,20).getTime(),
             new Float(545),"女"
         },
         {
             "李建新","江西",new GregorianCalendar(1978,Calendar.JANUARY,6).getTime(),
             new Float(608),"男"
         },
         {
             "张  萍","郑州",new GregorianCalendar(1977,Calendar.AUGUST,31).getTime(),
             new Float(578),"女"
         },
         {
             "王凤英","山西",new GregorianCalendar(1977,Calendar.JANUARY,16).getTime(),
             new Float(598),"女"
         },
         {
             "肖华瑞","河南",new GregorianCalendar(1978,Calendar.AUGUST,2).getTime(),
             new Float(567),"男"
         }
    };
    public int getRowCount() {
        return values.length;
    }
    public int getColumnCount() {
        return values[0].length;
    }
    public Object getValueAt(int row,int column) {
        return values[row][column];
    }
    public String getColumnName(int column) {
        return columnNames[column];
    }
    public boolean isCellEditable(int row,int column) {
        return true;
    }
    public void setValueAt(Object value,int row,int column) {
        values[row][column]=value;
    }
    public Class getColumnClass(int column){
        Class datatype=super.getColumnClass(column);
        if(column==2){
            datatype=Date.class;
        }
        return datatype;
    }
}