/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 vote156 views1 answer
Sql reverse order of results
SQL
0 vote166 views1 answer
Like and not like together in sql
SQL
0 vote146 views1 answer
Get first name and last name from full name string in SQL
SQL
1 vote187 views1 answer
Oracle schema size
SQL
0 vote160 views1 answer
Query by column for substring sql
SQL
0 vote171 views1 answer
Sql cmd no truncate
SQL
0 vote164 views1 answer
How to use lower case in mysql
SQL
6 votes150 views1 answer
Phpmyadmin password root
SQL
0 vote145 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
3 votes177 views3 answers
1396(hy00) mysql error
SQL