jdbc connect DB

zhuzhengping911 · zhuzhengping911 · commit b27806ca2fa4 · 2017-03-07T00:43:47.000+08:00
diff --git a/pom.xml b/pom.xml
@@ -76,6 +76,16 @@
 			<groupId>org.springframework.boot</groupId>
 			<artifactId>spring-boot-starter-amqp</artifactId>
 		</dependency>
+		<!--jdbc连接数据库-->
+		<dependency>
+			<groupId>org.springframework.boot</groupId>
+			<artifactId>spring-boot-starter-jdbc</artifactId>
+		</dependency>
+		<dependency>
+			<groupId>com.alibaba</groupId>
+			<artifactId>druid</artifactId>
+			<version>1.0.5</version>
+		</dependency>
 	</dependencies>
 
 	<build>
diff --git a/src/main/java/com/common/DBBeanConfig.java b/src/main/java/com/common/DBBeanConfig.java
@@ -0,0 +1,41 @@
+package com.common;
+
+import com.alibaba.druid.pool.DruidDataSource;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.context.annotation.Bean;
+import org.springframework.context.annotation.Configuration;
+import org.springframework.context.annotation.PropertySource;
+import org.springframework.core.env.Environment;
+import org.springframework.jdbc.core.JdbcTemplate;
+import org.springframework.transaction.annotation.EnableTransactionManagement;
+
+import javax.sql.DataSource;
+
+/**
+ * Created by zhuzhengping on 2017/3/7.
+ */
+@Configuration
+@EnableTransactionManagement
+@PropertySource(value = {"classpath:config/DBsource.properties"})
+public class DBBeanConfig {
+
+    @Autowired
+    private Environment env;
+
+    @Bean(destroyMethod = "close")
+    public DataSource dataSource(){
+        DruidDataSource dataSource = new DruidDataSource();
+        dataSource.setDriverClassName(env.getProperty("source.driverClassName").trim());
+        dataSource.setUrl(env.getProperty("source.url").trim());
+        dataSource.setUsername(env.getProperty("source.username").trim());
+        dataSource.setPassword(env.getProperty("source.password").trim());
+        return dataSource;
+    }
+
+    @Bean
+    public JdbcTemplate jdbcTemplate(){
+        JdbcTemplate jdbcTemplate = new JdbcTemplate();
+        jdbcTemplate.setDataSource(dataSource());
+        return jdbcTemplate;
+    }
+}
diff --git a/src/main/resources/config/DBsource.properties b/src/main/resources/config/DBsource.properties
@@ -0,0 +1,4 @@
+source.driverClassName = com.mysql.jdbc.Driver
+source.url = jdbc:mysql://localhost:3306/blog
+source.username = root
+source.password = 123
