/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 vote228 views1 answer
Liquibase update row
SQL
0 vote173 views1 answer
Sql select upcoming birthdays
SQL
4 votes174 views2 answers
Error loading MySQLdb module.
SQL
0 vote169 views1 answer
How to install mysql without admin rights
SQL
58 votes520 views6 answers
Create new user in postgres
SQL
0 vote130 views1 answer
Expose db in virtualbox
SQL
0 vote168 views1 answer
Sql add calculated column
SQL
9 votes157 views4 answers
How to remove duplicate in sql
SQL
0 vote328 views1 answer
Sql change a colum to unique
SQL
3 votes261 views1 answer
Sql add two values together
SQL