Explore the JDBC API to connect Java applications with relational databases, run SQL statements, and process results. Learn how this vendor-independent abstraction enables cross-database data access with drivers and APIs.

Examine the JDBC APIs, including connection and statement interfaces, prepared statements, result sets, metadata, and extension APIs, and how they map Java objects to database types.

Explore the driver manager class in the JDBC API, learn how it registers drivers, establishes connections via driver implementations, and manages login timeouts, logging, and properties.

Explains how to work with Java and JDBC connections: creating statements (statement, prepared, callable), managing result sets, and controlling auto-commit, transactions, savepoints, isolation levels, warnings, and type maps.

Explore the Java SQL connection and statement interfaces, focusing on transaction constants and isolation levels, batch execution, and result handling. Learn to manage warnings, fetch size, and query timeouts.

Master database connections in Java and JDBC by creating statement objects, executing queries and updates, processing result sets, and closing the connection with the driver manager.

Learn how to obtain a JDBC connection via driver object, driver manager, or datasource, then establish a session, create statements, and execute queries against the database.

Explore how to create and execute JDBC statements, navigate result sets, and manage connections, including driver types and Oracle specifics.

Learn to use JDBC statements and result sets in Java, creating statement objects from a connection, executing queries and updates, and employing prepared and callable statements to handle parameters.

Learn how to use the JDBC statement object to execute queries and updates, manage result sets, obtain update counts, and create tables with the create statement for dynamic SQL.

Create a database connection via jdbc driver jar, obtain a statement object, and execute SQL to create a table and insert data, while handling class not found exceptions.

Explore how to use statement and prepared statement objects in JDBC to insert data, manage parameters with setters, and understand performance and lifecycle considerations, including closing resources.

Learn how to use JDBC prepared statements to improve efficiency and reduce execution time by creating a prepared statement from the connection, binding parameters with placeholders, and executing updates.

Learn how to use prepared statements with a connection to execute parameterized updates, set values safely, and close the statement and connection, while comparing advantages and limitations to simple statements.

Learn to invoke stored procedures and functions in Java using the callable statement interface, handling input, output, and input-output parameters with pre-compiled statements for scalable web applications.

Use JDBC callable statements to execute stored procedures and retrieve outputs by setting input parameters, then close resources after running a sample create account procedure against bank and personal tables.

Learn to call a stored procedure from Java using a callable statement to obtain an account balance via an output parameter, including procedure creation and input and output handling.

Learn how to call functions using callable statements in Java and JDBC, retrieve data with result sets, and compare procedures, functions, and prepared versus callable statements in Oracle.

Explore how a cursor with a callable statement works with a result set, retrieving column values with get methods and managing metadata and lifecycles.

Retrieve and navigate data from a result set using get methods by index or column name, and handle common Java types such as String and long.

Learn how to use JDBC to retrieve records with a result set, iterate with next, read data by column name or index, and handle exceptions.

Explore how to work with result sets in Java and JDBC by executing select queries, retrieving column values, handling nulls, and dealing with column indexes and exceptions.

Explore using result set metadata to inspect query results, retrieving column names, types, lengths, display sizes, and nullable or auto increment properties for dynamic Java JDBC apps.

Explore result set metadata in Java by using the statement and resultset objects to retrieve column counts and names, and build a command-based editor to display query results.

Build a Windows-based SQL editor using Java and JDBC, creating a GUI with labels, text fields and a text area, and implementing a database connection, query execution, and event handling.

Develop a java sql editor graphical user interface by configuring labels, bounds, and an output box. Validate input, process result sets with metadata, and display column data.

Learn about result set objects in Java and JDBC, including forward-only and scrollable types, navigation methods, and basic update and concurrency behaviors.

Learn to use statement and prepared statement objects in Java JDBC, configure scrollable, insensitive, read-only result sets, and navigate results with next and previous methods.

Using a prepared statement in Java JDBC, this lecture demonstrates how to execute a query, obtain a scrollable result set, and navigate data with next, previous, and absolute moves.

Explore different result set types in JDBC, including scroll-insensitive and scroll-sensitive, and learn how their behavior affects updating and reflecting changes in the database.

Explore updating, deleting, and inserting via an updatable result set in Java JDBC, including a salary increment example for employees earning over 2000.

this example demonstrates deleting a database row via jdbc, using a statement and result set to locate an employee, then verify deletions with database metadata.

Learn to insert a new row into a database using a resultset object in JDBC, including setting column values, creating an add employee class, and closing statements and the connection.

Learn to load JDBC properties, create a database connection, and extract database product, driver name, and driver version from metadata using a properties file.

Master advanced JDBC concepts for dynamic web apps, including connection pooling, batch statements, and transaction management. Handle large objects, user-defined types, auto-generated keys, and scrollable result sets under SQL-99.

Learn to store and retrieve BLOB values in a database with Java JDBC, using prepared statements, input streams, and vendor-specific APIs for binary data like images.

Learn to read blob values from a database with getBinaryStream and ResultSet, and save the data to image files using file output streams.

Learn to store CLOB values in a database with prepared or callable statements, using set character stream and JDBC 4.0 createClob, while noting JDBC 3.0 limitations.

Learn to read and extract CLOB values from a database using JDBC, including character streams and substring techniques, then save results to a file while handling NCLOB with transactions.

Learn to create and use user defined and structure types like ENP_ADDRESS in Oracle, and map them to Java objects via JDBC for storing and retrieving structured data.

Explore array data types and ref types in Java using JDBC, including creating and manipulating ID and audio objects, and using prepared and callable statements to insert and query data.

Learn how to perform batch updates with JDBC: create and batch prepared statements, add heterogeneous dml or ddl commands, execute batch, and clear the batch.

Master batch updates with prepared statements in Java and JDBC, adding multiple parameter sets, executing batches, and handling batch update results for efficient employee data insertion.

Explore how to store XML data in databases with the SQLXML approach, compare batch updates using statement versus prepared statement, and handle generated keys with sequences and triggers in Oracle.

Explore how to retrieve auto generated keys with JDBC after inserts, using statement and prepared statement options, getGeneratedKeys, and mapping to columns like account numbers.

learn how to implement connection pooling in Java, manage pooled connections with get connection and close, and handle connection events using a listener to monitor performance with benchmarking.

Explore the role of transactions in databases, and how atomicity, consistency, isolation, and durability (acid properties) safeguard data integrity and provide a consistent view across concurrent operations.

Explore the wrapper interface and transaction management in JDBC, detailing local, distributed, and nested transactions, isolation levels, auto-commit, save points, and rollback.

Learn how a Java and JDBC based application transfers funds using transactions, savepoints, and rollbacks, with auto-commit control and transaction management.

Explore how Java servlets supersede CGI by running in a container to process requests and generate dynamic, portable content, with API 3.1 and non-blocking IO.

Explore the Servlet API, detailing the standard contract between the servlet container and user components, including interfaces and classes for requests, responses, dispatching, filters, listeners, and lifecycle management.

Understand the servlet life cycle, including loading and initializing the servlet, handling requests, and destroying the instance, as managed by the container via deployment descriptors.

Discover the servlet life cycle, from init and request handling with a request and response object, to destroy, including single-thread model behavior and handling unavailable states.

Create a servlet app on Tomcat server that demonstrates the servlet lifecycle by building a home page with an invoke lifecycle button and implementing init, service, and destroy, deployment descriptor.

Deploy a servlet-based web application on Tomcat by creating deployment scripts, configuring lifecycle methods, and validating startup on localhost with lifecycle messages.

Explore how a generic servlet handles request processing and navigation, including delegation to Silverlake instances, container initialization, and the servlet lifecycle.

Create a Java web app that demonstrates a generic servlet by building a hello servlet, mapping it in web.xml, and deploying to Tomcat to display a welcome message.

Learn how the servlet request interface encapsulates client data, reads parameters with getParameter, and how the container manages, reuses, and dispatches requests via the HTTP protocol.

Demonstrates implementing a servlet request interface by building a login web form, wiring a logon servlet, and configuring deployment with a descriptor to handle user authentication via JDBC.

Learn how to use initialization parameters in a Java web app, read name and password from a request, validate against user details via database connectivity, and handle exceptions with try-catch.

Learn to externalize startup configuration with initialization parameters in Java web apps, access them via deployment descriptor and getInitParameter, and implement a sample servlet to read multiple values.

Learn how to configure and access context initialization parameters in a Java web application, using deployment descriptor configurations and practical examples like home and login pages.

This lecture demonstrates building a Java and JDBC login and registration flow, including context initialization, registration form handling, database insertion, and login verification with prepared statements.

Explore how the servlet response object manages content, buffering, and committed states, and how request dispatching with include and forward enables reuse and multiple outcomes.

Examine the request dispatcher to include or forward a request and route responses between resources. Compare include versus forward, noting how forward targets a resource and include embeds the response.

Explore a Java and JDBC web application example that uses a request dispatcher to build and print an html table in the response, with exception handling for robust output.

Continue the request dispatcher example by configuring get request dispatcher, handling resource not found or unavailable, and using slash-based paths to locate and forward requests.

Describe how to use request attributes to pass data between servlets, using setAttribute, getAttribute, and removeAttribute, and forward via a RequestDispatcher for multiple actions in a Tomcat deployment.

Describe and manipulate request attributes, get and set attribute values, use a request dispatcher to forward responses, and configure deployment descriptors for the web app.

Describe http basic concepts and the request–response model, including http/2 improvements such as compression and latency reduction. Explain status codes from 1xx to 5xx with examples like 200 and 404.

Explore how http servlet request and response objects manage headers, content length, and content type, and learn dispatch strategies like forward and redirect to build dynamic web applications.

Explain http servlet request and response handling in a dynamic web app, covering form actions, processing requests, and basic try-catch error handling.

this lecture demonstrates building a response example in a Java web app, handling requests, printing results into a table with headers, and configuring deployment mappings.

Explore session tracking methods such as cookies, URL rewriting, and hidden form fields, and learn how a flexible API can select the right technique based on client capability.

Explore url rewriting and hidden form fields for session management in Java web applications, including login forms, form-based requests, and session tracking with database-backed state.

Implement a logon servlet in Java that uses JDBC to validate user input, establish a database connection, execute a query with a statement, handle exceptions, and forward to login page.

Explore building mail handling in Java using JDBC: create a mail class with subject and content fields and getters/setters, connect to a database, execute queries, and handle results with try-catch.

Develop dynamic web applications by building an inbox feature with Java servlets, handling HTTP requests and responses, generating HTML tables, and using URL rewriting to manage navigation.

Learn to work with hidden form fields, DML pages, and dynamic web application flows in Java and JDBC Mastery, including creating objects, mapping inputs, and configuring deployment.

Describe how cookies are transmitted via http headers, stored by the browser, and exchanged between client and server using the Java cookie API to manage name, value, and domain.

Explore how to create and retrieve cookies in a Java servlet, demonstrating cookie values, content type, and output messages like cookie added successfully to build dynamic web applications.

Learn how to manage user sessions in Java and JDBC web apps by creating and locating session objects, storing attributes, handling cookies, and controlling session lifecycles.

Explore describing cookies and session management in a java web app, weighing advantages and disadvantages, security, memory implications, and clustering with serializable session objects, demonstrated via a shopping cart app.

Develop dynamic web applications by implementing Java JDBC connections and HTTP session management, creating a user class and a product class, and implementing a login flow with a request dispatcher.

Explore managing HTTP sessions and request dispatching in a Java web app, implementing login, listing products, selecting items, adding to cart, and session invalidation.

Explore the scope and lifetime of web application objects, including request, session, and application scope, and learn about attributes, contexts, and single-threaded models in Java web apps.

Explore the scope of web application objects in Java and Tomcat, featuring request handling, exception blocks, and building a home page to fetch employee photos.

Discover how Java filters intercept and transform web requests and responses using the servlet filter API. Learn about filter chains, listeners, and wrapping objects to apply transformations in web applications.

Explore building dynamic web apps with Java by implementing filters that intercept requests, using the Filter interface, doFilter, and deployment descriptor to manage request and response flow.

Learn to use the Servlet context listener interface to manage application lifecycle events, initialize resources, and respond to request and session events through deployment descriptors.

Explore the servlet context listener interface by implementing contextInitialized and contextDestroyed to manage app lifecycle events, initialize resources such as a database connection, and clean up on shutdown.

Explore how to implement the servlet context attribute listener interface to monitor add, replace, and remove events of context attributes, using getName and getValue in a Java web application.

Build and implement a context attribute listener to monitor servlet context attribute additions, replacements, and removals, using event methods getName and getValue to log changes in the Tomcat deployment.

Implement http session listener and attribute listener to monitor session lifecycle events, including session created and destroyed, and attribute added, replaced, or removed with binding event details.

Explore how to implement an http session listener interface in java web apps, manage session attributes, bind lifecycle events, and use request dispatching to handle username attributes.

Implement the Http session binding listener interface in Java to handle valueBound and valueUnbound events when an object binds to or unbinds from a session, via a session binding event.

Learn to implement session binding and activation listeners to monitor binding and unbinding, session migration, and to track request lifecycle and request attribute events in a Java web app.

Explore how request and response wrappers extend base objects to add functionality using the wrapper pattern, altering rappo API behavior, content-type checks, and post operations.

Describe how to implement request and response wrappers, extend custom classes, and apply a filter to intercept and wrap Java web requests and responses.

Explore how Java applets communicate with CGI programs, sockets, and RMI, including trusted versus untrusted applets, security manager rules, and techniques for secure client-server communication.

Create a Java web application with an applet and a servlet, build an index page, and implement applet-servlet communication to exchange messages.

Explain inter servlet manipulation by covering direct servlet access, session and context sharing, and using get methods, reflection, and class loaders to enumerate and manage loaded servlets safely.

Explore an example of inter-servlet manipulation, showing how to save servlet state, manage context, and handle common exceptions during cross-servlet communication.

Demonstrate inter servlet manipulation with socket-based communication, creating sockets and streams, and handling exceptions; explain information sharing via system properties, shared objects, and inheritance for collaboration.

Explore non-blocking IO, asynchronous request processing, and protocol upgrade mechanisms with security enhancements to build fast, scalable dynamic web applications.

Learn how JSP separates dynamic content from static presentation and uses Java beans with JSP constructs to render live content such as the date and time.

This lecture demonstrates building a JSP example by implementing a doGet method with HttpServletRequest and HttpServletResponse, setting Content-Type, writing output, and configuring servlet mappings in the deployment descriptor.

This lecture explains the JSP life cycle, detailing translation, compilation, loading and initialization, request handling, and destruction within a web container, and how these stages enable dynamic web applications.

Explore the JSP life cycle by building a simple web application that collects a user name and city through a form and displays a welcome message.

Explore scripting tags in Java web development, learning declaration packs, expression stacks, implicit objects, and dynamic content generation with GST/GSB syntax and example loops.

Explore an example of scripting tags that implements a page view counter in a simple Java web app, incrementing a variable on each request using a function and implicit objects.

Explore how jsp implicit objects enable dynamic pages by auto initializing common objects like request, response, out, session, application, and pageContext, without imports, to handle inputs, outputs, and errors.

Explore an example of implicit objects in a Java web app, showing how request, session, and page context interact with form submission and application implicit objects.

Explore directive tags in the GC translation lifecycle, focusing on page directives and attributes like language, import, extents, content-type, buffer size, auto flush, and encoding.

Master a java and jdbc driven login flow by creating a database connection, constructing a statement, executing a user lookup to validate credentials, and handling errors in a jsp page.

Explore Java beans as reusable components that separate business logic from presentation, enabling dynamic web pages, with advantages in object sharing and simplified request handling on Google Cloud Platform.

Learn how to implement a Java bean example to pass parameters via JSP forms, manage user input, and navigate between pages in a dynamic web app.

Use the bean tag to instantiate or reference a Java bean in a specified scope (application, session, request), then set and retrieve its properties with name and value attributes.

Learn how to declare a bean in JSP, define a Java bean with username and email, plus last name and address, and expose data via getters and setters.

Declare a bean in a web page and configure an rtg process with a registration form, using properties and a dml page integration to pass user data.

Explore custom tags and tag libraries in Java web pages, including library descriptors, tag handlers, and custom actions, to embed Java logic and improve performance and maintainability.

Explore building a custom tag library in a Java web context by implementing tag interfaces, extending support classes, and managing the tag handler lifecycle from instantiation to release.

Learn to create and configure custom tags in a Java and JDBC web application, manage back library descriptors, XML configuration, and how to import and reference libraries during execution.

Explore creating custom tags in a Java web app, wiring attributes to a tag handler, and displaying tag responses on pages with examples of get message output.

Learn how to add a new Java class to a custom tag library, implement the back handler, and manage tag attributes and scopes to render dynamic content in JSP.

Explore the body content tag interface in Java web apps, detailing custom tag creation, body content evaluation, and the tag lifecycle from start to release.

Create a new web application named us custom bikes example and implement a jsp custom tag library with a tag handler that extends tag support and processes body content.

this lecture demonstrates building a dynamic web page in a Java and JDBC context, using if conditions to validate user input, handle login and registration, and execute database update statements.

Learn to build a Java class for database access with JDBC, manage a connection, execute statements, handle exceptions, and configure XML-driven data models for user requests.

Explore how a web app uses a GSP page and servlet logic to accept employee data, connect to a database, update salaries, and verify changes through a dynamic JDBC workflow.

Discover how the iteration tag interface operates in Java web applications, tracing its life cycle, tag handling, and integration with a tag library to manage page context and collections.

Create a new back library project, set live version 1.1 and GC version 1.2, define attributes name, ID, scop, build a GSP page, and wire deployment descriptor with standard libraries.

Examine the lifecycle of a simple custom tag in a Java web app, detailing tag handler creation, attribute setting, body evaluation, and invocation by the container.

Compare classic and simple tag handlers, noting how simple tags can use or omit a body and their lifecycle, then review the tag API, custom tag libraries, and exception handling.

Explore the types of EL expressions in JSF, including immediate and default expressions, value and method expressions, and how they access Java Beans properties.

Explore tag attribute types and how expression language resolves value and method expressions, including static and dynamic attributes, through the EL API and resolver process.

Explore el operators in a unified el api to perform calculations and build el expressions. Master arithmetic, relational, logical, and conditional operators with unary and prefix checks for empty values.

Explore example of EL operators, including arithmetic, relational, and logical expressions, and learn to use implicit EL objects for request, session, page, and application scopes in a Java web app.

Demonstrates EL operators and implicit objects in a dynamic web application, fetching attribute values, rendering user input from a form, and printing collection elements with implicit objects.

Explore how EL functions work in Java web apps, using libraries and prefixes to access public static methods and implicit objects, and distinguish function expressions from method expressions.

Discover how Java supports internationalization and localization through the Locale class, constructing locale objects with language, country, and variant to format dates, numbers, and messages for diverse regions.

Explore how to use Java resource bundles to internationalize apps with ListResourceBundle and PropertyResourceBundle, retrieve messages, and format numbers and dates per locale.

Extend list resource bundle by implementing getContents with key-value entries, including lists. Build a main class to load bundles by locale and display gdp, population, and literacy.

Explore internationalizing Java web applications by using Unicode, resource bundles, and user language detection via Accept-Language headers or explicit selection, with a simple example app.

Learn to internationalize web applications by using resource bundles and properties files for English US and Italian locales, then serve locale-specific greetings via a servlet and request dispatcher.

Explores general purpose tags and their core tagging library, covering iteration, conditional processing, expression language, and string handling, with examples of access prefixes and output tags.

Explore general purpose tags in Java web apps, including configuring jar libraries, rendering data with implicit objects, and using conditional and looping tags such as if, choose, and for each.

Master Java and JDBC to build dynamic web applications, implementing conditional logic and looping through forms for add and subtract operations, processing requests, and displaying results.

Build a Java web app with JDBC by creating a serializable employee class and a driver connection utility, then use a servlet to display details in an ENP details view.

Explore networking tags for including external pages, importing sources, and redirecting client requests, with syntax for context, scope, and session handling, and patterns for database access.

Explore JSTL SQL tags to configure data sources, bind parameters, run transactions with isolation levels, and render query results using foreach loops and links to delete records.

Learn to use JSTL SQL tags to delete an employee record, including parameter binding, executing the delete statement, and handling results via a data source in JSP.

Explore JSTL basic formatting tags to format numbers, dates, and time zones and support internationalization through resource bundles and locale settings.

Explore JSTL formatting and implement internationalization by creating properties files for English and Italian, wiring messages into a source bundle, and rendering localized welcome messages.

Explore JSTL number formatting tags, using format-number to format values by locale and parse-number to read formatted strings, with attributes like value, type (numbers, currencies, percentage), pattern, and grouping.

Master date formatting tags in Java to format and parse date and time values, using the FM date formatting syntax, with customizable patterns, styles, and time zones.

Explore time zone formatting tags and XML tags, and learn to specify and display time zones in web apps using FM colon time zone syntax.

Explore JSTL functions and standard string manipulation in Java web apps, including contains, starts with, ends with, index of, join, substring, and for loops.

Learn how to use JSF to build dynamic web applications with reusable UI components, backing beans, and navigation rules, while leveraging view actions and input validation.

Learn how JSF HTML tags power dynamic web pages with command links and buttons, action methods and listeners, value bindings, and common attributes, plus data table and graphic image components.

Master JSF html tags by examining output label and output link components, their attributes, binding, rendering decisions, and validation and value handling to drive dynamic web interfaces.

learn to implement checkbox selection with jsf html using select many and select one components, binding values, and handling value changes across multi and single option listboxes and menus.

This lecture outlines jsf core tags, covering action listener and value change listener, converters and validators, localization, binding, and attributes inside a f:view root that encloses the component tree.

Learn to use JSF core validator and output tags to bind UI inputs and enforce range and length constraints. Explore implementing custom validators with backing beans within JSF component framework.

Explore backing beans in Java web apps, showing how UI components bind to managed beans and trigger actions via properties and methods in a declarative, code-driven example.

Create a simple JSF web application by building the index page, a form with name, department, and number inputs, and a managed bean with navigation rules in faces-config.

Explore Java EE design patterns and the three-tier Java application architecture, including presentation, business, and data layers. Learn how patterns like front controller and service locator standardize solutions for scalable enterprise apps.

Explore Java EE design patterns for building dynamic web applications, including the controller, composite entity, and data access object patterns, and how these strategies handle authentication, navigation, and data access.

Explore authentication and authorization in Java web apps with the JAAS API, enforcing access control and data integrity through declarative and programmatic security.

Explore declarative security in a Java web application by implementing basic authentication and form-based login. Validate credentials, protect resources, and configure authentication constraints to control access.