import
java.sql.Connection;
import
java.sql.DriverManager;
import
java.sql.ResultSet;
import
java.sql.ResultSetMetaData;
import
java.sql.Statement;
public
class
GFG {
public
static
void
main(String args[])
{
try
{
Class.forName(
"oracle.jdbc.OracleDriver"
);
Connection con = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe"
,
"username"
,
"password"
);
Statement s = con.createStatement();
String sql1
=
"CREATE TABLE ACADEMY(COURSE_ID VARCHAR2(20) PRIMARY KEY, COURSE_NAME VARCHAR2(20),MENTOR VARCHAR2(20),COURSE_FEE NUMBER)"
;
String sql2
=
"INSERT INTO ACADEMY VALUES('C101','MATH','ROBERT',5000)"
;
String sql3
=
"INSERT INTO ACADEMY VALUES('C102','PHYSICS','JANE',8000)"
;
String sql4
=
"INSERT INTO ACADEMY VALUES('C103','HISTORY','ADAM',6000)"
;
String sql5
=
"INSERT INTO ACADEMY VALUES('C104','BIOLOGY','MARIE',5000)"
;
String sql6
=
"INSERT INTO ACADEMY VALUES('C105','ENGLISH','ALBERT',3000)"
;
s.addBatch(sql1);
s.addBatch(sql2);
s.addBatch(sql3);
s.addBatch(sql4);
s.addBatch(sql5);
s.addBatch(sql6);
s.executeBatch();
ResultSet rs
= s.executeQuery(
"SELECT * FROM ACADEMY"
);
while
(rs.next()) {
System.out.println(
rs.getString(
1
) +
"\t\t"
+ rs.getString(
2
) +
"\t\t"
+ rs.getString(
3
) +
"\t\t"
+ rs.getString(
4
));
}
ResultSetMetaData rsMetaData = rs.getMetaData();
System.out.println(
"List of column names in the current table: "
);
int
count = rsMetaData.getColumnCount();
for
(
int
i =
1
; i& lt; = count; i++) {
System.out.print(rsMetaData.getColumnName(i)
+
"\t"
);
}
con.commit();
con.close();
}
catch
(Exception e) {
System.out.println(e);
}
}
}