nodejs返回html代码引入路径问题+静态文件问题

最新推荐文章于 2023-03-29 22:00:13 发布

dongmelon

最新推荐文章于 2023-03-29 22:00:13 发布

阅读量3.9k

点赞数

文章标签： nodejs html

本文链接：https://blog.csdn.net/dongmelon/article/details/60956469

版权

node 专栏收录该内容

46 篇文章 0 订阅

订阅专栏

var express=require('express');
var app=express();
var path=require('path')  // 设置静态文件的服务
var mysql=require('mysql');
var url = require('url');
var qs = require('querystring');
var query='';
var html='';
app.use( express.static(path.join(__dirname, 'static'))); //设置静态文件的路径
console.log(path.join(__dirname,'static'))//c:/user/184/desktop/static 表示静态文件只要放在桌面的文件夹static下面就可以被引用了
app.get('/products',function(req,res){
	console.log(req);
    res.writeHead(200,{'Content-Type':'text/html','Access-Control-Allow-origin':'*'});
    console.log(req.url)// '/products?SN=2010191'
    query=url.parse(req.url,true).query;
    var SN=query.SN
    var conn=mysql.createConnection({
                host:'127.0.0.1',
                user:'root',
                password:'',
                port:'3306',
                database:'langjie'
            })
    conn.query('select * from products where SN='+SN,function(err,rows,fileds){
                html=`<!doctype html>
                    <html lang="en">
                     <head>
                      <meta charset="UTF-8">
                      <meta name="Generator" content="EditPlus®">
                      <meta name="Author" content="">
                      <meta name="Keywords" content="">
                      <meta name="Description" content="">
                      <title>Document</title>
                      <style type="text/css">

                            button{
                                padding:0;
                                width:20%;
                                margin-right:20%;
                                font-size:20px;
                                border-radius:5px;
                            }
                            .btn1{
                                margin-left:20%;
                            }
                      </style>
                     </head>
                     <body>
                          <div> <a href="">产品列表</a> > <a href="">代龙700</a></div>
                          <div><img src="images/2010191.png" width="50%"/></div>
                          <div>序列号：<span id="SN">${rows[0].SN}</span></div>
                          <hr />
                          <div>型号：<span id="Model">${rows[0].Model}</span></div>
                          <hr />
                          <div>生产日期：<span id="MakeDate">${rows[0].MakeDate}</span></div>
                          <hr />
                          <div>类型码：<span id="Type">${rows[0].Type}</span></div>
                          <hr />
                          <div>用户码：<span id="User">${rows[0].UserCode}</span></div>
                          <hr />
                          <div>注册起止日期：<span id="Valid">${rows[0].Valid}</span></div>
                          <hr />
                          <div>授权码：<span id="Lic">${rows[0].Lic}</span></div>
                          <hr />
                          <div>机器号：<span id="Cid">${rows[0].Cid}</span></div>
                          <hr />
                          <div>注册码：<span id="Key">${rows[0].PollCode}</span></div>
                          <hr />
                          <div>标比：<span id="CaliCoeff">${rows[0].CaliCoeff}</span></div>
                          <hr />
                          <div>固件版本号：<span id="FirmVer">${rows[0].FirmVer}</span></div>
                          <hr />
                          <button class="btn1">注册</button><button>详细</button>
                          
                          
                     </body>
                    </html>
                    `
                res.write(html);
	         res.end();  // 这个要有不然一直转圈表示响应结束
            })




})
app.listen(8888)