/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

24 votes247 views5 answers
Import dump mysql
SQL
0 vote236 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
3 votes322 views4 answers
Sql interview questions
SQL
0 vote297 views1 answer
Sql check if field is not null
SQL
0 vote232 views1 answer
How to put is null in where in clause
SQL
14 votes247 views2 answers
Oracle add column with default value
SQL
0 vote220 views1 answer
Sql remove last x char
SQL
0 vote244 views1 answer
Sort by
SQL
5 votes259 views1 answer
Sql integer to serial
SQL
3 votes232 views2 answers
Oracle apex charging debug
SQL