『不知道这段代码错在哪里？？？』

[loita2000]

（其中headno,highno,subno,midno,num,name,male,inlevel,Auth,Addrno,Cardid,
Certserialno,Certdate,Period等为表的字段名，是一个表中选种的一行的删除功能的实现，代码如下：请指正）


public void delData()
{
openConnection();
try
{
theStatement=theConnection.createStatement();
theResult=theStatement.executeQuery("select * from TABLE1");
theMetaData=theResult.getMetaData();
while (theResult.next())
{
rowDataheadno=theResult.getString("headno");
rowDatahighno=theResult.getString("highno");
rowDatasubno=theResult.getString("subno");
rowDatamidno=theResult.getString("midno");
rowDatanum=theResult.getString("num");
rowDataname=theResult.getString("name");
rowDatamale=theResult.getString("male");
rowDatainlevel=theResult.getString("inlevel");
rowDataAuth=theResult.getString("Auth");
rowDataAddrno=theResult.getString("Addrno");
rowDataCardid=theResult.getString("Cardid");
rowDataCertserialno=theResult.getString("Certserialno");
rowDataCertdate=theResult.getString("Certdate");
rowDataPeriod=theResult.getString("Period");

jtfheadno.setText(rowDataheadno);
jtfhighno.setText(rowDatahighno);
jtfsubno.setText(rowDatasubno);
jtfmidno.setText(rowDatamidno);
jtfnum.setText(rowDatanum);
jtfname.setText(rowDataname);
jtfmale.setText(rowDatamale);
jtfinlevel.setText(rowDatainlevel);
jtfAuth.setText(rowDataAuth);
jtfAddrno.setText(rowDataAddrno);
jtfCardid.setText(rowDataCardid);
jtfCertserialno.setText(rowDataCertserialno);
jtfCertdate.setText(rowDataCertdate);
jtfPeriod.setText(rowDataPeriod);//选中一行让其显示在文本区，然后在做其他操作

String str="delete from TABLE1 (headno,highno,subno,midno,num,name,male,inlevel,Auth,Addrno,Cardid,Certserialno,Certdate,Period) values ('"+rowDataheadno+"','"+rowDatahighno+"','"+rowDatasubno+"','"+rowDatamidno+"','"+rowDatanum+"','"+rowDataname+"','"+rowDatamale+"','"+rowDatainlevel+"','"+rowDataAuth+"','"+rowDataAddrno+"','"+rowDataCardid+"','"+rowDataCertserialno+"','"+rowDataCertdate+"','"+rowDataPeriod+"')";

theStatement.executeUpdate(str);

jtfStatus.setText(" 数据删除结束,请继续下一步的操作 ");
theResult.close();
}
}
catch(Exception e)
{
handleException(e);
}
}

[DragonFly-9]

把错误提示打出来吧!

[loita2000]

编译可以通过，就是不能实现删除的功能啊，
是不是对表操作的语法本身有问题咯？？？？

[clarepuma]

同感，SQL语句错了！

[SuperMMX]

ft, 用的是同一个 statement, 哪有这么干的.