java单击取消按钮清空_java-如何在单击按钮时不清除现有行就将新...

在不清除jTable中的现有行的情况下,如何在单击按钮时从数据库向jTable中添加新行？

我尝试了很多方法.但是没有成功.救命

String SQL = "SELECT name,price FROM items WHERE ID = ' "+jTextField1.getText()+" ' ";

pst = Conn.prepareStatement(sql);

rs = pst.executeQuery();

jTable1.setModel(DbUnits.resultSetToTableModel(rs));

编辑：-

在所有答案的帮助下,我将代码更改为以下代码,但是

好 .但是这里我在DefaultTableModel中得到一个错误

String sql = "SELECT name,price FROM items WHERE ID = '"+jtxt1.getText()+"'";

pst = conn.prepareStatement(sql);

rs=pst.executeQuery();

DefaultTableModel model = new DefaultTabelModel(new String[]{"Name","Price"},0);

Vector row = new Vector();

while(rs.next())

{

String d = rs.getString("name");

String e = rs.getString("price");

row.add(new Object[]{d,e});

model.addRow(row);}

新密码

String sql = "SELECT name,price FROM items WHERE ID = '"+jtxt1.getText()+"'";

pst = conn.prepareStatement(sql);

rs=pst.executeQuery();

DefaultTableModel model=(DefaultTableModel)jTable1.getModel();

Vector row = new Vector();

row.add(rs);

model.addRow(row);

最新代码

ResultSetMetaData metaData;

public void metaData() throws SQLException {

this.metaData = rs.getMetaData();

}

String sql = "SELECT name,price FROM items WHERE ID = '"+jtxt1.getText()+"'";

pst = conn.prepareStatement(sql);

rs=pst.executeQuery();

int columnCount = metaData.getColumnCount();

Vector columnNames = new Vector();

for (int column = 1; column <= columnCount; column++) {

columnNames.add(metaData.getColumnName(column));

System.out.println("ColumnNames "+columnNames );

}

DefaultTableModel datamodel = new DefaultTableModel(columnNames, 0);

jTable1.setModel(datamodel);

while (rs.next()) {

Vector vector = new Vector();

for (int columnIndex = 1; columnIndex <= columnCount; columnIndex++) {

vector.add(rs.getString(columnIndex));

}

datamodel.addRow(vector);

}

**但是在这里我得到了NullpointException错误！我该如何选择jTable1作为以上代码中的表？