The java.sql package contain a prepared statement, This prepared statement interface is available from the Statement interface. This is used to pass parameters at runtime. In this Tutorial we want to describe you a code that helps you in understanding JDBC Insert Prepared Statement. For this we have a class Jdbc Insert Prepared statement, Inside this class we have a main method that include the list of following steps -
import a package java.sql - this provides you a network interface that help in communicating between front end and backend in database.
Loading a driver followed by calling a class.forname( ),this class accept a driver class as argument. The Driver Manager call getConnection (),which returns you a connection object and this is used to built a connection between url and database.
prepareStatement ( ) : This method is useful when you want to execute the same statement object many times, This reduces the time of execution to use the same object.The method accept a sql object as parameter, that include the list of inserted values into the table set The String( ) : Set String XXX is defined in prepared statement to substitute a value in the question mark placeholder as string,int .In the code, we substitute a question mark value as string.executeUpdate ( ) :This method provides you the numbers of affected rows in the table and execute the statement in a given code.executeQuery ( ):This method provides you a set of records retrieved from a table in the database. The select statement is used to obtain the records from the result set.
next ( ) : This method retain you the next elements in a series.
Finally the print print the No, Name from a employee table present in database. In case there is an exception in try block, the subsequent catch block check and handle the exception.
No Name Girish Tewari Rohini Indian Komal Singh Rohini Indian Sandeep kumar Rohini Indian Amit Singh Rohini Indian Girish Tewari Rohini Indian Darshan Tewari Rohini Indian Rakesh Kanwal Delhi Indian
We have 1000s of tutorials on our website. Search Tutorials tutorials on our website.
Posted on: November 19, 2008 If you enjoyed this post then why not add us on Google+? Add us to your Circles