楼主莫灰心,我已经测试过了,你的配置有一点点不对,我帮你改好了,你用我的替换一下,保你解决问题<beans > <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" > <property name="driverClassName" value="com.mysql.jdbc.Driver"</property > <property name="url" value="jdbc:mysql://localhost:3306/company"</property > <property name="username" value="root" </property > <property name="password" value="123"</property >
</bean > <bean id="personDao" class="daojdbc.PersonDaoJdbc" >
<property name="dataSource" >
<ref local="dataSource"/ >
</property >
</bean ></beans >
</bean > <bean id="personDao" class="daojdbc.PersonDaoJdbc" >
<property name="dataSource" >
<ref local="dataSource"/ >
</property >
</bean ></beans >
<value >jdbc:mysql://localhost/company </value >
</property > 你没写端口吧
<property name="url" >
<value >jdbc:mysql://localhost:3306/company </value >
</property >
applicationContext.xml
<bean id="propertyConfigurer"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location">
<value>/WEB-INF/jdbc.properties</value>
</property>
</bean> <!-- Local DataSource that works in any environment --> <bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
<value>${jdbc.driverClassName}</value>
</property>
<property name="url">
<value>${jdbc.url}</value>
</property>
<property name="username">
<value>${jdbc.username}</value>
</property>
<property name="password">
<value>${jdbc.password}</value>
</property>
</bean>jdbc.properties
jdbc.driverClassName=com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc.url=jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=company;SelectMethod=Cursor;
jdbc.username=root
jdbc.password=123我只把Sql server的驱动放在\WEB-INF\lib下即可。
在web.xml中加入以下的内容:
<servlet>
<servlet-name>context</servlet-name>
<servlet-class>org.springframework.web.context.ContextLoaderServlet</servlet-class>
<load-on-startup>1</load-on-startup>
</servlet>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/classes/applicationContext.xml</param-value>//你的spring配置文件
</context-param>