nodejs之mysql查询

最新推荐文章于 2024-06-13 00:09:31 发布

子义间

最新推荐文章于 2024-06-13 00:09:31 发布

阅读量635

点赞数

分类专栏： nodejs

本文链接：https://blog.csdn.net/D_Z_Yong/article/details/101354406

版权

nodejs 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

第一

var mysql = require('mysql');
var http = require('http');
var url=require("url")
var connection = mysql.createConnection({
    host     : 'localhost',
    user     : 'root',
    password : '密码',
    port: '3306',
    database: '数据库表'
});

http.createServer(function (request, response) {
    response.writeHead(200, {'Content-Type': 'text/plain;charset=utf-8'});
    var b='';
    var  sql = 'SELECT * FROM t';
        connection.query(sql, function (err, result) {
            if (err) {
                console.log('[SELECT ERROR] - ', err.message);
            } else {
                result = JSON.stringify(result);//把results对象转为字符串，去掉RowDataPacket
                // result = JSON.parse(result);//把results对象转为字符串，去掉RowDataPacket
                response.end(result);
            }
        });
}).listen(8888);
// 终端打印如下信息
console.log('Server running at http://127.0.0.1:8888/');

第二

html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
    <script src="https://cdn.staticfile.org/jquery/2.2.1/jquery.min.js"></script>
    <script>
        $("document").ready(function () {
            $('#btm').click(function () {
                //var script =document.createElement("script");
                //script.src=" http://127.0.0.1:8888/?callback=show"
                //document.body.appendChild(script);
                //用ajax实现jsonp
                $.ajax({
                    url:" http://127.0.0.1:8888",
                    type:"get",
                    dataType:"jsonp",
                    success:function (data) {
                        console.log(data)
                    }
                })
            });
        })
    </script>
</head>
<body>
<button id="btm">点我啊</button>
</body>
</html>

server.js 运行时先要跑node server.js

var mysql = require('mysql');
var http = require('http');
var url=require("url")
var connection = mysql.createConnection({
    host     : 'localhost',
    user     : 'root',
    password : '密码',
    port: '3306',
    database: '数据库'
});
http.createServer(function (request, response) {
    var Url=url.parse(request.url,true)//获取url对象
    var callback=Url.query.callback;//获取url地址栏的？后面名字为callback的参数
    // 发送 HTTP 头部
    // HTTP 状态值: 200 : OK
    // 内容类型: text/plain
    response.writeHead(200, {'Content-Type': 'text/plain;charset=utf-8'});

    var b='';
    var  sql = 'SELECT * FROM t';
        connection.query(sql, function (err, result) {
            if (err) {
                console.log('[SELECT ERROR] - ', err.message);
            } else {
                var  res = JSON.stringify(result);//把results对象转为字符串，去掉RowDataPacket
                // res = JSON.parse(res);//把results字符串转为对象
                // console.log(res)
                // response.end(`${callback}("${res}")`);
                // response.end(`${res}`)
                response.end(callback+"("+res+")")
            };
        });
}).listen(8888);

// 终端打印如下信息
console.log('Server running at http://127.0.0.1:8888/');

子义间

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
nodejs之mysql查询

var mysql = require('mysql');var http = require('http');var url=require("url")var connection = mysql.createConnection({ host : 'localhost', user : 'root', password : '123123', ...
复制链接

扫一扫

专栏目录