Some people put forward the cursor is not good, will lock the row, luckily I locked is the temporary table, is not the data table, does not affect the data table's write operation.
Here is the 14 floor of the reply, let me enlightened, so with today's improved version, the use of a cursor cancellation, temporary table or exist, thank you.
In fact, you only have to split into two times query can:
1, or use Row_number to check the main Table page paging
In ASP.net, three powerful list controls are available: The GridView, DataList, and Repeater controls, but only the GridView control provides paging functionality. Although the DataGrid provides paging functionality, it appears to be limited in functionality, but we can take some of the GridView properties to get the status and add the home page, last feature button. If the speed efficiency is not very fast
Four paging modes of sqlserver and four paging modes of sqlserver
First: ROW_NUMBER () OVER () method
Select * from (Select *, ROW_NUMBER () OVER (Order by ArtistId) AS RowId from ArtistModels) As B
Where RowId between 10 and 20--- Where RowId BETWEEN current page number-1 * number of lines and number of pages * number of lines ---
The execution result is:
Method 2: offset fetch next (supported by SQL2012
Summary of four paging methods based on sqlserver and four paging methods of sqlserver
First: ROW_NUMBER () OVER () method
Select * from (Select *, ROW_NUMBER () OVER (Order by ArtistId) AS RowId from ArtistModels) As B
Where RowId between 10 and 20
--- Where RowId BETWEEN current page number-1 * number of lines and number of pages * number of lines ---
The execution result is:
Method 2: offset fetch next (
Simple jQuery paging control and jquery paging Control
Because it is an internal project and requires paging controls, I found a lot on the Internet and told the leaders that they couldn't do it. The reason is very simple and complicated. The leaders wanted a simple one, similar to Baidu's paging, but I have never writ
Jquery paging plug-in, jquery Paging
Jquery. mypagination. js file:
/***
* Jquery paging plug-in
* 1.0 zheng 2014-03-18
* 1.1 compatible URLs include # addresses. You can specify an anchor point for GoToPage (Special Requirements) 09:00:34
* 1.2 you can configure pagination entries to list the number of pages
* 1.3 Page code jump function added
* $ ('# Mypage')
Angularjs table paging function details, angularjs table Paging
Next, this article mainly introduces the table paging function. Because the project requires this case to be about the front-end paging method, it is rarely used now, but if necessary, you can refer to the ideas here.
Html:
1. Use UL to display the page ma
-- Oracle paging statements-- Id of each recordSelect t1. *, rownum rn from (select * from emp) t1;-- Retrieve the first 10 recordsSelect t1. *, rownum rn from (select * from emp) t1 where rownum -- Extract 6th to 10th records. This statement can be used as a paging template.Select * from(Select t1. *, rownum rn from (select * from emp) t1 where rownum Where rn> = 6;-- Start the
Jsp paging technology and jsp paging technology
In jsp development, paging technology is often used. In addition, pure paging takes up a lot of space, so it is necessary to use javabean.
Based on the actual code, this article shows how to use javabean in jsp to implement paging
PHP Generic paging class page. php [Imitation google paging] lt ;? Php/*** common php paging class. (Similar to Google style) ** you only need to provide two parameters: the total number of records and the number of entries displayed on each page. (Detailed instructions...) ** you do not need to specify a URL. the link is generated by the program. It is convenie
PHP Generic paging class page. php [like google paging]. The copy code of page. php is as follows :? Php *** common php paging class. (Similar to Google style) ** you only need to provide two parameters: the total number of records and the number of entries displayed on each page. (Detailed instructions are provided.) ** page. php is not required.
The code is a
Simple use of PHP thanks to a paging function module, PHP paging function module
Put a picture first to see the effect.
Just post the code.
Php$localhost= "localhost"; $username= "Root"; $password= "Root"; $db= "Test";//Information $pagesize= 5; $conn=mysql_connect($localhost,$username,$password);//Link Database if(!$conn){ Echo"Database link failed."Mysql_error(); }
PHP uses the array function to implement paging, Phparray function paging
The code is simple, so there's no more nonsense.
The copy Code code is as follows: $array =array ("1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20");//Specify the array to be paged $page = $_get[' page ']; $r = $this->page ($array, 5, $page); Print_r ($R); exit ();
MySQL paging Analysis Principle and efficiency improvement, mysql paging Efficiency Improvement
MySQL paging Analysis Principle and Efficiency Improvement
On percona performance conference 2009, several Yahoo engineers brought a "Efficient Pagination Using MySQL" report, which has many highlights. This article is a further extension based on the original article.
YII implements paging, and YII implements paging.
This article describes how to implement paging in yii by using the instance code for your reference. The specific code is as follows:
1. Some controller code:
public function actionTest() { $criteria=new CDbCriteria; $criteria->order='id DESC'; $count=User::model()->count($criteria); $pager=new CPagination($count)
Yii view operation-custom paging implementation method, yii view custom Paging
This article describes how to implement custom pages for Yii view operations. We will share this with you for your reference. The details are as follows:
1. The View File calls cgridview. The custom paging method is called during clistview.
2. Copy Base-class
This article introduces how to implement data paging display based on jquery + ajax + json and asynchronous paging Based on JAVA + JQuery. The code in this article is easy to understand and has reference value, if you are interested in learning together, let's show you how to run:
1. The background action generates json data.
List blackList = blackService. getBlackInfoList (mobileNum, gatewayid, startDate
Share the idea of implementing a paging control and the idea of a paging Control
Although the paging control is full, it is impossible to find the WinForm program, so it creates a wheel. At first, I thought this was a simple task. I started the project without thinking too much. In fact, I didn't spend much time writing the first version, and I wanted to implemen
Share a self-written jQuery paging plug-in, jquery Paging
I need a JS paging plug-in for my work. I want to write one by myself. When I access the Internet, I find a plug-in with an unclear code structure, which is difficult to solve, and the plug-in on the Internet contains too many functions, some cannot be used at all, so there is no need to load that section
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.