Answer:
Instead of executing a single query, we can execute a batch (group) of queries. It makes the performance fast. The java.sql.Statement and java.sql.PreparedStatement interfaces provide methods for batch processing. It gives the fast performance.
The addBatch() and executeBatch() methods are used to batch processing.
BatchExecuteStatement.java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class BatchExecuteStatement
{
//Declare database URL, username and password
public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:XE";
public static final String DBUSER = "local";
public static final String DBPASS = "test";
public static void main(String[] args)throws Exception
{
Class.forName ("oracle.jdbc.driver.OracleDriver");
//Creating connection
Connection con = DriverManager.getConnection (DBURL, DBUSER, DBPASS);
con.setAutoCommit(false);
// Executing the batch statement
Statement st=con.createStatement();
st.addBatch("insert into emp values (101,'jay','jay@gmail.com', 'Pune', 1)");
st.addBatch("insert into emp values(102,'satyam','satya@gmail.com', 'Mumbai', 1)");
st.addBatch("insert into emp values(103,'Shivam', 'shiv@gmail.com', 'Noida', 2)");
st.addBatch("insert into emp values(104,'sandy', 'sandy@gmail.com', 'Delhi', 2)");
int count[]=st.executeBatch();
con.commit();
for(int i=0;i <= count.length; i++)
{
if(count[i]!=0)
{
con.rollback();
break;
}
}
}
}
Output:
After running the program successfully. It inserts the given record into the “emp” table.
