Question

怎么使用JDBC连接SQL Server

Answer 1

properties中的配置：
jdbc.baseresource.driver=net.sourceforge.jtds.jdbc.Driver
jdbc.baseresource.url=jdbc:jtds:sqlserver://172.16.91.115:1433;databaseName=BasereSource
jdbc.baseresource.username=sa
jdbc.baseresource.password=sasa

applicationContext.xml中的配置：
<!-- Base库的配置 -->
<bean id="baseResourceDataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="${jdbc.baseresource.driver}" />
<property name="url" value="${jdbc.baseresource.url}" />
<property name="username" value="${jdbc.baseresource.username}" />
<property name="password" value="${jdbc.baseresource.password}" />

<property name="maxActive" value="20" />
<property name="maxIdle" value="5" />
<property name="defaultAutoCommit" value="true" />
<property name="minEvictableIdleTimeMillis" value="3600000" />
<property name="testWhileIdle" value="true" />
<property name="testOnBorrow" value="false" />
<property name="testOnReturn" value="false" />
<property name="validationQuery" value="select getdate()" />
<property name="validationQueryTimeout" value="1" />
<property name="timeBetweenEvictionRunsMillis" value="3000" />
<property name="numTestsPerEvictionRun" value="5" />
<property name="maxWait" value="60000" />
<property name="removeAbandoned" value="true" />
<property name="removeAbandonedTimeout" value="180" />
</bean>