java - How to extract Object[] and get it into query using preparedstatement setObject()? -

-

this question has answer here:

might silly question cant query running. code:

arraylist<attraction> getattraction(object[] obj) throws sqlexception {      connection connection = facade.getconnection();      arraylist<attraction> attractions = new arraylist<>();      // check obj value     system.out.println(java.util.arrays.tostring(obj));      preparedstatement ps = connection.preparestatement("select distinct attra.attractid,attractname,x,y,z,age,weight,"             + "height,duration,price,status attraction attra "             + "inner join attrib_bridge ab on attra.attractid = ab.attractid "             + "inner join attribute attri on ab.attributeid = attri.attributeid"             + "where attri.attributename in ?");      ps.setstring(1, java.util.arrays.tostring(obj));      resultset rs = ps.executequery();       while(rs.next()){          // initialize attraction object         attraction attraction = new attraction();          attraction.setattractionid(rs.getint(1));         attraction.setattractionname(rs.getstring(2));         attraction.setxlocation(rs.getint(3));         attraction.setylocation(rs.getint(4));         attraction.setzlocation(rs.getint(5));         attraction.setminage(rs.getint(6));         attraction.setmaxweight(rs.getint(7));         attraction.setminheight(rs.getint(8));          attraction.setrideduration(rs.getint(9));         attraction.setpriceride(rs.getint(10));         attraction.setstatus(rs.getstring(11));          // add new object to movies         attractions.add(attraction);     }      return attractions; }

and error :

[gentle rides, thrill rides, transport rides] com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception: have error in >your sql syntax; check manual corresponds mysql server version >for right syntax use near 'attri.attributename in '[gentle rides, thrill >rides, transport rides]'' @ line 1

at sun.reflect.nativeconstructoraccessorimpl.newinstance0(native method) @ sun.reflect.nativeconstructoraccessorimpl.newinstance(unknown source) @ sun.reflect.delegatingconstructoraccessorimpl.newinstance(unknown source) @ java.lang.reflect.constructor.newinstance(unknown source) @ com.mysql.jdbc.util.handlenewinstance(util.java:411) @ com.mysql.jdbc.util.getinstance(util.java:386) @ com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:1052) @ com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3609) @ com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3541) @ com.mysql.jdbc.mysqlio.sendcommand(mysqlio.java:2002) @ com.mysql.jdbc.mysqlio.sqlquerydirect(mysqlio.java:2163) @ com.mysql.jdbc.connectionimpl.execsql(connectionimpl.java:2624) @ com.mysql.jdbc.preparedstatement.executeinternal(preparedstatement.java:2127) @ com.mysql.jdbc.preparedstatement.executequery(preparedstatement.java:2293) @ com.themeparkg02.rs.control.manager.manageattraction.getattraction(manageattraction.java:123) @ com.themeparkg02.rs.control.manager.facade.getattraction(facade.java:85) @ com.themeparkg02.rs.control.listener.viewattractionlistlistener.run(viewattractionlistlistener.java:32)

i'm dizzy right now. values out query not working. '[' , ']' blocking goal. input guys?

thanks in advance.

note: missed issue of in clause, answer technically correct, first error in sql missing space. link provided miljen mikic explains how fix in clause issue.

your error says:

mysqlsyntaxerrorexception: have error in >your sql syntax

you missing space before where.

updated

for improved readability, prefer writing this:

string sql = "select distinct attra.attractid, attractname, x, y, z, age" +                            ", weight, height, duration, price, status" +               " attraction attra" +               " join attrib_bridge ab on attra.attractid = ab.attractid" +               " join attribute attri on ab.attributeid = attri.attributeid" +              " attri.attributename in ?"; try (preparedstatement ps = connection.preparestatement(sql)) {     ps.setstring(1, arrays.tostring(obj));     try (resultset rs = ps.executequery()) {         while (rs.next()) {             // process row here         }     } }

Comments

Post a Comment

Popular posts from this blog

html - Firefox flex bug applied to buttons? -

-
i'm trying apply flex button on firefox i'm having problem on chrome doesn't happens. this css: .button { display: inline-flex; align-items: center; } as can see in fiddle, "caret" word moved new line, happens if element <button> tag, <div> works expected. http://codepen.io/anon/pen/xblmgx is firefox bug or there css i'm missing? nevermind, looks "mr firefox" doesn't idea... <button> not implementable (by browsers) in pure css, bit of black box, perspective of css. means don't react in same way e.g. <div> would. this isn't specific flexbox -- e.g. don't render scrollbars if put "overflow:scroll" on button, , don't render table if put "display:table" on it. stepping further, isn't specific <button> . consider <fieldset> , <table> have special rendering behavior: data:text/html,<fieldset style="d...
Read more

html - Missing border-right in select on Firefox -

-
Image
when put select div width , padding-left, options have no border on right. more, happend if select have width 118px , parent have 15px of padding left! have idea, going on? my code: <!doctype html> <html> <head lang="en"> </head> <body> <div style="width: 1000px; padding-left: 15px;"> <select style="width: 118px;"> <option>a</option> <option>b</option> <option>c</option> </select> </div> </body> </html> and result: here plunker: click it happend on firefox on windows. tested on 40.0.2 version -webkit-box-sizing: border-box; -moz-box-sizing: border-box; -ms-box-sizing: border-box; box-sizing: border-box; source: https://stackoverflow.com/a/11390432/4431269 source of problem: https://bugzilla.mozilla.org/show_bug.cgi?id=924068 and use of google ! edit: (source of problem, explained) after rea...
Read more

python - build a suggestions list using fuzzywuzzy -

-
i building suggestion engine database. i'm using fuzzywuzzy module match user input string existing database shown below. if request.method == "get": display_dict = {} user_input = request.get["user_input"] # user input match_dict = {} food_items_obj = food_items.objects.all() # fetch objects table items in food_items_obj : match = fuzz.ratio(user_input.lower(),items.name.lower()) # try match user input existing names match_dict[match] = items.name # put 1 dictionary matched_dict = ordereddict(sorted(match_dict.items(),reverse = true)) # sort dictionary if max(matched_dict.keys()) == 100: # if exact match put in dict , return display_dict[100] = matched_dict[100] else : # if not found try best matching words.. ###########this part need help! ############# k,v in matched_dict.items(): if user_input in v : display_dict[k]...
Read more