/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 vote252 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
0 vote307 views3 answers
Postgres trim string
SQL
0 vote261 views2 answers
Enter into postgresql database,create user and grant Access
SQL
0 vote270 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote259 views1 answer
Sql server express download
SQL
5 votes271 views3 answers
Postgres show databases
SQL
0 vote218 views1 answer
Oracle list all stored procedures
SQL
0 vote253 views1 answer
How to get initials in sql
SQL
8 votes279 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote260 views1 answer
Mysql utc timestamp
SQL