/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

2 votes219 views2 answers
Sql query to copy data from one column to another
SQL
17 votes230 views3 answers
Postgresql version command
SQL
0 vote237 views1 answer
Mysql terminal run sql file
SQL
1 vote228 views1 answer
PLS-00225 type
SQL
-1 vote235 views1 answer
Sql oracle take only last results
SQL
1 vote226 views3 answers
Postgresql connect to database
SQL
0 vote213 views1 answer
Hibernate with springboot mysql
SQL
0 vote249 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
0 vote222 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
0 vote233 views1 answer
Sql common columns
SQL