MySQL
啊~小 l i
2020年获得“发现杯”大奖赛省级三等奖;2021年计算机设计大赛系统开发组省级优秀奖;“传智杯”Python组省级优秀奖;2022年蓝桥杯python组省级二等奖;计算机设计大赛人工智能组省级二等奖、国家级三等奖;
展开
-
java.sql.SQLException: Incorrect string value: ‘\xE4\xB8\x80\xE6\xAC\xA1...‘ for column ‘******‘
问题:今天在使用spring boot开发商城时,在插入数据的时候报错,检查了代码,发现没有问题,想到了是MySQL表的问题。java.sql.SQLException: Incorrect string value: '\xE4\xB8\x80\xE6\xAC\xA1...' for column 'Order' at row 1 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094) at.原创 2021-02-02 10:57:27 · 496 阅读 · 1 评论 -
maven(mvc)连接MySQL报错[Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The se]
原因分析Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: 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 configura原创 2020-10-16 16:38:54 · 573 阅读 · 0 评论 -
Java web(JDBC)大数据处理[BLOB数据,CLOB数据]
大数据处理处理CLOB数据在实际开发中,CLOB用于储存文本的大数据,但是,对于MySQL来说,大数据文本的储存方式是用TEXT类型表示,案例如下:import java.io.*;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.SQLException;public class CLOB { public static void main(String[] args) {原创 2020-08-28 11:10:33 · 307 阅读 · 0 评论 -
Mysql报错(Exception in thread “main“ java.sql.SQLException: The server time zone value ‘�й���ʱ��‘ is)
报错代码Exception in thread "main" java.sql.SQLException: 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原创 2020-08-13 11:52:52 · 9048 阅读 · 6 评论 -
MySQL连接报错(Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver class is `com.m)
错误现象Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class iscom.mysql.cj.jdbc.Driver’. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.可以加载出数据库(但是会报出红色警告)有时会报错。原创 2020-08-13 07:17:30 · 1209 阅读 · 2 评论 -
完美解决MySQL数据库建表报错((ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that )
错误现象mysql> CREATE TABLE users ( -> id INT PRIMARY KEY AUTO_INCREMENT, -> name VARCHAR(40), -> password VARCHAR (40 ), -> emil VARCHAR (60), -> brithday DATE)CHARACTER SET utf8 COLLATE utf8_general_ci;ERROR 1064 (4200原创 2020-08-12 14:17:10 · 34499 阅读 · 1 评论