maven mysql转mongodb_微服务实战(二)连接mysql以及mongodb

在实战一种我们完成了hello world，接下来我们就完成连接数据库以及mongodb，首先我们在配置文件application.properties中添加如下配置：

#connect mysql

spring.datasource.url=jdbc:mysql://localhost:3306/test

spring.datasource.username=root

spring.datasource.password=1988131zjp

spring.datasource.driver-class-name=com.mysql.jdbc.Driver

spring.datasource.max-idle=10

spring.datasource.max-wait=10000

spring.datasource.min-idle=5

spring.datasource.initial-size=5

spring.datasource.jdbc-interceptors=ConnectionState;SlowQueryReport(threshold=0)

#rabbitmq

spring.rabbitmq.host=192.168.20.102

spring.rabbitmq.port=5672

spring.rabbitmq.username=admin

spring.rabbitmq.password=admin

#mongodb mongodb 3.x 只支持这种方式

#spring.data.mongodb.uri=mongodb://192.168.20.102/local

spring.data.mongodb.host=192.168.20.102

spring.data.mongodb.port=27017

server.port=8080

server.session.timeout=10

server.tomcat.uri-encoding=UTF-8

然后再pom.xml加入下面的配置，配置文件如下:

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

4.0.0

com.datababy.springcloud

cloud

1.0-SNAPSHOT

org.springframework.boot

spring-boot-starter-parent

2.0.0.M7

UTF-8

UTF-8

1.8

org.springframework.boot

spring-boot-starter

org.springframework.boot

spring-boot-starter-web

org.springframework.boot

spring-boot-starter-test

test

mysql

mysql-connector-java

org.springframework.boot

spring-boot-starter-jdbc

org.mongodb

mongodb-driver

org.springframework.boot

spring-boot-starter-data-mongodb

org.springframework.data

spring-data-mongodb

org.mongodb

mongo-java-driver

org.springframework.boot

spring-boot-maven-plugin

spring-snapshots

Spring Snapshots

https://repo.spring.io/snapshot

true

spring-milestones

Spring Milestones

https://repo.spring.io/milestone

false

spring-snapshots

Spring Snapshots

https://repo.spring.io/libs-snapshot

true

spring-snapshots

Spring Snapshots

https://repo.spring.io/snapshot

true

spring-milestones

Spring Milestones

https://repo.spring.io/milestone

false

添加完成以后我们在SpringBootTest.java中加入如下的代码最后代码如下:

import com.datababy.enity.Customer;

import com.datababy.enity.Test;

import com.datababy.service.CustomerRepository;

import com.datababy.service.TestService;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.boot.SpringApplication;

import org.springframework.boot.autoconfigure.EnableAutoConfiguration;

import org.springframework.boot.autoconfigure.domain.EntityScan;

import org.springframework.context.annotation.ComponentScan;

import org.springframework.data.mongodb.repository.config.EnableMongoRepositories;

import org.springframework.web.bind.annotation.*;

import java.util.List;

/**

* Created by yongma on 2017/1/23.

*/

@RestController

@ComponentScan({"com.datababy.*"})

@EnableMongoRepositories

@EnableAutoConfiguration

public class SpringBootTest {

@Autowired

private TestService services;

@Autowired

private CustomerRepository customerRepository;

@ResponseBody

@RequestMapping(value = "/")

public String location() {

return "北京";

}

@ResponseBody

@RequestMapping(value="/get")

public List getTest(){

return services.getTest();

}

@RequestMapping(value = "/addCustomer", method = RequestMethod.GET)

public Customer addCustomer(){

return customerRepository.save(new Customer("test1","test1"));

}

public static void main(String[] args) {

SpringApplication.run(SpringBootTest.class, args);

}

}

最后项目结构结果如下图：

image.png