Java JDBC Commit Statement Example

            /* ............... 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 ............... */