Question

jtable 删除数据，删不掉 报 com.microsoft.sqlserver.jdbc.SQLServerException: '?' 附近有语法错误。

// 删除的方法
public static int delEmployee(int id) {

// TODO Auto-generated method stub
try {

server.getConn();
int selectRow = table.getSelectedRow();// 获得选中行的索引

// int reultSet = server.insert("delete from employee where id="
// + list.get(selectRow));
int reultSet=server.insert("delete from employee where id=?");

if (selectRow != -1) // 如果存在选中行
{
//
tableModel.removeRow(selectRow); // 删除行

}
System.out.println("删除成功！");
JOptionPane.showConfirmDialog(null, "删除成功了！");

} catch (Exception e2) {
// TODO: handle exception

System.out.println(e2.getMessage());
} finally {
server.Close();
}
return tableModel.getColumnCount();

}
在线等

Answer 1

Answer 2

Answer 3

Answer 4