在pom.xml里添加pagehelper插件
<!-- pagehelper 插件-->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.13</version>
</dependency>
代码里在查询数据库操作前添加添加：
一页3条数据
PageHelper.startPage(1,3);
<方法1>安装vue.js
File -> Settings -> Plugins ->
<方法2>
File Types: HTML 添加 *.vue类型
File -> Settings -> Editor -> File Types -> HTML
点Registered Patterns下的+，添加 *.vue
最右侧点击database
加号新建连接
使用console输入mysql命令
输入下面命令
drop table if exists `test`;
create table `test` (
`id` bigint not null comment 'id',
`name` varchar(50) comment '名称',
`password` varchar(50) comment '密码',
primary key (`id`)
) engine=innodb default charset=utf8mb4 comment='测试';
测试查询
添加数据
1.通过root用户，新建数据库
2.添加用户
3.添加权限
4.新建表
IDEA成功连接Database但不显示表怎么办？
https://jingyan.baidu.com/article/e5c39bf592c7be78d6603374.html
IDEA 使用mybatis插件Free Mybatis plugin
https://www.jianshu.com/p/4f1c2600802c
Docker查询MySQL版本号
https://blog.csdn.net/qq_24641227/article/details/92569384
Navicat15破解
https://www.jianshu.com/p/aadf52aa6475
1.首先在pom.xml里添加spring-boot-devtools
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
#添加spring-boot-devtools
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
2.打开IdeaIU setting->complier
3.在idea中 ，Shift+Ctrl+Alt+/，选择Registry
如图勾选
参考CSDN
https://blog.csdn.net/tuxwig/article/details/113788287
IdeaIU安装
https://www.cnblogs.com/tangsujuan/p/14148404.html
GIit安装
https://www.cnblogs.com/hdlan/p/14395189.html
IDEAIU Git登录404解决方法
https://blog.csdn.net/PengZyi/article/details/113914880
IntelliJ IDEA更改maven本地仓库位置
https://www.jianshu.com/p/0aa04f3b3baa?utm_campaign=haruki
【Git】ssh: connect to host github. com port 22: Connection timed out 的解决方案GIT
https://blog.csdn.net/qq_42351033/article/details/104759709
本地上传到git
git remote add origin git@github.com:onezos/wiki.git
git branch -M main
git push -u origin main
10分钟搭建自己的Git仓库
https://zhuanlan.zhihu.com/p/108165153
TO yaml
https://toyaml.com/index.html
Node.js下载地址：https://nodejs.org/en/
默认安装后
C:\Users\gdd93>node -v
v14.15.4
C:\Users\gdd93>npm -v
6.14.10
#安装cnpm
C:\Users\gdd93>npm install -g cnpm --registry=https://registry.npm.taobao.org
npm WARN deprecated request@2.88.2: request has been deprecated, see https://github.com/request/request/issues/3142
npm WARN deprecated har-validator@5.1.5: this
C:\Users\gdd93\AppData\Roaming\npm\cnpm -> C:\Users\gdd93\AppData\Roaming\npm\node_modules\cnpm\bin\cnpm
+ cnpm@6.1.1
added 689 packages from 973 contributors in 46.455s
#cnpm安装vue
C:\Users\gdd93>cnpm install -g @vue/cli
C:\Users\gdd93>vue --version
@vue/cli 4.5.11
C:\Users\gdd93>cnpm install -g @vue/cli-service-global
#安装yarn
C:\Users\gdd93>npm install -g yarn
C:\Users\gdd93>yarn -v
1.22.10
#安装淘宝镜像源
C:\Users\gdd93>yarn config set registry https://registry.npm.taobao.org/
yarn config v1.22.10
success Set "registry" to "https://registry.npm.taobao.org/".
Done in 0.07s.
#yarn安装vue
C:\Users\gdd93>yarn global add @vue/cli
安装node.js版本管理工具nvm
下载地址：https://github.com/coreybutler/nvm-windows/releases
安装完成后
C:\Users\gdd93>nvm -v
Running version 1.1.7.
Usage:
nvm arch : Show if node is running in 32 or 64 bit mode.
nvm install <version> [arch] : The version can be a node.js version or "latest" for the latest stable version.
Optionally specify whether to install the 32 or 64 bit version (defaults to system arch).
Set [arch] to "all" to install 32 AND 64 bit versions.
Add --insecure to the end of this command to bypass SSL validation of the remote download server.
nvm list [available] : List the node.js installations. Type "available" at the end to see what can be installed. Aliased as ls.
nvm on : Enable node.js version management.
nvm off : Disable node.js version management.
nvm proxy [url] : Set a proxy to use for downloads. Leave [url] blank to see the current proxy.
Set [url] to "none" to remove the proxy.
nvm node_mirror [url] : Set the node mirror. Defaults to https://nodejs.org/dist/. Leave [url] blank to use default url.
nvm npm_mirror [url] : Set the npm mirror. Defaults to https://github.com/npm/cli/archive/. Leave [url] blank to default url.
nvm uninstall <version> : The version must be a specific version.
nvm use [version] [arch] : Switch to use the specified version. Optionally specify 32/64bit architecture.
nvm use <arch> will continue using the selected version, but switch to 32/64 bit mode.
nvm root [path] : Set the directory where nvm should store different versions of node.js.
If <path> is not set, the current root will be displayed.
nvm version : Displays the current running version of nvm for Windows. Aliased as v.
C:\Users\gdd93>nvm ls available
| CURRENT | LTS | OLD STABLE | OLD UNSTABLE |
|--------------|--------------|--------------|--------------|
| 15.11.0 | 14.16.0 | 0.12.18 | 0.11.16 |
| 15.10.0 | 14.15.5 | 0.12.17 | 0.11.15 |
| 15.9.0 | 14.15.4 | 0.12.16 | 0.11.14 |
| 15.8.0 | 14.15.3 | 0.12.15 | 0.11.13 |
| 15.7.0 | 14.15.2 | 0.12.14 | 0.11.12 |
| 15.6.0 | 14.15.1 | 0.12.13 | 0.11.11 |
| 15.5.1 | 14.15.0 | 0.12.12 | 0.11.10 |
| 15.5.0 | 12.21.0 | 0.12.11 | 0.11.9 |
| 15.4.0 | 12.20.2 | 0.12.10 | 0.11.8 |
| 15.3.0 | 12.20.1 | 0.12.9 | 0.11.7 |
| 15.2.1 | 12.20.0 | 0.12.8 | 0.11.6 |
| 15.2.0 | 12.19.1 | 0.12.7 | 0.11.5 |
| 15.1.0 | 12.19.0 | 0.12.6 | 0.11.4 |
| 15.0.1 | 12.18.4 | 0.12.5 | 0.11.3 |
| 15.0.0 | 12.18.3 | 0.12.4 | 0.11.2 |
| 14.14.0 | 12.18.2 | 0.12.3 | 0.11.1 |
| 14.13.1 | 12.18.1 | 0.12.2 | 0.11.0 |
| 14.13.0 | 12.18.0 | 0.12.1 | 0.9.12 |
| 14.12.0 | 12.17.0 | 0.12.0 | 0.9.11 |
| 14.11.0 | 12.16.3 | 0.10.48 | 0.9.10 |
This is a partial list. For a complete list, visit https://nodejs.org/download/release
C:\Users\gdd93>nvm install v10.16.0
Downloading node.js version 10.16.0 (64-bit)...
Complete
Creating C:\Users\gdd93\AppData\Roaming\nvm\temp
Downloading npm version 6.9.0... Complete
Installing npm v6.9.0...
Installation complete. If you want to use this version, type
nvm use 10.16.0
#查看当前系统安装的nodejs版本列表
C:\Users\gdd93>nvm list
* 14.15.4 (Currently using 64-bit executable)
10.16.0
#切换nodejs版本
C:\Users\gdd93>nvm use v10.16.0
Now using node v10.16.0 (64-bit)
C:\Users\gdd93>node -v
v10.16.0
C:\Users\gdd93>npm -v
6.9.0
安装webpack和webpack-cli
npm install webpack webpack-cli -D
yarn add webpack webpack-cli -D
Webpack安装和使用
1.初始化项目
npm init -y快速创建nodejs项目
2.nvm,node,npm环境确认
nvm install/use v14.15.4/node -v/npm -v
3.两种webpack安装与三种使用方式
npm install webpack webpack-cli -D/-g
或yarn add webpack webpack-cli -D/yarn global add webpack webpack-cli
npx webpack & node_modules/.bin/webpack & npm run