Home Jdbc JDBC Prepared Statement Addbatch

JDBC Prepared Statement Addbatch
Posted on: November 19, 2008 at 12:00 AM

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

Related Tags for JDBC Prepared Statement Addbatch:
c, class, jdbc, batch, state, bat, this, dba, define, example, add, statement, dst, exam, e, il, from, in, as, sta, m, nt, par, tr, dd, j, prepared, ad, dbc, db, cl, em, me, jdb, preparedstatement, rate, defined, xa, xamp, s, at, is, ha, ll, mpl, pre, ar, stat, cod, code, str, s, s, th, av, bc, st, fin, ple, pl, pr, ode, om, o

«Previous Index Next»