Home Jdbc JDBC Prepared Statement Addbatch

Related Tutorials


 
 

Share on Google+Share on Google+

JDBC Prepared Statement Addbatch

Advertisement
The code illustrate an example from JDBC Prepared statement Add batch. In this code we have defined a class Jdbc PreparedstatementAddbatch,

JDBC Prepared Statement Addbatch

     

The code illustrate an example from JDBC Prepared statement Add batch. In this code we have defined a class Jdbc PreparedstatementAddbatch, The class include a main method that follows the list of steps -

1)  Importing a java.sql package that contain the list of all classes ,provides you a network interface enables you to communicate between front end -back end database.

2) Loading a driver by simply calling a class.forName( ),that accept driver class as argument

3) DriverManager.getConnection ( ) - This method is used to built a connection between url and database.

4) prepare Statement ( ) -This method is used to create a sql object. An object of connection class  is used to execute the query in the database.

5) set String ( ) - This method is used to set the value as string in place of question mark place holder.

6) addBatch ( ) - This method is used to add a set of parameter to the batch of command to this sql server prepared object.

7) execute Batch ( ) - This method is used to submit a set of command in sql query to the database, In case all the commands successfully, return you an array update count.

8) prepare Statement ( ) -This method is used when you want to execute the statement object many times, this reduces the execution time to execute the object statement.

9) execute query ( ) - This method returns you a record set stored in a result set, The select statement is used to retrieve the record set from a database.

Finally the println print the Table name, Table field name and its type.In case the exception exists in a try block, the catch block caught and handle the exception. 

 

import java.sql.*; public class JdbcPreparedstatementAddbatch { public static void main(String args[]) { Connection con = null; PreparedStatement pst = null; ResultSet rs = null; String url = "jdbc:mysql://localhost:3306/"; String db = "komal"; String driver = "com.mysql.jdbc.Driver"; String user = "root"; String pass = "root"; try { Class.forName(driver); con = DriverManager.getConnection(url + db, user, pass); pst = con.prepareStatement("insert into lib value(?,?)"); con.setAutoCommit(false); pst.setString(1, "6"); pst.setString(2, "106"); pst.addBatch(); pst.setString(1, "7"); pst.setString(2, "107"); pst.addBatch(); pst.setString(1, "8"); pst.setString(2, "108"); pst.addBatch(); pst.executeBatch(); con.commit(); pst.close(); String sql = "select * from lib"; pst = con.prepareStatement(sql); rs = pst.executeQuery(); System.out.println("rno\tlibno"); while (rs.next()) { System.out.print(rs.getString(1) + " \t"); System.out.println(rs.getString(2)); } rs.close(); pst.close(); con.close(); } catch (Exception e) { e.printStackTrace();
       //In case of error call con.rollback()
        }
    }
}

Output

Table Name : Employees
Field		Type
--------------------
EmployeeID	 11
FirstName	 50
LastName	 50

Download code

Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: November 19, 2008

Related Tutorials

Discuss: JDBC Prepared Statement Addbatch  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0
DMCA.com