这里写自定义目录标题
JDBC
BUG、问题
数据库无法启动
这是由于没有使用管理员身份打开命令行
复制粘贴代码到IDEA后遇到问题
1.No data sources are configured to run this SQL and provide advanced code ass
安装mysql驱动,可以用来执行sql命令
2.java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
tomcat找不到MYSQL JAR包报错。把mysql-connector-java-5.1.7-bin.jar导入到tomcat的lib目录下面就ok了
3.Unknown initial character set index ‘255’ received from server. Initial client character
MySQL驱动和数据库字符集设置不搭配
将
String url = "jdbc:mysql://localhost:3306/db_cjky"
改为
String url = "jdbc:mysql://localhost:3306/db_cjky?useUnicode=true&characterEncoding=utf8"
4…MySQLSyntaxErrorException: 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 ‘=‘123456789’ and password =‘123’’ at line 1
在拼凑MySQL指令语句时,在每一个下引号前加上空格或在每一个上引号后加上空格(由于MySQL会忽略多余的空格即可,所以拼凑后的语句有多个空格并无大碍)。