从mySQL数据填充Jtable

Question

我不知道如何以及在哪里开始我的代码。我试着在谷歌搜索如何使用java代码在netbeans GUI中填充Jtable。好吧，实际上，我不希望所有的列在我的MySql数据库将显示。所以我创建了表模型。我不知道这是否有效。但问题是我不知道下一步该做什么。我想要它显示在我的Jtable称为"tblList"。请告诉我怎么做。这是我的"ListOfMembersModel"

  import java.text.DateFormat;
  import java.util.ArrayList;
  import java.util.Locale;
  import javax.swing.table.DefaultTableModel;
  import rtu.tomis.bom.Member;
  public class ListOfMembersModel extends DefaultTableModel{
private ArrayList<Member> members;

public ArrayList<Member> getMembers() {
    return members;
}
public void setMembers(ArrayList<Member> members) {
    this.members = members;
}

public ListOfMembersModel(ArrayList<Member> members){
    this.members = members;
    String[] columns = {"MemberId", "Voters ID", "Full Name",  "Age",  "Address", "Gender", "Birthday", "Contact Number", "Email Address", "Type of Membership"};
    this.setColumnIdentifiers(columns);
}
 public int getRowCount() {
    int rows = 0;
    if(this.members!=null && this.members.size()>0){
        rows = this.members.size();
    }
    return rows;
}
public int getColumnCount() {
    int columns = 10;
    return columns;
}
@Override
public Object getValueAt(int rowIndex, int columnIndex) {
    String s = "";
    Member member = null;
    if(this.members!=null && this.members.size()>0){
        member = (Member)this.members.get(rowIndex);
        switch(columnIndex){
            case 0:
                s = ""+member.getMemberId();
                break;
            case 1:
                s = member.getVotersId();
                break;
            case 2:
                s = member.getFullname();
                break;
            case 3:
                s = "" + member.getAge();
                break;
            case 4:
                s = member.getFulladdress();
                break;
            case 5:
                s = member.getGender();
                break;
            case 6:
                DateFormat df = DateFormat.getDateInstance(DateFormat.MEDIUM, Locale.US);
                String bday = df.format(member.getBirthday());
                s = ""+bday;
                break;
               case 7:
                s = "" + member.getContactNo();
                break;
                case 8:
                s = member.getEmailAddress();
                break;
                 case 9:
                s = member.getMembershipType();
                break;
        }
    }
    return s;
}
public boolean isCellEditable(int row, int col){
    return false;
}

你能告诉我如何在填充我的Jtable时显示这个吗?谢谢你。

Answer 1

答案似乎是

jTable.setModel(new ListOfMembersModel(members));

一些更改可能必须向表侦听器发出通知，其中之一是JTable，请参阅AbstractTableModel.fire…方法