Junior — Middle

Have you used direct SQL query writing without using ORM or other abstractions?

sobes.tech AI

Answer from AI

Yes, direct SQL queries without using ORM are often used for more precise control over queries, performance optimization, or when working with non-standard queries. For example, in Java, JDBC can be used to execute SQL queries:

String query = "SELECT * FROM users WHERE id = ?";
try (PreparedStatement stmt = connection.prepareStatement(query)) {
    stmt.setInt(1, userId);
    ResultSet rs = stmt.executeQuery();
    while (rs.next()) {
        // process result
    }
}

This approach requires attention to security (e.g., SQL injection protection) and resource management (closing connections).

Previous Next