/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

3 votes353 views2 answers
Sql end of month
SQL
1 vote326 views1 answer
Show table columns
SQL
3 votes335 views1 answer
Dbms_scheduler drop_job
SQL
1 vote343 views1 answer
Copy postgres table from one schema into another
SQL
0 vote363 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote345 views1 answer
Stored function in sql
SQL
0 vote367 views1 answer
Select true if exists on another table or false sqlserver
SQL
18 votes290 views2 answers
How to get all the tables displayed in oracle
SQL
3 votes320 views1 answer
How to check schema privileges in oracle
SQL
19 votes351 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL