Skip to main content

JDBC FAQ part4

6:    How to establish a Database connection between java application and Database?
If we want to establish a connection between java application and the database we will the following piece of code.
Connection con= DriverMadoeer.getConnection(“jdbc:odbc:doe”,”doe”,”system”,”madoeer”);
Where getConnectin() is a static method from DriverMadoeer class, which can be used to return connection object.
7:  Basically Connection is an interface, how getConnection() will create an object for
      Connection interface?
Ans:   Connection is an interface from java.sql package, for which getConnection(_)  was return an anonymous inner class object of the Connection interface.
Note:-  Anonymous inner class is a nameless inner class, which can be sued to provide an implementation either for the interfaces or for abstract classes.
Eg:   interface I
         {
                void m1();
          }
         Class Outer
         {
                     I  i = new I(){
                                             public void m1()
                                             {
                                             
                                             }
                                             public void m2()
                                             {
}
                                           }
            }
            Outer o = new Outer();
            o.i.m1();   à  correct
            o.i.m2();   à  wrong
                        getConnection(_) is a static method from DriverMadoeer class, which will call internally  connect() method, this connect() will establish a virtual socket connection in between the java application and the database.
8:   What is the requirement to use Statement object?
  • After establishing a connection between java application and the database we need to write the sql queries and we need to execute them.
  • To execute the sql queries we will use some pre-defined library, which was defined in the form of Statement object,  PreparedStattement object and CallableStatement object.
  • As per the application requirements we need to create either Statement object or CallableStatement object and PreparedStatement object.
  • To create Statement object dwe will use the following method from connection object.
public  Statement createStatement()
Eg:     Statement st = con.createStatement();
9:  How to  execute SQL Queries from a java application?
To execute the sql queries we will use the following methods from Statement object.
  • st.executeQuery(…)
  • st.executeUpdate(…)
  • st.execute(…)

Comments

Post a Comment

Popular posts from this blog

Applications of Insulating Materials

All electrical systems require some kind of insulation to prevent short circuits and leaking currents. 3 forms of insulators: solid, liquid and gaseous Performance of these insulators depend on the temperature Classification according to their temperature rating. Impregnation: Letting the solid material absorb some liquid With the advent of new materials, the classification has been modified by International Electrotechnical Commission: The transformer insulation: (a) conductor or turn-to-turn insulation, (b) coil-to-coil insulation, (c) low voltage coil-to-earth insulation, (d) high voltage coil-to-low voltage coil insulation, and (e) high voltage coil-to-ground insulation. Transformer oil -- provides the required dielectric strength and insulation -- cools the transformer by circulating itself through the core and the coil structure. -- should be in the liquid state over the complete operating range of temperatures between -40°C and+50°C. -- gets o...
15 comments
Read more

JSTL-JSP Standard Tag Library part 2

Evolution of JSTL-JSP Standard Tag Library As JSP grew in popularity, it became clear that different sites' custom tags fell into familiar, frequently used patterns. For example, many pages needed to loop over data to print tables and lists. Vendors of JSP containers and members of the open-source community tried to address these needs by providing collections of tags --tag libraries--that solved common problems. While many JSP page authors used these libraries, nothing tied them together. To address this fragmentation, the Java Community Process --the same group that now maintains and standardizes JSP itself --decided to offer a standard tag library. JSTL 1.0, to include tags for the following common tasks:          •Looping over data to produce tables, lists, etc.          •Conditional operations          •Importing and processing data from other web pages         ...
Post a Comment
Read more

PV/GENSET HYBRID

Introduction: PV and genset systems do not have much in common. It is precisely for this reason that they can be mated to form a hybrid system that goes far in overcoming the drawbacks to each technology. Table 10.1 lists the respective advantages and disadvantages. As the sun is a variable energy source, PV system designs are increased in size (and therefore cost) to allow for a degree of system autonomy. Autonomy is required to allow for provision of reliable power during "worst case" situations, which are usually periods of adverse weather, seasonally low solar insulation values or an unpredicted increased demand for power. The addition of autonomy to the system is accomplished by increasing the size of the PV array and its requisite energy storage system (the battery). When a genset is added, additional battery charging and direct AC load supply capabilities are provided. The need to build in system autonomy is therefore greatly reduced. When energy demands cannot b...
Post a Comment
Read more