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

Java- Interview

Here are some popular tips in Java General Question JVM - Java Virtual Machine. Used to execute byte code. Platform dependent (but byte code is platform independent) JRE- Java Run time Environment. It provides run time environment and it's the implementation of JVM. It contains libraries and files that need to execute JVM.   JDK- Java Development Kit. It contains JRE and development tools. Why java doesn't support pointers: It's insecure and complex to understand We can save java file with another name if class is not defined as public Java use camalCase notation for objects naming (ex: firstName) OOP Concepts Related  Aggregation: weak relationship (bike has an indicator) Composition:  strong relationship (bike has an engine) GUI Java GUI - Install Window builder to create GUI using Eclipse IDE Code Related No issues when you write static public void instead of public static void We can execute program without main method : using static bloc...
Post a Comment
Read more

Core Java Concepts

Java Applications  There are mainly four types of Java applications. Standalone Web  Enterprise  Mobile Java Features  There are several features in Java, but in here listed some important ones Platform independent Object oriented Multi threaded Distributed Robust (automatic garbage collection, exception handling, type checking) Java Security  Java has 3 built-in security components; Classloader: Separate class files packages from imported packages. BytecodeVerifier: check the illegal access to objects Security Manager: check what resources can access the object. C++ vs Java Methods Static - No need to create an object to invoke the static method. Constructor - use to initialize objects Constructor name must same as the class name Constructor has no return type There are two types of constructors Default - no parameter Parameterized If there is no constructor defined in the class, compiler aut...
Post a Comment
Read more

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