解决Java和Mysql 5.1 jdbc 之间包含汉字的SQL命令无法正常解析问题

Jsp Encode=UTF-->Servlet by jdbc--->mysql 5.1

如果包含汉字需要在jboss mysql-ds.xml里链接字符串加入如下

<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/gpsrm?useUnicode=TRUE</connection-url>
<connection-property name="characterEncoding">utf8</connection-property>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password></password>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</local-tx-datasource>