PreparedStatement

java.sql.PreparedStatement is a more powerful database operation class than java.sql.Statement. You can send a pre-compiled SQL statement to the database server with specified parameters. It is more efficient than java.sql.Statement  when execute similar sql commands repeatedly. This article will show you how to use java.sql.PreparedStatement to implement create table, insert, update or delete records from MySQL Server.

To select data from table use java.sql.PreparedSatement, you need first create a select sql command, and then get data list by execute java.sql.PreparedSatement.executeQuery() method. This article will show you examples.