通过Jtable将记录修改到数据库中 [英] Modifying Records into Database Through Jtable

问题描述

我使用Netbeans 7.1创建了一个Jtable. 该表创建了如下的默认模型

I created a Jtable using Netbeans 7.1. The table created a default model as below

table.setModel(new javax.swing.table.DefaultTableModel(
        new Object [][] {
            {null, null, null, null},
            {null, null, null, null},
            {null, null, null, null},
            {null, null, null, null}
        },
        new String [] {
            "Title 1", "Title 2", "Title 3", "Title 4"
        }
    ));

我还添加了以下代码行以填充Sqlite数据库中的数据.

I also added the following lines of code to populate data from an Sqlite Database.

public void tabl()
{
  try
  {
    stmt=conn.createStatement();
    String sql2="SELECT * FROM students";
    rs=stmt.executeQuery(sql2);
    int n=0;
    while(rs.next())
    {  

      table.setValueAt(rs.getString(1),n,0);
      table.setValueAt(rs.getString(2),n,1);
      table.setValueAt(rs.getString(3),n,2);
      table.setValueAt(rs.getString(4),n,3);
      n++;
    }
  }
  catch(SQLException e)
  {

  }
}

我的测验是如何现在使JTable能够使用默认模型更新和删除记录.我是表模型的新手.

My quiz is How do I now make the JTable able to Update and delete records...with the default model.I am new to table Models.

推荐答案

DefaultTableModel dmReset = (DefaultTableModel) table.getModel();
try {
    stmt=conn.createStatement();
    String sql2="SELECT * FROM students";
    rs=stmt.executeQuery(sql2);
    while (rs.next()) {
          Vector v = new Vector();
          v.add(rs.getString(1));
          v.add(rs.getString(2));
          v.add(rs.getString(3));
          v.add(rs.getString(4));
          dmReset.addRow(v);
          }
    } catch (Exception e) {
          System.err.println(e.toString());
    }

注意:在rs.getXXX()方法中使用完整的列标题，而不要使用列索引. 有关TableModel的更多详细信息，可以引用此文件.

Note : Use full column headers in rs.getXXX() methods instead of column indexes. for more details on TableModel you can refer this document.

如果您想获取其他类型的数据，例如Float，int等...，可以在其中添加一个开关盒， 您可以在此处找到示例.

If you want to get other types of data like Float, int etc... a switch case can be added with this, you can find example here.

这篇关于通过Jtable将记录修改到数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！