# vrserver

**Repository Path**: lafengmaker/vrserver

## Basic Information

- **Project Name**: vrserver
- **Description**: 没啥用aaaaa,,只是学习所用
- **Primary Language**: Unknown
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2023-07-10
- **Last Updated**: 2023-07-28

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README



# 配置

## 环境
jdk8+mysql 5/6


拷贝file 目录下的文件到服务器<br/>
修改file/config <br/>
application.properties 的数据库跟用户  java -jar 启动 <br/>
登陆密码（用来新增维护）：
```
login.user=root
login.password=root
```

## 数据库配置
```aidl


spring.datasource.url=jdbc:mysql://aaaa:3600/gs-asset?useSSL=false&useUnicode=true&amp&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull
spring.datasource.username=aaa
spring.datasource.password=aaaa

```

## 数据库表
```sql
CREATE TABLE `s_vr_entity` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `key_id` varchar(45) DEFAULT NULL COMMENT 'Id，或者设备id',
  `encrypted` tinyint(4) DEFAULT NULL COMMENT '是否加密',
  `password` varchar(45) DEFAULT NULL COMMENT '密码',
  `valid_start` datetime DEFAULT NULL,
  `valid_end` varchar(45) DEFAULT NULL,
  `remark` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
```



#操作

* 登陆 http://localhost:8080/login
* 维护设备 http://localhost:8080/main

# 接口
## 登陆
http://localhost:8080/api/login?id=15&password=123456

{
"code": 200,
"success": true,
"data": {
"id": "15",
"encrypted": true, 是否加密
"validStart": "2023-07-01", 有效期开始时间
"validEnd": "2023-09-30", 有效期开始时间
"remark": ""
},
"message": "成功"
}
## 查询
http://localhost:8080/api/query?id=15
{
"code": 200,
"success": true,
"data": {
"id": "15",
"encrypted": true,
"validStart": "2023-07-01",
"validEnd": "2023-09-30",
"remark": ""
},
"message": "成功"
}