Created
October 15, 2019 04:28
-
-
Save amogh9594/82174413b35073fdc2380dccd457ce0b to your computer and use it in GitHub Desktop.
Batch Processing
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import java.sql.Connection; | |
import java.sql.DriverManager; | |
import java.sql.Statement; | |
public class add_batch { | |
public static void main(String [] args) { | |
try { | |
Class.forName("oracle.jdbc.OracleDriver"); | |
System.out.println("Sucessfully loaded drivers"); | |
Connection conn=DriverManager.getConnection | |
("jdbc:oracle:thin:@//localhost:1521/orcl","hr","hr"); | |
System.out.println("Sucessfully Connected"); | |
Statement st = conn.createStatement(); | |
String SQL="INSERT INTO COMPANY_1 values(8,'NIIT') "; | |
st.addBatch(SQL); | |
SQL="INSERT INTO COMPANY_1 values(9,'TATA MOTORS') "; | |
st.addBatch(SQL); | |
SQL="INSERT INTO COMPANY_1 values(10,'Mahindra') "; | |
st.addBatch(SQL); | |
st.executeBatch(); | |
System.out.println("Record ADDed"); | |
conn.close(); | |
} | |
catch(Exception e){ | |
e.printStackTrace(); | |
} | |
} | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import java.sql.Connection; | |
import java.sql.DriverManager; | |
import java.sql.PreparedStatement; | |
public class pre_batch { | |
public static void main(String [] args) { | |
try { | |
Class.forName("oracle.jdbc.OracleDriver"); | |
System.out.println("Sucessfully loaded drivers"); | |
Connection conn=DriverManager.getConnection | |
("jdbc:oracle:thin:@//localhost:1521/orcl","hr","hr"); | |
System.out.println("Sucessfully Connected"); | |
String SQL ="INSERT INTO company_1 values(?,?)"; | |
PreparedStatement pstmt=conn.prepareStatement(SQL); | |
pstmt.setString(1, "11"); | |
pstmt.setString(2, "Tata Tea"); | |
pstmt.addBatch(); | |
pstmt.setString(1, "12"); | |
pstmt.setString(2, "Jio"); | |
pstmt.addBatch(); | |
int[] count=pstmt.executeBatch(); | |
System.out.println("Record ADDed :"+count.length); | |
conn.close(); | |
} | |
catch(Exception e){ | |
e.printStackTrace(); | |
} | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment