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
Post a Comment