what are Prepared statement?Explain with example.?

Answer 1

Prepaid statement is an accounting term.
It is a statement issued to you by your creditor when you have paid your credit in advance, (or earlier to the due date.)
eg
you owe me $100 and I have given you a a week to pay it (given that I have to set my accounts at the end of the week).
My accouting period haven't started yet and you have paid me $100, so as you have paid your debt prior to the due date, and prior to the date it should have been recorded in my accounting books so I'll issue you a "Prepaid statement" of your payment.

Answer 2

I guess you are asking this question from Java programming language context.

Every query you submit to the database to execute (be it select, insert or update), has to go through many phases. Namely, Parsining, Execution and Fetching (only for select).

Parsing phase is very important as this is the phase where database checks if the query you submitted is syntactically and symantically valid. Like it checks if you have used the correct sytax, whether the tables/columns you referred are there etc. Once your query passes through this phase, database would execute the query and return the results.

If you are executing the same query again and again, you can save time database takes to parse by caching it. This is called prepared statement.

So you create a database query once and execute it over and over again using different bind parameters.