练习题解：一个可排序的html表格（Javascript/Jquery)

于 2018-06-29 21:11:13 发布
阅读量372 收藏
点赞数 1
CC 4.0 BY-SA版权
文章标签： Javascript 二维数组 排序 Jquery
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/qq_27069811/article/details/80861891
本文介绍了一种使用HTML、JavaScript和jQuery实现的表格字段排序方法。通过读取表格数据并将其存储到二维数组中，然后根据指定的列进行排序，并将排序后的结果显示在原表格中。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

最近在学Javascript/Jquery， 老师布置了一个作业，对html的表格字段进行排序，涉及的知识点：

DOM的数据读取；二维数组排序；DOM的设置更新; 按钮事件响应

练习解题如下：

<html>

<head>
<meta http-equiv="Content-Type" 
content="text/html; charset=UTF-8">
<link href="../css/employees.css" rel="stylesheet" type="text/css" /><title id="title">employees</title>
</head>
<body style="font-size:32px">
<table border="1" align="center" >
<caption>Employees</caption>
<tr>
<td><b>EMPLOYEE_ID</b></td>
<td><b>FIRST_NAME<input id="btn1"  id="1"  type="button" value="order" /></b></td>
<td><b>LAST_NAME</b></td>
<td><b>EMAIL</b></td>
<td><b>PHONE_NUMBER</b></td>
<td><b>HIRE_DATE</b></td>
<td><b>JOB_ID</b></td>
<td><b>SALARY<input id="btn7"  id="7"  type="button" value="order" /></b></td>
<td><b>COMMISSION_PCT</b></td>
<td id="9"><b>MANAGER_ID</b></td>
<td id="10"><b>DEPARTMENT_ID</b></td>
</tr>
<tr>
<td >100</td>
<td >Steven</td>
<td >King</td>
<td >SKING</td>
<td >515.123.4567</td>
<td >2003-00-17</td>
<td >AD_PRES</td>
<td >24000</td>
<td > </td>
<td > </td>
<td >90</td>
</tr>
<tr>
<td >101</td>
<td >Neena</td>
<td >Kochhar</td>
<td >NKOCHHAR</td>
<td >515.123.4568</td>
<td >2005-00-21</td>
<td >AD_VP</td>
<td >17000</td>
<td > </td>
<td >100</td>
<td >90</td>
</tr>
<tr>
<td >102</td>
<td >Lex</td>
<td >De Haan</td>
<td >LDEHAAN</td>
<td >515.123.4569</td>
<td >2001-00-13</td>
<td >AD_VP</td>
<td >17000</td>
<td > </td>
<td >100</td>
<td >90</td>
</tr>
<tr>
<td >103</td>
<td >Alexander</td>
<td >Hunold</td>
<td >AHUNOLD</td>
<td >590.423.4567</td>
<td >2006-00-03</td>
<td >IT_PROG</td>
<td >9000</td>
<td > </td>
<td >102</td>
<td >60</td>
</tr>
<tr>
<td >104</td>
<td >Bruce</td>
<td >Ernst</td>
<td >BERNST</td>
<td >590.423.4568</td>
<td >2007-00-21</td>
<td >IT_PROG</td>
<td >6000</td>
<td > </td>
<td >103</td>
<td >60</td>
</tr>
<tr>
<td >105</td>
<td >David</td>
<td >Austin</td>
<td >DAUSTIN</td>
<td >590.423.4569</td>
<td >2005-00-25</td>
<td >IT_PROG</td>
<td >4800</td>
<td > </td>
<td >103</td>
<td >60</td>
</tr>
<tr>
<td >106</td>
<td >Valli</td>
<td >Pataballa</td>
<td >VPATABAL</td>
<td >590.423.4560</td>
<td >2006-00-05</td>
<td >IT_PROG</td>
<td >4800</td>
<td > </td>
<td >103</td>
<td >60</td>
</tr>
<tr>
<td >107</td>
<td >Diana</td>
<td >Lorentz</td>
<td >DLORENTZ</td>
<td >590.423.5567</td>
<td >2007-00-07</td>
<td >IT_PROG</td>
<td >4200</td>
<td > </td>
<td >103</td>
<td >60</td>
</tr>
<tr>
<td >108</td>
<td >Nancy</td>
<td >Greenberg</td>
<td >NGREENBE</td>
<td >515.124.4569</td>
<td >2002-00-17</td>
<td >FI_MGR</td>
<td >12008</td>
<td > </td>
<td >101</td>
<td >100</td>
</tr>
<tr>
<td >109</td>
<td >Daniel</td>
<td >Faviet</td>
<td >DFAVIET</td>
<td >515.124.4169</td>
<td >2002-00-16</td>
<td >FI_ACCOUNT</td>
<td >9000</td>
<td > </td>
<td >108</td>
<td >100</td>
</tr>
<tr>
<td >110</td>
<td >John</td>
<td >Chen</td>
<td >JCHEN</td>
<td >515.124.4269</td>
<td >2005-00-28</td>
<td >FI_ACCOUNT</td>
<td >8200</td>
<td > </td>
<td >108</td>
<td >100</td>
</tr>
<tr>
<td >111</td>
<td >Ismael</td>
<td >Sciarra</td>
<td >ISCIARRA</td>
<td >515.124.4369</td>
<td >2005-00-30</td>
<td >FI_ACCOUNT</td>
<td >7700</td>
<td > </td>
<td >108</td>
<td >100</td>
</tr>
<tr>
<td >112</td>
<td >Jose Manuel</td>
<td >Urman</td>
<td >JMURMAN</td>
<td >515.124.4469</td>
<td >2006-00-07</td>
<td >FI_ACCOUNT</td>
<td >7800</td>
<td > </td>
<td >108</td>
<td >100</td>
</tr>
<tr>
<td >113</td>
<td >Luis</td>
<td >Popp</td>
<td >LPOPP</td>
<td >515.124.4567</td>
<td >2007-00-07</td>
<td >FI_ACCOUNT</td>
<td >6900</td>
<td > </td>
<td >108</td>
<td >100</td>
</tr>
<tr>
<td >114</td>
<td >Den</td>
<td >Raphaely</td>
<td >DRAPHEAL</td>
<td >515.127.4561</td>
<td >2002-00-07</td>
<td >PU_MAN</td>
<td >11000</td>
<td > </td>
<td >100</td>
<td >30</td>
</tr>
<tr>
<td >115</td>
<td >Alexander</td>
<td >Khoo</td>
<td >AKHOO</td>
<td >515.127.4562</td>
<td >2003-00-18</td>
<td >PU_CLERK</td>
<td >3100</td>
<td > </td>
<td >114</td>
<td >30</td>
</tr>
<tr>
<td >116</td>
<td >Shelli</td>
<td >Baida</td>
<td >SBAIDA</td>
<td >515.127.4563</td>
<td >2005-00-24</td>
<td >PU_CLERK</td>
<td >2900</td>
<td > </td>
<td >114</td>
<td >30</td>
</tr>
<tr>
<td >117</td>
<td >Sigal</td>
<td >Tobias</td>
<td >STOBIAS</td>
<td >515.127.4564</td>
<td >2005-00-24</td>
<td >PU_CLERK</td>
<td >2800</td>
<td > </td>
<td >114</td>
<td >30</td>
</tr>
<tr>
<td >118</td>
<td >Guy</td>
<td >Himuro</td>
<td >GHIMURO</td>
<td >515.127.4565</td>
<td >2006-00-15</td>
<td >PU_CLERK</td>
<td >2600</td>
<td > </td>
<td >114</td>
<td >30</td>
</tr>
<tr>
<td >119</td>
<td >Karen</td>
<td >Colmenares</td>
<td >KCOLMENA</td>
<td >515.127.4566</td>
<td >2007-00-10</td>
<td >PU_CLERK</td>
<td >2500</td>
<td > </td>
<td >114</td>
<td >30</td>
</tr>
<tr>
<td >120</td>
<td >Matthew</td>
<td >Weiss</td>
<td >MWEISS</td>
<td >650.123.1234</td>
<td >2004-00-18</td>
<td >ST_MAN</td>
<td >8000</td>
<td > </td>
<td >100</td>
<td >50</td>
</tr>
<tr>
<td >121</td>
<td >Adam</td>
<td >Fripp</td>
<td >AFRIPP</td>
<td >650.123.2234</td>
<td >2005-00-10</td>
<td >ST_MAN</td>
<td >8200</td>
<td > </td>
<td >100</td>
<td >50</td>
</tr>
<tr>
<td >122</td>
<td >Payam</td>
<td >Kaufling</td>
<td >PKAUFLIN</td>
<td >650.123.3234</td>
<td >2003-00-01</td>
<td >ST_MAN</td>
<td >7900</td>
<td > </td>
<td >100</td>
<td >50</td>
</tr>
<tr>
<td >123</td>
<td >Shanta</td>
<td >Vollman</td>
<td >SVOLLMAN</td>
<td >650.123.4234</td>
<td >2005-00-10</td>
<td >ST_MAN</td>
<td >6500</td>
<td > </td>
<td >100</td>
<td >50</td>
</tr>
<tr>
<td >124</td>
<td >Kevin</td>
<td >Mourgos</td>
<td >KMOURGOS</td>
<td >650.123.5234</td>
<td >2007-00-16</td>
<td >ST_MAN</td>
<td >5800</td>
<td > </td>
<td >100</td>
<td >50</td>
</tr>
<tr>
<td >125</td>
<td >Julia</td>
<td >Nayer</td>
<td >JNAYER</td>
<td >650.124.1214</td>
<td >2005-00-16</td>
<td >ST_CLERK</td>
<td >3200</td>
<td > </td>
<td >120</td>
<td >50</td>
</tr>
<tr>
<td >126</td>
<td >Irene</td>
<td >Mikkilineni</td>
<td >IMIKKILI</td>
<td >650.124.1224</td>
<td >2006-00-28</td>
<td >ST_CLERK</td>
<td >2700</td>
<td > </td>
<td >120</td>
<td >50</td>
</tr>
<tr>
<td >127</td>
<td >James</td>
<td >Landry</td>
<td >JLANDRY</td>
<td >650.124.1334</td>
<td >2007-00-14</td>
<td >ST_CLERK</td>
<td >2400</td>
<td > </td>
<td >120</td>
<td >50</td>
</tr>
<tr>
<td >128</td>
<td >Steven</td>
<td >Markle</td>
<td >SMARKLE</td>
<td >650.124.1434</td>
<td >2008-00-08</td>
<td >ST_CLERK</td>
<td >2200</td>
<td > </td>
<td >120</td>
<td >50</td>
</tr>
<tr>
<td >129</td>
<td >Laura</td>
<td >Bissot</td>
<td >LBISSOT</td>
<td >650.124.5234</td>
<td >2005-00-20</td>
<td >ST_CLERK</td>
<td >3300</td>
<td > </td>
<td >121</td>
<td >50</td>
</tr>
<tr>
<td >130</td>
<td >Mozhe</td>
<td >Atkinson</td>
<td >MATKINSO</td>
<td >650.124.6234</td>
<td >2005-00-30</td>
<td >ST_CLERK</td>
<td >2800</td>
<td > </td>
<td >121</td>
<td >50</td>
</tr>
<tr>
<td >131</td>
<td >James</td>
<td >Marlow</td>
<td >JAMRLOW</td>
<td >650.124.7234</td>
<td >2005-00-16</td>
<td >ST_CLERK</td>
<td >2500</td>
<td > </td>
<td >121</td>
<td >50</td>
</tr>
<tr>
<td >132</td>
<td >TJ</td>
<td >Olson</td>
<td >TJOLSON</td>
<td >650.124.8234</td>
<td >2007-00-10</td>
<td >ST_CLERK</td>
<td >2100</td>
<td > </td>
<td >121</td>
<td >50</td>
</tr>
<tr>
<td >133</td>
<td >Jason</td>
<td >Mallin</td>
<td >JMALLIN</td>
<td >650.127.1934</td>
<td >2004-00-14</td>
<td >ST_CLERK</td>
<td >3300</td>
<td > </td>
<td >122</td>
<td >50</td>
</tr>
<tr>
<td >134</td>
<td >Michael</td>
<td >Rogers</td>
<td >MROGERS</td>
<td >650.127.1834</td>
<td >2006-00-26</td>
<td >ST_CLERK</td>
<td >2900</td>
<td > </td>
<td >122</td>
<td >50</td>
</tr>
<tr>
<td >135</td>
<td >Ki</td>
<td >Gee</td>
<td >KGEE</td>
<td >650.127.1734</td>
<td >2007-00-12</td>
<td >ST_CLERK</td>
<td >2400</td>
<td > </td>
<td >122</td>
<td >50</td>
</tr>
<tr>
<td >136</td>
<td >Hazel</td>
<td >Philtanker</td>
<td >HPHILTAN</td>
<td >650.127.1634</td>
<td >2008-00-06</td>
<td >ST_CLERK</td>
<td >2200</td>
<td > </td>
<td >122</td>
<td >50</td>
</tr>
<tr>
<td >137</td>
<td >Renske</td>
<td >Ladwig</td>
<td >RLADWIG</td>
<td >650.121.1234</td>
<td >2003-00-14</td>
<td >ST_CLERK</td>
<td >3600</td>
<td > </td>
<td >123</td>
<td >50</td>
</tr>
<tr>
<td >138</td>
<td >Stephen</td>
<td >Stiles</td>
<td >SSTILES</td>
<td >650.121.2034</td>
<td >2005-00-26</td>
<td >ST_CLERK</td>
<td >3200</td>
<td > </td>
<td >123</td>
<td >50</td>
</tr>
<tr>
<td >139</td>
<td >John</td>
<td >Seo</td>
<td >JSEO</td>
<td >650.121.2019</td>
<td >2006-00-12</td>
<td >ST_CLERK</td>
<td >2700</td>
<td > </td>
<td >123</td>
<td >50</td>
</tr>
<tr>
<td >140</td>
<td >Joshua</td>
<td >Patel</td>
<td >JPATEL</td>
<td >650.121.1834</td>
<td >2006-00-06</td>
<td >ST_CLERK</td>
<td >2500</td>
<td > </td>
<td >123</td>
<td >50</td>
</tr>
<tr>
<td >141</td>
<td >Trenna</td>
<td >Rajs</td>
<td >TRAJS</td>
<td >650.121.8009</td>
<td >2003-00-17</td>
<td >ST_CLERK</td>
<td >3500</td>
<td > </td>
<td >124</td>
<td >50</td>
</tr>
<tr>
<td >142</td>
<td >Curtis</td>
<td >Davies</td>
<td >CDAVIES</td>
<td >650.121.2994</td>
<td >2005-00-29</td>
<td >ST_CLERK</td>
<td >3100</td>
<td > </td>
<td >124</td>
<td >50</td>
</tr>
<tr>
<td >143</td>
<td >Randall</td>
<td >Matos</td>
<td >RMATOS</td>
<td >650.121.2874</td>
<td >2006-00-15</td>
<td >ST_CLERK</td>
<td >2600</td>
<td > </td>
<td >124</td>
<td >50</td>
</tr>
<tr>
<td >144</td>
<td >Peter</td>
<td >Vargas</td>
<td >PVARGAS</td>
<td >650.121.2004</td>
<td >2006-00-09</td>
<td >ST_CLERK</td>
<td >2500</td>
<td > </td>
<td >124</td>
<td >50</td>
</tr>
<tr>
<td >145</td>
<td >John</td>
<td >Russell</td>
<td >JRUSSEL</td>
<td >011.44.1344.429268</td>
<td >2004-00-01</td>
<td >SA_MAN</td>
<td >14000</td>
<td >0.4</td>
<td >100</td>
<td >80</td>
</tr>
<tr>
<td >146</td>
<td >Karen</td>
<td >Partners</td>
<td >KPARTNER</td>
<td >011.44.1344.467268</td>
<td >2005-00-05</td>
<td >SA_MAN</td>
<td >13500</td>
<td >0.3</td>
<td >100</td>
<td >80</td>
</tr>
<tr>
<td >147</td>
<td >Alberto</td>
<td >Errazuriz</td>
<td >AERRAZUR</td>
<td >011.44.1344.429278</td>
<td >2005-00-10</td>
<td >SA_MAN</td>
<td >12000</td>
<td >0.3</td>
<td >100</td>
<td >80</td>
</tr>
<tr>
<td >148</td>
<td >Gerald</td>
<td >Cambrault</td>
<td >GCAMBRAU</td>
<td >011.44.1344.619268</td>
<td >2007-00-15</td>
<td >SA_MAN</td>
<td >11000</td>
<td >0.3</td>
<td >100</td>
<td >80</td>
</tr>
<tr>
<td >149</td>
<td >Eleni</td>
<td >Zlotkey</td>
<td >EZLOTKEY</td>
<td >011.44.1344.429018</td>
<td >2008-00-29</td>
<td >SA_MAN</td>
<td >10500</td>
<td >0.2</td>
<td >100</td>
<td >80</td>
</tr>
<tr>
<td >150</td>
<td >Peter</td>
<td >Tucker</td>
<td >PTUCKER</td>
<td >011.44.1344.129268</td>
<td >2005-00-30</td>
<td >SA_REP</td>
<td >10000</td>
<td >0.3</td>
<td >145</td>
<td >80</td>
</tr>
<tr>
<td >151</td>
<td >David</td>
<td >Bernstein</td>
<td >DBERNSTE</td>
<td >011.44.1344.345268</td>
<td >2005-00-24</td>
<td >SA_REP</td>
<td >9500</td>
<td >0.25</td>
<td >145</td>
<td >80</td>
</tr>
<tr>
<td >152</td>
<td >Peter</td>
<td >Hall</td>
<td >PHALL</td>
<td >011.44.1344.478968</td>
<td >2005-00-20</td>
<td >SA_REP</td>
<td >9000</td>
<td >0.25</td>
<td >145</td>
<td >80</td>
</tr>
<tr>
<td >153</td>
<td >Christopher</td>
<td >Olsen</td>
<td >COLSEN</td>
<td >011.44.1344.498718</td>
<td >2006-00-30</td>
<td >SA_REP</td>
<td >8000</td>
<td >0.2</td>
<td >145</td>
<td >80</td>
</tr>
<tr>
<td >154</td>
<td >Nanette</td>
<td >Cambrault</td>
<td >NCAMBRAU</td>
<td >011.44.1344.987668</td>
<td >2006-00-09</td>
<td >SA_REP</td>
<td >7500</td>
<td >0.2</td>
<td >145</td>
<td >80</td>
</tr>
<tr>
<td >155</td>
<td >Oliver</td>
<td >Tuvault</td>
<td >OTUVAULT</td>
<td >011.44.1344.486508</td>
<td >2007-00-23</td>
<td >SA_REP</td>
<td >7000</td>
<td >0.15</td>
<td >145</td>
<td >80</td>
</tr>
<tr>
<td >156</td>
<td >Janette</td>
<td >King</td>
<td >JKING</td>
<td >011.44.1345.429268</td>
<td >2004-00-30</td>
<td >SA_REP</td>
<td >10000</td>
<td >0.35</td>
<td >146</td>
<td >80</td>
</tr>
<tr>
<td >157</td>
<td >Patrick</td>
<td >Sully</td>
<td >PSULLY</td>
<td >011.44.1345.929268</td>
<td >2004-00-04</td>
<td >SA_REP</td>
<td >9500</td>
<td >0.35</td>
<td >146</td>
<td >80</td>
</tr>
<tr>
<td >158</td>
<td >Allan</td>
<td >McEwen</td>
<td >AMCEWEN</td>
<td >011.44.1345.829268</td>
<td >2004-00-01</td>
<td >SA_REP</td>
<td >9000</td>
<td >0.35</td>
<td >146</td>
<td >80</td>
</tr>
<tr>
<td >159</td>
<td >Lindsey</td>
<td >Smith</td>
<td >LSMITH</td>
<td >011.44.1345.729268</td>
<td >2005-00-10</td>
<td >SA_REP</td>
<td >8000</td>
<td >0.3</td>
<td >146</td>
<td >80</td>
</tr>
<tr>
<td >160</td>
<td >Louise</td>
<td >Doran</td>
<td >LDORAN</td>
<td >011.44.1345.629268</td>
<td >2005-00-15</td>
<td >SA_REP</td>
<td >7500</td>
<td >0.3</td>
<td >146</td>
<td >80</td>
</tr>
<tr>
<td >161</td>
<td >Sarath</td>
<td >Sewall</td>
<td >SSEWALL</td>
<td >011.44.1345.529268</td>
<td >2006-00-03</td>
<td >SA_REP</td>
<td >7000</td>
<td >0.25</td>
<td >146</td>
<td >80</td>
</tr>
<tr>
<td >162</td>
<td >Clara</td>
<td >Vishney</td>
<td >CVISHNEY</td>
<td >011.44.1346.129268</td>
<td >2005-00-11</td>
<td >SA_REP</td>
<td >10500</td>
<td >0.25</td>
<td >147</td>
<td >80</td>
</tr>
<tr>
<td >163</td>
<td >Danielle</td>
<td >Greene</td>
<td >DGREENE</td>
<td >011.44.1346.229268</td>
<td >2007-00-19</td>
<td >SA_REP</td>
<td >9500</td>
<td >0.15</td>
<td >147</td>
<td >80</td>
</tr>
<tr>
<td >164</td>
<td >Mattea</td>
<td >Marvins</td>
<td >MMARVINS</td>
<td >011.44.1346.329268</td>
<td >2008-00-24</td>
<td >SA_REP</td>
<td >7200</td>
<td >0.1</td>
<td >147</td>
<td >80</td>
</tr>
<tr>
<td >165</td>
<td >David</td>
<td >Lee</td>
<td >DLEE</td>
<td >011.44.1346.529268</td>
<td >2008-00-23</td>
<td >SA_REP</td>
<td >6800</td>
<td >0.1</td>
<td >147</td>
<td >80</td>
</tr>
<tr>
<td >166</td>
<td >Sundar</td>
<td >Ande</td>
<td >SANDE</td>
<td >011.44.1346.629268</td>
<td >2008-00-24</td>
<td >SA_REP</td>
<td >6400</td>
<td >0.1</td>
<td >147</td>
<td >80</td>
</tr>
<tr>
<td >167</td>
<td >Amit</td>
<td >Banda</td>
<td >ABANDA</td>
<td >011.44.1346.729268</td>
<td >2008-00-21</td>
<td >SA_REP</td>
<td >6200</td>
<td >0.1</td>
<td >147</td>
<td >80</td>
</tr>
<tr>
<td >168</td>
<td >Lisa</td>
<td >Ozer</td>
<td >LOZER</td>
<td >011.44.1343.929268</td>
<td >2005-00-11</td>
<td >SA_REP</td>
<td >11500</td>
<td >0.25</td>
<td >148</td>
<td >80</td>
</tr>
<tr>
<td >169</td>
<td >Harrison</td>
<td >Bloom</td>
<td >HBLOOM</td>
<td >011.44.1343.829268</td>
<td >2006-00-23</td>
<td >SA_REP</td>
<td >10000</td>
<td >0.2</td>
<td >148</td>
<td >80</td>
</tr>
<tr>
<td >170</td>
<td >Tayler</td>
<td >Fox</td>
<td >TFOX</td>
<td >011.44.1343.729268</td>
<td >2006-00-24</td>
<td >SA_REP</td>
<td >9600</td>
<td >0.2</td>
<td >148</td>
<td >80</td>
</tr>
<tr>
<td >171</td>
<td >William</td>
<td >Smith</td>
<td >WSMITH</td>
<td >011.44.1343.629268</td>
<td >2007-00-23</td>
<td >SA_REP</td>
<td >7400</td>
<td >0.15</td>
<td >148</td>
<td >80</td>
</tr>
<tr>
<td >172</td>
<td >Elizabeth</td>
<td >Bates</td>
<td >EBATES</td>
<td >011.44.1343.529268</td>
<td >2007-00-24</td>
<td >SA_REP</td>
<td >7300</td>
<td >0.15</td>
<td >148</td>
<td >80</td>
</tr>
<tr>
<td >173</td>
<td >Sundita</td>
<td >Kumar</td>
<td >SKUMAR</td>
<td >011.44.1343.329268</td>
<td >2008-00-21</td>
<td >SA_REP</td>
<td >6100</td>
<td >0.1</td>
<td >148</td>
<td >80</td>
</tr>
<tr>
<td >174</td>
<td >Ellen</td>
<td >Abel</td>
<td >EABEL</td>
<td >011.44.1644.429267</td>
<td >2004-00-11</td>
<td >SA_REP</td>
<td >11000</td>
<td >0.3</td>
<td >149</td>
<td >80</td>
</tr>
<tr>
<td >175</td>
<td >Alyssa</td>
<td >Hutton</td>
<td >AHUTTON</td>
<td >011.44.1644.429266</td>
<td >2005-00-19</td>
<td >SA_REP</td>
<td >8800</td>
<td >0.25</td>
<td >149</td>
<td >80</td>
</tr>
<tr>
<td >176</td>
<td >Jonathon</td>
<td >Taylor</td>
<td >JTAYLOR</td>
<td >011.44.1644.429265</td>
<td >2006-00-24</td>
<td >SA_REP</td>
<td >8600</td>
<td >0.2</td>
<td >149</td>
<td >80</td>
</tr>
<tr>
<td >177</td>
<td >Jack</td>
<td >Livingston</td>
<td >JLIVINGS</td>
<td >011.44.1644.429264</td>
<td >2006-00-23</td>
<td >SA_REP</td>
<td >8400</td>
<td >0.2</td>
<td >149</td>
<td >80</td>
</tr>
<tr>
<td >178</td>
<td >Kimberely</td>
<td >Grant</td>
<td >KGRANT</td>
<td >011.44.1644.429263</td>
<td >2007-00-24</td>
<td >SA_REP</td>
<td >7000</td>
<td >0.15</td>
<td >149</td>
<td >null</td>
</tr>
<tr>
<td >179</td>
<td >Charles</td>
<td >Johnson</td>
<td >CJOHNSON</td>
<td >011.44.1644.429262</td>
<td >2008-00-04</td>
<td >SA_REP</td>
<td >6200</td>
<td >0.1</td>
<td >149</td>
<td >80</td>
</tr>
<tr>
<td >180</td>
<td >Winston</td>
<td >Taylor</td>
<td >WTAYLOR</td>
<td >650.507.9876</td>
<td >2006-00-24</td>
<td >SH_CLERK</td>
<td >3200</td>
<td > </td>
<td >120</td>
<td >50</td>
</tr>
<tr>
<td >181</td>
<td >Jean</td>
<td >Fleaur</td>
<td >JFLEAUR</td>
<td >650.507.9877</td>
<td >2006-00-23</td>
<td >SH_CLERK</td>
<td >3100</td>
<td > </td>
<td >120</td>
<td >50</td>
</tr>
<tr>
<td >182</td>
<td >Martha</td>
<td >Sullivan</td>
<td >MSULLIVA</td>
<td >650.507.9878</td>
<td >2007-00-21</td>
<td >SH_CLERK</td>
<td >2500</td>
<td > </td>
<td >120</td>
<td >50</td>
</tr>
<tr>
<td >183</td>
<td >Girard</td>
<td >Geoni</td>
<td >GGEONI</td>
<td >650.507.9879</td>
<td >2008-00-03</td>
<td >SH_CLERK</td>
<td >2800</td>
<td > </td>
<td >120</td>
<td >50</td>
</tr>
<tr>
<td >184</td>
<td >Nandita</td>
<td >Sarchand</td>
<td >NSARCHAN</td>
<td >650.509.1876</td>
<td >2004-00-27</td>
<td >SH_CLERK</td>
<td >4200</td>
<td > </td>
<td >121</td>
<td >50</td>
</tr>
<tr>
<td >185</td>
<td >Alexis</td>
<td >Bull</td>
<td >ABULL</td>
<td >650.509.2876</td>
<td >2005-00-20</td>
<td >SH_CLERK</td>
<td >4100</td>
<td > </td>
<td >121</td>
<td >50</td>
</tr>
<tr>
<td >186</td>
<td >Julia</td>
<td >Dellinger</td>
<td >JDELLING</td>
<td >650.509.3876</td>
<td >2006-00-24</td>
<td >SH_CLERK</td>
<td >3400</td>
<td > </td>
<td >121</td>
<td >50</td>
</tr>
<tr>
<td >187</td>
<td >Anthony</td>
<td >Cabrio</td>
<td >ACABRIO</td>
<td >650.509.4876</td>
<td >2007-00-07</td>
<td >SH_CLERK</td>
<td >3000</td>
<td > </td>
<td >121</td>
<td >50</td>
</tr>
<tr>
<td >188</td>
<td >Kelly</td>
<td >Chung</td>
<td >KCHUNG</td>
<td >650.505.1876</td>
<td >2005-00-14</td>
<td >SH_CLERK</td>
<td >3800</td>
<td > </td>
<td >122</td>
<td >50</td>
</tr>
<tr>
<td >189</td>
<td >Jennifer</td>
<td >Dilly</td>
<td >JDILLY</td>
<td >650.505.2876</td>
<td >2005-00-13</td>
<td >SH_CLERK</td>
<td >3600</td>
<td > </td>
<td >122</td>
<td >50</td>
</tr>
<tr>
<td >190</td>
<td >Timothy</td>
<td >Gates</td>
<td >TGATES</td>
<td >650.505.3876</td>
<td >2006-00-11</td>
<td >SH_CLERK</td>
<td >2900</td>
<td > </td>
<td >122</td>
<td >50</td>
</tr>
<tr>
<td >191</td>
<td >Randall</td>
<td >Perkins</td>
<td >RPERKINS</td>
<td >650.505.4876</td>
<td >2007-00-19</td>
<td >SH_CLERK</td>
<td >2500</td>
<td > </td>
<td >122</td>
<td >50</td>
</tr>
<tr>
<td >192</td>
<td >Sarah</td>
<td >Bell</td>
<td >SBELL</td>
<td >650.501.1876</td>
<td >2004-00-04</td>
<td >SH_CLERK</td>
<td >4000</td>
<td > </td>
<td >123</td>
<td >50</td>
</tr>
<tr>
<td >193</td>
<td >Britney</td>
<td >Everett</td>
<td >BEVERETT</td>
<td >650.501.2876</td>
<td >2005-00-03</td>
<td >SH_CLERK</td>
<td >3900</td>
<td > </td>
<td >123</td>
<td >50</td>
</tr>
<tr>
<td >194</td>
<td >Samuel</td>
<td >McCain</td>
<td >SMCCAIN</td>
<td >650.501.3876</td>
<td >2006-00-01</td>
<td >SH_CLERK</td>
<td >3200</td>
<td > </td>
<td >123</td>
<td >50</td>
</tr>
<tr>
<td >195</td>
<td >Vance</td>
<td >Jones</td>
<td >VJONES</td>
<td >650.501.4876</td>
<td >2007-00-17</td>
<td >SH_CLERK</td>
<td >2800</td>
<td > </td>
<td >123</td>
<td >50</td>
</tr>
<tr>
<td >196</td>
<td >Alana</td>
<td >Walsh</td>
<td >AWALSH</td>
<td >650.507.9811</td>
<td >2006-00-24</td>
<td >SH_CLERK</td>
<td >3100</td>
<td > </td>
<td >124</td>
<td >50</td>
</tr>
<tr>
<td >197</td>
<td >Kevin</td>
<td >Feeney</td>
<td >KFEENEY</td>
<td >650.507.9822</td>
<td >2006-00-23</td>
<td >SH_CLERK</td>
<td >3000</td>
<td > </td>
<td >124</td>
<td >50</td>
</tr>
<tr>
<td >198</td>
<td >Donald</td>
<td >OConnell</td>
<td >DOCONNEL</td>
<td >650.507.9833</td>
<td >2007-00-21</td>
<td >SH_CLERK</td>
<td >2600</td>
<td > </td>
<td >124</td>
<td >50</td>
</tr>
<tr>
<td >199</td>
<td >Douglas</td>
<td >Grant</td>
<td >DGRANT</td>
<td >650.507.9844</td>
<td >2008-00-13</td>
<td >SH_CLERK</td>
<td >2600</td>
<td > </td>
<td >124</td>
<td >50</td>
</tr>
<tr>
<td >200</td>
<td >Jennifer</td>
<td >Whalen</td>
<td >JWHALEN</td>
<td >515.123.4444</td>
<td >2003-00-17</td>
<td >AD_ASST</td>
<td >4400</td>
<td > </td>
<td >101</td>
<td >10</td>
</tr>
<tr>
<td >201</td>
<td >Michael</td>
<td >Hartstein</td>
<td >MHARTSTE</td>
<td >515.123.5555</td>
<td >2004-00-17</td>
<td >MK_MAN</td>
<td >13000</td>
<td > </td>
<td >100</td>
<td >20</td>
</tr>
<tr>
<td >202</td>
<td >Pat</td>
<td >Fay</td>
<td >PFAY</td>
<td >603.123.6666</td>
<td >2005-00-17</td>
<td >MK_REP</td>
<td >6000</td>
<td > </td>
<td >201</td>
<td >20</td>
</tr>
<tr>
<td >203</td>
<td >Susan</td>
<td >Mavris</td>
<td >SMAVRIS</td>
<td >515.123.7777</td>
<td >2002-00-07</td>
<td >HR_REP</td>
<td >6500</td>
<td > </td>
<td >101</td>
<td >40</td>
</tr>
<tr>
<td >204</td>
<td >Hermann</td>
<td >Baer</td>
<td >HBAER</td>
<td >515.123.8888</td>
<td >2002-00-07</td>
<td >PR_REP</td>
<td >10000</td>
<td > </td>
<td >101</td>
<td >70</td>
</tr>
<tr>
<td >205</td>
<td >Shelley</td>
<td >Higgins</td>
<td >SHIGGINS</td>
<td >515.123.8080</td>
<td >2002-00-07</td>
<td >AC_MGR</td>
<td >12008</td>
<td > </td>
<td >101</td>
<td >110</td>
</tr>
<tr>
<td >206</td>
<td >William</td>
<td >Gietz</td>
<td >WGIETZ</td>
<td >515.123.8181</td>
<td >2002-00-07</td>
<td >AC_ACCOUNT</td>
<td >8300</td>
<td > </td>
<td >205</td>
<td >110</td>
</tr>
</table>
</body>
<script src="jquery.min.js"></script>
<script>
function ReadDate(){
var row=$("table tr").length;
var size=$("table tr").find("td").length;
var col=size/row;
var data = new Array();
for(var i=0;i<row-1;i++)
data[i]=new Array();
k=col;
for(var i=0;i<row-1;i++)
{
    for(var j=0;j<col;j++)
    {
    if($("table").find('td').eq(k).text()!=null)
    data[i][j]=$("table").find('td').eq(k).text();
    else 
    data[i][j]=0;
    k++;
    }
}
return data;
}
function updateResult(result){
console.log(result);
var row=$("table tr").length;
var size=$("table tr").find("td").length;
var col=$("table tr").find("td").length/row;


k=col;
for(var i=0;i<row-1;i++)
{
for(var j=0;j<col;j++)
{
if(result[i][j]==0)
$("table").find('td').eq(k).text("");
else 
$("table").find('td').eq(k).text(result[i][j]);
k++;
}
}
}


//用来保存修改时选中的tr,如果为null说明是添加操作，如果不为null说明是修改操作
$(document).ready(
function(){
var orderby=1;
$("#btn1").click(
function(){
orderby=-orderby;
$("table caption").text("姓氏排序");//修改对话框(就是表格)的标题
    var data=ReadDate();
var result=data.sort(function(x, y){
if(orderby>0)
  return x[1].localeCompare(y[1]);
else 
return -x[1].localeCompare(y[1]);
}
               );
updateResult(result);
console.log(result);

});
$("#btn7").click(
function(){
orderby=-orderby;
$("table caption").text("工资排序");//修改对话框(就是表格)的标题
    var data=ReadDate();
var result=data.sort(function(x, y){
if(orderby>0)
  return x[7]-y[7];
else 
return -(x[7]-y[7]);
}
               );
updateResult(result);
console.log(result);

});


});
</script>
</html>
qq_27069811
关注
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值