# Java GUI

**Repository Path**: lyxbiu/java-gui

## Basic Information

- **Project Name**: Java GUI
- **Description**: 使Java GUI和sqlserver实现一个简单的图形用户界面
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 1
- **Created**: 2025-02-16
- **Last Updated**: 2026-01-09

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

### Java GUI实现一个图书管理系统

- 数据库使用sqlserver，数据库脚本如下

``` sql
CREATE DATABASE books_management;

CREATE TABLE [dbo].[book_user](
	[userId] [nvarchar](50) NOT NULL,
	[userName] [nvarchar](50) NOT NULL,
	[bookId] [int] NOT NULL,
	[bookName] [nvarchar](50) NOT NULL,
	[borrowDate] [nvarchar](50) NOT NULL,
	[returnedDate] [nvarchar](50) NULL
);

CREATE TABLE [dbo].[books](
	[bookName] [nvarchar](50) NOT NULL,
	[bookId] [int] NOT NULL,
	[publisher] [nvarchar](50) NOT NULL,
	[price] [float] NOT NULL,
	[author] [nvarchar](50) NOT NULL,
	[booksCount] [int] NOT NULL,
	[remainedCount] [int] NOT NULL
); 

CREATE TABLE [dbo].[user](
	[userName] [nvarchar](50) NOT NULL,
	[userId] [nvarchar](50) NOT NULL,
	[userPassword] [nvarchar](50) NULL
);
```

- 用户界面

![1739683881763](README.assets/1739683881763.png)

- 运行时

要将lib下的jdbc添加进library