Cool Video Tutorial explaining SQL Injection and protecting methods...(For sites written in JSP and Servlets). File size: 35064 KB http://rapidshare.com/files/2272011...step_by_step_video_tutorial_demonstration.wmv
The most common methods to prevent this kind of SQL injection vulnerability are to check the user's input for dangerous characters like single-quotes; and using prepared statements, which tell the database exactly what to expect before any user-provided data is passed to it. Enjoy...