Method executeUpdate

src/main/java/smbms/dao/BaseDao.java:92–101

更新操作,返回受影响的行数 @param connection @param pstm @param sql @param params @return @throws Exception

(Connection connection, PreparedStatement pstm,
                                    String sql, Object[] params)

     * @throws Exception
     */
    public static int executeUpdate(Connection connection, PreparedStatement pstm,
                                    String sql, Object[] params) throws Exception {
        int updateRows = 0;
        pstm = connection.prepareStatement(sql);
        for (int i = 0; i < params.length; i++) {
            pstm.setObject(i + 1, params[i]);
        }
        updateRows = pstm.executeUpdate();
        return updateRows;
    }

    /**
     *