本文介绍一下SpringBoot 数据源配置 SqlServer。
想了解其他类型数据库配置方式的同学请出门左转http://blog.didispace.com/springbootdata1/
测试项目结构如下:
1.配置Beans文件
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd ">
<!-- Initialization for data source -->
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<property name="url" value="jdbc:sqlserver://109.118.1.32:49176;databaseName=Webportal"/>
<property name="username" value="sa"/>
<property name="password" value="lob@1.32"/>
</bean>
<!-- Definition for studentJDBCTemplate bean -->
<bean id="userJDBCTemplate"
class="com.didispace.dao.UserJDBCTemplate">
<property name="dataSource" ref="dataSource" />
</bean>
</beans>
2.Controller中引用
ApplicationContext context =
new ClassPathXmlApplicationContext("Beans.xml");
UserJDBCTemplate userJDBCTemplate =
(UserJDBCTemplate)context.getBean("userJDBCTemplate");