Advanced Java Programming
Java Enterprise Edition Architecture
Java Servlets
Servlet Advantages
Servlet Application Architecture
Servlet Container
Steps to develop Servlet Code
Servlet Hierarchy & API
Servlet Life Cycle
ServletConfig & ServletContext
Servlet Session Management
getRequestDispatcher() & sendRedirect()
ServletContext, Session & Request attributes
JavaServer Pages (JSP)
JSP Advantages
JSP Application Architecture
JSP Tags
Steps to develop JSP Code
JSP Comparison with Servlet
JSP becomes Servlet
JSP API
JSP Life Cycle
JSP Implicit Objects
JSP with JavaBeans
JSP Programming Examples
JSP Standard Tag Library (JSTL)
Java Database Connectivity (JDBC)
JDBC Architecture
JDBC Driver Types
JDBC API
Steps to develop JDBC Code
JDBC Methods Comparison
JDBC PreparedStatement
JDBC CallableStatement
JDBC Connection Pooling
Model-View-Controller (MVC)
MVC Architecture with Apache Struts 1
MVC Architecture with Apache Struts 2
Java Database Connectivity (JDBC)
Java applications cannot communicate directly with a RDBMS to submit data and retrieve the results of queries. This is because a RDBMS can interpret only SQL statements and not the Java language statements. So, we need some kind of mechanism to translate Java statements into SQL statements. In Java programming domain, the technology that enables database access and manipulation is called Java Database Connectivity (JDBC).
JDBC has two parts: the JDBC core API and the JDBC optional package API. The JDBC Core API is the main part of JDBC and it takes the form of the classes and interfaces in the java.sql package. The JDBC optional package API is specified in the javax.sql package and it supports connection pooling, distributed transactions, row sets, and so forth.