<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
p:driverClass="com.mysql.jdbc.Driver"
p:jdbcUrl="jdbc:mysql://localhost:3306/auction ?useUnicode=true&characterEncoding=gbk"
p:user="ligeng"
p:password="123456"
p:maxPoolSize="200"
p:minPoolSize="2"
p:initialPoolSize="2"
p:maxIdleTime="2000"
p:driverClass="com.mysql.jdbc.Driver"
p:jdbcUrl="jdbc:mysql://localhost:3306/auction ?useUnicode=true&characterEncoding=gbk"
p:user="ligeng"
p:password="123456"
p:maxPoolSize="200"
p:minPoolSize="2"
p:initialPoolSize="2"
p:maxIdleTime="2000"
destroy-method="close"/>
指定字符集,可以解决汉字存入数据库里面显示不正常问题
如果是用java jdbc 的话url应该为"jdbc:mysql://localhost:3306/auction?useUnicode=true&characterEncoding=gbk"