| 发表于:2007-08-20 13:13:295楼 得分:0 |
public void selectname(string n)throws classnotfoundexception{ try{ sql= "select assetid,asset_name,model,price,purchase_date,status from asset where asset_name= ' "+n+ " ' "; dc=new dbconn(); con=dc.getcon(); st=con.createstatement(); resultset rs=st.EXECutequery(sql); list=new arraylist <tcardmodel> (); while(rs.next()){ tcm=new tcardmodel(rs.getint(1),rs.getstring(2),rs.getstring(3),rs.getdouble(4),rs.getstring(5),rs.getstring(6)); list.add(tcm); j++; } if(j==0){ joptionpane.showmessagedialog(null, "相关数据不存在 ", "error! ",joptionpane.information_message); } else{ iter=list.listiterator(); tcm=(tcardmodel)iter.next(); //tcm=list.get(2); tcard.label2.settext(tcm.getassetid()); tcard.label4.settext(tcm.getasset_name()); tcard.label6.settext(tcm.getmodel()); tcard.label8.settext(tcm.getprice()); tcard.label10.settext(tcm.getpurchase_date()); tcard.label12.settext(tcm.getstatus()); if(iter.hasnext()) { system.out.println( "有多条记录 "); //tcard.nextbtn.setenabled(true); //tcard.proviousbtn.setenabled(true); } } } catch(sqlexception sqle){ system.err.println(sqle); } } public void next(){ if(iter.hasnext()) { tcm=(tcardmodel)iter.next(); tcard.label2.settext(tcm.getassetid()); tcard.label4.settext(tcm.getasset_name()); tcard.label6.settext(tcm.getmodel()); tcard.label8.settext(tcm.getprice()); tcard.label10.settext(tcm.getpurchase_date()); tcard.label12.settext(tcm.getstatus()); }else{system.out.println( "最后纪录 ");} } public void provious(){ if(iter.hasprevious()){ tcm=(tcardmodel)iter.previous(); tcard.label2.settext(tcm.getassetid()); tcard.label4.settext(tcm.getasset_name()); tcard.label6.settext(tcm.getmodel()); tcard.label8.settext(tcm.getprice()); tcard.label10.settext(tcm.getpurchase_date()); tcard.label12.settext(tcm.getstatus()); } } 都丢上来了 谁能帮我看看 我这个provious方法错在哪儿 | | |
|