/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 vote183 views1 answer
Postgresql like
SQL
2 votes199 views3 answers
Mysql list tables by size
SQL
1 vote189 views1 answer
Give a column name to values generated from case statement in sql
SQL
25 votes183 views3 answers
How to use a database to see tables mysql
SQL
2 votes203 views1 answer
Install postgresql centos 5
SQL
1 vote307 views1 answer
Mysql breakline on string
SQL
0 vote197 views3 answers
Delete in SQL SERVER
SQL
0 vote232 views1 answer
Postgresql select fast check no rows
SQL
1 vote196 views2 answers
Sql drop multiple columns if exists
SQL
5 votes185 views1 answer
Alter table add comment oracle
SQL