How do I use prepared statements in different programming languages?

Can you explain what prepared statements are?

Prepared statements are precompiled SQL statements that can be executed multiple times with different parameters, improving performance and security.

How do I use prepared statements in Python?

In Python, you can use the sqlite3 module. Here's an example:

import sqlite3

conn = sqlite3.connect('example.db')
cursor = conn.cursor()

# Prepare a statement
stmt = "INSERT INTO users (name, age) VALUES (?, ?)"

# Execute with parameters
cursor.execute(stmt, ('Alice', 30))
conn.commit()

What about in PHP?

In PHP, you can use PDO. Here's a quick example:

$pdo = new PDO('mysql:host=localhost;dbname=test', 'user', 'password');
$stmt = $pdo->prepare('SELECT * FROM users WHERE age > ?');
$stmt->execute([25]);
$results = $stmt->fetchAll();

Can you show me an example in Java?

Sure! In Java, you can use JDBC like this:

Connection conn = DriverManager.getConnection(url, user, password);
PreparedStatement pstmt = conn.prepareStatement("SELECT * FROM users WHERE name = ?");
pstmt.setString(1, "Bob");
ResultSet rs = pstmt.executeQuery();