如何将数据库数据显示到 Swings 中的 JTable（动态）？

发布于 2024-08-31 02:44:38 字数 458 浏览 6 评论 0原文

我们在业务层使用hibernate，但任务是，通过使用Swing中的JTable来显示数据库中的动态数据(Swing)。代码：

    Criteria criteria=session.createCriteria(User.class);
    //here user.class is pojo class in hibernate.

    List studentlist= criteria.list();

    System.out.println("records"+studentlist);
    //here the data is showing in hibernate console, but how  to represent that data in the format of "jtable".

原文

We are using hibernate in business layer,but the task is,
by using the JTable in Swing to display the dynamic data(Swing) from the database.
code:

    Criteria criteria=session.createCriteria(User.class);
    //here user.class is pojo class in hibernate.

    List studentlist= criteria.list();

    System.out.println("records"+studentlist);
    //here the data is showing in hibernate console, but how  to represent that data in the format of "jtable".

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

疧_╮線 2024-09-07 02:44:38

我们可以从休眠中检索对象列表。要显示 JTable 中的对象，只需从 AbstractTableModel 继承一个类并提供 getRowCount() 、 getColumnCount() 和 getValueAt() 方法。并且经常需要重写 getColumnName 方法来显示您想要的列名，而不是 X,Y,Z 形式。
假设您在某个数据库中有一个 PERSON 表及其相应的持久类 Person。

PersonTableModel.java 的来源：

import org.hibernate.*;
import org.hibernate.cfg.*;
import java.util.*;
import javax.swing.table.AbstractTableModel;



public class PersonTableModel extends AbstractTableModel
{
    private static final long serialVersionUID = 6105842825518764825L;
    private ArrayList<Person> PersonList;

    public PersonTableModel()
    {
        super();
        SessionFactory sf=new Configuration().configure().buildSessionFactory();
        Session session=sf.openSession();

        Query q=session.createQuery("from Person");
        PersonList=new ArrayList<Person>(q.list());

        session.close();
        sf.close();
    }

    public int getRowCount()
    {
        return PersonList.size();
    }

    public int getColumnCount()
    {
        return 5;
    }

    public Object getValueAt(int rowIndex, int columnIndex)
    {
        Person p=PersonList.get(rowIndex);
        Object[] values=new Object[]{p.getId(),p.getFirstname(),p.getLastname(),
                p.getAge(),p.getDescription()};
        return values[columnIndex];
    }

    @Override
    public String getColumnName(int column)
    {
        String[] columnNames=new String[]{"id","FirstName","LastName","Age","description"};
        return columnNames[column];
    }
}

然后创建一个 PersonTableModel 对象并为其设置 JTable 的模型

We can retrieve a List of Objects from hibernate. To show the Objects in JTable, just inherited a class from AbstractTableModel and supply getRowCount() ,getColumnCount() and getValueAt() methods. And the getColumnName method is often need to be overrided to show the column name you want, not the X,Y,Z form.
Lets say You have a PERSON table in some database and its corresponding persistent class Person.

Source of PersonTableModel.java:

import org.hibernate.*;
import org.hibernate.cfg.*;
import java.util.*;
import javax.swing.table.AbstractTableModel;



public class PersonTableModel extends AbstractTableModel
{
    private static final long serialVersionUID = 6105842825518764825L;
    private ArrayList<Person> PersonList;

    public PersonTableModel()
    {
        super();
        SessionFactory sf=new Configuration().configure().buildSessionFactory();
        Session session=sf.openSession();

        Query q=session.createQuery("from Person");
        PersonList=new ArrayList<Person>(q.list());

        session.close();
        sf.close();
    }

    public int getRowCount()
    {
        return PersonList.size();
    }

    public int getColumnCount()
    {
        return 5;
    }

    public Object getValueAt(int rowIndex, int columnIndex)
    {
        Person p=PersonList.get(rowIndex);
        Object[] values=new Object[]{p.getId(),p.getFirstname(),p.getLastname(),
                p.getAge(),p.getDescription()};
        return values[columnIndex];
    }

    @Override
    public String getColumnName(int column)
    {
        String[] columnNames=new String[]{"id","FirstName","LastName","Age","description"};
        return columnNames[column];
    }
}

Then create a PersonTableModel Object and set the JTable’s model to it

回复收藏 0 原文