# 后台

**Repository Path**: byehly/jdbc

## Basic Information

- **Project Name**: 后台
- **Description**: 基于
express的后台系统，在学习Spring框架之前暂时先使用这个进行后端接口测试联调
- **Primary Language**: Unknown
- **License**: MulanPSL-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-10-21
- **Last Updated**: 2026-01-27

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# JDBC Project Documentation

## Introduction
This project is a database connection and operation tool built on Node.js, primarily utilizing JDBC (JavaScript Database Connectivity) to perform basic database operations such as create, read, update, and delete (CRUD). The project uses the Express framework to establish a basic web service and implements database operation logic through simple APIs.

## Key Features
- Provides a web service based on Express.
- Performs database operations using Node.js database modules.
- Supports CRUD operations for user information.
- Offers basic environment configuration and route management.

## Project Structure
- `app.js`: Main Express application file that configures the server, routes, and middleware.
- `bin/www`: Startup file used to launch the HTTP service.
- `database/user/userTable.js`: User table operation module containing database functions such as `get_user`, `insert_user`, `update_user`, and `delete_user`.
- `env/config.js`: Environment configuration file for setting database connection parameters and other environment-related configurations.
- `node_modules/`: Contains third-party dependencies for the project, such as Express, body-parser, cookie-parser, cors, etc.

## Installation and Execution
### Install Dependencies
Ensure Node.js and npm are installed, then run the following command to install dependencies:
```bash
npm install
```

### Start the Project
Start the project using one of the following commands:
```bash
npm start
```
or directly run:
```bash
node bin/www
```

### Database Configuration
Modify the database connection settings in the `env/config.js` file according to your project requirements.

## Usage Instructions
### User Operation APIs
- `GET /user`: Retrieve user information.
- `POST /user`: Insert new user information.
- `PUT /user`: Update user information.
- `DELETE /user`: Delete user information.

Appropriate parameters must be provided for each operation to successfully perform database actions.

## License
This project is licensed under the MIT License. For details, refer to the `LICENSE` file in the project root directory.

## Contributors
This project relies on the following open-source modules:
- Express
- body-parser
- cors
- cookie-parser
- morgan
- mysql2

Thank you to all contributors and maintainers of these open-source modules.

## Contact and Feedback
If you have any questions or suggestions, please submit an Issue via Gitee or contact the project maintainer.

## Reference Documentation
- [Express Official Documentation](https://expressjs.com/)
- [Node.js Documentation](https://nodejs.org/)
- [MySQL2 Documentation](https://github.com/sidorares/node-mysql2)

---
This project serves as a basic database operation framework and can be extended and optimized according to actual requirements.