/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 votes127 views1 answer
Query any digits record
SQL
1 vote122 views2 answers
Begin transaction in sql
SQL
0 vote112 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote78 views1 answer
Mysql workbench search all tables
SQL
16 votes115 views2 answers
Add column to all tables after first column mysql
SQL
0 vote120 views1 answer
Drop-toys-table
SQL
0 vote115 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote120 views1 answer
Postgres enumerated type
SQL
3 votes168 views6 answers
Jwt laravel
SQL
0 vote163 views1 answer
Osm2pgsql mac
SQL