Unknown initial character set index ‘255‘ received from server. Initial client character set can be

此时xml配置文件为：

 <!--连接数据库连接池-->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
          destroy-method="close">
        <property name="url" value="jdbc:mysql:///user_db"/>
        <property name="username" value="root"/>
        <property name="password" value="123456"/>
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    </bean>

会报下面的错误：

Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.

很明显显示的是字符编码的问题，那么在xml文件中添加编码参数

<property name="url" value="jdbc:mysql:///user_db?useUnicode=true&characterEncoding=utf8"/>

此时又会报下面的错误：

org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line 16 in XML document from class path resource [bean1.xml] is invalid; nested exception is org.xml.sax.SAXParseException; lineNumber: 16; columnNumber: 92; 对实体 "characterEncoding" 的引用必须以 ';' 分隔符结尾。

那么改成下面的代码，就不会出现错误了：

<property name="url" value="jdbc:mysql:///user_db?useUnicode=true&amp;characterEncoding=utf8"/>

参数的分割要使用转义字符表示，       &