/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

10 votes169 views4 answers
Fetch first 5 characters of the string in sql
SQL
1 vote152 views1 answer
Median mysql
SQL
0 vote94 views1 answer
Update row in sqlite python
SQL
2 votes193 views1 answer
Oracle trace session
SQL
40 votes221 views4 answers
PostgreSQL add column
SQL
0 vote144 views1 answer
Postgres populate table from another table
SQL
0 vote140 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
1 vote153 views2 answers
Foreign key set 0
SQL
1 vote91 views1 answer
Postgresql last element of array
SQL
2 votes142 views1 answer
Mysql virtual column
SQL