Java

import javax.sql.DataSource;
import java.sql.*;
import java.util.*;
import java.util.stream.Collectors;
import java.util.stream.Stream;


DataSource ds = ...;
try(Connection conn = ds.getConnection()) {    // remember to enclosed by try with resource pattern
    conn.setAutoCommit(false);              // starts with disable auto commit

    // Selecting from table
    PreparedStatement stmt = conn.prepareStatement("select fieldA,fieldB,fieldC from {table}");
    ResultSet rs = stmt.executeQuery();
    while (rs.next()){          // loop over records
        System.out.println("Field A: " + rs.getString("fieldA"));
        System.out.println("Field A: " + rs.getString("fieldB"));
        System.out.println("Field C: " + rs.getString("fieldC"));
    }


    String insertionSql = "INSERT INTO {table} (fieldA, fieldB, fieldC) VALUES (?,?,?)";
    stmt = conn.prepareStatement(insertionSql);
    stmt.setString(1, "a");
    stmt.setString(2, "b");
    stmt.setString(3, "c");
    int resultCount = stmt.executeUpdate(); // return number of record inserted

    ArrayList<Integer> list = new ArrayList<Integer>();
    List<Map<String, String>> dataToBeInserted = Arrays.asList(
            Stream.of(
                    new AbstractMap.SimpleEntry<>("fieldA", "a"),
                    new AbstractMap.SimpleEntry<>("fieldB", "b"),
                    new AbstractMap.SimpleEntry<>("fieldC", "c")
            ).collect(Collectors.toMap(Map.Entry::getKey, Map.Entry::getValue)),
            Stream.of(
                    new AbstractMap.SimpleEntry<>("fieldA", "d"),
                    new AbstractMap.SimpleEntry<>("fieldB", "e"),
                    new AbstractMap.SimpleEntry<>("fieldC", "f")
            ).collect(Collectors.toMap(Map.Entry::getKey, Map.Entry::getValue))
    );
    stmt.executeBatch();

    stmt = conn.prepareStatement(insertionSql);
    int i=0;
    for(Map<String, String> item : dataToBeInserted){
        stmt.setString(1, item.get("fieldA"));
        stmt.setString(2, item.get("fieldB"));
        stmt.setString(3, item.get("fieldC"));
        i++;
        if(i%100 == 0){
            list.add(stmt.executeBatch().length);
        } else {
            stmt.addBatch();
        }
    }
    if(i%100 != 0) {
        list.add(stmt.executeBatch().length);
    }
    System.out.println("Batch insertion result: " + list.stream().mapToInt(x->x).sum());


    /**
     *The procedure have three parameters
     *  - in value 
     *  - out value
     *  - in and out value
     * Result:
     *  - 2 param will the error message if any
     *  - 3 param will be the actual return value
     */
    String callProcedure = "{ call procedure_name(?,?,?)}";
    CallableStatement cs = conn.prepareCall(callProcedure);
    cs.setString(1, "inputValue for 1");        // The value passing in the procedure
    cs.registerOutParameter(2, Types.VARCHAR);  // The value registered for output
    cs.setString(3, "inputValue for 3");        // The value passing in the procedure
    cs.registerOutParameter(3, Types.VARCHAR);  // The value registered for output
    cs.execute();

    String error = cs.getString(2);             // extract the error if any 
    String resultValue = cs.getString(3);       // extract the value if any

    if(error != null){
        System.out.println("Error from procedure: " + error);
    } else {
        System.out.println("Result from procedure: " + resultValue);
    }
} catch (Exception ex){
    throw ex;
}