本帖最后由 xvshj 于 2016-05-19 15:23:02 编辑
jdbc.driverClass=com.mysql.jdbc.Driver
jdbc.URL=jdbc:mysql://localhost:3306/bookstore?useUnicode=true&characterEncoding=UTF-8
user=root
password=root
1
2
3
4
5
6
7
8
9
10
11
12
|
<
context:property-placeholder
location
=
"classpath:jdbc.properties"
/>
<
bean
id
=
"dataSource"
class
=
"com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method
=
"close"
>
<
property
name
=
"driverClass"
><
value
>${jdbc.driverClass}</
value
></
property
>
<
property
name
=
"jdbcUrl"
><
value
>${jdbc.Url}</
value
></
property
>
<
property
name
=
"user"
><
value
>${user}</
value
></
property
>
<
property
name
=
"password"
><
value
>${password}</
value
></
property
>
<
property
name
=
"maxPoolSize"
><
value
>40</
value
></
property
>
<
property
name
=
"minPoolSize"
><
value
>2</
value
></
property
>
<
property
name
=
"initialPoolSize"
><
value
>2</
value
></
property
>
<
property
name
=
"maxIdleTime"
><
value
>30</
value
></
property
>
</
bean
>
|
以上的配置信息,我放在jdbc.property中,插入mysql的中文是乱码??
3 | ?? | 40bd001563085fc35165329ea1ff5c5ecbdbbeef | lisi@qq.com。
如果把配置信息放到spring applicationContext.xml中,就没有问题。
1
2
3
4
5
6
7
8
9
10
11
|
<
bean
id
=
"dataSource"
class
=
"com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method
=
"close"
p:driverClass
=
"com.mysql.jdbc.Driver"
p:jdbcUrl
=
"jdbc:mysql://localhost:3306/bookstore?useUnicode=true&characterEncoding=UTF-8"
p:user
=
"root"
p:password
=
"root"
p:maxPoolSize
=
"40"
p:minPoolSize
=
"2"
p:initialPoolSize
=
"2"
p:maxIdleTime
=
"30"
/>
|
大神们,何解?