Home Tutorial Java Jdbc JDBC Batch Update Example

 
 

Share on Google+Share on Google+
JDBC Batch Update Example
Posted on: October 23, 2010 at 12:00 AM
Advertisement
In this JDBC tutorial you will learn how to update data in batch.

Batch Update Example

You can update data in a table batch. To update in batch at first you need set connection autoCommit fale mode then add the query string in batch as

String updateQuery1 = "INSERT INTO student VALUES(4,'Raman','B.Tech','Betiah')";
statement.addBatch(updateQuery1);

and finally commit the connection. An example of batch update is given below

 

BatchupdateExample.java

package roseindia.net;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class BatchupdateExample {
	Connection connection = null;
	static int roll;

	public BatchupdateExample() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			System.out.println(e.toString());
		}
	}

	public Connection getConnection() throws SQLException {
		connection = DriverManager.getConnection(
				"jdbc:mysql://localhost:3306/student", "root", "root");

		return connection;
	}

	public static void main(String[] args) throws Exception {
		BatchupdateExample updateableResultSet = new BatchupdateExample();
		Connection conn = updateableResultSet.getConnection();
		Statement statement = conn.createStatement(
				ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
		conn.setAutoCommit(false);
		String updateQuery1 = "INSERT INTO student VALUES(12,'Raman','B.Tech','Betiah')";
		statement.addBatch(updateQuery1);
		String updateQuery2 = "INSERT INTO student VALUES(13,'Kanhaiya','M.Tech','Delhi')";
		statement.addBatch(updateQuery2);
		String updateQuery3 = "INSERT INTO student VALUES(14,'Tinkoo','MBA','Alligarh')";
		statement.addBatch(updateQuery3);
		String updateQuery4 = "INSERT INTO student VALUES(11,'Pawan','BBA','Darbhanga')";
		statement.addBatch(updateQuery4);
		statement.executeBatch();
		String query = "SELECT * FROM student";
		ResultSet rs = statement.executeQuery(query);
		conn.commit();
		while (rs.next()) {
			System.out.println(rs.getInt(1) + ":" + rs.getString(2) + ":"
					+ rs.getString(3) + ":" + rs.getString(4));
		}
		rs.close();
		statement.close();
		conn.close();
	}
}
When you run this application it will display message as shown below:

1:Java:MCA:Motihari
2:Ravi:BCA:Patna
3:Mansukh:M.Sc:Katihar
4:Raman:B.Tech:Betiah
5:Kanhaiya:M.Tech:Delhi
6:Tinkoo:MBA:Alligarh
7:Pawan:BBA:Darbhanga
8:Ram:BCA:Patna
9:Data Structures:Program:LaheriaSarai
11:Pawan:BBA:Darbhanga
12:Raman:B.Tech:Betiah
13:Kanhaiya:M.Tech:Delhi
14:Tinkoo:MBA:Alligarh

Download this example code

Advertisement

Related Tags for JDBC Batch Update Example:


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: October 23, 2010

Recommend the tutorial

Advertisements Advertisements
 

 

 

DMCA.com