今天,做一个Demo.程序用utf-8,mySql数据库用utf-8,但是插进去的数据还是乱码.
解决方法如下:
<
bean
id
="dataSource"
class ="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method ="close" >
< property name ="driverClass" value ="com.mysql.jdbc.Driver" />
< property name ="jdbcUrl"
value ="jdbc:mysql://127.0.0.1:3306/mydata?useUnicode=true&characterEncoding=utf-8" />
< property name ="user" value ="root" />
< property name ="password" value ="root" />
< property name ="autoCommitOnClose" value ="true" />
< property name ="checkoutTimeout" value ="5000" />
< property name ="initialPoolSize" value ="2" />
< property name ="minPoolSize" value ="2" />
< property name ="maxPoolSize" value ="4" />
< property name ="maxIdleTime" value ="25200" />
< property name ="acquireIncrement" value ="1800" />
< property name ="maxIdleTimeExcessConnections" value ="5" />
</ bean >
class ="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method ="close" >
< property name ="driverClass" value ="com.mysql.jdbc.Driver" />
< property name ="jdbcUrl"
value ="jdbc:mysql://127.0.0.1:3306/mydata?useUnicode=true&characterEncoding=utf-8" />
< property name ="user" value ="root" />
< property name ="password" value ="root" />
< property name ="autoCommitOnClose" value ="true" />
< property name ="checkoutTimeout" value ="5000" />
< property name ="initialPoolSize" value ="2" />
< property name ="minPoolSize" value ="2" />
< property name ="maxPoolSize" value ="4" />
< property name ="maxIdleTime" value ="25200" />
< property name ="acquireIncrement" value ="1800" />
< property name ="maxIdleTimeExcessConnections" value ="5" />
</ bean >