How to use MySQL and C++ to develop a command line-based library management system

How to use MySQL and C to develop a command line-based library management system

Summary:
In this article, we will introduce how to use MySQL and C to develop A simple command line based library management system. We'll cover the entire process from database design to C code implementation, and provide specific code examples.

Introduction:
Book management system is a common application used to manage libraries or personal book collections. By using MySQL as the database and C as the programming language, we can easily implement a fully functional library management system and provide users with convenient book search, borrowing and return functions.

Step 1: Database design
First, we need to design a suitable database schema to store books and related information. In this example, we will use the following table:

• books table: stores basic information about books, including book ID, title, author, and publication date.
• Users table: stores user information, including user ID, user name, password, etc.
• borrowings table: stores book borrowing records, including borrowing ID, book ID, user ID, borrowing date and return date, etc.

The following is an example MySQL code to create a table:

CREATE TABLE books (
    book_id INT PRIMARY KEY,
    title VARCHAR(100),
    author VARCHAR(100),
    publication_date DATE
);

CREATE TABLE users (
    user_id INT PRIMARY KEY,
    username VARCHAR(100),
    password VARCHAR(100)
);

CREATE TABLE borrowings (
    borrowing_id INT PRIMARY KEY,
    book_id INT,
    user_id INT,
    borrowing_date DATE,
    return_date DATE,
    FOREIGN KEY (book_id) REFERENCES books(book_id),
    FOREIGN KEY (user_id) REFERENCES users(user_id)
);

Step 2: C code implementation
Next, we will use C to link to the MySQL database and write Code to implement various functions of the library management system.

First, we need to include the necessary C header files:

#include <iostream>
#include <mysql.h>

Then, we need to create a connect function to connect to the MySQL database:

MYSQL* connect() {
    MYSQL* conn;
    conn = mysql_init(NULL);
    if (conn == NULL) {
        std::cout << "Failed to initialize mysql client library" << std::endl;
        exit(1);
    }
    if (mysql_real_connect(conn, "localhost", "username", "password", "database_name", 0, NULL, 0) == NULL) {
        std::cout << "Failed to connect to database" << std::endl;
        exit(1);
    }
    return conn;
}

Next, we can implement various functions, such as adding books, deleting books, borrowing books, returning books, etc. The following is a sample function addBook to add books to the database:

void addBook(MYSQL* conn, int book_id, std::string title, std::string author, std::string publication_date) {
    std::string query = "INSERT INTO books (book_id, title, author, publication_date) VALUES ("
                      + std::to_string(book_id) + ",'" + title + "','" + author + "','" + publication_date + "')";
    if (mysql_query(conn, query.c_str()) != 0) {
        std::cout << mysql_error(conn) << std::endl;
    }
}

Finally, we can write a main function to test various functional functions:

int main() {
    MYSQL* conn = connect();
    addBook(conn, 1, "C++ Primer", "Stanley B. Lippman", "1998-10-01");
    // ... 其他功能函数的调用

    mysql_close(conn);
    return 0;
}

Summary:
Through this article, we learned how to use MySQL and C to develop a command line-based library management system. From database design to C code implementation, we cover the entire development process and provide specific code examples. With this foundation, we can further expand and improve the library management system to meet our own needs.

The above is the detailed content of How to use MySQL and C++ to develop a command line-based library management system. For more information, please follow other related articles on the PHP Chinese website!