[Solved] Java GUI syntax error in SQL statment

by


Oh my god, thanks @Orel Eraki, of course beside the unbalanced single-quotes you will have to follow proper SQL Insert Syntax and hava a form of ‘INSERT INTO …’, try it like this (see my change dirctly after “values(” as the one of Orel Eraki (no ‘table’ “keyword” after into):

Sql_insert="insert into itemmanag(itemID,purchesPrice,sellPrice,quantity,vendor,unitM )values('"+txt_itemID.getText()+"','"+Item_Pprice.getText()+"','"+txt_itemSprice.getText()+"','"+txt_qunti.getText()+"','" +jcombo1+"','"+jcombo2+ "')";

7

solved Java GUI syntax error in SQL statment