nodejs mysql 實現分頁的方法，nodejsmysql

nodejs mysql 實現分頁的方法，nodejsmysql

這兩天學習了nodejs mysql 實現分頁，很重要，所以，今天添加一點小筆記。

代碼如下

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; //預設為1  var num = 9; //一頁條數  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', '資料查詢有誤');    }    if (!err) {      if (!rows[0]) {        req.flash('error', '已到最後一頁,請返回');      }      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;

以上就是本文的全部內容，希望對大家的學習有所協助，也希望大家多多支援幫客之家。