batch in jdbc
In Batch processing, many queries work together as batch,run query in batch in java jdbc.
In Batch processing, many queries work together as batch,run query in batch in java jdbc.
JDBC BATCH PROCESSING
In Batch processing, many queries work together as batch.
The following program include collective set of SQL queries executed altogether
to the database.".addBatch()" method is used to add query in "Statement" object
and "executeBatch()" method is used to run all queries altogether.
sqlbatch.java
import java.sql.*;
public class sqlbatch {
public static void main(String args[]) {
Connection con = null;
Statement st = null;
ResultSet rs = null;
String url = "jdbc:mysql://192.168.10.13:3306/";
String db = "ankdb";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "root";
try {
Class.forName(driver);
con = DriverManager.getConnection(url + db, user, pass);
st = con.createStatement();
st.addBatch("INSERT INTO cellular " +
"VALUES('3036','9560534071')");
st.addBatch("INSERT INTO cellular " +
"VALUES('3037','9560534072')");
st.addBatch("INSERT INTO cellular " +
"VALUES('3038','9560534073')");
st.executeBatch();
String sql = "select * from cellular ";
rs = st.executeQuery(sql);
System.out.println("ID \tMOBILE");
while (rs.next()) {
System.out.print(rs.getInt(1) + " \t");
System.out.println(rs.getString(2));
}
rs.close();
st.close();
con.close();
} catch (Exception e) {
e.printStackTrace();
}
}
} |
output
Download this Code