请问这段代码那里出错，易导致后面的报错（在线等）

Question

在进行对数据库的操作是出现异常，不能实现对数据库的更新，求解
String sql1 = "'" + id +"','"+client+"','"+name+"','"+spec+"','"+unit+"','"+value+"','"+make+"','"+date+"','"+text +"'";
sql = "insert into product_out values(" + sql1 + ")";
USeDB.UpdateDB(sql);
sql = "select product_value from product_in where product_value >="+num;
int val = DBUtil.getValue(sql);

val = Integer.parseInt(value) - val;
if(val==0){
sql = "delete product_in where product_ID=" +"'" + id + "'";
}
if(val>0){
sql = "update product_in set product_value="+val+" where product_ID=" +"'" + id + "'";
}
还有
if(!DBUtil.isExist("select * from product_out where product_ID="+"'"+baba[0]+"'")){
javax.swing.JOptionPane.showMessageDialog(null, "请注意更改的数据编号不存在，不能更改，请重新输入！","数据有误",javax.swing.JOptionPane.ERROR_MESSAGE);
clean();
return;
}
sql = "'"+id +"','"+client+"','"+name+"','"+spec+"','"+unit+"','"+value+"','"+make+"','"+date+"','"+text+"'";
sql = "update product_out set product_ID='"+id+",'product_client='"+client+",'product_name='"+name+"',product_spec='"+spec+",'product_unit='"+unit+
",'product_value='"+value+",'product_make='"+make+",'stock_date='"+date+",'product_text='"+text+",'where product_ID="+"'" + id +"'";
USeDB.UpdateDB(sql);
//frame.setTitle("数据录入成功！");
clean();

}错误
java.sql.SQLException: No row count was produced
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(Unknown Source)
at src.USeDB.UpdateDB(USeDB.java:33)
at src.createUserProductOutInterFace.Input(createUserProductOutInterFace.java:323)
at src.createUserProductOutInterFace.access$12(createUserProductOutInterFace.java:229)
at src.createUserProductOutInterFace$11.actionPerformed(createUserProductOutInterFace.java:181)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)

Answer 1

sql = "update product_out set product_ID='"+id+",'product_client='"+client+",'product_name='"+name+"',product_spec='"+spec+",'product_unit='"+unit+
",'product_value='"+value+",'product_make='"+make+",'stock_date='"+date+",'product_text='"+text+",'where product_ID="+"'" + id +"'";
这个有问题啊。 应该是 product_ID='"+id+"',product_client='"+..... 后面的错了好几个分号。

Answer 2

sql = "insert into product_out values(" + sql1 + ")";
把这句改成
sql = "insert into product_out values(sql1)";
看看

Answer 3

太错了sql = "update product_out set product_ID='"+id+"','product_client='"+client+"','product_name='"+name+"',product_spec='"+spec+"','product_unit='"+unit+
",'product_value='"+value+",'product_make='"+make+"','stock_date='"+date+"','product_text='"+text+"','where product_ID="+"'" + id +"'";

Answer 4

sql = "update product_out set product_ID='"+id+"',product_client='"+client+"'
修改语句是这样的