February 2013
Intermediate to advanced
380 pages
7h 45m
Japanese
Content preview from Nodeクックブック
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
101
レシピ 4.2 MySQL サーバと接続し、SQL 文を実行する
quotes.js
if(params.author && params.quote) {
client.query('INSERT INTO quotes.quotes (' +
'author, quote) ' +
'VALUES(?, ?);', [params.author, params.quote]);
}
params
オブジェクトに格納された文字列を
mysql
モジュールが自動的にクリーニングした上で、
INSERT
文に挿入します。
client.query
の
2
つ目の引数として渡された配列の値をクエスチョン
マーク（
?
）に順番に代入します。
以上でデータベースに発言を追加する準備ができました。以下のコマンドを実行して結果を確認
してください。
% node quotes.js "
" "
"
ミニレシピ
4.2.2
MySQL
サーバから
SQL
文の実行結果を受け取る
レシピ
4.2.1
の
quotes.js
をさらに拡張し、コマンドの引数に発言者のみを渡した場合、データ
ベースに格納されているその発言者のすべての発言を出力するようにします。コマンドは以下のよ
うに実行します。
% node quotes.js "
"
INSERT
文を生成する
if
ブロックの後、
client.end
の前に次のコードを挿入します。
quotes.js
if(params.author) ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.