Breaking News: Grepper is joining You.com. Read the official announcement!

Write about BatchPreparedStatementSetter?

Anjali Sharma answered on January 9, 2023 Popularity 1/10 Helpfulness 1/10

answer Write about BatchPreparedStatementSetter?

Write about BatchPreparedStatementSetter?

Comment

BatchPreparedStatementSetter is used to update more than a single row in one go, they can use BatchPreparedStatementSetter.

This interface provides two methods they are

setValues( PreparedStatement ps, int i) throws SOL exception

int getBatchSize

public class MainApp {
   public static void main(String[] args) {
      ApplicationContext context = new ClassPathXmlApplicationContext("Beans.xml");

      StudentJDBCTemplate studentJDBCTemplate = (StudentJDBCTemplate)context.getBean("studentJDBCTemplate");

      List<Student> initialStudents = studentJDBCTemplate.listStudents();
      System.out.println("Initial Students");
      
      for(Student student2: initialStudents){
         System.out.print("ID : " + student2.getId() );
         System.out.println(", Age : " + student2.getAge()); 
      }
      Student student = new Student();
      student.setId(1);
      student.setAge(10);

      Student student1 = new Student();
      student1.setId(3);
      student1.setAge(10);

      List<Student> students = new ArrayList<Student>();
      students.add(student);
      students.add(student1);

      studentJDBCTemplate.batchUpdate(students);

      List<Student> updatedStudents = studentJDBCTemplate.listStudents();
      System.out.println("Updated Students");
      
      for(Student student3: updatedStudents){
         System.out.print("ID : " + student3.getId() );
         System.out.println(", Age : " + student3.getAge()); 
      }
   }
}

https://www.tutorialspoint.com/springjdbc/springjdbc_batch_operation.htm

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: Grepper

Tags: javascript

Link to this answer
Share Copy Link

Contributed on Jan 09 2023

Anjali Sharma

0 Answers Avg Quality 2/10

Write about BatchPreparedStatementSetter?

Contents

More Related Answers

Write about BatchPreparedStatementSetter?

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.