/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 votes355 views2 answers
Oracle drop sequence
SQL
0 vote288 views1 answer
Update using case in mysql
SQL
4 votes294 views1 answer
Describe table mysql
SQL
0 vote283 views2 answers
What is 1=2 in sql
SQL
6 votes307 views2 answers
Mysql interval 1 day
SQL
5 votes289 views1 answer
Oracle sysdate
SQL
0 vote301 views1 answer
Add multiple field in table sql
SQL
0 vote288 views1 answer
Components/Fields of Internal Table
SQL
0 vote325 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote305 views1 answer
How to to get time in sql
SQL