大螃嗨

好记性不如烂笔头

用户工具

站点工具


nodejs

版本升级

先清除 npm cache npm cache clean -f

安装n模块 npm install -g n

然后就可以开始升级了:自动安装到最新的稳定版本命令是 n stable,自由选择版本安装是n 4.4.0(版本号)

备注:升级前后可先使用node -v 查看版本。查看所有node版本是n ls

链接Oracle

npm i oracledb

下载安装Oracle Client: https://www.oracle.com/database/technologies/instant-client/downloads.html

var oracledb = require("oracledb");
(async ()=>{
	try{
		await oracledb.createPool({
		        _enableStats: true,
		        user: 'xxxxx',
		        password: 'xxxxx',
		        connectString: 'IP:PORT/orcl',
		        poolAlias: "pangxiepool"
	      });
	     var connection =  await oracledb.getPool('pangxiepool').getConnection();
	console.log('connection');
console.log(connection);
	     var result = await connection.execute('select * from EZR_TRANS WHERE rownum<10');
console.log('result');
console.log(result);
	     await connection.close();
	     console.log(result)
	}catch(err){
	    console.log(err.message)
	}
})();

跨域

$ npm install cors

Usage Simple Usage (Enable All CORS Requests)

var express = require('express')
var cors = require('cors')
var app = express()
 
app.use(cors())
 
app.get('/products/:id', function (req, res, next) {
  res.json({msg: 'This is CORS-enabled for all origins!'})
})
 
app.listen(80, function () {
  console.log('CORS-enabled web server listening on port 80')
})

安全证书

var oracledb = require("oracledb");
var express = require('express')
var cors = require('cors')
var https = require('https')
var http = require('http')
var server = express()
var fs = require('fs')
//使用跨域中间件
server.use(cors());
var options = {
	key: fs.readFileSync('./biapi.re-blue.com.key'),
	cert: fs.readFileSync('./biapi.re-blue.com.pem'),
}
console.log(options)
http.createServer(server).listen(80);
https.createServer(options, server).listen(443);
console.log('启动成功...')

相关概念

nodejs.txt · 最后更改: 2020/10/18 05:58 由 螃蟹