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.
100
4 章 データベース接続
ミニレシピ
4.2.1
ユーザ入力をクリーニングして
SQL
インジェクション攻撃を防ぐ
他の言語やプラットフォームで文字列を組み合わせて
SQL
文を生成する場合と同様に、
Node
で
SQL
文を生成する場合も、
SQL
インジェクション攻撃からサーバを守らなければなりません。
基本的にはユーザが入力したデータはすべてクリーニングを行い（つまり、エスケープ処理を行
い ）、
SQL
インジェクション攻撃の可能性を排除する必要があります。
幸いなことに、
mysql
モジュールには入力値のクリーニング機能が用意されています。ここでは
その機能を使って、コマンドラインで入力された引数を安全にデータベースに入力するスクリプト
を作成します。
新しいディレクトリを作成し、レシピ
4.2
の
mysql.js
を
quotes.js
にコピーしておき、
mysql
モジュールをインストールします。ここではシンプルな入力方法として、コマンドラインの引数
をユーザ入力として扱います。通常は
GET
リクエストのクエリストリングや
POST
リクエストの
データなどが入力値になりますが、入力ルートは違っていても、入力値のクリーニングの原則は変
わりません。
コマンドは以下のように実行します。
% node quotes.js "
" "
"
コマンドライン引数を分割する場合、引数のダブルクォート記号は必須となります。ここでは
コードの簡潔さを優先するため、引数のバリデーションは行いません。
...
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.