gudii9
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.