编程软件排序代码怎么写

时间:2025-01-26 09:11:36 网络游戏

1. VBA(Excel)

假设你手头有一份学生成绩单,列 A 是学生姓名,列 B 是考试成绩,现在想先按成绩从高到低排序,成绩相同的再按姓名升序排列。

```vba

Sub SortStudents()

Dim ws As Worksheet

Set ws = ThisWorkbook.Worksheets("Sheet1") ' 改成你实际的工作表名

ws.Range("A1:B100").Sort Key1:=ws.Range("B1"), Order1:=xlDescending, Key2:=ws.Range("A1"), Order2:=xlAscending, Header:=xlYes

End Sub

```

2. C++

```cpp

include

include

void swap(int *a, int *b) {

int t = *a;

*a = *b;

*b = t;

}

int partition(std::vector &arr, int low, int high) {

int pivot = arr[high];

int i = (low - 1);

for (int j = low; j <= high - 1; j++) {

if (arr[j] < pivot) {

i++;

swap(&arr[i], &arr[j]);

}

}

swap(&arr[i + 1], &arr[high]);

return (i + 1);

}

void quickSort(std::vector &arr, int low, int high) {

if (low < high) {

int pi = partition(arr, low, high);

quickSort(arr, low, pi - 1);

quickSort(arr, pi + 1, high);

}

}

int main() {

std::vector arr = {10, 7, 8, 9, 1, 5};

quickSort(arr, 0, arr.size() - 1);

for (int i = 0; i < arr.size(); i++) {

std::cout << arr[i] << " ";

}

return 0;

}

```

3. Python

冒泡排序

```python

def bubbleSort(arr):

n = len(arr)

for i in range(n):

for j in range(0, n-i-1):

if arr[j] > arr[j+1]:

arr[j], arr[j+1] = arr[j+1], arr[j]

return arr

```

选择排序

```python

def selectionSort(arr):

n = len(arr)

for i in range(n):

min_idx = i

for j in range(i+1, n):

if arr[min_idx] > arr[j]:

min_idx = j

arr[i], arr[min_idx] = arr[min_idx], arr[i]

return arr

```

插入排序

```python

def insertionSort(arr):

for i in range(1, len(arr)):

key = arr[i]

j = i-1

while j >= 0 and key < arr[j]:

arr[j+1] = arr[j]

j -= 1

arr[j+1] = key

return arr

```

快速排序

```python

def quickSort(arr):

if len(arr) <= 1:

return arr

pivot = arr[len(arr)//2]

left = [x for x in arr if x < pivot]

middle = [x for x in arr if x == pivot]

right = [x for x in arr if x > pivot]

return quickSort(left) + middle + quickSort(right)

```

这些示例代码展示了如何在不同的编程语言中实现排序算法。你可以根据具体需求选择合适的排序算法和编程语言。