/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

7 votes194 views2 answers
N highest salary in sql
SQL
5 votes187 views2 answers
Oracle tables with column name
SQL
1 vote196 views1 answer
Postgres set column based on another column
SQL
13 votes193 views2 answers
Get date from now() mysql
SQL
2 votes217 views2 answers
Calculate percentage in sql
SQL
0 vote194 views1 answer
Mysql update even / odd rows
SQL
4 votes189 views1 answer
Adding data to table in sql python
SQL
0 vote184 views1 answer
Sum value by month sql
SQL
12 votes220 views4 answers
How to check mysql version ubuntu
SQL
0 vote201 views1 answer
Drop column from local database postgres pgadmin
SQL