【软件设计师备考 专题 】标准化知识：意识和发展（二）

#include <iostream>
#include <sys/socket.h>
#include <arpa/inet.h>
#include <unistd.h>
using namespace std;
int main() {
    int serverSocket = socket(AF_INET, SOCK_STREAM, 0);
    if (serverSocket == -1) {
        cout << "创建socket失败" << endl;
        return -1;
    }
    sockaddr_in serverAddr;
    serverAddr.sin_family = AF_INET;
    serverAddr.sin_port = htons(8888);
    serverAddr.sin_addr.s_addr = INADDR_ANY;
    if (bind(serverSocket, (struct sockaddr*)&serverAddr, sizeof(serverAddr)) == -1) {
        cout << "绑定地址失败" << endl;
        close(serverSocket);
        return -1;
    }
    if (listen(serverSocket, 5) == -1) {
        cout << "监听失败" << endl;
        close(serverSocket);
        return -1;
    }
    sockaddr_in clientAddr;
    socklen_t clientAddrLen = sizeof(clientAddr);
    int clientSocket = accept(serverSocket, (struct sockaddr*)&clientAddr, &clientAddrLen);
    if (clientSocket == -1) {
        cout << "接受连接失败" << endl;
        close(serverSocket);
        return -1;
    }
    char buffer[1024];
    ssize_t recvSize = recv(clientSocket, buffer, sizeof(buffer), 0);
    if (recvSize <= 0) {
        cout << "接收数据失败" << endl;
        close(clientSocket);
        close(serverSocket);
        return -1;
    }
    cout << "接收到客户端的数据：" << buffer << endl;
    close(clientSocket);
    close(serverSocket);
    return 0;
}

#include <iostream>
#include <mysql/mysql.h>
using namespace std;
int main() {
    MYSQL* mysql = mysql_init(NULL);
    if (mysql == NULL) {
        cout << "初始化数据库失败" << endl;
        return -1;
    }
    if (mysql_real_connect(mysql, "localhost", "root", "123456", "test", 3306, NULL, 0) == NULL) {
        cout << "连接数据库失败" << endl;
        mysql_close(mysql);
        return -1;
    }
    if (mysql_query(mysql, "CREATE TABLE IF NOT EXISTS students (id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(20) NOT NULL, age INT NOT NULL)")) {
        cout << "创建表失败" << endl;
        mysql_close(mysql);
        return -1;
    }
    if (mysql_query(mysql, "INSERT INTO students (name, age) VALUES ('Alice', 20), ('Bob', 22), ('Charlie', 25)")) {
        cout << "插入数据失败" << endl;
        mysql_close(mysql);
        return -1;
    }
    if (mysql_query(mysql, "SELECT * FROM students")) {
        cout << "查询数据失败" << endl;
        mysql_close(mysql);
        return -1;
    }
    MYSQL_RES* result = mysql_store_result(mysql);
    if (result == NULL) {
        cout << "获取查询结果失败" << endl;
        mysql_close(mysql);
        return -1;
    }
    MYSQL_ROW row;
    while ((row = mysql_fetch_row(result)) != NULL) {
        cout << "ID: " << row[0] << ", Name: " << row[1] << ", Age: " << row[2] << endl;
    }
    mysql_free_result(result);
    mysql_close(mysql);
    return 0;
}

@startuml
class Person {
  -name: string
  +getName(): string
  +setName(name: string): void
}
class Student {
  -studentId: string
  +getStudentId(): string
  +setStudentId(studentId: string): void
}
Person <|-- Student
@enduml