/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 vote242 views1 answer
Mysql disable triggers
SQL
0 vote184 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote188 views1 answer
CREATE MULTIPLE FK
SQL
0 vote220 views1 answer
Insert overwrite table in mysql in nifi
SQL
0 vote207 views1 answer
MySql get primary keys of table
SQL
0 vote225 views1 answer
Stored function in sql
SQL
2 votes211 views2 answers
Mysql date range
SQL
1 vote179 views1 answer
Restart identity postgresql
SQL
0 vote213 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
0 vote214 views1 answer
Sql waitfor
SQL