基于Ajax技术和JAVAEE的分页查询优化

摘要

本文一方面利用Ajax无刷新技术,无需刷新等待,另一方面利用Oracle 11g数据库服务器中PL/SQL编程创建存储过程实现了海量数据分页查询,把两种技术有机的结合在一起,只将需要显示的那一部分数据查询或计算出来并传输到WEB服务器端,在客户端采用Ajax异步通信技术无刷新的获取WEB服务器端的数据,缩短了用户等待的时间,同时提高了应用系统执行性能.%This paper uses Ajax without refreshing technology to eliminate the waiting time.At the same time,it uses the Oracle 11g database server in PL/SQL programming to create a stored procedure realization of data paging query.With these two technologies combined together,by querying or computing and transmitting the necessary part of the data to the WEB server,the client can use the asynchronous Ajax communication technology to obtain WEB server without refreshing the data,which shortens the waiting time of the users,and improves the application performance.