Spring 4.x 可以实现根据数据库脚本文件自动初始化数据库的配置，具体配置如下：
作者使用的数据库是MySQL
第一、将数据库脚本放入自定义的目录，我的目录如下：
demo.sql 和 log.sql是作者两个数据库的脚本文件
第二、在配置文件ApplicationContent.xml中增加如下配置：
<!-- 初始化数据库 （需要先手动创建好数据库） enabled=true/false 是否启用初始化 --> <jdbc:initialize-database data-source="mysqlDataSource" enabled="true"> <!-- 系统所用的数据库 --> <jdbc:script location="classpath:../db/demo.sql" /> <!-- 日志所用的数据库 --> <jdbc:script location="classpath:../db/log.sql" /> </jdbc:initialize-database>
mysqlDataSource是我的数据源配置如下：
<!-- mysql数据源配置 --> <bean id="mysqlDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> <!-- 设置JDBC驱动名称 --> <property name="driverClass" value="${c3p0.driverClass}" /> <property name="jdbcUrl" value="${c3p0.url}" /> <property name="user" value="${c3p0.username}" /> <property name="password" value="${c3p0.password}" /> <property name="initialPoolSize" value="${c3p0.initialPoolSize}" /> <property name="maxPoolSize" value="${c3p0.maxPoolSize}" /> <property name="minPoolSize" value="${c3p0.minPoolSize}" /> <property name="acquireIncrement" value="${c3p0.acquireIncrement}" /> <property name="maxStatements" value="${c3p0.maxStatements}" /> <property name="preferredTestQuery" value="${c3p0.preferredTestQuery}" /> <property name="maxConnectionAge" value="${c3p0.maxConnectionAge}" /> <property name="testConnectionOnCheckout" value="${c3p0.testConnectionOnCheckout}" /> <property name="testConnectionOnCheckin" value="${c3p0.testConnectionOnCheckin}" /> <property name="acquireRetryAttempts" value="${c3p0.acquireRetryAttempts}" /> <property name="acquireRetryDelay" value="${c3p0.acquireRetryDelay}" /> <property name="breakAfterAcquireFailure" value="${c3p0.breakAfterAcquireFailure}" /> </bean>
注：使用jdbc标签的时候需要引入http://www.springframework.org/schema/jdbc，xml中的头文件如下红色字体部分：
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:oscache="http://www.springmodules.org/schema/oscache" xmlns:jdbc="http://www.springframework.org/schema/jdbc" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.1.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.1.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.1.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-4.1.xsd">
