{"id":2393,"date":"2020-10-21T14:57:54","date_gmt":"2020-10-21T05:57:54","guid":{"rendered":"https:\/\/www.agtech.co.jp\/actian\/?post_type=faq&#038;p=2393"},"modified":"2020-10-21T14:57:54","modified_gmt":"2020-10-21T05:57:54","slug":"13-201012","status":"publish","type":"faq","link":"https:\/\/www.agtech.co.jp\/actian\/faq\/13-201012\/","title":{"rendered":"Node.js \u304b\u3089 PSQL \u30c7\u30fc\u30bf\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u307e\u3059\u304b\uff1f"},"content":{"rendered":"PSQL \u306f Node.js \u304b\u3089\u306e ODBC \u306e\u30a2\u30af\u30bb\u30b9\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u307e\u3059\u3002<br>\r\n\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3067 ODBC \u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u5c0e\u5165\u3057\u3066\u304f\u3060\u3055\u3044\u3002\r\n<table class=\"base_tbl\">\r\n<tbody>\r\n<tr>\r\n<td>npm install odbc<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n\u30b5\u30f3\u30d7\u30eb\u30b9\u30af\u30ea\u30d7\u30c8(sample.js)\u306f\u3053\u3061\u3089\u306b\u306a\u308a\u307e\u3059\u3002(UTF8\u3067\u4fdd\u5b58\u3057\u3066\u304f\u3060\u3055\u3044\uff09\r\n<pre><code>\r\n-------------------------------\r\n\/\/\u63a5\u7d9a\u6587\u5b57\u5217\u3092\u5b9a\u7fa9\u3057\u3001DEMODATA\u3092\u958b\u304d\u307e\u3059\r\nvar db = require('odbc')()\r\n  ,cn = 'Driver={Pervasive ODBC Interface};server=localhost;dbq=demodata'\r\n  ;\r\n\r\ndb.open(cn, function (err) {\r\n    if (err) return console.log(err);\r\n\r\n    \/\/ DEMODATA \u306eROOM\u30c6\u30fc\u30d6\u30eb\u306b\u30c7\u30fc\u30bf\u3092\u683c\u7d0d\u3059\u308b\r\n    db.query(\"INSERT INTO room VALUES('\u90e8\u5c4b\u540d1', 1000, 1000, '\u30b5\u30f3\u30d7\u30eb')\", \r\n                                                    function (err, data) {\r\n        if (err) return console.log(err);\r\n            console.log(data);\r\n\r\n        \/\/ DEMODATA \u306eROOM \u30c6\u30fc\u30d6\u30eb\u3092\u8868\u793a\u3059\u308b\r\n        db.query(\"SELECT * FROM ROOM WHERE number &gt; 999\", \r\n                                                   function (err, data2) {\r\n            if (err) return console.log(err);\r\n                console.log(data2);\r\n        });\r\n\r\n        db.close(function () {\r\n            console.log('done');\r\n        });\r\n    });\r\n\r\n});\r\n-------------------------------\r\n<\/code><\/pre>\r\n\u672c\u30b9\u30af\u30ea\u30d7\u30c8\u3067\u306f\u3001\u30b3\u30f3\u30bd\u30fc\u30eb\u306b\u65e5\u672c\u8a9e\u6587\u5b57\u5217\u3092\u51fa\u529b\u3057\u3066\u3044\u307e\u3059\u3002<br>\r\n\u5b9f\u884c\u306e\u969b\u306b\u306f\u3001\u300cNode.js command prompt\u300d\u306e\u30b3\u30fc\u30c9\u30da\u30fc\u30b8\u3092 UTF8\uff0865001\uff09\u306b\u5909\u66f4\u3057\u3066\u304f\u3060\u3055\u3044\u3002\r\n<table class=\"base_tbl\">\r\n<tbody>\r\n<tr>\r\n<td>chcp 65001<br>\r\nnode sample.js<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n\u3053\u308c\u3067\u30b9\u30af\u30ea\u30d7\u30c8\u304b\u3089\u65e5\u672c\u8a9e\u6587\u5b57\u5217\u306e\u30ec\u30b3\u30fc\u30c9\u304c INSERT \u3055\u308c\u3001SELECT \u306b\u3088\u308a\u8868\u793a\u3055\u308c\u307e\u3059\u3002","protected":false},"featured_media":0,"parent":0,"template":"","faq_page":[28,23],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.agtech.co.jp\/actian\/wp-json\/wp\/v2\/faq\/2393"}],"collection":[{"href":"https:\/\/www.agtech.co.jp\/actian\/wp-json\/wp\/v2\/faq"}],"about":[{"href":"https:\/\/www.agtech.co.jp\/actian\/wp-json\/wp\/v2\/types\/faq"}],"wp:attachment":[{"href":"https:\/\/www.agtech.co.jp\/actian\/wp-json\/wp\/v2\/media?parent=2393"}],"wp:term":[{"taxonomy":"faq_page","embeddable":true,"href":"https:\/\/www.agtech.co.jp\/actian\/wp-json\/wp\/v2\/faq_page?post=2393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}