/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 vote174 views1 answer
Phpmyadmin tabellentyp ändern
SQL
3 votes243 views2 answers
Oracle drop column
SQL
9 votes186 views3 answers
Sql delete where in
SQL
1 vote177 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
18 votes166 views3 answers
Mysql query add column with default string value
SQL
1 vote267 views3 answers
Showing all columns in an sqlite table
SQL
8 votes173 views2 answers
Mysql get first x characters
SQL
0 vote194 views1 answer
Is not numeric sql
SQL
0 vote240 views1 answer
How many rows affected in sqllite
SQL
-1 vote172 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL