java - Error in SQL statement with inserting -

-

i trying insert user inputted data database, getting error "syntax error: encountered "[" @ line 1, column 160." here code, doing wrong?`

if (action.getsource() == submit_button) {     try     {         sql = "insert customer (fname, lname, age, licnum, state, car_type, rentdate, returndate, total, paytype, returned) values(";         sql = sql + "'" + f_name.gettext() + "'" + "," + "'" + l_name.gettext() + "'" + "," + age + "," + "'" + liscense_num.gettext() + "'" + "," + "'"              + issuing.gettext() + "'" + "," + "'" + car_select.gettoolkit() + "'" + "," + "'" + rental.gettext() + "'" + "," + "'" + return_d.gettext() + "'"             + "," + total.gettext() + "," + "'" + button_val.gettext() + "'" + "," + "'true'" + ")";          mystatement.execute(sql);         system.out.print("record has been added database");     }     catch (sqlexception e)     {         // todo auto-generated catch block         e.printstacktrace();     } }

can change query this?

sql = "insert customer (fname, lname, age, licnum, state, car_type, rentdate, returndate, total, paytype, returned) values('"+f_name.gettext()+"','"+l_name.gettext()+"','"+age+"','"+liscense_num.gettext()+"','"+issuing.gettext()+"','"+car_select.gettoolkit()+"','"+rental.gettext()+"','"+return_d.gettext()+"','"+total.gettext()+"','"+button_val.gettext()+"','true') ";

Comments

Post a Comment

Popular posts from this blog

Load Balancing in Bluemix using custom domain and DNS SRV records -

-
i'm trying load balancing of application in bluemix using custom domain , srv record in dns manager. created own doamin ccbluemix.dynu.com , added custom domain bluemix. created application in region , created route custom domain myapp.ccbluemix.dynu.com deployed same application in uk region , created route custom domain myapp.ccbluemix.dynu.com there well. now whenever user hits route want load balancing between , uk region alternate requests served , uk regions. for created srv records like _http._tcp.ccbluemix.dynu.com srv eu-gb.mybluemix.net [priority: 0] [weight: 50] 10 _http._tcp.ccbluemix.dynu.com srv mybluemix.net [priority: 0] [weight: 50] 10 but nothing happening , i'm not able access application using custom route @ all. if create 'a' record cc-load-bal-app.ccbluemix.dynu.com 75.126.81.68 i can access app using custom route ends hitting server. how can achieve load balancing using srv records? wrong creating srv records here? i read ne...
Read more

oracle - pls-00402 alias required in select list of cursor to avoid duplicate column names -

-
my cursor : select xzis.msisdn msisdn, xzis.in_account_number in_account_number xxobw_zte_in_sync xzis not exists (select 1 hz_contact_points hcp, hz_cust_accounts hca hcp.owner_table_id = hca.party_id , hcp.owner_table_name = 'hz_parties' , hcp.phone_number = substr (xzis.msisdn, -8) , nvl (hca.attribute12, 'nil') = xzis.in_account_number); i have given alias columns, still facing issue. suggestions? it's cursor. 1 has no such problems. problem is, when you're joining 2 tables, or apply wrong aliases in subselect, cursor may @ end return 2 columns same name/alias. the problem not need alias, no 2 columns can have same alias (the name counting alias, when no alias given). apparently has happened, far can tell, it's ...
Read more

python - Apache Thrift Tutorial Error -

-
i've been trying learn use apache thrift in python following tutorial: http://www.billdimmick.com/devjournal/building-an-apache-thrift-service-in-python.html . thrift file used tutorial is: namespace py demo service mathservice { i64 add(1: i64 a, 2: i64 y) } when try compile python code thrift --gen py:new_style demo.thrift following error: [error:/home/pi/programming/python/thrift-tutorial/demo.thrift:4] (last token '{') syntax error [failure:/home/pi/programming/python/thrift-tutorial/demo.thrift:4] parser error during include pass i can't see wrong thrift file i'm still getting errors. what's wrong?
Read more