1、 public List getBeanBook() return beanBook; public void setBeanBook(List beanBook) this.beanBook = beanBook;B、 给出改造后ReaderManager类的方法代码。List result1=new ArrayList(); String sql1=select a.barcode,a.bookname,a.pubid,a.price,a.state from beanbook a ,beanbooklendrecord b where b.readerid=+rs.getString(1
2、)+ and b.bookBarcode=a.barcode and b.returnDate is null; java.sql.PreparedStatement pst1=conn.prepareStatement(sql1); java.sql.ResultSet rs1=pst1.executeQuery(); while(rs1.next() BeanBook b=new BeanBook(); b.setBarcode(rs1.getString(1); b.setBookname(rs1.getString(2); b.setPubid(rs1.getString(3); b.
3、setPrice(rs1.getFloat(4); b.setState(rs1.getString(5); result1.add(b); r.setBeanBook(result1); result.add(r);在图书管理系统借几本书修改ui类的地方:1private Object tblTitle=读者证号,姓名类别借阅限额状态未归还图书信息;2tblData =new Objectreaders.size()6;3List t2 = readers.get(i).getBeanBook(); String imf= if(t2!=null) for(int j=0;j beanRea
4、der; 用set与get创建方法B. 给出改造后ReaderManager类的方法代码。public PageData searchReaderPage(String keyword,int readerTypeId,PageData page)throws BaseException /加一个page类 Connection conn=null; try conn=DBUtil.getConnection(); String sql=select count(*) from BeanReader r,BeanReaderType rt where r.readerTypeId=rt.rea
5、derTypeId + and removeDate is null / 这个sql是为了记录总记录数 java.sql.PreparedStatement pst=conn.prepareStatement(sql); java.sql.ResultSet rs=pst.executeQuery(); if(rs.next() page.setTotalRecordCount(rs.getInt(1); /赋值总记录数 page.setPageCount(page.getTotalRecordCount()/page.getPagesize(); /赋值总页面数 List0) sql1+=
6、and r.readerTypeId=+readerTypeId; if(keyword!=null & !.equals(keyword) and (readerid like ? or readerName like ?) sql1+= order by readerid java.sql.PreparedStatement pst1=conn.prepareStatement(sql1);.equals(keyword) pst1.setString(1, %+keyword+); pst1.setString(2, java.sql.ResultSet rs1=pst1.execute
7、Query(); while(rs1.next() BeanReader r=new BeanReader(); r.setReaderid(rs1.getString(1); r.setReaderName(rs1.getString(2); r.setReaderTypeId(rs1.getInt(3); r.setLendBookLimitted(rs1.getInt(4); r.setCreateDate(rs1.getDate(5); r.setCreatorUserId(rs1.getString(6); r.setStopDate(rs1.getDate(7); r.setSto
8、pUserId(rs1.getString(8); r.setReaderTypeName(rs1.getString(9); List result2=new ArrayList1) page.setPageRecordCount(page.getPageRecordCount()-1); this.reloadTable(); else if(e.getSource()=this.next) if(page.getPageRecordCount()page.getTotalRecordCount() page.setPageRecordCount(page.getPageRecordCount()+1);第一页:当按下下一页后:当按下上一页后:
copyright@ 2008-2023 冰点文库 网站版权所有
经营许可证编号:鄂ICP备19020893号-2