Posts

web server & application server

 Difference between Web Server and Application Server 1. Web Server A Web Server is defined as a server which accepts a request for data and sends the relevant document in return.  In other words, it is a computer program that accepts a request for a specific document and sends it to the client machine. Web servers are designed to serve HTTP content to the client computer. In most cases, the web servers are the integral parts of the application servers. Web servers accept the HTTP requests and interpret them to serve the requested content. Although Web Servers are designed to serve static content, most Web Servers have plugins to support scripting languages like PHP, Perl, etc. through which they can generate dynamic HTTP content. Ex - Apache Web Server. 2.Application Server An application server is one that is designed to generate dynamic content. It is a software framework that transforms the data to provide specialized functionalities offered by a business, service, or application.

Java Database Connectivity (JDBC)

Image
JDBC ( Java Database Connectivity ) Database : A database is a separate application that stores a collection of data. Why to Learn JDBC? The JDBC library includes APIs we can use for : 1.Making a connection to a database. 2.Creating SQL or MySQL statements. 3.Executing SQL or MySQL queries in the database. 4.Viewing & Modifying the resulting records. What is JDBC? JDBC is a standard Java API for database connectivity between the Java programming language and a wide range of databases. JDBC Architecture  JDBC Architecture consists of two layers − 1. JDBC API − This provides the application-to-JDBC Manager connection. 2. JDBC Driver API − This supports the JDBC Manager-to-Driver Connection. Common JDBC Components The JDBC API provides the following interfaces and classes − DriverManager  Driver  Connection  Statement  ResultSet SQLException  Types of Driver  Driver divided into four categories as below Type 1 − JDBC - ODBC Bridge Driver  (ODBC - Open DataBase Connectivity)  - Using

JDBC

Image
  JDBC Architecture