/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

1 vote150 views1 answer
Stored procedure return value
SQL
0 vote182 views1 answer
Mysql limit order by
SQL
4 votes191 views6 answers
List all tables in postgres
SQL
0 vote158 views1 answer
Postgres 11 add primary key
SQL
-1 vote168 views2 answers
Postgresql user permissions to database
SQL
12 votes174 views1 answer
Script to add new column in table sql
SQL
0 vote190 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote127 views1 answer
Jooq finding lastest value in table
SQL
0 vote186 views2 answers
Mysql dump database tables only
SQL
51 votes278 views6 answers
Opera gx
SQL