/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 vote111 views2 answers
Insert into
SQL
0 vote135 views1 answer
Gcloud sql list databases
SQL
0 vote112 views1 answer
Import big data to mysql
SQL
0 vote133 views1 answer
Java nosql sort
SQL
0 vote117 views1 answer
Mysql calculated column
SQL
0 vote123 views1 answer
Pl/pgsql declare variable
SQL
0 vote117 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
2 votes105 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote124 views1 answer
Convert int to varchar sql
SQL
0 vote118 views1 answer
Mysql add to number
SQL