java jdbc batch | batch execution | batch processing | okay java смотреть онлайн

java jdbc batch | batch execution | batch processing | okay java
Buy me a coffee - https://www.buymeacoffee.com/okayjava
download the source code
https://gitlab.com/okay-java/mysql-jdbc.git

Steps
Step -1 : Register the driver
The forName() method of Class is used to register the driver class (dynamically load the driver class)
Step-2 : Create the database connection
The getConnection() method of DriverManager class is used to establish connection with the database.
Step-3 : Set auto commit to false con.setAutoCommit(false);
Step-4 : Create the statement or prepared statement object
The createStatement() method of Connection interface is used to create statement..
Step-5: Write SQLs
String sql1 = "insert into user values (1, 'david', 'gill', '[email protected]', 'gill@1234', '1991-10-25', 'M')";
String sql2 = "insert into user values (2, 'watson', 'light', '[email protected]', 'ligh@1234', '1985-11-25', 'M')";
String sql3 = "insert into user values (3, 'kara', 'joraell', '[email protected]', 'kara@1234', '1987-12-25', 'F')";
String sql4 = "update user set firstname='supergirl' where id = 3";
String sql5 = "delete from user where id = 1";
String sql6 = "insert into user values (4, 'okay', 'java', '[email protected]', 'okay@1234', '1987-12-25', 'M')";

Step-6 : Add SQLs to batch by using addBatch()
Step-7 : Run the batch by calling executeBatch()
Step-8 : Commit the transaction to the database by calling commit() function
Step-9 : Close the database connection
The close() method of Connection interface is used to close the connection.

Download mysql driver
https://dbschema.com/jdbc-driver/MySql.html

Login to mysql database server
mysql -u root -p

--- create database
create database userdb;
use userdb;

create table user(id int not null auto_increment,
firstname varchar(50),
lastname varchar(50),
email varchar(50),
password varchar(10),
birth_date date,
gender char(1),
primary key(id));

show tables;
describe user;
insert into user values (1, 'adam', 'kia', '[email protected]', 'abcd@1234', '2021-12-25', 'M');
insert into user values (2, 'david', 'gill', '[email protected]', 'gill@1234', '2021-10-25', 'M');
insert into user values (3, 'watson', 'light', '[email protected]', 'ligh@1234', '2021-11-25', 'M');
insert into user values (4, 'kara', 'joraell', '[email protected]', 'kara@1234', '2021-12-25', 'M');
insert into user values (5, 'alex', 'danvers', '[email protected]', 'alex@1234', '2021-12-25', 'M');