transfermoney.java

来自「噶额外噶外骨骼感广泛高热感 就 啊啊」· Java 代码 · 共 50 行

/**
 * JDBC Stored Procedure ITSO.transferMoney
 * @param account1 
 * @param account2 
 * @param amount 
 * @param success 
 */
/**
 * Header fragment inserted from SP_JAVA_HDR.FRAGMENT
 */
import java.sql.*;                   // JDBC classes

public class TransferMoney
{
    public static void transferMoney ( String account1,
                                       String account2,
                                       java.math.BigDecimal amount,
                                       int[] success ) throws SQLException, Exception
    {
        // Get connection to the database
        Connection con = DriverManager.getConnection("jdbc:default:connection");
        PreparedStatement stmt = null;
        PreparedStatement stmt2 = null;
        int updateCount = 0;
        int updateCount2 = 0;
        String sql, sql2;

                sql = "UPDATE  ITSO.ACCOUNT"
                    + "    SET  BALANCE = (BALANCE -  ?) "
                    + "  WHERE  ACCID =  ?   "
                    + "    AND  BALANCE >  ?";
                stmt = con.prepareStatement( sql );
                stmt.setBigDecimal( 1, amount );
                stmt.setString( 2, account1 );
                stmt.setBigDecimal( 3, amount );
                updateCount = stmt.executeUpdate();

                sql2 = "UPDATE  ITSO.ACCOUNT"
                    + "    SET  BALANCE = (BALANCE +  ?) "
                    + "  WHERE  ACCID =  ?";
                stmt2 = con.prepareStatement( sql2 );
                stmt2.setBigDecimal( 1, amount );
                stmt2.setString( 2, account2 );
                updateCount2 = stmt2.executeUpdate();
 
        // Set return parameter
        success[0] = updateCount + updateCount2;
    }
}