Home Java Batch Program in Java JDBC

Batch Program in Java JDBC

1 min read
0
0
425

The group of update statements that are sent to a database to be executed as a single unit called batch in java.

import java.sql.*;
public class Batch{

	public static void main(String[] args)
	{
		Connection con=null;

    try{

        Class.forName("com.mysql.jdbc.Driver");
        con = DriverManager.getConnection("jdbc:mysql://localhost/vbank","root","");    
		Statement st1=con.createStatement( );		
		String SQL1="insert into account (accno,bal) values('A0008',2500) ";

		String SQL2="insert into account (accno,bal) values('A0009',1500) ";

		String SQL3="update account set bal=1300 where accno='A0006' ";

		String SQL4="delete from account where accno='A0005' ";

		st1.addBatch(SQL1);
		st1.addBatch(SQL2);
		st1.addBatch(SQL3);
		st1.addBatch(SQL4);

		int[ ] status= st1.executeBatch( );

		for(int i=0;i<status.length;i++)
		{
		   System.out.println( status[ i ] );
		 }

		}
        catch (Exception e) 
         {
			System.out.println(e);
	     }
	}
	}


I have attached the video tutorial below it will help you  to do this  step by step.

 

  • Java String Methods

    Java provides a rich set of built-in methods for handling String operations efficiently. S…
  • Is Java Hard to Learn?

    Is Java Hard to Learn is it True? Java is one of the most popular programming languages in…
  • How to generate random with weight java

    Generating Random Numbers with Weights in Java Random number generation with weighted prob…
Load More Related Articles
  • Conditional Statements in Python

    Conditional statements in Python allow us to control the flow of execution based on condit…
  • Java Beans

    A Java Bean is a reusable software component that follows a specific set of conventions. J…
  • Java String Methods

    Java provides a rich set of built-in methods for handling String operations efficiently. S…
Load More By admin
  • Java Beans

    A Java Bean is a reusable software component that follows a specific set of conventions. J…
  • Java String Methods

    Java provides a rich set of built-in methods for handling String operations efficiently. S…
  • Java Developer Jobs

    Java remains one of the most in-demand programming languages worldwide, powering everythin…
Load More In Java

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also

Conditional Statements in Python

Conditional statements in Python allow us to control the flow of execution based on condit…