mysql - 节点js mysql错误意外输入结束

Question

var express = require('express');
var app = express();
var fs= require('fs');
var mysql = require('mysql');
var bodyParser = require('body-parser');
var conn = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: '111222',
  database: 'o2'
});
conn.connect();


app.use(bodyParser.urlencoded({ extended: true })); 

app.get(['/topic', '/topic/:id'],function(req,res){
  var sql= 'select id, title *from topic';
  conn.query(sql, function(err, rows, fields){
    res.render('new',{topic:rows});

  });



app.locals.pretty = true; 
app.set('view engine','pug'); 
app.set('views','./views');  



app.listen(3000,function(){
  console.log('connect!');
})`enter code here`

我想用node js创建一个网页，但是不知道为什么会报错。我想用node js创建一个网页，但是不知道为什么会报错。

标签： mysqlnode.js

Answer 1

var express = require('express');
var app = express();
var fs= require('fs');
var mysql = require('mysql');
var bodyParser = require('body-parser');
var conn = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: '111222',
  database: 'o2'
});
conn.connect();


app.use(bodyParser.urlencoded({ extended: true }));

app.locals.pretty = true;
app.set('view engine','pug');
app.set('views','./views');

app.get(['/topic', '/topic/:id'],function(req,res) {
  var sql = 'select id, title *from topic';
  conn.query(sql, function(err, rows, fields) {
    res.render('new', { topic: rows });

  });
});
app.listen(3000,function(){
  console.log('connect!');
});