Hi Friend,

You can use more than one prepared Statement object in the java class.Try the following code:

import java.sql.*;

public class JdbcPreparedstatementAddbatch {

public static void main(String args[]) {

Connection con = null;
PreparedStatement pst1 = null;
PreparedStatement pst2 = null;

String url = "jdbc:mysql://localhost:3306/";;
String db = "mysql";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "root";

try {

Class.forName(driver);
con = DriverManager.getConnection(url + db, user, pass);
pst1 = con.prepareStatement("update data set address=? where name =?");


pst1.setString(1, "Delhi");
pst1.setString(2, "angelina1");
pst1.addBatch();

pst1.setString(1, "Mumbai");
pst1.setString(2, "angelina2");
pst1.addBatch();

pst1.executeBatch();
pst1.close();
pst2 = con.prepareStatement("update data set address=? where name =?");


pst2.setString(1, "Agra");
pst2.setString(2, "AAAAA");
pst2.addBatch();

pst2.setString(1, "Chennai");
pst2.setString(2, "BBBBB");
pst2.addBatch();

pst2.executeBatch();
pst2.close();
con.close();

} catch (Exception e) {
e.printStackTrace();
}
}
}
Here we have taken two fields name and address of varchar type in the database table. We have used following methods.

1) set String ( ) - This method is used to set the value as string in place of question mark place holder.
2) addBatch ( ) - This method is used to add a set of parameter to the batch of command to this sql server prepared object.

3) execute Batch ( ) - This method is used to submit a set of command in sql query to the database, In case all the commands successfully, return you an array update count.

Thanks