java+mysql的一些问题

问题：Unbound classpath container: ‘JRE System Library [OSGi/Minimum-1.2]’ in project ‘test’ test

解决：
1.Right click on the project

2.Open Properties

3.Select Java Build Path

4.Select the JRE System Library under the Libraries tab .

5.Click on Edit .

6.Click on Alternate JRE .

7.If Alternate JRE present , then Select it and hit Finish .

8.If not present , then click on Installed JREs which opens a pop up.

9.Click on Add .

10.Select Standard VM and Click Next.

11.Select the JRE Home , Navigate to JDK root and select that .

12.Click on Finish .

13.Select that in installed JREs.

在一个外国网站找到的，自行翻译。好像使用的是eclipse

eclipse+java中添加mysql

buili path ->add external archives ->mysql-connector-java-8.0.11.java
参考：https://blog.csdn.net/yefengzhichen/article/details/51834511
url后面加上?serverTimezone=UTC可解决某个问题，&useSSL=true可解决某个问题。
com.mysql.jdbc.Driver可替换为：com.mysql.cj.jdbc.Driver

mysql中文输入

参考：https://blog.csdn.net/ch717828/article/details/41357431
因为找不到my.ini，所以建表时要标明格式，参考：https://blog.csdn.net/fhzaitian/article/details/53168551

修改mysql的字符集

改已经建好的表的字符集：
alter table persons default character set utf8;
改字段的字符集：
alter table persons change sex sex varchar(50) character set utf8;