搭建Java 开发环境

1. 下载tomcat 并解压，详见参考：https://www.cnblogs.com/lizhilin2016/p/13579414.html

　　tomcat 日志乱码：conf->logging.properties->java.util.logging.ConsoleHandler.encoding = GBK

2. 安装Idea 开发环境，详细参考：https://www.codenong.com/cs106392310/ 

　　碰到的问题及解决方案：

　　1）不要直接去官方下载，最新版本无法破解，可下载历史版本：https://www.gpsmap.cc/soft/146.html 

　　2）破解教程：https://blog.faaoo.cn/archives/24490 （百度网盘链接: https://pan.baidu.com/s/1Sf7OowO1m_5UgjM2afIjEQ  提取码: 3qdx）

3. Intellij idea 部署tomcat ， 参考：https://blog.csdn.net/qq_19986309/article/details/75416381

　　碰到的问题和解决方案：

　　1）配置tomcat 时提示：Application server libraries no found in Intellij, 解决方案：tomcat 使用9 的，参考：https://www.it1352.com/1840944.html 

　　2）Intellij IDEA 部署tomcat 时提示：No artifacts marked for deployment, 解决方案：https://blog.csdn.net/sinat_41905822/article/details/88981871

　　至此， Idea 部署 Tomcat 配置完毕~

4. 运行拷贝的项目，项目demo 参照：https://blog.csdn.net/diyangxia/article/details/64122387 

　　碰到的问题和解决方案：

　　1）把项目代码的导入到Idea 中无法正常运行，一堆错误，提示 xxx 程序包不存在，根本原因是 maven 本地库 的配置有问题

　　　　解决思路：https://blog.csdn.net/Jioho_chen/article/details/81046183/ 配置环境变量，并集成 maven 到 Idea 中

5. 安MySQL 数据库

　　1）MySQL 下载地址和安装配置，参考：https://www.cnblogs.com/winton-nfs/p/11524007.html

　　　　（注意需要用管理员身份打开命令行，否则权限不足 lz）

　　2）安装可视化工具Navicatfor MySQL，参考：https://blog.csdn.net/pc915968220/article/details/100763987 

　　　　碰到的问题和解决方案：

　　　　1）报错1130，host .. is not allowed to connect to this MySql server, 权限不足，参考：https://blog.csdn.net/dabao87/article/details/80571877 

　　　　2）报错1251，client does not support authentication.. consider upgrading mysql client, 版本不兼容，参考：https://www.cnblogs.com/chao202426/p/11770894.html 

　　　　　　

　　　　3）报错：Duplicate entry '0' for key 'PRIMARY'，表的主键没设置自增，将表的主键设置为自增即可

6. 项目部署，参考：https://blog.csdn.net/zhanglf02/article/details/73565354 

　　找到项目的war 文件（Idea 在target 目录下），直接放在 tomcat webapp 目录下面，启动tomcat 即可（最简单）

PS C:WINDOWSsystem32> cd /
PS C:> cd D:softmysql-8.0.21-winx64in
PS D:softmysql-8.0.21-winx64in> mysqld --install
Service successfully installed.
PS D:softmysql-8.0.21-winx64in> mysqld --initialize --console
2020-09-02T01:58:14.802373Z 0 [System] [MY-013169] [Server] D:softmysql-8.0.21-winx64inmysqld.exe (mysqld 8.0.21) initializing of server in progress as process 16348
2020-09-02T01:58:14.817044Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-09-02T01:58:15.363177Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-09-02T01:58:16.541750Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 9f9t<!OEFYKC
PS D:softmysql-8.0.21-winx64in> ^C
PS D:softmysql-8.0.21-winx64in> ^C
PS D:softmysql-8.0.21-winx64in> net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。

PS D:softmysql-8.0.21-winx64in> mysql -u root -p
Enter password: ************
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 8
Server version: 8.0.21

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> alter user 'root'@'localhost' identified by 'lz';
Query OK, 0 rows affected (0.01 sec)

mysql> exit
Bye
PS D:softmysql-8.0.21-winx64in> mysql -u root -p
Enter password: **
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 9
Server version: 8.0.21 MySQL Community Server - GPL

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> ipconfig
    -> cd /
    -> show tables;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ipconfig
cd /
show tables' at line 1
mysql> show tables;
ERROR 1046 (3D000): No database selected
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)

mysql> use mysql;
Database changed
mysql> show tables;
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
| columns_priv              |
| component                 |
| db                        |
| default_roles             |
| engine_cost               |
| func                      |
| general_log               |
| global_grants             |
| gtid_executed             |
| help_category             |
| help_keyword              |
| help_relation             |
| help_topic                |
| innodb_index_stats        |
| innodb_table_stats        |
| password_history          |
| plugin                    |
| procs_priv                |
| proxies_priv              |
| role_edges                |
| server_cost               |
| servers                   |
| slave_master_info         |
| slave_relay_log_info      |
| slave_worker_info         |
| slow_log                  |
| tables_priv               |
| time_zone                 |
| time_zone_leap_second     |
| time_zone_name            |
| time_zone_transition      |
| time_zone_transition_type |
| user                      |
+---------------------------+
33 rows in set (0.01 sec)

mysql> select Host, User,Password from user;
ERROR 1054 (42S22): Unknown column 'Password' in 'field list'
mysql> select Host, User from user;
+-----------+------------------+
| Host      | User             |
+-----------+------------------+
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
| localhost | root             |
+-----------+------------------+
4 rows in set (0.00 sec)

mysql> update user set Host='%' where User='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> --help|grep my.cnf
    -> mysql --help|grep my.cnf
    -> mysql --help|grep my.cnf;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--help|grep my.cnf
mysql --help|grep my.cnf
mysql --help|grep my.cnf' at line 1
mysql> --help|grep my.cnf;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--help|grep my.cnf' at line 1
mysql> help

For information about MySQL products and services, visit:
   http://www.mysql.com/
For developer information, including the MySQL Reference Manual, visit:
   http://dev.mysql.com/
To buy MySQL Enterprise support, training, or other products, visit:
   https://shop.mysql.com/

List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
?         (?) Synonym for `help'.
clear     (c) Clear the current input statement.
connect   (
) Reconnect to the server. Optional arguments are db and host.
delimiter (d) Set statement delimiter.
ego       (G) Send command to mysql server, display result vertically.
exit      (q) Exit mysql. Same as quit.
go        (g) Send command to mysql server.
help      (h) Display this help.
notee     (	) Don't write into outfile.
print     (p) Print current command.
prompt    (R) Change your mysql prompt.
quit      (q) Quit mysql.
rehash    (#) Rebuild completion hash.
source    (.) Execute an SQL script file. Takes a file name as an argument.
status    (s) Get status information from the server.
system    (!) Execute a system shell command.
tee       (T) Set outfile [to_outfile]. Append everything into given outfile.
use       (u) Use another database. Takes database name as argument.
charset   (C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.
warnings  (W) Show warnings after every statement.
nowarning (w) Don't show warnings after every statement.
resetconnection(x) Clean session context.

For server side help, type 'help contents'

mysql> show variables like 'default_authentication_plugin';
+-------------------------------+-----------------------+
| Variable_name                 | Value                 |
+-------------------------------+-----------------------+
| default_authentication_plugin | caching_sha2_password |
+-------------------------------+-----------------------+
1 row in set, 1 warning (0.00 sec)

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'lz';
ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'
mysql> ^C
mysql>  alter user 'root'@'localhost' identified by 'lz';
ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'
mysql> USE mysql;
Database changed
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'lz';
ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'lz';
ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'
mysql> use mysql;
Database changed
mysql> select user,host from user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| root             | %         |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
+------------------+-----------+
4 rows in set (0.00 sec)

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'lz';
ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'lz';
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)

---

项目中碰到的一些问题：

1. 接口返回乱码，参考：https://blog.csdn.net/weixin_43453386/article/details/83512451 

三、Content-Type用法
1.headers

//Accept=application/json ：表示客户端希望接受的数据类型是json
@RequestMapping(value = "/test/ContentType", headers = "Accept=application/json")  
public void test1(HttpServletResponse response) throws IOException {  
    //表示响应的内容区数据的媒体类型为json格式，且编码为utf-8(客户端应该以utf-8解码)  
    response.setContentType("application/json;charset=utf-8");  
    //写出响应体内容  
    String jsonData = "{"username":"zhang", "password":"123"}";  
    response.getWriter().write(jsonData);  
}


//content-type =application/json ：表示客户端发送的数据格式是json
@RequestMapping(value = "/test/ContentType", headers = {"content-type = application/json"})  
public void test2(@RequestBody Pet pet) throws IOException {  
    // TODO
}


2.consumes

//仅处理request Content-Type为“application/json”类型的请求
@RequestMapping(value = "/test/produces", method = RequestMethod.POST, consumes="application/json")  
public void test(@RequestBody Pet pet, Model model) {      
    // TODO
}

//处理request Content-Type，定义的2种类型的请求
@RequestMapping(consumes = {"application/json","application/x-www-form-urlencoded"})
public void test2(@RequestBody Pet pet, Model model) {      
    // TODO
}

//处理request Content-Type中，除了以下2种类型的请求
@RequestMapping(consumes = {"!application/json","!application/x-www-form-urlencoded"})
public void test3(@RequestBody Pet pet, Model model) {      
    // TODO
}



3.produces

//返回json数据 && 字符编码为utf-8
@RequestMapping(value = "/test/consumes", method = RequestMethod.POST, produces="application/json;charset=utf-8")    
@ResponseBody    
public Pet test3(@PathVariable String petId, Model model) {       
    // TODO
} 

　　

2.