When something is important enough, you do it even if the odds are not in your favor.”
Elon Musk
Oh man I totally forgot to do this blog post. I apologize for this being super brief.
- When coding a Java program that will perform a SELECT statement that return multiple rows, what are the steps needed? The first is to make a connection to the database and the last is close the connection. What are the other steps?
– Java needs to import JDBC packages and also load and register the JDBC driver. JDBC stands for Java database connection here. Once these above steps are done properly, we will have a successful connection.
2. What is a parameterized SQL statement?
– A parameterized SQL statement or query is a pre-compiling statement set that is provided by a user that needs to be inserted into the statement for it to be executed.
3. Do a google search for “SQL injection attack”. What is an “injection attack” and how do parameterized statements help to prevent such security attacks
– An SQL-Injection attack is when a malicious user enters a fragment of SQL or a fragment of code that may cause problems when the string is processed by the DBMS or fetched and re displayed at the browser rather than entering their first name.
jeanniecodes 