Recently, the project was completed and a code sharing was conducted. One of the students shared some of their experiences in solving the problem. Sort it out and share it with you.We recommend that you use your own android OS and virtual machine to
First refer to these three filesHtmlBody> Div> Divclass= "title"> H1>Workload StatisticsH1> Div> Tablewidth= "50%"Border= "1"class= "T1"> thead> th>Tomb Type Codeth> th>Tomb
Copy CodeThe code is as follows:
SET ANSI_NULLS on
Go
SET QUOTED_IDENTIFIER ON
Go
CREATE PROCEDURE [dbo]. [Pagination]
@Page int = 1,--current page number
@PageSize int = 10--Number of record bars per page (page size)
@Table nvarchar (500)--table
Data | database | Network 1 database is Access Webuser.mdb table name: Talks
Automatic ID Increase
FromName: His name is rows
ToName each other's name characters
Word Paging Content Notes
Isread whether or not to spend the type
Adddate Paging Time
Copy codeThe Code is as follows:SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCreate procedure [dbo]. [Pagination]@ Page int = 1, -- current Page number@ PageSize int = 10, -- number of records per page (page size)@ Table nvarchar (500), -- Table
Recently, we have a project requirement to achieve horizontal slide view switching (display by PAGE)
The first thing that comes to mind is imageswitcher + viewfilpper. I don't want to use this effect, let alone the customer's feeling: The sliding
Copy Code code as follows:
SET ANSI_NULLS on
Go
SET QUOTED_IDENTIFIER ON
Go
CREATE PROCEDURE [dbo]. [Pagination]
@Page int = 1,--current page number
@PageSize int = 10--Number of record bars per page (page size)
@Table nvarchar
The basic logical idea is the same as. NET, which is to configure through the entity class to be configured through an array, logic is relatively simple, based on the criteria to determine the stitching of the paging HTML.
Here are a few simple features:
1: Support the display of related buttons or not configuration
2: Support per page number, text name, HTML tag class name free configuration
3: Support URL rewrite pages (you need to add rewrite rules in the configuration array yourself)
s
The basic logical thinking and. NET, is to be configured through the entity classes replaced by the array configuration, the logic is relatively simple, based on the conditions to determine the Mosaic page HTML.
Here are a few simple features:
1: Support the display of related buttons or not configuration
2: Support the number of pages per page, text name, HTML tag class name free configuration
3: URL-rewritten pages are supported (you need to add rewrite rules to the configuration array you
We'll take the SQL stored procedure first.
Paging stored procedures.
The code is as follows
Copy Code
CREATE PROCEDURE [dbo]. [Proc_splitpage] --Add The parameters for the stored procedure here @tblName VA Rchar (255),--table name @strFields varchar (1000) = ' * ',--columns that need to be returned, Default * @strOrder varchar (255) = ',--sorted field name, required @strOrderType varchar = ' ASC ',--Sort by default ASC @PageSize int = 10, -page size,
Pear's pager pagination class is a very useful PHP paging class, scalability is very strong, able to adapt to the needs of various paging situation, at least I in a few years large and small projects, basically not for paging extra code, all are used pager, It shows the pager of the availability of the strong. Here's how to use the code to see the example:
Examp
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.