Jtable利用SetModel进行数据绑定

首页定义了一个公用Model类，代码如下：

 

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package TableModel;

import java.sql.ResultSet;
import java.util.LinkedList;
import javax.swing.table.AbstractTableModel;
import zhinengkaiguanjiankong.comm.LoggerUtil;

/**
 *数据库和JTable数据绑定记录数据存放对象
 * @author http://www.my400800.cn
 */
public class TableModel extends AbstractTableModel {

    private int column = 4;
    private String[] columnName = null;
    private LinkedList<String[]> resultSet = null;  

    public TableModel() {
    }

    /** Creates a new instance of TableModel */
    public TableModel(ResultSet rs, String[] DScolumnName, String[] columnName) throws Exception {
        if (DScolumnName.length != columnName.length) {
            throw new Exception("指定JTable列和指定数据库列数不一致，无法进行数据绑定");
        }
        this.columnName = columnName;
        column = columnName.length;
        resultSet = new LinkedList<String[]>();
        try {
            while (rs.next()) {
                String[] row = new String[column];
                for (int i = 0; i < column; i++) {
                    row[i] = rs.getString(DScolumnName[i]);
                }
                resultSet.add(row);             
            }
        } catch (Exception e) {
            LoggerUtil.WriteErrLog(e);
            throw e;
            // System.out.println("err");
        }
    }

    /**
     * 取得总记录数
     * @return  总记录数
     */
    public int getRowCount() {
        return resultSet.size();
    }

    /**
     * 取得总列数
     * @return  总列数
     */
    public int getColumnCount() {
        return column;
    }

    /**
     * 取得指定行指定列数据
     * @param rowIndex      行
     * @param columnIndex   列
     * @return
     */
    public Object getValueAt(int rowIndex, int columnIndex) {
        String[] row = resultSet.get(rowIndex);
        return row[columnIndex];
    }

    /**
     * 取得指定列名称
     * @param i  指定列
     * @return   指定列名称返回
     */
    public String getColumnName(int i) {
        return columnName[i];
    }
}

 

 

model实现类，在这个列里面设定JTable列明和数据库的取得字段名

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package TableModel;

import java.sql.ResultSet;

/**
 *
 * @author 173.114
 */
public class ZhinengkaiguanjiankongViewTableModel extends TableModel {

    public ZhinengkaiguanjiankongViewTableModel(ResultSet rs) throws Exception {
        /**
         * 记录rs   数据库字段名    JTable列明
         */
        super(rs, new String[]{"id", "i64val", "timeval", "val14", "val22", "adv", "val24", "val13"},
                new String[]{"ID", "名称", "时间", "状态", "段位", "属性", "备注", "开关ID"});     
    }
}

 

数据绑定代码

 tableModel = new ZhinengkaiguanjiankongViewTableModel(数据库取得的ResultSet );
            jtbl_DataList.setModel(tableModel);

通过上面的代码，就把数据通过Model绑定到JTable了