Objective:
Learn the fundamentals of JDBC and using the different interfaces in the JDBC API. Learn how to use Java servlets in the role of Web application control. Identify the options to state management in a Java Web application and understand the pros/cons of each. Understand how JSPs can help to separate Web logic and functionality from page layout. Explore how to make JSPs smaller and more powerful with JSTL, custom tags and expression language. Explore strategies in the exchange of data between Web pages (views) and business processing (model). Learn the meaning and importance of MVC
Introduction
- About Java Platforms
- Applications of Java
- About API (Application Programming Interface)
- Static Blocks
- Introduction to interfaces
- Runtime Polymorphism
Persistence
- What is Persistence?
- File management system
- Disadvantages of File management system
- Database management system
- Advantages of Database management system
JDBC
- Introduction to JDBC
- Why JDBC? & ODBC Vs JDBC
- Approch-1 Vendor specific library
- Disadvantages
- Approch-2 X/Open standards
- Disadvantages
- Approch-3 ODBC standards
- Disadvantages
- Approch-4 JDBC standards
- Advantages
JDBC API and JDBC Drivers
- About JDBC API
- What is a JDBC Driver?
- JDBC architecture
- Types of JDBC Drivers
- JDBC-ODBC bridge driver
- Advantages & Disadvantages
- Native API Partly Java Driver
- Advantages & Disadvantages
- Net-Protocol all/pure java driver
- Advantages & Disadvantages
- Native-Protocol pure java driver
- Advantages
JDBC API
- JDBC Packages
- sql, Javax.sql
- Interfaces and classes in above packages
- Versions of JDBC API
- Steps for developing JDBC application
SQL
- Introduction to SQL
- Types of SQL queries
Establishing Connection to Database
- About DriverManager class
- Methods of DriverManager
- What is registering driver with DriverManager
- Different methods of registering driver with DriverManager
- About getConnection method of DriverManager
- Syntax of URL to communicate with database
- Autoloading of class driver in JDBC 4.0
- Example with Application
Statement interface
- What is Statement? & Need of Statement
- Characteristics of Statement
- How to get Statement object?
- Methods of Statement
- Passing SQL statements to Database
- About execute, execute Update, execute Query, large Execute Updates methods
- Example with Application
Prepared Statement interface
- What is Prepared Statement?
- Need of Prepared Statement
- Difference between Statement and Prepared Statement
- How to get Prepared Statement object
- Defining parameters
- How to pass values to Prepared Statement object
- What is SQL Injection attack & how to overcome
- Example with Application
Result set Interface
- What is Result Set?,
- Need of Result Set
- How to get result set object
- Methods of Result Set
- Reading data, Various types of Result Set
- Result set types
- TYPE_SCROLL_SENSITIVE
- TYPE_SCROLL_INSENSITIVE
- TYPE_FORWARD_ONLY
- Result set modes
- CONCUR_READ_ONLY, CONCUR_UPDATABLE
- Example with Application
SQL 99 Datatypes
- BLOB
- Inserting blob type, Reading blob type
- CLOB
- Inserting clob type, Reading clob type
- Array, Inserting array type
- Reading array type
- Object, Inserting object
- Reading object
- Example with Application
Metadata
- Resultset Metadata
- Need of ResultsetMetaData
- How to get metadata
- DatabaseMetadata
- How to get database metadata
- Parameterizedmetadata
- How to get parameterizedmetadata
- Example with Application
Callable Statement
- About Callable Statement
- Advantage of Callable Statement
- Creating Callable Statement object
- Calling Procedure using Callable Statement
- Calling functions using Callable Statement
- About PL/SQL Programming vs Manual on Batch Queries
Batch updates
- What is batch processing
- Batch updates using Statement object
- Batch updates using Prepared Statement object
Transaction Management
- Transaction Definition
- ACID Properties
- Atomicity, Consistency,Isolation, Durability
- Methods in Transaction Management
- set Auto Commit(), set Save Point()
- commit(), rollback()
- Example with All Application
Connection Pooling
- What is connection pooling?
- Advantages of connection pooling
- Disadvantage of Driver Manager
- About Data Source
- JDBC connection pooling
- Isolation Levels
- Example with Application
Row Set
- What is Row Set?
- What is difference between Result Set and Row Set
- Types of Row Sets
- Jdbc Row Set
- Cached Row Set
- Web Row Set
- Example with Application
Communicating with difference databases
- Communicating with MYSQL
- Working with CSV files
- Communicating with MS-EXCEL
- Communicating with PostgreSql
- Example with Application
JDBC 4.0 Features
- Auto-loading of JDBC driver class
- Connection management enhancements
- Support for RowIdSQL type
- DataSet implementation of SQL using Annotations
- SQL exception handling enhancements
- SQL XML support
- Example with Application
Working With Properties File
- Working With Date Values
- Procedure To Create Desktop icon (jar file execution)
SERVLET
JEE
- JEE technology
- Components of JEE technology
- What is Enterprises Application
- What is Web Application
- Types of Web Application
- Presentation Oriented Web Application
- Service Oriented Web Application
- About Web Client, About WebServer
- About ApplicationServer
- Diff Between WebServer And Application Server
Introduction
- Server side technologies
- Need of server side technologies
- Client side technologies
- What is Servlet? & Advantages of Servlet
- Difference between CGI and Servlet
Servlet API
- Versions of Servlet API
- Packages of Servlet API
- About Servlet Container
- Responsibilities of Servlet Container
HTTP Protocol
- What is HTTP?
- What is HTTP Request format & Response format
Developing Servlet
- Servlet interface
- Methods of Servlet interface
- Developing servlet by implementing Servlet interface
- Life cycle methods of Servlet
- Webapplication directory structure
- Deployment descriptor file (web.xml)
- What is deployment?
- Types of deployments
- Deployment, Console deployment
- Tool deployment
- Deployment webapplication in tomcat server
- URL patterns
Developing And Deploying Servlet Apps in Diff Servers Like
- Tomcat Server
- JBoss Server / WildFly
- Weblogic Server
- GlassFish
Servlet Request
- Methods of ServletRequest
- About request parameters
- About request headers
Servlet Response
- Methods of Servlet Response
- MIME types
- Generating response
Servlet Config
- What is ServletConfig?
- What is need of ServletConfig
- Methods of ServletConfig
- Different ways of getting ServletConfig object.
- Defining config initial parameters in web.xml
Generic Servlet
- What is Generic Servlet?
- Methods of Generic Servlet
- About init(Servlet Config),init() method
Working with welcome-file
- Configuring welcome-file in web.xml
Methods of loading Servlet
- About load on start up
- When client send first request
Servlet Context
- What is Servlet Context?, Need of Servlet Context
- Methods of Servlet Context
- Different ways of getting Servlet Context object
- Context init parameters
- Defining Context init parameters in web.xml
Http Servlet
- What is Http Servlet?
- Methods of Http Servlet
- HTTP Request methods
- About public service and protected service methods
- About doXXX() methods
- Difference between Generic Servlet and Http Servlet
- Diff Between doGet(-,-) and doPost(-,-) methods
Http Servlet Request
- HttpServletRequest VS ServletRequest
- How to read request parameters of HttpServletRequest
- How to read request headers of HttpServletRequest
Http Servlet Response
- HttpServletResponse VS ServletResponse
- About HttpServletResponse methods
- Response status codes
Html To Servlet Communication
Form Validations
Different Types of Form Components
Working With Multiple Hyperlinks
Working With Multiple Submit Buttons
War File Creation
Servlet To Data Base Software Communication
Request Dispatching
- What is Request Dispatcher?
- What is need of Request Dispatcher?
- Request Dispatching methods
- Include
- Forward
- Difference between include and forward methods
- Getting Request Dispatcher
- Using Servlet Request
- Using Servlet Context
- Difference between getting Request Dispatcher using Servlet Request and Servlet Context
- What is Servlet Collaboration?
Redirecting
- About send Redirect method
- Difference between send Redirect and forward methods
- set Status, response.set Header methods
Attributes
- What is Attribute
- Difference between parameter and attribute
- Scope of Attributes
- Request scope, Context scope
- Session scope
- Adding, removing and modifying attributes
Thread Saftey In Servlet Programming
State and Session Management
- About connectionless protocol
- About connection oriented protocol
- Stateless protocol
- What is state/session management
- Need of session management
- Session management methods
- URL rewriting, Hidden form fields
- Cookies, HttpSession
URL Rewriting
- What is URL rewriting
- URL rewriting techniques
- Disadvantages of URL rewriting
Hidden form fields
- What is hidden form fields
- Disadvantages of hidden form fields
Cookies
- What is Cookie,
- How to create Cookie
- Methods of Cookie
- Types of Cookies
- Non Persistent Cookie
- Persistent Cookie
- How to add cookie to response
- How to read cookie from request
- Deleting cookie from servlet
- Properties of Cookie
- Disadvantages of Cookies
Http Session
- What is Http Session
- Advantage of Http Session
- How to create Http Session object
- How to read Http Session object from request
- Invalidating Http Session
- Using invalidate method
- Using session config in web.xml
- By setting time
- Http Session attribute
Error Handling in Servlet
- Configuring in web.xml
- Programmatically
Filters
- What is Filter?
- Need of Filter & Life cycle of Filter
- Filter mapping in web.xml
- About Filter Config
- Defining config parameters in web.xml
- About Filter Chain interface
- Methods of Filter Chain
- What is Filter chaining?
- Working with filter chaining
Listeners
- What is Listener?
- Usage of Listener
- About Event Delegation Model Architecture
- Types of Listeners
- Request Listener
- Servlet Context Listener
- Http Session Listener
- Types of Attribute Listener
- Request Attribute Listener
- Http Session Attribute Listener
- Servlet Context Attribute Listener
- About Event classes
Authentication and Authorization(Security In Servlet Programming)
- Understanding Authentication Mechanism
- HTTP basic authentication
- HTTP Digest authentication
- HTTPS Client authentication
- HTTP form based authentication
Working Connection Pooling
- Connection pooling in difference servers
- Tomcat, Weblogic, Glassfish
- JBoss Server / WildFly
- Developing servlet using serverside connection pooling
Working with domains
- Creating domain in weblogic server
- Deploying webapplication using console
- Creating domain in glassfish server
- Deploying webapplication using console
Working with Servlet 2.5/3.0/3.1 features
- Async Servlet
- File Uploading and Downloading
- Non-blocking I/O
- HTTP protocol upgrade mechanism
- Different Types Of URL Patterns
- Dynamic Registration Of Servlet (Developing Servlet Program Without web.xml)
Annotations in Servlet Programming
- Introduction to Annotations
- Types of Annotations
- Annotations Vs web.xml
JSP
Introduction
- What is JSP?
- Advantages of JSP & Applications of JSP
- Difference between JSP & Servlet
JSP Basics
- JSP Life cycle, JSP Lifecycle methods
- jspInit, _jspService
- jspDestroy, Saving jsp file as a,
- Public resource, Private resouse
- JSP tags
JSP Tags
- three categories of tags
- scripting elements, directives
- standard actions
Scripting Elements
- What is scripting elements
- Types of scripting elements
- Declaration tag
- Expression tag
- Scriptlet
JSP implicit object
- What is jsp implicit objects
- Need of jsp implicit objects
- Implicit objects of jsp
- Request, Response, Page
- pageContext, out, session
- exception, application, config
Directives
- What is directive?
- Types of directives
- Page directive, Include directive
- Taglib directive
Standard Actions
- What is standard action
- Standard actions
- Working with
- Difference between and <%@include> directive
- Working with
Java Bean
- What is java bean?
- Usage of bean
- Properties of bean
Using Java Bean in JSP
- About
- Attributes of
- Working with scope of bean object
- Using bean with and
- Assigning values to bean using
- Reading values from bean using
Expression Language
- What is Expression Language
- Advantage of Expression Language
- Syntax of defining expression
- Basic Operators in EL
- Implicit objects In EL
- page Scope, request Scope
- session Scope, application Scope
- param, param Values, header
- header Values, init Param, cookie
- page Context, Defining functions
Working JSTL
- What is JSTL?, Version of JSTL
- Classification of JSTL tags
- Core tags, Formatting tags
- SQL Tags, XML tags
- JSTL Functions
- How to use JSTL in web application
- Working with Core tags, Formatting tags & SQL tags
- Working JSTL functions
Custom Tags
- What is tag?, Java based tag
- Components of tag library
- The Tag Handler Class
- The Tag Library Descriptor File
- Imports a tag library (referencing URL of descriptor file)
- Defines tag prefix
- Uses tags, About tag handler
- Tag interface, Simple Tag
- Tag Support, Body Tag Support
- Simple Tag Support
- Developing tag using Simple Tag Support class
- Life cycle of custom tag
- Tag hander class with attributes
- Developing tag with body
MVC Architecture
- MVC Design pattern
- MVC-1 Page Centric
- Advantages & Disadvantages
- MVC-2
Developing Project using MVC
- Integrating JDBC , Servlets And JSP
Write a public review