Client Server Computing - Exam Notes (As per 2020-21 Syllabus)
Unit I: Java Database Connectivity
- JDBC Concepts: Java Database Connectivity (JDBC) provides a standard API for accessing databases from Java
programs.
- JDBC API: Interfaces like Driver, Connection, Statement, PreparedStatement, CallableStatement, and ResultSet.
- DriverManager: Manages a list of database drivers and establishes a connection to the database.
- Connection: Interface to connect to the database.
- Statement: Used to execute static SQL queries.
- PreparedStatement: Precompiled SQL statements to execute parameterized queries.
- CallableStatement: Used to execute stored procedures.
- ResultSet: Interface to hold data retrieved from the database.
- Types of ResultSet: TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE.
- Query Handling: SELECT, INSERT, UPDATE, DELETE.
- Stored Procedures: Precompiled database procedures invoked using CallableStatement.
Unit II: Servlets in Java
- Servlet Structure: Java classes that handle requests and generate responses.
- Servlet Lifecycle: init(), service(), destroy() methods.
- Servlet API: [Link] and [Link] packages.
- Interfaces: Servlet, ServletRequest, ServletResponse, etc.
- Requirements: Deployment descriptor ([Link]), servlet container (e.g., Tomcat).
- Running Servlets: Via HTTP requests and responses.
- Session Management: Using HttpSession, Cookies.
- Cookies: Used for session tracking.
- Servlet Chaining: Request forwarding between multiple servlets.
- JDBC Servlets: Integration of JDBC with Servlets to access databases.
Unit III: Introduction to JSP (JavaServer Pages)
- JSP Concepts: Used to create dynamically generated web pages.
- JSP Lifecycle: Translation, Compilation, Initialization, Execution, and Cleanup.
Client Server Computing - Exam Notes (As per 2020-21 Syllabus)
- Environment Setup: Web server like Apache Tomcat, JSP files.
- JSP Elements: Directives, Declarations, Expressions, Scriptlets.
- Implicit Objects: request, response, out, session, application, config, page, pageContext, exception.
- JavaBeans: Reusable software components in JSP.
- Bean Concepts: Properties, set/get methods.
- Serialization: Saving the state of a Bean.
- Writing Beans: Create Java class with properties and getters/setters.
- Deploying a Bean: Use <jsp:useBean> tag.
- Using a Bean: <jsp:getProperty> and <jsp:setProperty> tags.
- JDBC with JSP: Used to connect to database and execute queries.
- JSP Actions: Standard tags like <jsp:include>, <jsp:forward>.
- JSTL (Java Standard Tag Library): Provides standard tags to simplify JSP.
- JSTL Tags: Core, Formatting, SQL, XML, Functions.
