Content ITV PRO
This is Itvedant Content department
Topic Name
Subtopic Name
Learning Outcome(Slide2)
6
Basics of branding and messaging
5
Target audience and segmentation
4
Different marketing channels
3
Creating value for customers
2
Understanding customer needs
1
What marketing means ?
Choose cool, soft colors instead of vibrant colors
Max 6 Points for Summary & Min 4
Topic Name-Recall(Slide3)
Imagine you are the librarian of a busy library
Whenever a new book arrives, you add it to the catalog so readers can easily find it.
Whenever a reader asks which Java books are available, you search the catalog and show the results.
Whenever a book is moved to a different shelf, you update its location in the catalog to keep the information accurate.
Whenever a book gets damaged and removed, you delete its entry from the catalog.
To keep the library running smoothly, the catalog must always remain accurate, organized, and up to date.
Just like a library manages books using a catalog:
A program needs a way to store information
It must retrieve specific details when needed
It should modify existing information
And sometimes remove data that’s no longer required
In programming—especially when working with databases—these actions are formally known as: CRUD operations
What is API?
API stands for Application Programming Interface. It is a set of classes, interfaces, and methods that allow different software components to communicate.
Interfaces and classes of JDBC API
Statement
SQLException
Connection
ResultSet
Driver
DriverManager
Represents the JDBC driver for a specific database.
Driver
DriverManager
Establishes a Connection to the database.
Connection
Represents a session with the database.
Statement
Used to execute SQL queries.
ResultSet
Holds the data returned by a SELECT query.
SQLException
Handles all database errors.
-
It is more secure than Statement, prevents SQL injection
String sql = "INSERT INTO student (id, name, age) VALUES (?, ?, ?)";
PreparedStatement ps = con.prepareStatement(sql);
ps.setInt(1, 101);
ps.setString(2, "John");
ps.setInt(3, 20);
ps.executeUpdate(); // Executes the insert
Age
101
ID
Name
John
20
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery ("SELECT * FROM students");
while (rs.next()) {
System.out.println(
rs.getInt("id") + " " + rs.getString("name")
);
- Use executeQuery() to run a SELECT query, store the results in a ResultSet, move through rows using rs.next(), and read column values with getInt(), getString(), etc.
ID
Name
101
John
-
? are placeholders, filled with setInt(), setString(), etc.
-
executeUpdate() → used for UPDATE, INSERT, DELET
String query = "UPDATE students SET age = ? WHERE id = ?";
PreparedStatement pstmt = conn.prepareStatement(query);
pstmt.setInt(1, 23); // new age
pstmt.setInt(2, 1); // student id
int rows = pstmt.executeUpdate();
System.out.println(rows + " row(s) updated.")
Age
101
ID
Name
John
23
Summary
5
Build strong branding
4
Use different marketing channels
3
Target the right audience
2
Create and communicate value
1
Understand customer needs
Choose cool, soft colors instead of vibrant colors
Max 5 Points for Summary & Min 2
Quiz
Which platform is mainly used for professional networking and B2B marketing ?
A. Facebook
B. Instagram
C. LinkedIn
D. Snapchat
Quiz-Answer
Which platform is mainly used for professional networking and B2B marketing ?
A. Facebook
B. Instagram
C. LinkedIn
D. Snapchat
JAVA - JDBC CRUD CRAZE
By Content ITV
