/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

4 votes323 views4 answers
Sqlite describe table
SQL
0 vote353 views1 answer
Sql max of two values
SQL
2 votes313 views1 answer
Sql select min value from multiple columns
SQL
1 vote317 views1 answer
Oracle split string
SQL
0 vote315 views2 answers
Create new table plsql
SQL
8 votes283 views1 answer
Similarities between ddl and dml
SQL
3 votes333 views3 answers
Docker create postgresql database
SQL
4 votes364 views6 answers
List all tables in postgres
SQL
0 vote318 views4 answers
Mysql select bottom 10 rows
SQL
0 vote332 views1 answer
Extract sql from query object sqlalchemy
SQL