java - Mysql table not found -


here query along java code..

 public arraylist getproductinfo(int id){       try{         string query="select product_name,product_description product category_id = "+id;         statement = connect.createstatement();         result = statement.executequery(query);         system.out.println("successfull query info..");     }catch(exception e){         system.out.println("error in query..");         e.printstacktrace();     }      arraylist<string> columnname = null;     try{         columnname = new arraylist<string>();          for(int = 1 ; <= result.getmetadata().getcolumncount(); i++){                 columnname.add(result.getmetadata().getcolumnname(i));             }     }catch(exception e){         e.printstacktrace();     }     return columnname;  }

this function called one:

private void jbutton3actionperformed(java.awt.event.actionevent evt) {                                              // todo add handling code here:           jtable1.removeall();     jtable1.setmodel(new javax.swing.table.defaulttablemodel(      new object [][] { }, null ));      defaulttablemodel model = (defaulttablemodel) jtable1.getmodel();     mydatabasehandler db=new mydatabasehandler();     db.setconnection(null, null, null);     arraylist content=db.getproductinfo(1);     model.addcolumn("image");     model.addcolumn("description");     object[] rows=new object[2];     resultset result=db.getrset();      try{        while(result.next()){            string ss="";             int m=0;            for(object c : content){               m++;               if(m==1){                   //rows[0]=result.getblob(c.tostring());                   rows[0]=result.getstring(c.tostring());               }else if(m==2){                   ss+="name:"+result.getstring(c.tostring()+"\n");               }else if(m==3){                   ss+="description:"+result.getstring(c.tostring()+"\n");               }else if(m==4){                   ss+="price:"+result.getstring(c.tostring()+"\n");               }else if(m==5){                   ss+="quantity:"+result.getstring(c.tostring());               }           }            rows[1]=ss;             //system.out.println(ss);             model.addrow(rows);         }    }catch(exception e){         e.printstacktrace();     } }

this executes should in cmd whenever run java class gives me error:

java.sql.sqlexception:column'product_description' not found

note: query works in cmd fine , column product_description there , there no mistake in spelling.if give 1 column name after select string such select product_description executes normally...what doing wrong? in advance.

'product_description' column name - not table name. apparently either don't have such column or have mistake in name.


Comments

Post a Comment

Popular posts from this blog

javascript - Create a stacked percentage column -

i have collection of data : var data = [ {"p301a":"10","p301b":"7","p301c":"7","p301d":"3","p301e":"8","p301f":"8","p301g":"8","p301h":"8","p301i":"8","p301j":"8","p301k":"8","p301l":"8","p301m":"8","p301n":"8","p301o":"8","age":"31-40 years","profesion":"2","position":"2"}, {"p301a":"5","p301b":"4","p301c":"4","p301d":"4","p301e":"4","p301f":"4","p301g":"4","p301h":"4","p301i":"4","p301j":"4","p301k":"4...
Read more

Optimising Firebase database by automatically overwriting data -

in firebase app have following structure: posts latest all users can write posts > latest . want limit entries 20 posts save space in database. , posts beyond 20 unnecessary never shown on homepage. how can limit posts 20, when user writes posts > latest posts @ end drop off (be deleted) automatically? this sample should you. you need : const max_log_count = 20; exports.removeold = functions.database.ref('/posts/latest/{postid}').oncreate(event => { const parentref = event.data.ref.parent; return parentref.once('value').then(snapshot => { if (snapshot.numchildren() >= max_log_count) { let childcount = 0; const updates = {}; snapshot.foreach(function(child) { if (++childcount <= snapshot.numchildren() - max_log_count) { updates[child.key] = null; } }); // update parent. removes children. ...
Read more

javascript - Angular UI-Grid customTemplate directive causing rows to load slowly/? -

Image
each grid cell can have more 1 customtemplate loaded. have directive holds watcher on model_col_field listen cell updates on scroll when dom rows updated , recompile celltemplate . without watcher , $compile rows repeat on scroll, showing same set of rows. is there more angular way of approaching or way improve performance? relevant controller code: create gridoptions.data & gridoptions.columndefs : var customtemp = '<div ng-repeat="opt in grid.appscope.colvalueoptionsmodel" ng-init="tempstring=model_col_field.clazz+opt.key;"><comparison-directive dbo="model_col_field" attobj="opt" fff="grid.appscope.getattributetemplate(tempstring)" /></div>'; $scope.gridoptions.columndefs = [ { name:'yindex',pinnedleft:true,celltemplate: customtemp, displayname:'index'}, { name:'col1',celltemplate: customtemp}, { name:'col2',celltemplate: c...
Read more