Junior — Middle
Do you have skills in writing prepared SQL queries?
sobes.tech AI
Answer from AI
Yes, I know how to write prepared SQL queries. They allow for safe parameter passing, preventing SQL injection and improving performance during repeated execution.
Example in Java using JDBC:
String sql = "SELECT * FROM users WHERE email = ?";
PreparedStatement pstmt = connection.prepareStatement(sql);
pstmt.setString(1, "user@example.com");
ResultSet rs = pstmt.executeQuery();
This approach ensures that parameters are properly escaped and queries are executed efficiently.