JTable与H2数据库的使用方法

JTable控件与H2数据库的使用方法：

JTable使用的关键点有两个：

1. JTable的数据

抽象类AbstractTableModel的子类，完成数据的管理。

JTable类---------------使用AbstractTableModel子类创建，直接提取Abstract子类的数据。

2.JTable的滚动

将JTable加入JScrollPane

将JScrollPane加入JFrame

通过JScrollPane面板类完成滚动。其实类似的面板容器还有许多

JTabbedPane------选项卡面板

JSplitPane-----------分割条面板

JScrollPane----------滚动条面板

JDesktopPane-------MDI面板

3.数据的存储问题

全部数据存储在集合类中，如Array，Vector

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package testh2;

import java.awt.BorderLayout;
import java.awt.EventQueue;
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.JFrame;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.AbstractTableModel;

class TableModel extends AbstractTableModel
{
    public Vector<String> columnsName=new Vector<String>();
    public Vector<String[]> Data=new Vector<String[]>(); 
    //public String[] columnsName={"a","b"};
    //public Object[][] Data={{"a1","b1"},{"a2","b2"}};
    public int getRowCount()
    {
        
        return Data.size();
    }
    public int getColumnCount() 
    {
        return columnsName.size();
    }
    public Object getValueAt(int rowIndex, int columnIndex) 
    {
        
        return Data.get(rowIndex)[columnIndex];
    }
}
/**
 *
 * @author wind
 */
public class TestH2 {

    public static void GUItest() throws InterruptedException
    {
        final TableModel tm=new TableModel();
        tm.columnsName.add("第一列");
        tm.columnsName.add("第二列");
        tm.columnsName.add("第三列");
        tm.columnsName.add("第四列");
        tm.columnsName.add("第五列");
        tm.columnsName.add("第六列");
        tm.columnsName.add("第七列");
        tm.columnsName.add("第八列");
        EventQueue.invokeLater(new Runnable() {
            public void run() {
                JFrame jf=new JFrame();
                JTable jt=new JTable(tm);
                jt.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); 
                JScrollPane js=new JScrollPane(jt);
                jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
                jf.setSize(600, 400);
                jf.setVisible(true);
                jf.add(js);             
            }
        });
        for(int i=3;i<50;i++)
        {
            tm.Data.add(new String[]{"a"+i,"b"+i,"c"+i,"d"+i,"e"+i,"f"+i,"g"+i,"h"+i});
            //Thread.sleep(1000);
        }
    }
    public static void H2Test() throws ClassNotFoundException, SQLException
    {
        Class.forName("org.h2.Driver");
        Connection conn = DriverManager.getConnection("jdbc:h2:E:/test", "sa", "123456");
        Statement stat = conn.createStatement();
        ResultSet rs = stat.executeQuery("select * from Test");
        String str;
        while (rs.next()) {
            str = rs.getString(1) + "\t";
            str += rs.getString(2) + "\t";
            str += rs.getString(3) + "\t";
            str += rs.getString(4) + "\t";
            str += "\n";
            System.out.println(str);
        }
    }

    public static void main(String[] args) throws ClassNotFoundException, SQLException, InterruptedException
    {
        // TODO code application logic here
        H2Test();
        GUItest();
    }
    

}

使用JTable就可以完成对H2数据库的编辑等操作。