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

Q) Retrieving data from database?

A)   ->to retrieve the data from database we need to submit SELECT statement from JDBC application. -> executeQuery() method of statement object is used for this purpose. This method has the fallowing ResultSet executeQuery(String sql) throws SQLException Ex: ResultSet rs = st.executeQuery(“SELECT * FROM ACCOUNT”); ->objectoriented representation of tables formate data is called ResultSet object. Ao the driver created one object i.e. ResultSet object. ->object orientation representation of a table of records returned from db is nothing but “ ResultSet ” object.  
Post a Comment
Read more

Q) What is the purpose of JDBC?

A) -> Java application can do any task by making a method (function) call. ->java method calls are not understandable to database management system. They can understand only SQL statements. ->SQL statements can’t be directly used in a java application. Java compiler complains. ->therefore, we say that java environment and database environment are heterogeneous to each other. Purpose of JDBC: ->for any kind of java application to communicate with any kind of database (management system) in a standard manner, JDBC is used.
Post a Comment
Read more