Java JDBC Commit Statement Example
Chapter:
JDBC
Last Updated:
10-09-2016 07:23:21 UTC
Program:
/* ............... START ............... */
import java.sql.*;
public class JavaJDBCCommitStatement {
public static void main(String[] args) throws Exception {
Class.forName("org.apache.derby.jdbc.ClientDriver");
Connection connection = DriverManager.
getConnection("jdbc:derby://localhost:1527/testDb", "name", "pass");
Statement stmt = connection.createStatement();
String query = "insert into emp values(2,'name1','job')";
String query1 = "insert into emp values(5,'name2','job')";
String query2 = "select * from emp";
ResultSet rs = stmt.executeQuery(query2);
int no_of_rows = 0;
while (rs.next()) {
no_of_rows++;
}
System.out.println("No. of rows before commit statement = " + no_of_rows);
connection.setAutoCommit(false);
stmt.execute(query1);
stmt.execute(query);
connection.commit();
rs = stmt.executeQuery(query2);
no_of_rows = 0;
while (rs.next()) {
no_of_rows++;
}
System.out.println("No. of rows after commit statement = " + no_of_rows);
}
}
/* ............... END ............... */
Tags
JDBC Commit Statement Example, Java, JDBC