本帖最后由 uusl 于 2020-2-2 16:46 编辑
- <pre><span style="background-color:#efefef"><</span><strong>script </strong><strong>th</strong><strong>:inline=</strong><strong>"javascript"</strong><span style="background-color:#efefef">></span>
- <strong>[ DISCUZ_CODE_0 ]lt;/strong>(<strong>function </strong>() {
- <strong>[ DISCUZ_CODE_0 ]lt;/strong>.<span style="color:#7a7a43">ajax</span>({
- <strong>url</strong>:<strong>'/Student/pagelist'</strong>,
- <strong>type</strong>:<strong>'get'</strong>,
- <strong>dataType</strong>: <strong>'json'</strong>,
- <span style="color:#7a7a43">success</span>:<strong>function </strong>(data) {
- <strong>var </strong><span style="color:#458383">json</span>=<em>eval</em>(data)
- <strong>var </strong><span style="color:#458383">tt</span>=<strong>""</strong>;
- <strong>[ DISCUZ_CODE_0 ]lt;/strong>.<span style="color:#7a7a43">each</span>(<span style="color:#458383">json</span>,<strong>function </strong>(index) {
- <strong>var </strong><span style="color:#458383">Id</span>=<span style="color:#458383">json</span>[index].<strong>id</strong>;
- <span style="color:#458383">tt </span>+= <span style="color:#458383">Id </span>+ <strong>"___"</strong>;
- })
- <strong>[ DISCUZ_CODE_0 ]lt;/strong>(<strong>"#list"</strong>).<span style="color:#7a7a43">html</span>(<strong>''</strong>);
- <strong>[ DISCUZ_CODE_0 ]lt;/strong>(<strong>"#list"</strong>).<span style="color:#7a7a43">html</span>(<span style="color:#458383">tt</span>);
- }</pre>
- <div class="line alt2"><table><tbody><tr><td class="number"><code>02</code></td><td class="content"><code class="plain">Navicat MySQL Data Transfer</code></td></tr></tbody></table></div><div class="line alt1"><table><tbody><tr><td class="number"><code>03</code></td><td class="content"> </td></tr></tbody></table></div><div class="line alt2"><table><tbody><tr><td class="number"><code>04</code></td><td class="content"><code class="plain">Source Server : longyi</code></td></tr></tbody></table></div><div class="line alt1"><table><tbody><tr><td class="number"><code>05</code></td><td class="content"><code class="plain">Source Server Version : 50140</code></td></tr></tbody></table></div><div class="line alt2"><table><tbody><tr><td class="number"><code>06</code></td><td class="content"><code class="plain">Source Host : localhost:3306</code></td></tr></tbody></table></div><div class="line alt1"><table><tbody><tr><td class="number"><code>07</code></td><td class="content"><code class="plain">Source </code><code class="keyword">Database</code> <code class="plain">: adp</code></td></tr></tbody></table></div><div class="line alt2"><table><tbody><tr><td class="number"><code>08</code></td><td class="content"> </td></tr></tbody></table></div><div class="line alt1"><table><tbody><tr><td class="number"><code>09</code></td><td class="content"><code class="plain">Target Server Type : MYSQL</code></td></tr></tbody></table></div><div class="line alt2"><table><tbody><tr><td class="number"><code>10</code></td><td class="content"><code class="plain">Target Server Version : 50140</code></td></tr></tbody></table></div><div class="line alt1"><table><tbody><tr><td class="number"><code>11</code></td><td class="content"><code class="plain">File Encoding : 65001</code></td></tr></tbody></table></div><div class="line alt2"><table><tbody><tr><td class="number"><code>12</code></td><td class="content"> </td></tr></tbody></table></div><div class="line alt1"><table><tbody><tr><td class="number"><code>13</code></td><td class="content"><code class="keyword">Date</code><code class="plain">: 2014-05-07 10:45:30</code></td></tr></tbody></table></div><div class="line alt2"><table><tbody><tr><td class="number"><code>14</code></td><td class="content"><code class="plain">*/</code></td></tr></tbody></table></div><div class="line alt1"><table><tbody><tr><td class="number"><code>15</code></td><td class="content"> </td></tr></tbody></table></div><div class="line alt2"><table><tbody><tr><td class="number"><code>16</code></td><td class="content"><code class="keyword">drop</code> <code class="keyword">database</code> <code class="plain">if exists `adp`;</code></td></tr></tbody></table></div><div class="line alt1"><table><tbody><tr><td class="number"><code>17</code></td><td class="content"><code class="keyword">create</code> <code class="keyword">database</code> <code class="plain">`adp`;</code></td></tr></tbody></table></div><div class="line alt2"><table><tbody><tr><td class="number"><code>18</code></td><td class="content"><code class="plain">use `adp`;</code></td></tr></tbody></table></div><div class="line alt1"><table><tbody><tr><td class="number"><code>19</code></td><td class="content"> </td></tr></tbody></table></div><div class="line alt2"><table><tbody><tr><td class="number"><code>20</code></td><td class="content"><code class="keyword">SET</code> <code class="plain">FOREIGN_KEY_CHECKS=0;</code></td></tr></tbody></table></div><div class="line alt1"><table><tbody><tr><td class="number"><code>21</code></td><td class="content"><code class="comments">-- ----------------------------</code></td></tr></tbody></table></div><div class="line alt2"><table><tbody><tr><td class="number"><code>22</code></td><td class="content"><code class="comments">-- Table structure for `manager`</code></td></tr></tbody></table></div><div class="line alt1"><table><tbody><tr><td class="number"><code>23</code></td><td class="content"><code class="comments">-- ----------------------------</code></td></tr></tbody></table></div><div class="line alt2"><table><tbody><tr><td class="number"><code>24</code></td><td class="content"><code class="keyword">DROP</code> <code class="keyword">TABLE</code> <code class="plain">IF EXISTS `manager`;</code></td></tr></tbody></table></div><div class="line alt1"><table><tbody><tr><td class="number"><code>25</code></td><td class="content"><code class="keyword">CREATE</code> <code class="keyword">TABLE</code> <code class="plain">`manager` (</code></td></tr></tbody></table></div><div class="line alt2"><table><tbody><tr><td class="number"><code>26</code></td><td class="content"><code class="spaces"> </code><code class="plain">`managerId` </code><code class="keyword">int</code><code class="plain">(11) </code><code class="color1">NOT</code> <code class="color1">NULL</code> <code class="plain">AUTO_INCREMENT,</code></td></tr></tbody></table></div><div class="line alt1"><table><tbody><tr><td class="number"><code>27</code></td><td class="content"><code class="spaces"> </code><code class="plain">`</code><code class="keyword">name</code><code class="plain">` </code><code class="keyword">varchar</code><code class="plain">(20) </code><code class="color1">NOT</code> <code class="color1">NULL</code><code class="plain">,</code></td></tr></tbody></table></div><div class="line alt2"><table><tbody><tr><td class="number"><code>28</code></td><td class="content"><code class="spaces"> </code><code class="plain">`</code><code class="keyword">password</code><code class="plain">` </code><code class="keyword">varchar</code><code class="plain">(255) </code><code class="color1">NOT</code> <code class="color1">NULL</code><code class="plain">,</code></td></tr></tbody></table></div><div class="line alt1"><table><tbody><tr><td class="number"><code>29</code></td><td class="content"><code class="spaces"> </code><code class="plain">`role` </code><code class="keyword">varchar</code><code class="plain">(255) </code><code class="color1">NOT</code> <code class="color1">NULL</code><code class="plain">,</code></td></tr></tbody></table></div><div class="line alt2"><table><tbody><tr><td class="number"><code>30</code></td><td class="content"><code class="spaces"> </code><code class="plain">`status` </code><code class="keyword">varchar</code><code class="plain">(255) </code><code class="keyword">DEFAULT</code> <code class="color1">NULL</code><code class="plain">,</code></td></tr></tbody></table></div><div class="line alt1"><table><tbody><tr><td class="number"><code>31</code></td><td class="content"><code class="spaces"> </code><code class="plain">`descrition` </code><code class="keyword">varchar</code><code class="plain">(255) </code><code class="keyword">DEFAULT</code> <code class="color1">NULL</code><code class="plain">,</code></td></tr></tbody></table></div><div class="line alt2"><table><tbody><tr><td class="number"><code>32</code></td><td class="content"><code class="spaces"> </code><code class="keyword">PRIMARY</code> <code class="keyword">KEY</code> <code class="plain">(`managerId`)</code></td></tr></tbody></table></div><div class="line alt1"><table><tbody><tr><td class="number"><code>33</code></td><td class="content"><code class="plain">) ENGINE=InnoDB AUTO_INCREMENT=20 </code><code class="keyword">DEFAULT</code> <code class="plain">CHARSET=utf8;</code></td></tr></tbody></table></div><div class="line alt2"><table><tbody><tr><td class="number"><code>34</code></td><td class="content"> </td></tr></tbody></table></div><div class="line alt1"><table><tbody><tr><td class="number"><code>35</code></td><td class="content"><code class="comments">-- ----------------------------</code></td></tr></tbody></table></div><div class="line alt2"><table><tbody><tr><td class="number"><code>36</code></td><td class="content"><code class="comments">-- Records of manager</code></td></tr></tbody></table></div><table><tbody><tr><td class="number"><code>37</code></td><td class="content"><code class="comments">-- ----------------------------</code></td></tr></tbody></table><table><tbody><tr><td class="number"><code>01</code></td><td class="content"><code class="plain">/*</code></td></tr></tbody></table>
复制代码
|