Javaweb the same code, there is no problem testing locally, why is there a coding problem when it comes to data inventory on centos's server?

    <!-- 1.  : DriverManagerDataSource -->
    <bean id="dataSource"
        class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://localhost:3306/ehouse" />
        <property name="username" value="root" />
        <property name="password" value="" />
    </bean>


is there a problem with this configuration?

Java
Mar.03,2021

when using JDBC to connect to the Mysql database and insert a record with Chinese into the Mysql database, it is found that they are all?
here is a picture description
to query some information. The simplest solution is as follows:
1: set the encoding of the current database 

ALTER DATABASE zhongfucheng
CHARACTER SET utf8;

2: set the encoding of the current table 

ALTER TABLE customer
  CHARACTER SET utf8;

3: specify the encoding when using JDBC to connect to the database 

jdbc:mysql://localhost:3306/zhongfucheng?characterEncoding=utf8

when we complete these three steps, insert the data again: that's it

it seems that you have not specified the encoding to be used when connecting to the database, so the default encoding of the system will be used, and the default encoding may be different between the two systems.

I guess your database code should be gbk?. Therefore, the coding of the local Chinese environment is the same as that of the database, while the default of centos may not be gbk.

No encoding was specified when configuring the database connection

Previous: The upload file in element fails to be uploaded after it is uploaded to the server. How to close the uploaded file manually?

Next: Find a method to judge the file header by using js

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
© 2021 CodesHelper
Advertising Contact us About us
Menu