学node的一点小笔记（十三） node操作mysql

最新推荐文章于 2022-03-07 21:59:11 发布

夏天咯

最新推荐文章于 2022-03-07 21:59:11 发布

阅读量187

点赞数

分类专栏： node 文章标签： node mysql

本文链接：https://blog.csdn.net/qq_37628661/article/details/80048833

版权

node 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

这里是做了一个增删改查的简单操作，mysql怎么安就不用我说了吧，id是自增字段 alter table user change id id int(10) auto_increment primary key;

mysql.js

 
  var 
  mysql = 
  require( 
  'mysql'); 
 
  var 
  connection = 
  mysql. 
  createConnection({ 
 
  host : 
  'localhost', 
 
  user : 
  'root', 
 
  password : 
  '', 
 
  database : 
  'test' 
 
   }); 
 
  connection. 
  connect(); 
 
  // connection.query('SELECT 1 + 1 AS solution', function (error, results, fields) { 
 
  // if (error) throw error; 
 
  // console.log('The solution is: ', results[0].solution); 
 
  // }); 
 
  //var _sql = `SELECT * FROM user`; 
 
  //var _sql = `INSERT INTO user(id,name,age) VALUES(1,'a',1)` 
 
  var 
  express = 
  require( 
  'express'); 
 
  var 
  app = 
  express(); 
 
  var 
  bodyParser = 
  require( 
  'body-parser'); 
 
  //创建application/x-www-form-urlencoded编码解析 
 
  var 
  urlencodeParser = 
  bodyParser. 
  urlencoded({ 
  extended: 
  false}) 
 
  app. 
  use( 
  express. 
  static( 
  'static')); 
 
  //没有"/"是不行滴 
 
  app. 
  get( 
  '/mysql.html', 
  function( 
  req, 
  res){ 
 
  console. 
  log( 
  __dirname) 
 
  res. 
  sendFile( 
  __dirname+ 
  '/'+ 
  'mysql.html'); 
 
   }) 
 
  app. 
  post( 
  '/mysql', 
  urlencodeParser, 
  function( 
  req, 
  res){ 
 
  var 
  name = 
  req. 
  body. 
  name; 
 
  var 
  age = 
  req. 
  body. 
  age; 
 
  // console.log(name,age); 
 
  //增加一条数据 
 
  //var _sql = `INSERT INTO user(name,age) VALUES('`+name+`',`+age+`)`; 
 
  //查询 
 
  //var _sql = `SELECT * FROM user`; 
 
  //删除 null必须大写 
 
  //var _sql = `DELETE FROM user WHERE name=NULL`; 
 
  //字符串需转义 
 
  //var _sql = `DELETE from user WHERE name='\+name\+'`; 
 
  // console.log(_sql) 
 
  connection. 
  query( 
  _sql, 
  function( 
  err, 
  results){ 
 
  if( 
  err){ 
 
  console. 
  log( 
  err) 
 
   } 
 
  console. 
  log( 
  results) 
 
   }) 
 
  res. 
  end() 
 
   }) 
 
  var 
  server = 
  app. 
  listen( 
  8082, 
  function(){ 
 
  var 
  host = 
  server. 
  address(). 
  address; 
 
  var 
  port = 
  server. 
  address(). 
  port; 
 
  console. 
  log( 
  '请求地址：http://%s:%s', 
  host, 
  port) 
 
   }) 
 
  // connection.query(_sql,function(err,results){ 
 
  // console.log(results) 
 
  // }) 
 
  mysql.html 
 
    <html> 
   
    <body> 
   
    <form 
    action= 
    "http://127.0.0.1:8082/mysql" 
    method= 
    "POST" 
    onsubmit= 
    "return check(this)" 
    > 
   
     firstName: 
    <input 
     type= 
    "text" 
     name = 
    "name" 
     /><br/> 
   
     lastName: 
    <input 
     type= 
    "text" 
     name = 
    "age" 
     /> 
   
    <input 
    type= 
    "submit" 
    value= 
    "提交" 
     /> 
   
    </form> 
   
    <script> 
   
    function 
    check( 
    form){ 
   
    if( 
    form. 
    name. 
    value== 
    ''){ 
   
    alert( 
    '请输入名字'); 
   
    form. 
    name. 
    focus(); 
   
    return 
    false; 
   
     } 
   
    if( 
    form. 
    age. 
    value== 
    ''){ 
   
    alert( 
    '请输入年龄'); 
   
    form. 
    age. 
    focus(); 
   
    return 
    false; 
   
     } 
   
    return 
    true; 
   
     } 
   
    < 
    /script> 
   
    </body> 
   
    </html>

夏天咯

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
学node的一点小笔记（十三） node操作mysql

这里是做了一个增删改查的简单操作，mysql怎么安就不用我说了吧，id是自增字段 alter table user change id id int(10) auto_increment primary key;mysql.jsvar mysql =require('mysql');var connection =mysql.createConnection({ho
复制链接

扫一扫