JDBC, Servlets, JSP Syllabus
1. Storage Areas
- Temporary Storage Areas
- Permanent Storage Areas
2. Query Processing System
- Query Tokenization
- Query Processing
- Query Optimization
- Query Execution
3. Driver and Driver Types
- Type 1 Driver
- Type 2 Driver
- Type 3 Driver
- Type 4 Driver
4. Steps to design JDBC Applications
- Load and register the Driver
- Establish the connection between Java Application
- Prepare either Statement or Prepared Statement or Callable Statement Objects
- Write and execute SQL Queries
- Close the connection
5. ResultSet and ResultSet Types
- Read only ResultSet
- Updatable ResultSet
- Forward only ResultSet
- Scrollable ResultSets
6. Prepared Statement
- PreparedStatement with insert SQL query
- PreparedStatement with update SQL query
- PreparedStatement with select SQL query
- PreparedStatement with Dates Handling
- PreparedStatement with Batch Updations
7. Callable Statement
- CallableStatement with procedure
- CallableStatement with function
- CallableStatement with CURSOR Type Procedure
- CallableStatement with CURSOR type function
8. Transaction Management
- Atomicity
- Consistency
- Isolation
- Durability
9. Savepoint
10. Batch Updations
11. Connection Pooling
12. BLOB and CLOB
13. RowSets
SERVLETS
1. Introduction
- Standalone Applications
- Enterprise Applications
2. Client-Server Architecture
3. Servlets Design
- Servlet interface
- Generic Servlet
- Http Servlet
4. Servlet Lifecycle
5. User Interface
- Static Form Generation
- Dynamic Form Generation
6. Servlet Config
7. Servlet Context
8. Servlet Communication
- Browser-servlet
- Web-component
- Applet-Servlet
9. Session Tracking Mechanisms
- HttpSession Session Tracking Mechanism
- Cookies Session Tracking Mechanism
- URL-Rewriting Session Tracking Mechanism
- Hidden Form Fields Session Tracking Mechanism
10. Servlets Filters
11. Servlets Wrappers
- ServletRequest Wrapper
- HttpServletRequest Wrapper
- ServletResponse Wrapper
- HttpServletResponse Wrapper
12. Servlets Listeners
- Request Listeners
- Context Listeners
- Session Listeners
13. Web Security
- Programmatic Approach
- Declarative Approach
JAVA SERVER PAGES
1. Introduction
2. JSP Deployment
3. JSP Life Cycle
4. JSP Elements
- JSP Directives
- Scripting Elements
- JSP Actions
5. JSP Directives
- Page Directive
- Include Directive
- Taglib Directive
6. JSP Scripting Elements
- Declarations
- Scriptlets
- Expressions
7. JSP Implicit Objects
- Out
- Request
- Response
- Config
- Application
- Session
- Exception
- Page
- Page Context
8. JSP Scopes
- Page Scope
- Request Scope
- Application Scope
- Session Scope
9. JSP Standard Actions
- <jsp:useBean>
- <jsp:setProperty>
- <jsp:getProperty>
- <jsp:include>
- <jsp:forward>
- <jsp:param>
- <jsp:plugIn>
- <jsp:fallback>
- <jsp:params>
- <jsp:declaration>
- <jsp:scriptlet>
- <jsp:expression>
10. JSP Custom Actions
- Tag
- IterationTag
- BodyTags
- TagSupport
- BodyTagSupport
- SimpleTag
- SimpleTagSupport
- Nestedtags
11. JSTL
- Core Tags
- XML Tags
- Internationalization or I18N Tags (Formatted tags)
- SQL Tags
- Functions tags
12. Expression Language
- EL operators
- EL implicit objects
- EL functions