sql²åÈë³É¹¦£¬¸üÐÂʧ°Ü - Java / Web ¿ª·¢

Java code:

String sql="insert into StockIn(SiId,SiName,SiNumber,SiPrice,SiSupName,Sistorehouse,SiUser,SiTime,SiMoney) VALUES(NULL,'"+SIName+"','"+Si_Number+"','"+SIPrice+"','"+SISupName+"','"+SIstorehouse+"','"+name+"','"+date+"','"+SIMoney+"') ";

ConnDBSQLite.executeUpdate(sql);

String upstno = "UPDATE stock SET StockNumber=10 where StockName=' "+SIName+" ' ";
upstock.executeUpdate(upstno);




²åÈëÊý¾Ýµ½±íStockIn²Ù×÷³É¹¦£¬²¢ÇÒ¿ÉÒÔÔÚÒ³ÃæÉÏÊä³ö
µ«ÊÇÏÂÃæµÄ¸üбístock ²Ù×÷ËƺõûÓÐÖ´ÐУ¬²¢ÇÒûÓб¨´í

---

UPDATE stock SET StockNumber=10 where StockName=' "+SIName+" '
¶ªµ½Êý¾ÝÄÜÓÐЧ¹û²»£¿£¿

---

ÒýÓÃ

UPDATE stock SET StockNumber=10 where StockName=' "+SIName+" '
¶ªµ½Êý¾ÝÄÜÓÐЧ¹û²»£¿£¿

ÔÚÊý¾Ý¿âÀïÖ´ÐдúÂë
UPDATE stock SET StockNumber=10 where StockName='ÉÌÆ·A'
¿ÉÒÔÐÞ¸Ä

---

ûÌá½»°É£¿

---

ÒýÓÃ

ûÌá½»°É£¿

ÉÏÃæµÄ²åÈë²Ù×÷¿ÉÒÔʵÏֵİ¡
Õâ2ÌõдһÆðµÄ£¬ÔõôÉÏÃæµÄ²åÈë¿ÉÒԳɹ¦£¬ÏÂÃæµÄ¸üв»ÄܲÙ×÷

---

Äã¿ÉÒÔ²âÊÔһϣ¬ÓÐûÓÐÖ´ÐÐÕâ¸öÓï¾ä¡£

---

ConnDBSQLite.executeUpdate(sql);
//Õâ¸öÊÇÒ»¸ö¾²Ì¬·½·¨£¬¿ÉÄÜÀïÃæ¾ÍÓÐÌá½»ÁË

upstock.executeUp