Skip to main content

Q) Develop a JDBC application that deletes all the employees from the db. Make use of pure JDBC approach of connectivity



A)
import java.sql.*;
class EmplyeeRemoval {

       public static void main(String[] args) throws Exception{
              Class.forName("oracle.jdbc.driver.OracleDriver");
              Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:server","scott","tiger");
              Statement st = con.createStatement();
              int rc = st.executeUpdate("DELETE FROM EMPLOYEE");
              System.out.println(rc+"employees are fired");
              st.close();
              con.close();
       }

}

Explanation:
->in the above program execute operation is a method call that is called by main method. The main method calling the execute Update method on the statement object.
->when the deletion statement is executed the all rows are deleted in the database. But in the DML commands are saved when we executed commit; statement in the oracle prompt but we are not used commit; statement in the java program. Because the connection is opened in the auto connection enabled mode.
->“auto connect enabled mode” the connection is opened so that’s why changes are maid permanently.
->”clear scr” is used to clear the oracle prompt.

Comments

Post a Comment

Popular posts from this blog

Q) Explain repeated deletion of records.

A) //RepeatedDeletion.java import java.util.Scanner; import java.sql.*; class RepeatedDeletion {        public static void main(String[] args) {               Connection con= DriverManager. getConnection ( "jdbc:odbc:prince" , "scott" , "tiger" );               PreparedStatement ps=con.PreparedStatement( "DELETE FROM ACCOUNT WHERE ACCNO=?" );               Scanner s= new Scanner(System. in );               while ( true )               {                      System. out .println( "Enter accno : " );      ...
Post a Comment
Read more

Introduction

1) What is not JDBC? 2) What is the purpose of JDBC? 3) What is ODBC? 4) What is JDBC? 5) What is JDBC architecture? 6) What is JDBC client? What are its responsibilities? 7) What is JDBC API?  8) What is driver manager? 9) What is JDBC driver? What is its role in java database connection? 10) What is database server?
Post a Comment
Read more

Q) Explain about nested classes?

A) ->defining a class with in another class is known as nesting of the class. Ex: class A {        class B        {                      } //nested class, and inner class.because it is not static class. } //enclosing class or outer class. ->static class is declared in inside an another class then it does not become an inner class. Note: non-static nested class is known as “inner class”. In the above example class B is nested but not an inner class. Ex: class D {        static c        {                      } //nested class, but not an inner class , because of static class. } //outer class. ->we have three different kinds of inner classes. 1) Member inner class 2) Meth...
Post a Comment
Read more