/SQL/A good way of running a SQL query in JDBC using a parameterized statement

A good way of running a SQL query in JDBC using a parameterized statement

// Connect to the database.
Connection conn = DriverManager.getConnection(URL, USER, PASS);

// Construct the SQL statement we want to run, specifying the parameter.
String sql = "SELECT * FROM users WHERE email = ?";

// Generate a prepared statement with the placeholder parameter.
PreparedStatement stmt = conn.prepareStatement(sql);

// Bind email value into the statement at parameter index 1.
stmt.setString(1, email);

// Run the query...
ResultSet results = stmt.executeQuery(sql);

while (results.next())
{
    // ...do something with the data returned.
}

Source: hacksplaining.com

Similar codes

0 vote351 views4 answers
Best data type to represent money in mysql
SQL
0 vote350 views2 answers
How to know the character set of an oracle databes
SQL
3 votes370 views1 answer
Oracle failed login attempts
SQL
0 vote352 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
2 votes357 views1 answer
SQL column name Postgre
SQL
1 vote331 views3 answers
Default password of mysql
SQL
4 votes353 views1 answer
Mysql copy table with new name
SQL
0 vote347 views1 answer
Commit transaction sql
SQL
0 vote356 views1 answer
Oracle current session details
SQL
17 votes390 views2 answers
T_sql contains
SQL