import
java.io.*;
import
java.sql.*;
import
java.sql.SQLException;
import
java.sql.DriverManager;
import
java.sql.Connection;
import
java.sql.ResultSet;
import
java.sql.Statement;
import
java.sql.PreparedStatement;
import
java.sql.Date;
class
GFG {
static
String DB_URL
=
"jdbc:oracle:thin:@localhost/my_database_"
;
static
String DB_USER =
"local"
;
static
String DB_PASSWORD =
"test"
;
public
static
void
main(String args[])
{
try
{
Class.forName(
"oracle.jdbc.driver.OracleDriver"
);
Connection conn = DriverManager.getConnection(
DB_URL, DB_USER, DB_PASSWORD);
conn.setAutoCommit(
false
);
String sql_
=
"INSERT INTO Employee (empid, empname) VALUES (?, ?)"
;
PreparedStatement ps
= conn.prepareStatement(sql_);
BufferedReader br =
new
BufferedReader(
new
InputStreamReader(System.in));
while
(
true
) {
System.out.print(
"Enter emp_Id: "
);
String s_1 = br.readLine();
int
empid = Integer.parseInt(s_1);
System.out.print(
"Enter emp_name: "
);
String name = br.readLine();
ps.setInt(
1
, empid);
ps.setString(
2
, name);
ps.executeUpdate();
System.out.println(
"commit or rollback"
);
String answer = br.readLine();
if
(answer.equals(
"commit"
)) {
conn.commit();
}
if
(answer.equals(
"rollback"
)) {
conn.rollback();
}
System.out.println(
"Do you want to include more records"
);
System.out.println(
"\n yes/no"
);
String answ = br.readLine();
if
(answ.equals(
"no"
)) {
break
;
}
}
conn.commit();
System.out.println(
"record is successfully saved"
);
conn.close();
}
catch
(Exception exc) {
exc.printStackTrace();
}
}
}