Breaking News: Grepper is joining You.com. Read the official announcement!

how to prevent sql injection in java

Puzzled Peafowl answered on April 12, 2021 Popularity 10/10 Helpfulness 2/10

answer how to prevent sql injection in java

related How to prevent sql Injection

how to prevent sql injection in java

Comment

// This should REALLY be validated too
String custname = request.getParameter("customerName");
// Perform input validation to detect attacks
String query = "SELECT account_balance FROM user_data WHERE user_name = ? ";
PreparedStatement pstmt = connection.prepareStatement( query );
pstmt.setString( 1, custname);
ResultSet results = pstmt.executeQuery( );

Popularity 10/10 Helpfulness 2/10 Language sql

Source: cheatsheetseries.owasp.org

Tags: java sql sql-injection

Link to this answer
Share Copy Link

Contributed on Apr 12 2021

Puzzled Peafowl

0 Answers Avg Quality 2/10

Closely Related Answers

How to prevent sql Injection

Comment

// use prepared statement to prevent SQL injection
$preparedStatement = $dbConnection->prepare('SELECT * FROM animals WHERE name = ?');
$preparedStatement->bind_param('s', $name); 
$preparedStatement->execute();
$result = $preparedStatement->get_result();
while ($row = $result->fetch_assoc()) {
// Process $row
}

Popularity 10/10 Helpfulness 2/10 Language sql

Source: phppot.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jul 07 2021

Outstanding Lioncatcher

0 Answers Avg Quality 2/10

how to prevent sql injection in java

Contents

More Related Answers

how to prevent sql injection in java

Closely Related Answers

How to prevent sql Injection

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.