Question

10. a. Write a short Java Program that shows how SQL commands and JDBC can be used to connect the two. (See JDBC/ODBC Connections Lecture Notes 'CS267- SQL Injection, Security, and JDBC') b. Write a short paragraph 3-4 lines about the dangers of techniques like SQL Injection. 5 PT BONUS: Find the names of all the managers who manage more than 10 employees. [Hint: Can use Nested Select OR Group By... Having]

Answer 1

// import sql libraray
import java.sql.*;
class databaseConnection{
public static void main(String args[]){
try{
   // register the drivers
   Class.forName("com.mysql.jdbc.Driver");
   // create the connection instance
   // do fill the username and password,port number as of your database
   Connection con=DriverManager.getConnection("jdbc:mysql://localhost:portNumber","username","password");
   // create the statment to execute the query
   // different types of sql statements are avaiable
   // callable,prepared,statment
   Statement stmt=con.createStatement();
   // resultset instance to hold the result of query
   ResultSet rs=stmt.executeQuery("select * from emp");
   // rs.next is pointer the rows of result
   // we can move along each row by calling rs.next()
   while(rs.next())
   // getString ,getInt(),getDouble() are differet method to get the column value
   // so you must aware of the datatype of column otherwise exception is thrown
   System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getDouble(3));
   // colse the connection
   con.close();
   }
   catch(Exception e){
       // any wxception inside the class ishandled here
       System.out.println(e);
       }
   }
}

Sal Pnfection s an attack that at on tPthey it Corments Aynamic sl stulerent down me Sa) code (or adel statemnns B that dumys are Me attackors to esccute ralicicus sQ2 cade jeeflon attacks SAL VThe Ye avc peeeiblk Hype acessing Checlantils dieleing data nsotngdaty Opeleting da fe pit daber has to beon alidlateal Sure it is fee fro s)jection pavent attacbts (2 C The to Malee mis ay Can SL salect Manages (Remplyes count (eaployers) Count mplayee. group ly haudng (Emphyees) count