Spring数据源配置至dataSource

引入jar文件：commons-dbcp.jar、commons-pool.jar

Spring实例化org.apache.commons.dbcp.BasicDataSource类是，会调用到commons-dbcp.jar和commons-pool.jar文件

<bean id="myDataSource" class="org.apache.commons.dbcp.BasicDataSource"
        destroy-method="close">
        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
        <property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl" />
        <property name="username" value="oracle" />
        <property name="password" value="oracle" />
    </bean>

dataSource获取Connection时，会调用数据库驱动包，本次采用的是oracle数据，所以要引入包ojdbc6.jar

try {
            conn = dataSource.getConnection();
            statement = conn.createStatement();
            statement.executeUpdate("insert int book values(null,'离散数据'，'12.56')");
        } catch (SQLException e) {            
            e.printStackTrace();
            
        }finally{
            
            try {
                statement.close();
                conn.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }