java暑期培訓(xùn)文件分頁

1、rockeyNamevarchar(20), -對應(yīng)表中的分頁字段（主鍵） columns varchar(100), -需要查詢的字段 conditions varchar(100),-查詢條件declare countdeclaresqlvarchar(100);setsql=selectcount(*)from+tableName; setsql=sql+wheredeclaredeclare sqlStr varchar(200); setm=pageSize*(pageNum-1);setsqlStr=selecttop(+convert(varchar,pageSize)+) +c

2、olumns+ from +tableName+ where +keyName+notin(selecttop(+convert(varchar,m)+) +keyName+ from +tableName;setsqlStr=sqlStr+where+conditions+)and+conditions; end else beginset/調(diào)用分/調(diào)用分過public Map listBooks(String condition,pageNum)Mapmap=newHashMap(); List books = new ArrayList();tryStringsql=callproc_s

3、plit(tb_book,book_id,*,?,?,?); conn = DBManager.getConn();cs=conn.prepareCall(sql); cs.set (2, pageSize);cs.set (3,pageNum); /直接獲取第一rs=count = rs.getmap.put(count,/取到第二個集rs=id=String name = rs.getString(book_name); String author = rs.getString(book_author); Stringpublish=rs.getString(book_publish);

4、Date date = rs.getDate(book_date);num = rs.getStringremark=map.put(books, catch(SQLExceptionDBManager.close(rs,cs,returnhref=BookListServlet?pn=1href=BookListServlet?pn=1【首頁】c:if上一頁c:forEachvar=xbegin=$1end=$pageCountc:whentest=$pageNumeq$pageNum 如果總頁面大于5c:if3&pageNum-3&$x 3&pageCount-$x c:ifc:if$x c:if$x c:if下一頁【尾頁】c:iftest=$pageNumc:iftest=$pageNum=首頁|上一頁首頁|上一頁|$pageNum/$pageCount|c:iftest=$pag