jQuery+Ajax implements table data title sorting-JS Tutorial-php.cn

Home

Web Front-end

JS Tutorial

jQuery+Ajax implements table data title sorting

php中世界最好的语言

Apr 26, 2018 am 09:26 AM

datatitle

这次给大家带来jQuery+Ajax实现表格数据标题排序，jQuery+Ajax实现表格数据标题排序的注意事项有哪些，下面就是实战案例，一起来看一下。

表格大家都十分熟悉，如今的CSS也使得表格的布局越来越光彩耀人。但是，无论如何，都掩饰不了那些包装下的死板。

那么如何让那些死板的数据更具有可读性、可用性，能够让我们那些数据在“动”呢？
下面我们使用jquery+ajax 来为表格注入些活力。主要实现的目的就是：将表格的列标题转化为按钮，点击不同的列标题，便按相应的列对数据进行排序。比如学生信息表，我点击“生日”列，这张表便按生日排序将结果呈现在我们面前。使用ajax来调用本页也避免了刷新页面所带来的折磨。
下面我给出最基本的jsp页面
jQuery+Ajax implements table data title sorting

<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%> 
<% 
String path = request.getContextPath(); 
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; 
%> 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> 
<html> 
<head> 
<base href="<%=basePath%>"> 
<title>My JSP &#39;sorttable.jsp&#39; starting page</title> 
<meta http-equiv="pragma" content="no-cache"> 
<meta http-equiv="cache-control" content="no-cache"> 
<meta http-equiv="expires" content="0"> 
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> 
<meta http-equiv="description" content="This is my page"> 
<!-- <link rel="stylesheet" type="text/css" href="styles.css"> 
--> 
<script type="text/javascript" src="js/jquery-1.4.4.js"></script> 
</head> 
<body> 
<table class = "sorttable" style="background-color: gray;color: white;"> 
<thead> 
<tr > 
<th></th> 
<th class="sort-alpha">Title</th> 
<th>Author</th> 
<th>PublishDate</th> 
<th>Price</th> 
</tr> 
</thead> 
<tbody> 
<tr> 
<td><img  src="/static/imghwm/default1.png"  data-src="<%=path % alt="jQuery+Ajax implements table data title sorting" >/images/javascript.jpg"  class="lazy"   width="40"    style="max-width:90%" alt="JavaScript" /></td> 
<td>JavaScript</td> 
<td> Douglas Crockford </td> 
<td> May 2008</td> 
<td>$31.02</td> 
</tr> 
<tr> 
<td><img  src="/static/imghwm/default1.png"  data-src="<%=path % alt="jQuery+Ajax implements table data title sorting" >/images/Ajax.jpg"  class="lazy"   width="40"    style="max-width:90%" alt="AJAX and PHP:Building Responsive Web Applications" /></td> 
<td>AJAX and PHP:Building Responsive Web Applications</td> 
<td>Cristian Darie,Mihak Bucica</td> 
<td> Mar 2006</td> 
<td>$31.02</td> 
</tr> 
<tr> 
<td><img  src="/static/imghwm/default1.png"  data-src="<%=path % alt="jQuery+Ajax implements table data title sorting" >/images/Learning.jpg"  class="lazy"   width="40"    style="max-width:90%" alt="Learning Mambo" /></td> 
<td>Learning Mambo</td> 
<td>Douglas Paterson</td> 
<td> Mar 2006</td> 
<td>$31.02</td> 
</tr> 
<tr> 
<td><img  src="/static/imghwm/default1.png"  data-src="<%=path % alt="jQuery+Ajax implements table data title sorting" >/images/Think.jpg"  class="lazy"   width="40"    style="max-width:90%" alt="Thinking in java" /></td> 
<td>Thinking in java</td> 
<td>Bruce Eckel </td> 
<td> Feb 2006</td> 
<td>$33.02</td> 
</tr> 
<tr> 
<td><img  src="/static/imghwm/default1.png"  data-src="<%=path % alt="jQuery+Ajax implements table data title sorting" >/images/jQuery.jpg"  class="lazy"   width="40"    style="max-width:90%" alt="jQuery in Action, Second Edition" /></td> 
<td>jQuery in Action, Second Edition</td> 
<td>Bear Bibeault / Yehuda Katz 
</td> 
<td> Apr 2010</td> 
<td>$35.02</td> 
</tr> 
</tbody> 
</table> 
</body> 
</html>

第一步：为表格添加奇偶行交替背景
jQuery+Ajax implements table data title sorting

<style type="text/css"> 
.even{ 
background-color: #E8A824; 
} 
.odd{ 
background-color:#74411B; 
} 
</style>

第二步：按字母排序
实现基于表格的Title列进行排序

<thclass="sort-alpha">Title</th>

为Title定义了一个sort-alpha类

<script type="text/javascript" language="javascript"> 
$(
document
).ready(function(){ 
var alternateRowColors = function($table){ 
$(&#39;tbody tr:odd&#39;,$table).removeClass(&#39;even&#39;).addClass(&#39;odd&#39;); 
$(&#39;tbody tr:even&#39;,$table).removeClass(&#39;odd&#39;).addClass(&#39;even&#39;) 
}; 
$(&#39;table.sorttable&#39;).each(function (){ 
var $table =$(this); 
alternateRowColors($table); 
$(&#39;th&#39;,$table).each(function(column){ 
var $header = $(this); 
if($header.is(&#39;.sort-alpha&#39;)){ 
$header.addClass(&#39;clickable&#39;).hover(function(){ 
$header.addClass(&#39;hover&#39;); 
},function(){ 
$header.removeClass(&#39;hover&#39;); 
}).click(function(){ 
var rows = $table.find(&#39;tbody>tr&#39;).get(); 
rows.sort(function(a,b){ 
var keyA =$(a).children(&#39;td&#39;).eq(column).text().toUpperCase(); 
var keyB =$(b).children(&#39;td&#39;).eq(column).text().toUpperCase(); 
if(keyA<keyB) return -1; 
if(keyA>keyB) return 1; 
return 0; 
}); 
$.each(rows,function(index,row){ 
$table.children(&#39;tbody&#39;).append(row); 
}); 
alternateRowColors($table); 
}); 
} 
}); 
}); 
}); 
</script>

最后
当你点击Title时
最终效果：
jQuery+Ajax implements table data title sorting

相信看了本文案例你已经掌握了方法，更多精彩请关注php中文网其它相关文章！

推荐阅读：

jquery实现表格排序+实时搜索功能

sortElements实现table排序步骤详解

jquery动态操作表格行的方法（附代码）

The above is the detailed content of jQuery+Ajax implements table data title sorting. For more information, please follow other related articles on the PHP Chinese website!

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Understanding the JavaScript Engine: Implementation DetailsApr 17, 2025 am 12:05 AM

Understanding how JavaScript engine works internally is important to developers because it helps write more efficient code and understand performance bottlenecks and optimization strategies. 1) The engine's workflow includes three stages: parsing, compiling and execution; 2) During the execution process, the engine will perform dynamic optimization, such as inline cache and hidden classes; 3) Best practices include avoiding global variables, optimizing loops, using const and lets, and avoiding excessive use of closures.

Python vs. JavaScript: The Learning Curve and Ease of UseApr 16, 2025 am 12:12 AM

Python is more suitable for beginners, with a smooth learning curve and concise syntax; JavaScript is suitable for front-end development, with a steep learning curve and flexible syntax. 1. Python syntax is intuitive and suitable for data science and back-end development. 2. JavaScript is flexible and widely used in front-end and server-side programming.

Python vs. JavaScript: Community, Libraries, and ResourcesApr 15, 2025 am 12:16 AM

Python and JavaScript have their own advantages and disadvantages in terms of community, libraries and resources. 1) The Python community is friendly and suitable for beginners, but the front-end development resources are not as rich as JavaScript. 2) Python is powerful in data science and machine learning libraries, while JavaScript is better in front-end development libraries and frameworks. 3) Both have rich learning resources, but Python is suitable for starting with official documents, while JavaScript is better with MDNWebDocs. The choice should be based on project needs and personal interests.

From C/C to JavaScript: How It All WorksApr 14, 2025 am 12:05 AM

The shift from C/C to JavaScript requires adapting to dynamic typing, garbage collection and asynchronous programming. 1) C/C is a statically typed language that requires manual memory management, while JavaScript is dynamically typed and garbage collection is automatically processed. 2) C/C needs to be compiled into machine code, while JavaScript is an interpreted language. 3) JavaScript introduces concepts such as closures, prototype chains and Promise, which enhances flexibility and asynchronous programming capabilities.

JavaScript Engines: Comparing ImplementationsApr 13, 2025 am 12:05 AM

Different JavaScript engines have different effects when parsing and executing JavaScript code, because the implementation principles and optimization strategies of each engine differ. 1. Lexical analysis: convert source code into lexical unit. 2. Grammar analysis: Generate an abstract syntax tree. 3. Optimization and compilation: Generate machine code through the JIT compiler. 4. Execute: Run the machine code. V8 engine optimizes through instant compilation and hidden class, SpiderMonkey uses a type inference system, resulting in different performance performance on the same code.

Beyond the Browser: JavaScript in the Real WorldApr 12, 2025 am 12:06 AM

JavaScript's applications in the real world include server-side programming, mobile application development and Internet of Things control: 1. Server-side programming is realized through Node.js, suitable for high concurrent request processing. 2. Mobile application development is carried out through ReactNative and supports cross-platform deployment. 3. Used for IoT device control through Johnny-Five library, suitable for hardware interaction.

Building a Multi-Tenant SaaS Application with Next.js (Backend Integration)Apr 11, 2025 am 08:23 AM

I built a functional multi-tenant SaaS application (an EdTech app) with your everyday tech tool and you can do the same. First, what’s a multi-tenant SaaS application? Multi-tenant SaaS applications let you serve multiple customers from a sing

How to Build a Multi-Tenant SaaS Application with Next.js (Frontend Integration)Apr 11, 2025 am 08:22 AM

This article demonstrates frontend integration with a backend secured by Permit, building a functional EdTech SaaS application using Next.js. The frontend fetches user permissions to control UI visibility and ensures API requests adhere to role-base

See all articles