Prevention of SQL Injection attack on web applications

The good news is that there is actually a lot that website owners can do to prevent SQL Injection. The bad news is that there is not one complete, foolproof solution to database security: