JDBC学习过程中遇到的几种错误（2）【获取链接过程报错与定义sql语句报错】

1.获取链接过程报错

connection = DriverManager.getConnection("jdbc:mysql:///db1", "root", "yroot");

链接数据库时报错

The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

解决方案：在语句中加入?serverTimezone=UTC。即：

connection = DriverManager.getConnection("jdbc:mysql:///db1?serverTimezone=UTC", "root", "yroot");

2.定义sql语句报错

String sql = "select * from user where username = '"+username+"'and password ='"+ password+"' ";

报错：

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 ''' at line 1```
原因是在SQL语句中存在空格，要仔细检查双引号内的内容，应该与定义的方法中的内容一致：

```java
public boolean login(String username,String password)