# library-management-system

**Repository Path**: scc-zl/library-management-system

## Basic Information

- **Project Name**: library-management-system
- **Description**: 图书馆管理系统
- **Primary Language**: Java
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-12-17
- **Last Updated**: 2025-12-18

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 图书管理系统

## 一、数据库准备

```sql
/*
SQLyog Ultimate v8.32 
MySQL - 8.0.15 : Database - test
*********************************************************************
*/
CREATE DATABASE `library_system`;
USE `library_system`;

CREATE TABLE `student` (
  `s_id` varchar(20) NOT NULL,
  `name` varchar(12) NOT NULL,
  `password` varchar(20) NOT NULL,
  `age` int,
  `profession` varchar(20),
  `grade` varchar(20),
  `sex` char(4),
  `integrity` int DEFAULT 1,
  `cumulative` int DEFAULT 0,
  PRIMARY KEY (`s_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `manager` (
  `id` varchar(20) NOT NULL,
  `name` varchar(12) NOT NULL,
  `password` varchar(20) NOT NULL,
  `age` int,
  `phone` char(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `book_sort` (
  `sort_id` int NOT NULL AUTO_INCREMENT,
  `sort_name` varchar(20) NOT NULL,
  PRIMARY KEY (`sort_id`),
  UNIQUE KEY (`sort_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `book` (
  `ISBN` varchar(20) NOT NULL,
  `book_name` varchar(50) NOT NULL,
  `book_author` varchar(20) NOT NULL,
  `book_pub` varchar(50),
  `sort_id` int NOT NULL,
  `book_record` datetime,
  `book_price` DECIMAL NOT NULL,
  `book_borrow` int DEFAULT 0,
  PRIMARY KEY (`ISBN`),
  FOREIGN KEY (sort_id) REFERENCES book_sort(sort_id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `borrow` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `ISBN` VARCHAR(20) NOT NULL,
  `s_id` VARCHAR(20) NOT NULL,
  `price` DECIMAL NOT NULL,
  `book_name` VARCHAR(50) NOT NULL,
  `borrow_date` DATETIME NOT NULL,
  `expect_return_date` DATETIME NOT NULL,
  `return_date` DATETIME NOT NULL,
  `book_borrow` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  FOREIGN KEY (s_id) REFERENCES student(s_id) ON DELETE CASCADE ON UPDATE CASCADE,
  FOREIGN KEY (ISBN) REFERENCES book(ISBN) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=INNODB DEFAULT CHARSET=utf8mb4;
```

## 二、打开服务

- 打开IDEA
- 打开项目
- 打开`pom.xml`文件
- 点击右侧Maven按钮：
  - 点击`clear`清除包
  - 点击`install`安装包

![image-20251218084220762](assets/image-20251218084220762.png)

## 三、启动服务

- 点击`Edit Configurations`

![image-20251218084211622](assets/image-20251218084211622.png)

- 添加 `Tomcat Server` - `Local`

![image-20251218084329441](assets/image-20251218084329441.png)

- 点击底部`Fix`修复项目

![image-20251218084423570](assets/image-20251218084423570.png)

- 选择第一个`books`，保存后启动即可。

![image-20251218084525322](assets/image-20251218084525322.png)