这个例子演示了在表格每一列加上索引
Name | Position | Office | Age | Salary | |
---|---|---|---|---|---|
Name | Position | Office | Age | Salary | |
Tiger Nixon | System Architect | Edinburgh | 61 | $320,800 | |
Garrett Winters | Accountant | Tokyo | 63 | $170,750 | |
Ashton Cox | Junior Technical Author | San Francisco | 66 | $86,000 | |
Cedric Kelly | Senior Javascript Developer | Edinburgh | 22 | $433,060 | |
Airi Satou | Accountant | Tokyo | 33 | $162,700 | |
Brielle Williamson | Integration Specialist | New York | 61 | $372,000 | |
Herrod Chandler | Sales Assistant | San Francisco | 59 | $137,500 | |
Rhona Davidson | Integration Specialist | Tokyo | 55 | $327,900 | |
Colleen Hurst | Javascript Developer | San Francisco | 39 | $205,500 | |
Sonya Frost | Software Engineer | Edinburgh | 23 | $103,600 | |
Jena Gaines | Office Manager | London | 30 | $90,560 | |
Quinn Flynn | Support Lead | Edinburgh | 22 | $342,000 | |
Charde Marshall | Regional Director | San Francisco | 36 | $470,600 | |
Haley Kennedy | Senior Marketing Designer | London | 43 | $313,500 | |
Tatyana Fitzpatrick | Regional Director | London | 19 | $385,750 | |
Michael Silva | Marketing Designer | London | 66 | $198,500 | |
Paul Byrd | Chief Financial Officer (CFO) | New York | 64 | $725,000 | |
Gloria Little | Systems Administrator | New York | 59 | $237,500 | |
Bradley Greer | Software Engineer | London | 41 | $132,000 | |
Dai Rios | Personnel Lead | Edinburgh | 35 | $217,500 | |
Jenette Caldwell | Development Lead | New York | 30 | $345,000 | |
Yuri Berry | Chief Marketing Officer (CMO) | New York | 40 | $675,000 | |
Caesar Vance | Pre-Sales Support | New York | 21 | $106,450 | |
Doris Wilder | Sales Assistant | Sidney | 23 | $85,600 | |
Angelica Ramos | Chief Executive Officer (CEO) | London | 47 | $1,200,000 | |
Gavin Joyce | Developer | Edinburgh | 42 | $92,575 | |
Jennifer Chang | Regional Director | Singapore | 28 | $357,650 | |
Brenden Wagner | Software Engineer | San Francisco | 28 | $206,850 | |
Fiona Green | Chief Operating Officer (COO) | San Francisco | 48 | $850,000 | |
Shou Itou | Regional Marketing | Tokyo | 20 | $163,000 | |
Michelle House | Integration Specialist | Sidney | 37 | $95,400 | |
Suki Burks | Developer | London | 53 | $114,500 | |
Prescott Bartlett | Technical Author | London | 27 | $145,000 | |
Gavin Cortez | Team Leader | San Francisco | 22 | $235,500 | |
Martena Mccray | Post-Sales support | Edinburgh | 46 | $324,050 | |
Unity Butler | Marketing Designer | San Francisco | 47 | $85,675 | |
Howard Hatfield | Office Manager | San Francisco | 51 | $164,500 | |
Hope Fuentes | Secretary | San Francisco | 41 | $109,850 | |
Vivian Harrell | Financial Controller | San Francisco | 62 | $452,500 | |
Timothy Mooney | Office Manager | London | 37 | $136,200 | |
Jackson Bradshaw | Director | New York | 65 | $645,750 | |
Olivia Liang | Support Engineer | Singapore | 64 | $234,500 | |
Bruno Nash | Software Engineer | London | 38 | $163,500 | |
Sakura Yamamoto | Support Engineer | Tokyo | 37 | $139,575 | |
Thor Walton | Developer | New York | 61 | $98,540 | |
Finn Camacho | Support Engineer | San Francisco | 47 | $87,500 | |
Serge Baldwin | Data Coordinator | Singapore | 64 | $138,575 | |
Zenaida Frank | Software Engineer | New York | 63 | $125,250 | |
Zorita Serrano | Software Engineer | San Francisco | 56 | $115,000 | |
Jennifer Acosta | Junior Javascript Developer | Edinburgh | 43 | $75,650 | |
Cara Stevens | Sales Assistant | New York | 46 | $145,600 | |
Hermione Butler | Regional Director | London | 47 | $356,250 | |
Lael Greer | Systems Administrator | London | 21 | $103,500 | |
Jonas Alexander | Developer | San Francisco | 30 | $86,500 | |
Shad Decker | Regional Director | Edinburgh | 51 | $183,000 | |
Michael Bruce | Javascript Developer | Singapore | 29 | $183,000 | |
Donna Snider | Customer Support | New York | 27 | $112,000 |
$(document).ready(function() { var t = $('#example').DataTable({ "columnDefs": [{ "searchable": false, "orderable": false, "targets": 0 }], "order": [[1, 'asc']] }); t.on('order.dt search.dt', function() { t.column(0, { search: 'applied', order: 'applied' }).nodes().each(function(cell, i) { cell.innerHTML = i + 1; }); }).draw(); });
<table id="example" class="display" cellspacing="0" width="100%"> <thead> <tr> <th></th> <th>Name</th> <th>Position</th> <th>Office</th> <th>Age</th> <th>Salary</th> </tr> </thead> <tfoot> <tr> <th></th> <th>Name</th> <th>Position</th> <th>Office</th> <th>Age</th> <th>Salary</th> </tr> </tfoot> <tbody> <tr> <td></td> <td>Tiger Nixon</td> <td>System Architect</td> <td>Edinburgh</td> <td>61</td> <td>$320,800</td> </tr> <tr> <td></td> <td>Garrett Winters</td> <td>Accountant</td> <td>Tokyo</td> <td>63</td> <td>$170,750</td> </tr> <tr> <td></td> <td>Ashton Cox</td> <td>Junior Technical Author</td> <td>San Francisco</td> <td>66</td> <td>$86,000</td> </tr> <tr> <td></td> <td>Cedric Kelly</td> <td>Senior Javascript Developer</td> <td>Edinburgh</td> <td>22</td> <td>$433,060</td> </tr> <tr> <td></td> <td>Airi Satou</td> <td>Accountant</td> <td>Tokyo</td> <td>33</td> <td>$162,700</td> </tr> <tr> <td></td> <td>Brielle Williamson</td> <td>Integration Specialist</td> <td>New York</td> <td>61</td> <td>$372,000</td> </tr> <tr> <td></td> <td>Herrod Chandler</td> <td>Sales Assistant</td> <td>San Francisco</td> <td>59</td> <td>$137,500</td> </tr> <tr> <td></td> <td>Rhona Davidson</td> <td>Integration Specialist</td> <td>Tokyo</td> <td>55</td> <td>$327,900</td> </tr> <tr> <td></td> <td>Colleen Hurst</td> <td>Javascript Developer</td> <td>San Francisco</td> <td>39</td> <td>$205,500</td> </tr> <tr> <td></td> <td>Sonya Frost</td> <td>Software Engineer</td> <td>Edinburgh</td> <td>23</td> <td>$103,600</td> </tr> <tr> <td></td> <td>Jena Gaines</td> <td>Office Manager</td> <td>London</td> <td>30</td> <td>$90,560</td> </tr> <tr> <td></td> <td>Quinn Flynn</td> <td>Support Lead</td> <td>Edinburgh</td> <td>22</td> <td>$342,000</td> </tr> <tr> <td></td> <td>Charde Marshall</td> <td>Regional Director</td> <td>San Francisco</td> <td>36</td> <td>$470,600</td> </tr> <tr> <td></td> <td>Haley Kennedy</td> <td>Senior Marketing Designer</td> <td>London</td> <td>43</td> <td>$313,500</td> </tr> <tr> <td></td> <td>Tatyana Fitzpatrick</td> <td>Regional Director</td> <td>London</td> <td>19</td> <td>$385,750</td> </tr> <tr> <td></td> <td>Michael Silva</td> <td>Marketing Designer</td> <td>London</td> <td>66</td> <td>$198,500</td> </tr> <tr> <td></td> <td>Paul Byrd</td> <td>Chief Financial Officer (CFO)</td> <td>New York</td> <td>64</td> <td>$725,000</td> </tr> <tr> <td></td> <td>Gloria Little</td> <td>Systems Administrator</td> <td>New York</td> <td>59</td> <td>$237,500</td> </tr> <tr> <td></td> <td>Bradley Greer</td> <td>Software Engineer</td> <td>London</td> <td>41</td> <td>$132,000</td> </tr> <tr> <td></td> <td>Dai Rios</td> <td>Personnel Lead</td> <td>Edinburgh</td> <td>35</td> <td>$217,500</td> </tr> <tr> <td></td> <td>Jenette Caldwell</td> <td>Development Lead</td> <td>New York</td> <td>30</td> <td>$345,000</td> </tr> <tr> <td></td> <td>Yuri Berry</td> <td>Chief Marketing Officer (CMO)</td> <td>New York</td> <td>40</td> <td>$675,000</td> </tr> <tr> <td></td> <td>Caesar Vance</td> <td>Pre-Sales Support</td> <td>New York</td> <td>21</td> <td>$106,450</td> </tr> <tr> <td></td> <td>Doris Wilder</td> <td>Sales Assistant</td> <td>Sidney</td> <td>23</td> <td>$85,600</td> </tr> <tr> <td></td> <td>Angelica Ramos</td> <td>Chief Executive Officer (CEO)</td> <td>London</td> <td>47</td> <td>$1,200,000</td> </tr> <tr> <td></td> <td>Gavin Joyce</td> <td>Developer</td> <td>Edinburgh</td> <td>42</td> <td>$92,575</td> </tr> <tr> <td></td> <td>Jennifer Chang</td> <td>Regional Director</td> <td>Singapore</td> <td>28</td> <td>$357,650</td> </tr> <tr> <td></td> <td>Brenden Wagner</td> <td>Software Engineer</td> <td>San Francisco</td> <td>28</td> <td>$206,850</td> </tr> <tr> <td></td> <td>Fiona Green</td> <td>Chief Operating Officer (COO)</td> <td>San Francisco</td> <td>48</td> <td>$850,000</td> </tr> <tr> <td></td> <td>Shou Itou</td> <td>Regional Marketing</td> <td>Tokyo</td> <td>20</td> <td>$163,000</td> </tr> <tr> <td></td> <td>Michelle House</td> <td>Integration Specialist</td> <td>Sidney</td> <td>37</td> <td>$95,400</td> </tr> <tr> <td></td> <td>Suki Burks</td> <td>Developer</td> <td>London</td> <td>53</td> <td>$114,500</td> </tr> <tr> <td></td> <td>Prescott Bartlett</td> <td>Technical Author</td> <td>London</td> <td>27</td> <td>$145,000</td> </tr> <tr> <td></td> <td>Gavin Cortez</td> <td>Team Leader</td> <td>San Francisco</td> <td>22</td> <td>$235,500</td> </tr> <tr> <td></td> <td>Martena Mccray</td> <td>Post-Sales support</td> <td>Edinburgh</td> <td>46</td> <td>$324,050</td> </tr> <tr> <td></td> <td>Unity Butler</td> <td>Marketing Designer</td> <td>San Francisco</td> <td>47</td> <td>$85,675</td> </tr> <tr> <td></td> <td>Howard Hatfield</td> <td>Office Manager</td> <td>San Francisco</td> <td>51</td> <td>$164,500</td> </tr> <tr> <td></td> <td>Hope Fuentes</td> <td>Secretary</td> <td>San Francisco</td> <td>41</td> <td>$109,850</td> </tr> <tr> <td></td> <td>Vivian Harrell</td> <td>Financial Controller</td> <td>San Francisco</td> <td>62</td> <td>$452,500</td> </tr> <tr> <td></td> <td>Timothy Mooney</td> <td>Office Manager</td> <td>London</td> <td>37</td> <td>$136,200</td> </tr> <tr> <td></td> <td>Jackson Bradshaw</td> <td>Director</td> <td>New York</td> <td>65</td> <td>$645,750</td> </tr> <tr> <td></td> <td>Olivia Liang</td> <td>Support Engineer</td> <td>Singapore</td> <td>64</td> <td>$234,500</td> </tr> <tr> <td></td> <td>Bruno Nash</td> <td>Software Engineer</td> <td>London</td> <td>38</td> <td>$163,500</td> </tr> <tr> <td></td> <td>Sakura Yamamoto</td> <td>Support Engineer</td> <td>Tokyo</td> <td>37</td> <td>$139,575</td> </tr> <tr> <td></td> <td>Thor Walton</td> <td>Developer</td> <td>New York</td> <td>61</td> <td>$98,540</td> </tr> <tr> <td></td> <td>Finn Camacho</td> <td>Support Engineer</td> <td>San Francisco</td> <td>47</td> <td>$87,500</td> </tr> <tr> <td></td> <td>Serge Baldwin</td> <td>Data Coordinator</td> <td>Singapore</td> <td>64</td> <td>$138,575</td> </tr> <tr> <td></td> <td>Zenaida Frank</td> <td>Software Engineer</td> <td>New York</td> <td>63</td> <td>$125,250</td> </tr> <tr> <td></td> <td>Zorita Serrano</td> <td>Software Engineer</td> <td>San Francisco</td> <td>56</td> <td>$115,000</td> </tr> <tr> <td></td> <td>Jennifer Acosta</td> <td>Junior Javascript Developer</td> <td>Edinburgh</td> <td>43</td> <td>$75,650</td> </tr> <tr> <td></td> <td>Cara Stevens</td> <td>Sales Assistant</td> <td>New York</td> <td>46</td> <td>$145,600</td> </tr> <tr> <td></td> <td>Hermione Butler</td> <td>Regional Director</td> <td>London</td> <td>47</td> <td>$356,250</td> </tr> <tr> <td></td> <td>Lael Greer</td> <td>Systems Administrator</td> <td>London</td> <td>21</td> <td>$103,500</td> </tr> <tr> <td></td> <td>Jonas Alexander</td> <td>Developer</td> <td>San Francisco</td> <td>30</td> <td>$86,500</td> </tr> <tr> <td></td> <td>Shad Decker</td> <td>Regional Director</td> <td>Edinburgh</td> <td>51</td> <td>$183,000</td> </tr> <tr> <td></td> <td>Michael Bruce</td> <td>Javascript Developer</td> <td>Singapore</td> <td>29</td> <td>$183,000</td> </tr> <tr> <td></td> <td>Donna Snider</td> <td>Customer Support</td> <td>New York</td> <td>27</td> <td>$112,000</td> </tr> </tbody> </table>
Translation from DataTables.net, with permission