Link to home
Start Free TrialLog in
Avatar of gudii9
gudii9Flag for United States of America

asked on

jsp CRUD operations with and without prepared statement also hibernatge

Hi,

I am workign in jsp CRUD operations 0n mysql with and without prepared statements and hibernate approach. I wonder what are advanges and disadvantages and practical uses of each approach? can you please provide some sample code on each aproach to try on mysql databse preferable with primary key and foeign key kind of relationships as i am not that strong on the data modeling and relationships?
please advise
ASKER CERTIFIED SOLUTION
Avatar of gurpsbassi
gurpsbassi
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Oliver Russell
Oliver Russell

I can tell you about the benefit of using prepared statement to execute crud operations. The most important benefit is that prepared statement executes same query multiple times with more efficiency. This minimize the risk of sql injection attacks on your website. This is the most secure and efficient method of performing crud in PHP/MySQL.