con = DriverManager.getConnection(Singleton.getBase(), Singleton.getBase_login(), Singleton.getBase_password());
 proc = con.prepareCall("{ call имя_процедуры(" + param + ")}");
 proc.executeQuery();

con = DriverManager.getConnection(Singleton.getBase(), Singleton.getBase_login(), Singleton.getBase_password());
proc = con.prepareCall("{ call имя_процедуры(" + param + ")}");
rs = proc.executeQuery();
rs.next();
rs.getString("имя столбца") - результат хранимки

 UPDATE `table` SET `field` = CASE `id`
WHEN val1 THEN data1
WHEN val2 THEN data2
ELSE `field` END

UPDATE `table` SET `field`=нужное

 UPDATE `table` SET `field` = CASE `id`
WHEN val1 THEN data1
WHEN val2 THEN data2
ELSE `field` END

try {
            con = DriverManager.getConnection(getBase, getBase_login, getBase_password);
            proc = con.prepareCall("{ call page1('" + param + "')}");
            rs = proc.executeQuery();
            while(rs.next()){
ля-ля
            }
        } catch (SQLException ex) {
            Logger.getLogger(SSLServer.class.getName()).log(Level.SEVERE, null, ex);
        } finally {
            try {
                proc.close();
                rs.close();
                con.close();
            } catch (SQLException ex) {
                Logger.getLogger(SSLServer.class.getName()).log(Level.SEVERE, null, ex);
            }

Connection cn = null;
        Statement st = null;

        try {
            cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/PaymentServer?user=root&password=xxxxxx");

            ResultSet rs = null;

            st = cn.createStatement();

            StringBuilder updateQuery = new StringBuilder("");
            if (listsOfResponses.getResponseList().size() > 0) {
                for (ResponseFromOperator responseFromOperator : listsOfResponses.getResponseList()) {
                    st.addBatch("UPDATE OperationtTable SET paymentresult = '" + responseFromOperator.getResponse() + "' WHERE paymentid = " + responseFromOperator.getId() + ";");
                }

                st.executeBatch();

                st.close(); ------------------------это лишнее
                cn.close(); -----------------------это лишнее
            }
        }

        catch (Exception e) {
            e.printStackTrace();
        }
        finally {
            try {

                st.close();
                cn.close();
            } catch (Exception ex) {
                ex.printStackTrace();
            }
        }
    }