spring配置连接mysql_spring配置数据库连接池(SSH)

1、db.propertities数据库连接参数配置文件：

#oracle配置

#driver=oracle.jdbc.driver.OracleDriver

#连接url

#url=jdbc:oracle:thin:@127.0.0.1:1521:xe

#用户名

#user=system

#密码

#password=oracle

#mysql配置

#驱动名格式key=value注意不要有空格不要结尾分号

driver=com.mysql.jdbc.Driver

#连接url

url=jdbc:mysql://localhost:3306/utf8?useUnicode=true&characterEncoding=utf-8

#用户名

user=root

#密码

password=1234

#连接池配置

initialPoolSize=2

maxPoolSize=6

minPoolSize=2

maxIdleTime=600

acquireIncrement=2

timeBetweenEvictionRunsMillis=600

minEvictableIdleTimeMillis=400

2、spring_hibernate.xml获取数据库源(数据库连接池)的配置文件：

xmlns:context="http://www.springframework.org/schema/context"  xmlns:jdbc="http://www.springframework.org/schema/jdbc"

xmlns:jee="http://www.springframework.org/schema/jee"  xmlns:tx="http://www.springframework.org/schema/tx"

xmlns:aop="http://www.springframework.org/schema/aop"  xmlns:mvc="http://www.springframework.org/schema/mvc"

xmlns:util="http://www.springframework.org/schema/util"  xmlns:jpa="http://www.springframework.org/schema/data/jpa"

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd   http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-3.2.xsd

http://www.springframework.org/schema/jdbc  http://www.springframework.org/schema/jdbc/spring-jdbc-3.2.xsd

http://www.springframework.org/schema/jee  http://www.springframework.org/schema/jee/spring-jee-3.2.xsd

http://www.springframework.org/schema/tx  http://www.springframework.org/schema/tx/spring-tx-3.2.xsd

http://www.springframework.org/schema/data/jpa  http://www.springframework.org/schema/data/jpa/spring-jpa-1.3.xsd

http://www.springframework.org/schema/aop  http://www.springframework.org/schema/aop/spring-aop-3.2.xsd

http://www.springframework.org/schema/mvc  http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd

http://www.springframework.org/schema/util  http://www.springframework.org/schema/util/spring-util-3.2.xsd">

isolation="DEFAULT" rollback-for="java.lang.ClassNotFoundException"/>