如何在java swing中按jtabel中的数据显示组?

时间:2023-01-27 23:11:34

I have to face one problem I want To display Data in GroupWise there Are this type of field in java swing jtable.

我必须面对一个我想要的问题在GroupWise中显示数据在java swing jtable中有这种类型的字段。

DataBase Table is :

数据库表是:

1] category

1]类别

  • categoryID int
  • categoryID int
  • categoryName var
  • categoryName var

2] product

2]产品

  • productID int
  • productID int
  • productName var
  • productName var
  • qty float
  • 数量漂浮
  • categoryId int ref of category[categoryid]
  • categoryId int类别[categoryid]

Now Display group by query data in jTable java Swing that type format

现在按jTable java中的查询数据显示组Swing那种类型格式


cat.Id | cat.Name | prod.Id | Prod.Name | qty | sub Tot | Tot Qty
1      | Mobile _____________________________________   |20 
  • 1 Nokia 5233 [10]
  • 1诺基亚5233 [10]
  • 2 Nokia Lumiya 510 [10]
  • 2诺基亚Lumiya 510 [10]

2      |  Pen Drive__________________________________   |50
  • 1 PNY [20]
  • 1 PNY [20]
  • 2 HP [20]
  • 2 HP [20]
  • 3 Sony [10]
  • 3索尼[10]

Total Quantity is__________________70

1 个解决方案

#1


2  

You can try the EnvelopeTableModel http://java-sl.com/envelope.html Just load your data and create wrapping model based on the initial one with grouped columns

您可以尝试使用EnvelopeTableModel http://java-sl.com/envelope.html只需加载数据并根据带有分组列的初始数据创建包装模型

#1


2  

You can try the EnvelopeTableModel http://java-sl.com/envelope.html Just load your data and create wrapping model based on the initial one with grouped columns

您可以尝试使用EnvelopeTableModel http://java-sl.com/envelope.html只需加载数据并根据带有分组列的初始数据创建包装模型