Java Database Connectivity (JDBC) bilan tajribangiz qanday?

Java Database Connectivity (JDBC) — bu Java ilovalari bilan ma'lumotlar bazalari o'rtasida o'zaro aloqani ta'minlovchi API.

JDBC bilan ishlash tajribasi odatda quyidagilarni o'z ichiga oladi:

• DriverManager.getConnection() yordamida ma'lumotlar bazasiga ulanish.
• Statement yoki PreparedStatement yordamida SQL so'rovlarini yaratish va bajarish.
• ResultSet orqali so'rov natijalarini qayta ishlash.
• Transaktsiyalarni boshqarish (commit, rollback).
• Resurslarni yopish va oqib ketishlarni oldini olish.

JDBC yordamida oddiy so'rov misoli:

try (Connection conn = DriverManager.getConnection(url, user, password);
     PreparedStatement ps = conn.prepareStatement("SELECT * FROM users WHERE id = ?")) {
    ps.setInt(1, 10);
    try (ResultSet rs = ps.executeQuery()) {
        while (rs.next()) {
            System.out.println(rs.getString("username"));
        }
    }
}

Tajribaga ulash uchun shuningdek, ulanish havzalar bilan ishlash, xatoliklarni boshqarish va so'rovlarni optimallashtirish kiradi.