2MARKS

1. What is AWT in Java?

AWT (Abstract Window Toolkit) in Java is a GUI (Graphical User Interface) framework used to
create platform-independent window-based applications. It is part of Java's standard library
and provides a set of lightweight components to create UI elements such as buttons,
windows, menus, labels, text fields, and more.

2. Name any two AWT components?

 Button – A clickable button used to perform an action when clicked.
Syntax :- Button btn = new Button("Click Me");
 Label – A non-editable text display used for displaying information.
Syntax :- Label lbl = new Label("Hello, AWT!");

3. What is the purpose of the Button class in AWT?

 To provide a clickable UI element for user interaction.
 To trigger an event (e.g., opening a new window, submitting data).
 To be used with event listeners like ActionListener for handling button clicks.

4. How does Label work in AWT?

The Label class in AWT is used to display static text in a GUI application. It is a non-editable
component that simply shows information to the user.
How Label Works:
 Create a Label Object – A Label is created using the Label constructor.
 Set the Label Text – You can specify the text while creating the label or use setText().
 Add the Label to a Container – The Label must be added to a Frame or Panel for
display.

5. What is an event in Java?

An event in Java represents an action or occurrence detected by the program, such as mouse
clicks, key presses, window actions, or button clicks. Events are generated by user
interactions or system notifications.

6. Define event handling in Java. ?

 Event handling in Java is the mechanism that enables a program to respond to user
actions (events). It involves:
 Event Source – The component that generates the event (e.g., a button).
 Event Object – Encapsulates details about the event (e.g., ActionEvent,
MouseEvent).
 Event Listener – An interface that handles the event (e.g., ActionListener,
MouseListener).
 Event Handling Mechanism – Registering the listener to the event source using
addActionListener() or similar methods.

7. What is the role of the ActionListener interface?

The ActionListener interface in Java handles action events like button clicks. It contains the
actionPerformed(ActionEvent e) method, which executes when an action event occurs.

8. How does MouseListener differ from KeyListener?

 Feature MouseListener KeyListener

Handles mouse events (click, press, Handles keyboard events

Purpose
release, enter, exit) (key press, release, type)

Event Type MouseEvent KeyEvent

mouseClicked(), mousePressed(), keyPressed(),

Common
mouseReleased(), mouseEntered(), keyReleased(),
Methods
mouseExited() keyTyped()

Example
Clicking a button Pressing the "Enter" key
Event

9. What is Swing in Java?

Swing is a Java GUI toolkit that provides lightweight, platform-independent, and more
flexible UI components than AWT. It is part of the [Link] package and supports
advanced components like tables, trees, and tabbed panes.

10. Name any two Swing components.?

 JButton – A button component used for performing actions.
Syntax :- JButton btn = new JButton("Click Me");
 JLabel – A label component used to display text.
Syntax :- JLabel lbl = new JLabel("Hello, Swing!");

11. How does JButton differ from Button in AWT?

Feature Button (AWT) JButton (Swing)

Package [Link] [Link]

No (uses OS
Lightweight Yes (pure Java implementation)
components)

Look & Feel OS-dependent Customizable with UIManager

Advanced Supports icons, tooltips, styles, and

Limited
Features mnemonics

Uses ActionListener with enhanced

Event Handling Uses ActionListener
features

12. What is the purpose of JLabel?

JLabel is a Swing component used to display text, images, or both in a GUI application. It is
read-only and does not support user interaction.

13. Mention any two layout managers in Java.?

  FlowLayout – Arranges components in a left-to-right flow.
 BorderLayout – Divides the container into five regions: North, South, East, West,
and Center.

14. What is the default layout for JFrame?

The default layout for JFrame is BorderLayout.

15. Define FlowLayout.

FlowLayout arranges components horizontally, wrapping to the next line when space is
insufficient. It is the default layout for JPanel.

16. What is JDBC?

JDBC (Java Database Connectivity) is an API that allows Java applications to connect to
databases and execute SQL queries.
Key Features:
 Connects Java applications with databases.
 Supports CRUD (Create, Read, Update, Delete) operations.
 Works with relational databases like MySQL, PostgreSQL, and Oracle.

17. Draw the architecture of JDBC.

Java Application
↓
JDBC API ([Link])
↓
JDBC Driver Manager
↓
JDBC Driver
↓
Database (MySQL, Oracle, etc.)

18. List the types of JDBC drivers.

There are four types of JDBC drivers:
Type 1 – JDBC-ODBC Bridge Driver (Uses ODBC, not recommended)
Type 2 – Native-API Driver (Uses native OS calls, platform-dependent)
Type 3 – Network Protocol Driver (Middleware-based, used in enterprise apps)
Type 4 – Thin Driver (Pure Java Driver) (Directly communicates with the database, most
commonly used)

19. What is the difference between Statement and PreparedStatement?

Feature Statement PreparedStatement

Executes static SQL Executes precompiled queries with

SQL Execution
queries parameters

Slower (parses query

Performance Faster (query is compiled once)
each time)

Security Prone to SQL injection Prevents SQL injection

 Feature Statement PreparedStatement

Usage Simple queries Dynamic queries with parameters

20. Define JDBC URL.

A JDBC URL is a string used to connect a Java application to a database. It specifies
the database type, host, port, and database name.
Syntax:
jdbc:<database_type>://<host>:<port>/<database_name>

21. What is the purpose of ResultSet?

The ResultSet in JDBC is used to store and retrieve the results of a SQL query executed
using executeQuery(). It acts as a cursor that moves through rows of a result set.

22. What does DriverManager do in JDBC?

DriverManager is a class that manages database drivers. It establishes a connection between
the Java application and the database.
Key Methods:
 getConnection(String url, String user, String password) – Creates a connection.

23. How do you load a JDBC driver?

You can load a JDBC driver using either:
 [Link]() (For older versions of JDBC)
o [Link]("[Link]");
 Automatic loading (JDBC 4.0 and above)
o No need to explicitly load the driver if using [Link]().

24. What is the role of executeQuery() in JDBC?

The executeQuery() method of Statement or PreparedStatement is used to execute SELECT
queries and retrieve data from the database.

25. How do you establish a database connection in Java?

To connect to a database in Java:
o Load JDBC Driver (Optional in JDBC 4.0+).
o Create Connection using [Link]().
o Create Statement & Execute Query.

26. What is the difference between AWT and Swing?

AWT (Abstract Window

Feature Swing
Toolkit)
Package [Link] [Link]
No (uses native OS Yes (pure Java
Lightweight?
components) implementation)
Look & Feel OS-dependent Customizable (UIManager)
Components Button, Label, TextField JButton, JLabel, JTextField
Performance Slower Faster
Advanced Supports icons, tooltips,
Limited
Features tables, etc.
 27. How does GridLayout work in Java?

GridLayout arranges components in a grid of equal-sized cells, aligning them in rows and
columns.
Constructor:
GridLayout(int rows, int cols)
GridLayout(int rows, int cols, int hgap, int vgap)
 rows – Number of rows.
 cols – Number of columns.
 hgap – Horizontal gap.
 vgap – Vertical gap.

28. Mention any two methods of ActionListener.

The ActionListener interface has one method, but it is indirectly associated with
event handling methods in Swing components.
o actionPerformed(ActionEvent e) – This is the only method in ActionListener and is
triggered when an action event (e.g., button click) occurs.
o addActionListener(ActionListener l) – Although not a method of ActionListener, this
method of JButton, JTextField, etc., is used to register an ActionListener to a
component.

29. What is the use of JTable in Swing?

JTable is a Swing component used to display and manage tabular data in a graphical
format. It allows users to view, edit, and interact with data in a structured manner.
Features:
o Supports sorting, selection, and editing.
o Uses a TableModel for managing data.
o Supports customization of appearance and behavior.

30. Explain the role of [Link]() in JDBC.

[Link]("[Link]") is used in JDBC to load and register a
database driver dynamically at runtime.
Role:
 Loads the JDBC Driver Class – Ensures the required driver is available.
 Registers the Driver with DriverManager – Allows DriverManager to manage
database connections.

31. What does executeUpdate() return in JDBC?

The executeUpdate() method in JDBC is used for DML (INSERT, UPDATE, DELETE) and DDL
(CREATE, DROP, ALTER) statements.
Return Value:
 If used with INSERT, UPDATE, DELETE → Returns the number of affected rows.
 If used with DDL statements → Returns 0.

5 MARKS
1. Explain the AWT components with examples.

AWT (Abstract Window Toolkit) is Java’s original GUI framework, which provides platform-
independent components to build graphical applications. The main AWT components are:
2. Frame: The main window where components are placed.
3. Label: Displays text that cannot be edited.
4. Button: Triggers an action when clicked.
5. TextField: A single-line text input field.
6. TextArea: A multi-line text input field.
7. Checkbox: A toggle option.
8. Choice: A dropdown selection box.
9. List: A list of selectable items.

CODE:
import [Link].*;

public class AWTExample {

AWTExample() {
Frame f = new Frame("AWT Example");
Label l = new Label("Enter Name:");
TextField tf = new TextField(20);
Button b = new Button("Submit");

[Link](50, 50, 100, 30);

[Link](150, 50, 150, 30);
[Link](100, 100, 80, 30);

[Link](l);
[Link](tf);
[Link](b);
[Link](400, 300);
[Link](null);
[Link](true);
}

public static void main(String[] args) {

new AWTExample();
}
}

2 Describe different AWT controls available in Java.

AWT provides various controls to create user interfaces. Some commonly used controls
include:

 Button: Clickable button for actions.

 Label: Non-editable text display.
 TextField: Single-line text input.
  TextArea: Multi-line text input.
 Checkbox: A box that can be checked or unchecked.
 CheckboxGroup: A group of mutually exclusive radio buttons.
 Choice: A dropdown menu.
 List: A selectable list of items.
 Scrollbar: Allows scrolling content.

Example Code:
import [Link].*;

public class AWTControlsExample {

AWTControlsExample() {
Frame f = new Frame("AWT Controls Example");

Checkbox cb = new Checkbox("Accept Terms?");

Choice c = new Choice();
[Link]("Red");
[Link]("Blue");
[Link]("Green");

List list = new List(3);

[Link]("Apple");
[Link]("Banana");
[Link]("Cherry");

[Link](50, 50, 100, 30);

[Link](50, 100, 100, 30);
[Link](50, 150, 100, 60);

[Link](cb);
[Link](c);
[Link](list);
[Link](300, 300);
[Link](null);
[Link](true);
}

public static void main(String[] args) {

new AWTControlsExample();
}
}

3. Explain event handling in AWT with an example.

Event handling in AWT is done using Event Listeners. The steps are:
 Register an event source (e.g., a Button).
 Attach a listener to handle the event.
 Override the event-handling method (e.g., actionPerformed).
 o Commonly used event listener interfaces:
 ActionListener (for buttons, menu items).
 MouseListener (for mouse events).
 KeyListener (for keyboard events).

CODE:
import [Link].*;
import [Link].*;

public class AWTEventHandlingExample {

AWTEventHandlingExample() {
Frame f = new Frame("Event Handling Example");
Button b = new Button("Click Me");
[Link](100, 100, 80, 30);

[Link](new ActionListener() {
public void actionPerformed(ActionEvent e) {
[Link]("Button Clicked!");
}
});

[Link](b);
[Link](300, 200);
[Link](null);
[Link](true);
}

public static void main(String[] args) {

new AWTEventHandlingExample();
}
}

4. Discuss the key differences between AWT and Swing.

Swing is preferred over AWT because of its flexibility, improved performance, and
customizable look-and-feel.
import [Link].*;

public class SwingExample {

public static void main(String[] args) {
JFrame f = new JFrame("Swing Example");
JButton b = new JButton("Click Me");
[Link](100, 100, 100, 40);

[Link](b);
[Link](300, 300);
[Link](null);
[Link](true);
 }
}

Feature AWT (Abstract Window Swing

Toolkit)
Component Type Heavyweight (relies on OS Lightweight (pure Java,
components) independent of OS)
Look & Feel OS-dependent (varies across Customizable (Pluggable
platforms) Look & Feel)
Performance Slower (uses system calls) Faster (fully Java-based,
better rendering)
Features Basic UI elements (Button, Advanced UI components
Label, TextField) (JTable, JTree, JTabbedPane)
Event Handling Old event model (explicit Modern event model
ActionListener needed) (supports Lambda
expressions)
Extensibility Limited customization Highly customizable UI
(themes, icons, styles)

5 Describe different Swing components with examples.

Swing is an advanced GUI toolkit that provides a rich set of components, including:
 JLabel: Displays a label.
 JButton: A clickable button.
 JTextField: A single-line text input.
 JTextArea: A multi-line text input.
 JCheckBox: A toggle checkbox.
 JRadioButton: A radio button (used with ButtonGroup).
 JComboBox: A dropdown list.
 JList: A list of selectable items.
 JTable: A table component.
 JPanel: A container for grouping components.

Code:

import [Link].*;

public class SwingComponentsExample {

SwingComponentsExample() {

JFrame f = new JFrame("Swing Components");

JLabel l = new JLabel("Enter Name:");

JTextField tf = new JTextField(20);

JButton b = new JButton("Submit");

JCheckBox cb = new JCheckBox("Accept Terms?");

JRadioButton rb1 = new JRadioButton("Male");

JRadioButton rb2 = new JRadioButton("Female");

ButtonGroup bg = new ButtonGroup();

[Link](rb1);

[Link](rb2);

[Link](50, 50, 100, 30);

[Link]

15 Event Handling Model

 AWT: Uses the old event delegation model, requiring explicit listeners for event handling.
 Swing: Uses a more flexible event model with built-in support for anonymous inner
classes and lambda expressions.

import [Link].*;
import [Link].*;

public class AWTEventHandling {

public static void main(String[] args) {
Frame frame = new Frame("AWT Event Example");
Button button = new Button("Click Me");

[Link](new ActionListener() {
public void actionPerformed(ActionEvent e) {
[Link]("AWT Button Clicked!");
}
});

[Link](button);
[Link](300, 200);
[Link](new FlowLayout());
[Link](true);
}
}

import [Link].*;

public class SwingEventHandling {

public static void main(String[] args) {
JFrame frame = new JFrame("Swing Event Example");
 JButton button = new JButton("Click Me");

[Link](e -> [Link]("Swing Button Clicked!"));

[Link](button);
[Link](300, 200);
[Link](new FlowLayout());
[Link](true);
}
}

6. Layout Management in Swing

Layout management in Swing refers to the process of arranging and positioning GUI components like
buttons, labels, and text fields within containers such as JFrame or JPanel. Java provides various
layout managers to handle component placement effectively.

Types of Layout Managers:

1. FlowLayout
1. Arranges components in a row, from left to right (like words in a
sentence).
2. Automatically moves to the next row when space is insufficient.
3. Default layout for JPanel.
Example:

java
CopyEdit
JFrame frame = new JFrame("FlowLayout Example");
[Link](new FlowLayout());
[Link](new JButton("Button 1"));
[Link](new JButton("Button 2"));
[Link](new JButton("Button 3"));
[Link](300, 150);
[Link](true);

2. BorderLayout
1. Divides the container into five regions: North, South, East, West, and
Center.
2. Ideal for creating complex layouts.
Example:

java
CopyEdit
JFrame frame = new JFrame("BorderLayout Example");
[Link](new BorderLayout());
[Link](new JButton("North"), [Link]);
[Link](new JButton("South"), [Link]);
[Link](new JButton("East"), [Link]);
[Link](new JButton("West"), [Link]);
[Link](new JButton("Center"), [Link]);
[Link](400, 200);
[Link](true);
 3. GridLayout
1. Arranges components in a grid (rows and columns).
2. All components are of equal size.
Example:

java
CopyEdit
JFrame frame = new JFrame("GridLayout Example");
[Link](new GridLayout(2, 2));
[Link](new JButton("Button 1"));
[Link](new JButton("Button 2"));
[Link](new JButton("Button 3"));
[Link](new JButton("Button 4"));
[Link](300, 200);
[Link](true);

4. BoxLayout
1. Aligns components either vertically (BoxLayout.Y_AXIS) or
horizontally (BoxLayout.X_AXIS).
Example:

java
CopyEdit
JFrame frame = new JFrame("BoxLayout Example");
JPanel panel = new JPanel();
[Link](new BoxLayout(panel, BoxLayout.Y_AXIS));
[Link](new JButton("Button 1"));
[Link](new JButton("Button 2"));
[Link](panel);
[Link](300, 200);
[Link](true);

5. CardLayout
1. Allows switching between multiple components, like a stack of cards.
2. Useful for implementing wizards or tabbed interfaces.

7. JDBC Architecture

JDBC (Java Database Connectivity) is an API used to connect and interact with relational databases
using Java. It provides a standard interface to perform SQL operations.

Components of JDBC Architecture:

1. JDBC API
1. A set of classes and interfaces (Connection, Statement, ResultSet)
for database operations.
2. JDBC Driver Manager
1. Manages JDBC drivers.
2. Establishes connections between Java applications and databases.
3. JDBC Driver
1. A software component that handles the database connection.
2. Converts Java API calls into database-specific calls.
4. Database
 1. The actual database where data is stored and managed.

Workflow:

1. Application requests a connection using DriverManager.

2. JDBC Driver establishes the connection.
3. SQL statements are executed using Statement or PreparedStatement.
4. Results are processed using ResultSet.

8. Types of JDBC Drivers with Advantages and Disadvantages

JDBC drivers are divided into four categories:

1. Type 1: JDBC-ODBC Bridge Driver

1. Acts as a bridge between JDBC and ODBC drivers.
2. Suitable for testing but not for production.
Advantages:
3. Simple and easy to use.
4. No specific database driver required.
Disadvantages:
5. Low performance.
6. Requires ODBC setup.

2. Type 2: Native-API Driver

1. Converts JDBC calls to database-specific API calls.
Advantages:
2. Faster than Type 1.
Disadvantages:
3. Platform-dependent.
4. Database-specific.

3. Type 3: Network Protocol Driver

1. Uses middleware to convert JDBC calls into database-specific protocol.
Advantages:
2. Database-independent.
Disadvantages:
3. Additional network overhead.
4. Requires middleware setup.

4. Type 4: Thin Driver (Pure Java Driver)

1. Directly converts JDBC calls to database-specific calls.
Advantages:
2. High performance.
3. Platform-independent.
Disadvantages:
 4. Database-specific driver needed.

9. Performing Database Operations Using JDBC

Steps to perform database operations:

1. Load the Driver:

java
CopyEdit
[Link]("[Link]");

2. Establish a Connection:

java
CopyEdit
Connection con =
[Link]("jdbc:mysql://localhost:3306/dbname",
"username", "password");

3. Create Statement:

java
CopyEdit
Statement stmt = [Link]();

4. Execute Query:

java
CopyEdit
ResultSet rs = [Link]("SELECT * FROM students");

5. Process Results:

java
CopyEdit
while ([Link]()) {
 [Link]("ID: " + [Link]("id") + ", Name: " +
[Link]("name"));
}

6. Close Resources:

java
CopyEdit
[Link]();
[Link]();
[Link]();

10. Comparison of Statement, PreparedStatement, and CallableStatement

Feature Statement PreparedStateme CallableStatemen

nt t
Purpose Executes static SQL Executes parameterized Executes stored
queries. SQL queries. procedures.
SQL Injection Risk High risk. Low risk due to Low risk with
parameterization. stored
procedures.
Reusability Not reusable. Reusable for multiple Reusable for
executions. stored
procedures.
Performanc Low due to query High as query is compiled High for stored
e compilation every time once procedures.
Parameter Support No parameters. Supports ? placeholders Supports input,
for parameters. output, and inout
parameters.
ExampleExample [Link]("SELEC [Link](); [Link]();
T * FROM users");
Use Case Simple, one-time queries. Repeated query execution Complex
with different data. database
operations using
procedures.

10 MARKS

1. Java Program using AWT with Text Field, Button, and Label (Event Handling)

AWT (Abstract Window Toolkit) is one of the earliest GUI frameworks in Java. It provides a set of
components like buttons, text fields, and labels to create graphical user interfaces. Event handling
in AWT involves attaching listeners to components to perform actions when events like mouse
clicks or key presses occur.

Code Explanation:

import [Link].*;
import [Link].*;

public class AWTEventHandlingExample {

public static void main(String[] args) {

Frame frame = new Frame("AWT Event Handling Example");

// Creating components

Label label = new Label("Enter Text:");

TextField textField = new TextField();

Button button = new Button("Click Me");

// Setting Layout

[Link](new FlowLayout());

// Adding components to the frame

[Link](label);

[Link](textField);

[Link](button);

// Event handling for button

[Link](new ActionListener() {

public void actionPerformed(ActionEvent e) {

String inputText = [Link]();

[Link]("You entered: " + inputText); // Update the label with the text field input

});

// Setting frame size and visibility

[Link](300, 150);

[Link](true);
 // Window closing event

[Link](new WindowAdapter() {

public void windowClosing(WindowEvent we) {

[Link](0); // Exit the program on window close

});

Detailed Explanation:

1. Components: A Label, TextField, and Button are created. A label is used to

display text, a text field is used to take user input, and a button is used to trigger
actions.

2. FlowLayout: The layout manager used here is FlowLayout, which places

components from left to right in the container.

3. Event Handling: An ActionListener is added to the button to handle the button

click. The actionPerformed() method is called when the button is clicked, and it
updates the label text with the input from the text field.

4. Window Listener: A WindowAdapter is used to handle the window close event

(to ensure the program exits properly).

2. Swing Application with Different Layout Managers

Swing is a more advanced GUI toolkit in Java compared to AWT. It provides better flexibility and
design options, including support for layout managers that control how components are arranged
in a container. The common layout managers in Swing include FlowLayout, BorderLayout,
GridLayout, BoxLayout, etc.

Code Example Using BorderLayout:

import [Link].*;

import [Link].*;

public class SwingLayoutExample {

public static void main(String[] args) {

JFrame frame = new JFrame("Swing Layout Managers");

// Border Layout
 [Link](new BorderLayout());

// Components for Border Layout

JButton button1 = new JButton("North");

JButton button2 = new JButton("South");

JButton button3 = new JButton("East");

JButton button4 = new JButton("West");

JButton button5 = new JButton("Center");

[Link](button1, [Link]);

[Link](button2, [Link]);

[Link](button3, [Link]);

[Link](button4, [Link]);

[Link](button5, [Link]);

[Link](400, 300);

[Link](true);

[Link](JFrame.EXIT_ON_CLOSE);

Detailed Explanation:

10. BorderLayout: This layout divides the container into five regions: North, South, East, West,
and Center.

11. Adding Components: Components (in this case, JButtons) are added to specific regions of
the layout using constants from the BorderLayout class (e.g., [Link]).

12. Window Closure: The setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE) ensures that the

application terminates when the window is closed.

3. Java Program to Perform CRUD Operations Using JDBC

JDBC (Java Database Connectivity) is used to connect Java applications with databases. JDBC
allows you to perform CRUD operations (Create, Read, Update, Delete) on the database. Below is a
Java program that demonstrates how to perform these operations using JDBC with MySQL.

Code Explanation:
import [Link].*;

public class JDBCExample {

public static void main(String[] args) {

String url = "jdbc:mysql://localhost:3306/testdb"; // Database URL

String user = "root"; // Database username

String password = "password"; // Database password

try {

// Establishing the connection

Connection conn = [Link](url, user, password);

// Create operation (Insert data)

String createQuery = "INSERT INTO users (name, email) VALUES (?, ?)";

PreparedStatement stmt = [Link](createQuery);

[Link](1, "John Doe");

[Link](2, "[Link]@[Link]");

[Link]();

// Read operation (Select data)

String readQuery = "SELECT * FROM users";

Statement stmtRead = [Link]();

ResultSet rs = [Link](readQuery);

while ([Link]()) {

[Link]("User ID: " + [Link]("id") + ", Name: " + [Link]("name"));

// Update operation (Update data)

String updateQuery = "UPDATE users SET email = ? WHERE name = ?";

PreparedStatement stmtUpdate = [Link](updateQuery);

[Link](1, "[Link]@[Link]");
 [Link](2, "John Doe");

[Link]();

// Delete operation (Delete data)

String deleteQuery = "DELETE FROM users WHERE name = ?";

PreparedStatement stmtDelete = [Link](deleteQuery);

[Link](1, "John Doe");

[Link]();

// Closing the connection

[Link]();

} catch (SQLException e) {

[Link]();

Detailed Explanation:

13. Connection: [Link]() is used to establish a connection to the

MySQL database. The database URL, username, and password are provided.

14. CRUD Operations:

o Create: The INSERT INTO query adds a new record to the users table.

o Read: The SELECT query retrieves data from the users table and prints it to the
console.

o Update: The UPDATE query modifies the email address of a user.

o Delete: The DELETE query removes a user based on the name.

15. PreparedStatement: This helps prevent SQL injection by safely inserting user input into
queries.

16. ResultSet: Used to retrieve and process the results of SELECT queries.

4. Event Handling Mechanisms in Java (Detailed Explanation)

In Java, event handling is achieved using the delegation event model. Here, the source of an event
(such as a button click) sends an event to an event listener, which then processes it. This allows
components to handle specific events in a modular way.
Key Concepts:

17. Event Source: The object that generates the event, like a button or a text field.

18. Event Listener: The object that listens for events. You can add listeners like ActionListener
(for button clicks), MouseListener (for mouse events), etc.

19. Event Object: Contains details about the event (e.g., the mouse coordinates, the key
pressed).

20. Adapter Classes: These are optional classes that provide default implementations for event
listeners, so you only need to override the methods you need.

Example of Button Click Handling:

import [Link].*;

import [Link].*;

public class ButtonEventExample {

public static void main(String[] args) {

Frame frame = new Frame("Event Handling Example");

Button button = new Button("Click Me");

// Add ActionListener to the button

[Link](new ActionListener() {

public void actionPerformed(ActionEvent e) {

[Link]("Button Clicked!"); // Action performed on click

});

[Link](new FlowLayout());

[Link](button);

[Link](200, 200);

[Link](true);

// Close the window properly

[Link](new WindowAdapter() {

public void windowClosing(WindowEvent we) {

 [Link](0); // Exit the program

});

Detailed Explanation:

1. The program listens for the button click event using addActionListener.

2. The actionPerformed() method is triggered when the button is clicked,

displaying a message in the console.

3. WindowAdapter handles the window close event (windowClosing) to terminate

the application.

5. Complete JDBC Implementation Process with Example Program

JDBC Implementation Process:

4. Loading the Driver: Using [Link]("driver_class_name") (optional for

newer JDBC versions).

5. Establishing Connection: Use [Link]() with the database

URL, username, and password.

6. Creating Statements: You can create a Statement, PreparedStatement, or

CallableStatement.

7. Executing Queries: Use executeQuery() for SELECT and executeUpdate() for

INSERT, UPDATE, DELETE.

8. Processing Results: Use ResultSet to fetch the results of SELECT queries.

9. Closing Resources: Always close the ResultSet, Statement, and Connection

objects to release resources.

Example Program:

import [Link].*;

public class JDBCImplementation {

public static void main(String[] args) {

String url = "jdbc:mysql://localhost:3306/mydb";

String user = "root";

String password = "rootpassword";

 try {

// Load the JDBC driver (not necessary with JDBC 4.0 and above)

[Link]("[Link]");

// Establish a connection

Connection conn = [Link](url, user, password);

// Create a Statement

Statement stmt = [Link]();

// Execute a query

ResultSet rs = [Link]("SELECT * FROM students");

while ([Link]()) {

[Link]("Student ID: " + [Link]("id") + ", Name: " + [Link]("name"));

// Close resources

[Link]();

[Link]();

[Link]();

} catch (Exception e) {

[Link]();

Explanation:

10. The program demonstrates how to connect to a MySQL database, execute a

SELECT query, and process the results using a ResultSet.

11. [Link]() loads the JDBC driver, and [Link]()

establishes a connection to the database.
12. The Statement object is used to execute queries, and the ResultSet processes
the result.