jsp实现连接数据库分页浏览 增删改查等功能.docVIP

一 利用jsp实现Oracle数据库中表格的分页浏览： 二 在Oracle数据库中建立表格，包含员工的工号、姓名、性别、工龄、工资等字段，并实现增删改查操作。 （1）所建的worker表格如下： （2）Input.jsp运行结果如下： Inputcheck.jsp运行结果如下： Pagebreak.jsp代码如下： %@page contentType=text/htmlpageEncoding=UTF-8 import=java.sql.*% html head meta http-equiv=Content-Type content=text/html;charset=UTF-8 titleJSP page/title /head body center 分页显示记录内容 hr table border=1 bgcolor=cccfff align=center tr th工号/th th姓名/th th性别/th th工龄/th th工资/th /tr %String oracledriver=oracle.jdbc.driver.OracleDriver; String oracleUrl=jdbc:oracle:thin:@localhost:1521:ORACLE; String username=scott; String password=tiger; Connection con; Class.forName(oracledriver); con=DriverManager.getConnection(oracleUrl,username,password); int intPageSize; int intRowCount; int intPageCount; int intPage; String strPage; int i; intPageSize = 10; strPage = request.getParameter(page); if(strPage==null){ intPage =1; }else{ intPage = java.lang.Integer.parseInt(strPage); if(intPage1) intPage = 1; } Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); String sql = select * from worker; ResultSet rs=stmt.executeQuery(sql); rs.last(); intRowCount = rs.getRow(); intPageCount = (intRowCount+intPageSize-1)/intPageSize; if(intPageintPageCount) intPage =intPageCount; if(intPageCount0){ rs.absolute((int1)*intPageSize+1); i = 0; while(iintPageSize !rs.isAfterLast()){% tr td%=rs.getString(id)%/td td%=rs.getString(name)%/td td%=rs.getString(sex)%/td td%=rs.getString(workyear)%/td td%=rs.getString(sal)%/td /tr % rs.next(); i++; } } % /table hr div align=center 第%=intPage%页 共%=intPageCount%页 % if(intPageintPageCount){ % a href=pagebreak.jsp?page=%=intPage+1%下一页/a % } if(intPage1){ % a href=pagebreak.jsp?page=%=int1%上一页/a % } rs.close(); stmt.close(); con.close(