spring配置mssql的jdbc驱动

最新推荐文章于 2025-05-29 12:59:44 发布

weixin_33907511

最新推荐文章于 2025-05-29 12:59:44 发布

阅读量278

点赞数

CC 4.0 BY-SA版权

文章标签： java 数据库测试

原文链接：http://www.cnblogs.com/czxu/archive/2011/07/01/2095865.html

本文详细介绍如何在Spring框架中整合Microsoft SQL Server数据库，包括下载并配置JDBC驱动jar包，以及具体的Spring配置文件示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.首选需要下载MSSQL的JDBC驱动jar包“sqljdbc.jar”或者“sqljdbc4.jar”.

2.然后在spring中的配置文件中进行配置，详细如下：

<? 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:p ="http://www.springframework.org/schema/p" xmlns:context ="http://www.springframework.org/schema/context"
xmlns:aop ="http://www.springframework.org/schema/aop"
xmlns:tx ="http://www.springframework.org/schema/tx"
xsi:schemaLocation ="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd" >

< bean id ="dataSource" class ="org.apache.commons.dbcp.BasicDataSource" destroy-method ="close" >
< property name ="driverClassName" value ="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
< property name ="url" value ="jdbc:sqlserver://LENOVO-HHZHANG;DatabaseName=VideoCompress" />

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

</ bean >

< bean id ="txManager" class ="org.springframework.jdbc.datasource.DataSourceTransactionManager" >
< property name ="dataSource" ref ="dataSource" />
</ bean >

< tx:annotation-driven transaction-manager ="txManager" />

< bean id ="personService" class ="com.fancy.serviceImpl.PersonServiceBean" >
< property name ="dataSource" ref ="dataSource" />
</ bean >
</ beans >

详细例子见附件： http://files.cnblogs.com/czxu/SpringAndJDBC.rar

转载于:https://www.cnblogs.com/czxu/archive/2011/07/01/2095865.html