分页显示记录内容

<%        

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(intPage<1) 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(intPage>intPageCount)

                    intPage =intPageCount;

         if(intPageCount>0){

                    rs.absolute((intPage-1)*intPageSize+1);

                    i = 0;

         while(i

     <%

            rs.next();

            i++;

            }

        }

     %>

        第<%=intPage%>页 共<%=intPageCount%>页

     <%

         if(intPage     %>

     下一页

     <%

          }

         if(intPage>1){

     %>

     上一页

     <%

        }

rs.close();

            stmt.close();

            con.close();

     %>

已添加员工信息

     <%

            String empID = request.getParameter("empID");

            byte []b=empID.getBytes("ISO-8859-1");

            empID = new String(b,"UTF-8");

            String empName = request.getParameter("empName");

            byte []b1=empName.getBytes("ISO-8859-1");

            empName = new String(b1,"UTF-8");

            String empSex = request.getParameter("empSex");

            byte []b2=empSex.getBytes("ISO-8859-1");

            empSex = new String(b2,"UTF-8");

            String  empWorkyear= request.getParameter("empWorkyear");

            byte []b3=empWorkyear.getBytes("ISO-8859-1");

            empWorkyear = new String(b3,"UTF-8");

            String empSal = request.getParameter("empSal");

            byte []b4=empSal.getBytes("ISO-8859-1");

            empSal = new String(b4,"UTF-8");

            String oracledriver="oracle.jdbc.driver.OracleDriver";

            String oracleUrl="jdbc:oracle:thin:@localhost:1521:ORACLE";

            String username="scott";

            String password="tiger";

            Class.forName(oracledriver);

            Connection con=DriverManager.getConnection(oracleUrl,username,password);

            Statement stmt=con.createStatement();

            String sql="insert into worker values('" +empID +"','"+empName+"','"+empSex+"',"+empWorkyear+                                        

            stmt.executeUpdate(sql);

            stmt.close();

            con.close();

     %>

已删除员工信息

     <%

            String oracledriver1="oracle.jdbc.driver.OracleDriver";

            String oracleUrl1="jdbc:oracle:thin:@localhost:1521:ORACLE";

            String username1="scott";

            String password1="tiger";

            Class.forName(oracledriver1);

            Connection con1=DriverManager.getConnection(oracleUrl1,username1,password1);

            Statement stmt1=con1.createStatement();

            String sql1="delete from worker where empName='韩信'";

            stmt1.executeUpdate(sql1);

            stmt1.close();

            con1.close();

     %>

已更改员工信息

     <%

            String oracledriver2="oracle.jdbc.driver.OracleDriver";

            String oracleUrl2="jdbc:oracle:thin:@localhost:1521:ORACLE";

            String username2="scott";

            String password2="tiger";

            Class.forName(oracledriver2);

            Connection con2=DriverManager.getConnection(oracleUrl2,username2,password2);

            Statement stmt2=con2.createStatement();

            String sql2="update worker set empName='李莉莉' where empName='Kababa'";

            stmt2.executeUpdate(sql2);

            stmt2.close();

            con2.close();

     %>

经过以上操作后，Worker表如下：

     <%

            String oracledriver3="oracle.jdbc.driver.OracleDriver";

            String oracleUrl3="jdbc:oracle:thin:@localhost:1521:ORACLE";

            String username3="scott";

            String password3="tiger";

            Class.forName(oracledriver3);

            Connection con3=DriverManager.getConnection(oracleUrl3,username3,password3);

            Statement stmt3=con3.createStatement();

            String sql3="Select * from worker";

            ResultSet rs=stmt3.executeQuery(sql3);

            while(rs.next()){

     %>

         <%

        }    rs.close();

            stmt3.close();

            con3.close();

         %>