<!-- 配置数据库参数及连接池 -->

     <!-- sqlServer数据库配置 -->

     <bean id = "dbcp2"

     class = "org.apache.commons.dbcp2.BasicDataSource">

         <property name ="username" value ="sa"></property>

         <property name ="password" value ="sa123456"></property>

         <property name ="driverClassName" value ="com.microsoft.sqlserver.jdbc.SQLServerDriver"></property>

         <property name ="url" value ="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=BNSY-SIS"></property>

     </bean>

<!-- https://mvnrepository.com/artifact/com.microsoft.sqlserver/sqljdbc4 -->

    <dependency>

        <groupId>com.microsoft.sqlserver</groupId>

        <artifactId>sqljdbc4</artifactId>

        <version>4.0</version>

        <scope>test</scope>

    </dependency>