1.4               java.sql  Package

This package provides the APIs for accessing and processing data which is stored in the relational database by using the java programming language. It includes a framework where different drivers can be installed dynamically to access different databases.

This java.sql package contains API for the following operations:

·        Loading Driver

      try {           

            Class.forName("com.mysql.jdbc.Driver");

        } catch (ClassNotFoundException ex) {

            ex.printStackTrace();

        }

·        Establishing Connection

      try {

           Connection   con=DriverManager.getConnection(url, "root", "root");           

        } catch (SQLException ex) {ex.printStackTrace();}  

·        Executing Statements

      Statement st = con.createStatement();

      ResultSet rs = st.executeQuery("SELECT * FROM  MyTable");

·        Getting Results

      try {

      System.out.println("MyTable: " );

      while (rs.next()) {                       

                      System.out.println(rs.getInt("keyCode"));

                      System.out.println(rs.getString("firstName"));

                      System.out.println(rs.getString("employee_name"));

                }

              } catch (SQLException ex) {ex.printStackTrace();}  

·        Updating row

     try {   rs.absolute(4);

       rs.updateInt("keyCode",123);

       rs.updateString("firstName","McJoy");

       rs.updateString("employee_name","Bill");

       rs.updateRow();

         } catch (SQLException ex) {ex.printStackTrace();}  

       or with Sql

      stmt.executeUpdate ("UPDATE  MyTable SET (keyCode=123,

                                        firstName=’McJoy’, employee_name =’Bill’)");

·        Inserting row

      try {   rs.moveToInsertRow();

                rs.updateInt("keyCode",123);

        rs.updateString("firstName","McJoy");

       rs.updateString("employee_name","Bill");

       rs.insertRow();

         } catch (SQLException ex) {ex.printStackTrace();}  

or with Sql

      stmt.executeUpdate ("INSERT INTO  MyTable values (keyCode=123,

                                        firstName=’McJoy’, employee_name =’Bill’)");

·        Deleting row

                              try {  

                                     rs.first();

                                              rs.deleteRow();

         } catch (SQLException ex) {ex.printStackTrace();}  

   or with Sql

      stmt.executeUpdate ("DELETE  MyTable........");

·        Closing Database Connection

       try {

               con.close();

        } catch (SQLException ex) {ex.printStackTrace();}