9)Write a JDBC Program that adds many records at a time using Prepared Statement.

 source file name :  PrepareLoop.java

import java.sql.*;

class PrepareLoop

{

public static void main(String as[])

{

System.out.println("JDBC Program");

String names[]={"ram","kavita","soham","savita","sana"};

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con=DriverManager.getConnection("jdbc:odbc:javadsn");

PreparedStatement psst=con.prepareStatement("insert into stud values(?,? )");

int i=0;

int rn=511;

for(int cnt=1;cnt<=5;cnt++)

{

psst.setInt(1,rn);

psst.setString(2,names[i]);

psst.executeUpdate();

rn++;

i++;

}

con.close();

psst.close();

}

catch(Exception e)

{

System.out.println(e );

}

}

}

output: