java - Oracle ERROR invalid number -


i have table this:

arithmos kod date         b c 1        ΑΓΟ 01/08/2016   5 2 3 2        ΠΛΗ 02/08/2016   3 2 1 

and netbeans program want insert name table , date , kod , rows meet criteria.

code:

string pote=ac3.gettext();//name table  string c=((jtextfield)jdt1.getdateeditor().getuicomponent()).gettext();//date       string d=((jtextfield)jdt2.getdateeditor().getuicomponent()).gettext();//date string s0=(string)jcb1.getselecteditem();//kod  string sql="select * "+pote+" (hmerominia between "+c+" , "+d+") , kod='"+s0+"' order arithmos";  

if (re == joptionpane.yes_option) { try{

    stm=(oraclestatement) conn.createstatement(rs.type_scroll_insensitive,rs.concur_updatable);       rs = (oracleresultset) stm.executequery(sql);     updatejtable();   /* while(rs.next()){         v0.settext(rs.getstring("arithmos"));      }*/  } catch(exception e1){     joptionpane.showmessagedialog(null, e1); }      }else if (re == joptionpane.no_option) {         this.setvisible(true);     } 

error showing invalid number.

fixed:

public static resultset consult(string consult){        connection conn = connectdb();//connection database         statement declare;         try{             declare=conn.createstatement();             resultset rs=declare.executequery(consult);             return rs;         }catch(exception e){             joptionpane.showmessagedialog(null, e);          }        return null;      }   }  code in button:    string  pote=ac3.gettext();//chosen table name     string c=((jtextfield)jdt1.getdateeditor().getuicomponent()).gettext();//date varchar2 set database table     string d=((jtextfield)jdt2.getdateeditor().getuicomponent()).gettext();//date varchar2 set database table     string s0=(string)jcb1.getselecteditem();//chosen item        string sql="select * "+pote+"   hmerominia between '"+c+"' , '"+d+"' , kod='"+s0+"'";       int re = joptionpane.showconfirmdialog(this, "search?", "confirm",         joptionpane.yes_no_option, joptionpane.question_message);       if (re == joptionpane.yes_option) {         defaulttablemodel md=( defaulttablemodel)pel300.getmodel();  md.setrowcount(0);  rs=(oracleresultset) connect.consult(sql);//connect class   try{      while(rs.next()){      vector v=new vector();      v.add(rs.getstring(1));      v.add(rs.getstring(2));      v.add(rs.getstring(3));      v.add(rs.getstring(4));      v.add(rs.getstring(5));      v.add(rs.getstring(6));      v.add(rs.getstring(7));      v.add(rs.getstring(8));        md.addrow(v);      pel300.setmodel(md);        pel300.setshowgrid(true);        }  }catch(exception e){      joptionpane.showmessagedialog(null, e);  }      }else if (re == joptionpane.no_option) {         this.setvisible(true);     } 

Comments