ps.executeUpdate("update dangan set name='" + xm.getText().trim() +
"',sex='" + sex.getText().trim() +
"',brithday='"
+ rq.getText().trim()+ "',jobnum='" +
bh.getSelectedItem()+ "',tele='"
+ tel.getText().trim() + "',intime='" +
rxrq.getText().trim() + "',zhuzhi='" +
address.getText().trim() + "',add='"
+comment.getText().trim() + "'where worknum = " +xh.getText().trim()+"");
"',sex='" + sex.getText().trim() +
"',brithday='"
+ rq.getText().trim()+ "',jobnum='" +
bh.getSelectedItem()+ "',tele='"
+ tel.getText().trim() + "',intime='" +
rxrq.getText().trim() + "',zhuzhi='" +
address.getText().trim() + "',add='"
+comment.getText().trim() + "'where worknum = " +xh.getText().trim()+"");
ps.executeUpdate("update dangan set name='" + xm.getText().trim() +
"',sex='" + sex.getText().trim() +
"',brithday='"
+ rq.getText().trim()+ "',jobnum='" +
bh.getSelectedItem()+ "',tele='"
+ tel.getText().trim() + "',intime='" +
rxrq.getText().trim() + "',zhuzhi='" +
address.getText().trim() + "',add='"
+"aaa" + "' where worknum = " +xh.getText().trim()+"");
这样试试,挨个排除一下,看看问题出在哪个上面
+1
ps.executeUpdate("update dangan set name= ? ....");
ps.setString(1,xm.getText().trim()).
....
你这样
String s="update dangan set name='" + xm.getText().trim() +
"',sex='" + sex.getText().trim() +
"',brithday='"
+ rq.getText().trim()+ "',jobnum='" +
bh.getSelectedItem()+ "',tele='"
+ tel.getText().trim() + "',intime='" +
rxrq.getText().trim() + "',zhuzhi='" +
address.getText().trim() + "',add='"
+comment.getText().trim() + "'where worknum = " +xh.getText().trim()+"";然后断个点。看看S的内容是怎样的。
"' where worknum = " +xh.getText().trim()+"");