import
java.sql.Connection;
import
java.sql.DriverManager;
import
java.sql.PreparedStatement;
import
java.sql.ResultSet;
import
java.sql.Statement;
import
java.util.*;
public
class
AddBatchCommand {
public
static
void
main(String args[])
{
Scanner scan =
new
Scanner(System.in);
try
{
Class.forName(
"oracle.jdbc.OracleDriver"
);
Connection con = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe"
,
"username"
,
"password"
);
String sql1
=
"CREATE TABLE STUDENTS(STUDENTID VARCHAR2(10) PRIMARY KEY,NAME VARCHAR2(20),DEPARTMENT VARCHAR2(10))"
;
PreparedStatement ps
= con.prepareStatement(sql1);
ps.execute(sql1);
String sql
=
"Insert into Students values(?,?,?)"
;
PreparedStatement ps1
= con.prepareStatement(sql);
for
(
int
i =
0
; i <
3
; i++) {
System.out.println(
"Enter Student ID"
);
String id = scan.nextLine();
System.out.println(
"Enter Student Name"
);
String name = scan.nextLine();
System.out.println(
"Enter the Department"
);
String dept = scan.nextLine();
ps1.setString(
1
, id);
ps1.setString(
2
, name);
ps1.setString(
3
, dept);
ps1.addBatch();
}
ps1.executeBatch();
ResultSet rs
= ps.executeQuery(
"Select * from Students"
);
System.out.println(
"StudentID\tName\t\tDepartment"
);
System.out.println(
"-------------------------------------------------------"
);
while
(rs.next()) {
System.out.println(rs.getString(
1
) +
"\t\t"
+ rs.getString(
2
)
+
"\t\t"
+ rs.getString(
3
));
}
con.commit();
con.close();
}
catch
(Exception e) {
System.out.println(e);
}
}
}