這兩天學(xué)習(xí)了nodejs mysql 實(shí)現(xiàn)分頁(yè)，很重要，所以，今天添加一點(diǎn)小筆記。

代碼如下

var express = require('express');var router = express.Router();var settings = require('../settings.js');var mysql = require('mysql2');router.get('/', function(req, res, next) {  var current_page = 1; //默認(rèn)為1  var num = 9; //一頁(yè)條數(shù)  if (req.query.page) {    current_page = parseInt(req.query.page);  }  var last_page = current_page - 1;  if (current_page <= 1) {    last_page = 1;  }  var next_page = current_page + 1;  var str = 'SELECT left(paragraph,50) as paragraph,date,id FROM notice limit ' + num + ' offset ' + num * (current_page - 1);  var conn = mysql.createConnection(settings.db);  conn.connect();  conn.query(str, function(err, rows, fields) {    if (err) {      req.flash('error', '數(shù)據(jù)查詢有誤');    }    if (!err) {      if (!rows[0]) {        req.flash('error', '已到最后一頁(yè),請(qǐng)返回');      }      res.render('notice', {        last_page: last_page,        next_page: next_page,        current_page: current_page,        mes: rows,        error: req.flash('error').toString()      });    }  });  conn.end();});module.exports = router;

以上就是本文的全部?jī)?nèi)容，希望對(duì)大家的學(xué)習(xí)有所幫助，也希望大家多多支持錯(cuò)新站長(zhǎng)站。