# ssm_in_one

**Repository Path**: home_robertzhai/java_web_ssm

## Basic Information

- **Project Name**: ssm_in_one
- **Description**: java web ssm boilerplate , add 、delete 、update 、query http rest api , deploy and test with docker 
- **Primary Language**: Java
- **License**: MulanPSL-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2023-06-03
- **Last Updated**: 2023-06-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

### java web ssm v1.0.0
- 列表、添加、编辑、删除功能
- 可以用户后台系统
- 使用docker镜像部署
- 镜像仓库使用阿里云

### 界面效果图
![输入图片说明](docs/images/WechatIMG59.png)
![输入图片说明](docs/images/WechatIMG60.png)
![输入图片说明](docs/images/WechatIMG61.png)
![输入图片说明](docs/images/WechatIMG63.png)

### 运行方式
- 运行mysql 5.7
  - docker pull registry.cn-beijing.aliyuncs.com/robertzhai/mysql1.1:v5.7   
  - docker run  --name=mysql3306 --privileged=true -p 3306:3306 -v /Users/robert/docker/mysql57_3306:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root -d registry.cn-beijing.aliyuncs.com/robertzhai/mysql1.1:v5.7 --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci  
  - mysql -h127.0.0.1 -uroot -p 
  - 密码root登录
- create database java;
``` 
CREATE TABLE `user`
(
    `username` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `desc`     varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
    `id`       int(11) NOT NULL AUTO_INCREMENT,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
```

- 运行tomcat8
  - docker pull registry.cn-beijing.aliyuncs.com/robertzhai/tomcat1.2:v8  
  - docker run -d -p 8081:8080 --name tomcat8081  registry.cn-beijing.aliyuncs.com/robertzhai/tomcat1.2:v8  
  - docker ps --format "table{{.ID}}\t{{.Names}}\t{{.Image}}\t{{.Ports}}"  
```
CONTAINER ID        NAMES               IMAGE                                                       PORTS
6eaa46bd7992        tomcat8081          registry.cn-beijing.aliyuncs.com/robertzhai/tomcat1.2:v8    0.0.0.0:8081->8080/tcp
41932643cddf        mysql3306           registry.cn-beijing.aliyuncs.com/robertzhai/mysql1.1:v5.7   0.0.0.0:3306->3306/tcp, 33060/tcp
```
- 修改db配置,ip改成本机ip
  - docker exec -it 6eaa46bd7992 /bin/bash
  - vim ssm_in_one/WEB-INF/classes/jdbc.properties
- 访问 http://localhost:8081/
- 访问 http://localhost:8081/ssm_in_one/index 


### docker image制作参考
- https://developer.aliyun.com/article/1113403
- https://gitee.com/home_robertzhai/java_web_ssm/blob/master/docs/docker/Dockerfile

### other
- https://tomcat.apache.org/download-80.cgi
- https://www.bilibili.com/video/BV1U541157Wp