Skip to main content

JDBC- Java

JDBC allows java applications to connect to relational databases.

Database can be reside in local, network or cloud.

JDBC Features

  • Provide portable access to various databases
  • Can build custom sql statements

JDBC Supported Databases

  • MySQL
  • Oracle
  • DB2
  • PostgreSQL

Key Classes of JDBC

  • java.sql.DriverManager
  • java.sql.Connection
  • java.sql.Statement
  • java.sql.ResultSet
  • java.sql.DataSource

JDBC Development Process

  • Get a connection to the database
    • ex :  jdbc:<driver protocol>:<driver connection details>
  • Create a statement object
  • Execute the Query
  • Process the result set



Comments

Post a Comment

Popular posts from this blog

Object Oriented Programming (OOP)

Object Object is an entity that has state and behavior Class Collection of objects is known as class. There are four main types of OOP concepts Inheritance Object acquire all the properties and behavior of parent object Improve code re-usability Polymorphism One task is performed by different ways Use method overload and override Abstraction Hiding internal details and showing functionality Use abstract class and interfaces Encapsulation Binding code and data into a single unit
Post a Comment
Read more

Java-8

Java 8 New Features There are several new features added in Java 8 version. Some of the important new features are: Define methods inside the interface For each method Lambda Expression Stream API DateTime API 1) Define methods (default, static) inside the Interface After you published your interface, you can't change it by adding some abstract methods. But if you want to add methods you can define those methods inside the interface. Therefore Java 8 support default and static methods inside the interface. In Java 7 version interface only have abstract methods (no method implementation) and an abstract class can have both abstract and non-abstract methods. In Java 8 version you can add method implementation in the interface, but you have to declare that method as default method. ex: default void show(){............} To avoid diamond problem you have to override the method in implementation class if two interfaces have same default method ...
Post a Comment
Read more

Apache Tomcat- Ubuntu

Tomcat is a web-container that allows to run servelet and Java Server Pages (JSP) based web applications. Tomcat Usages A container that allows running web applications. Can use as HTTP server(default port : 8080) Installation Follwing steps are described to install Tomcat7 in Ubuntu OS using terminal. sudo apt-get install tomcat7 sudo apt-get install tomcat7-admin sudo apt-get install tomcat7-docs sudo apt-get install tomcat7-examples Start/Stop Tomcat Server In Ubuntu after istalling Tomcat server it will start automaticaly. But if you want to restart the server you can use follwing command sudo /etc/init.d/tomcat7 restart If you want to stop the Tomcat Server you can issue following command. sudo /etc/init.d/tomcat7 stop Test The Server After starting the Tomcat server you can check it by entering the following URL in the brower http://localhost:8080 Admin Console  Tomcat provides a web based administrat...
Post a Comment
Read more