SpringBoot开发实践-datasource

来源：互联网发布：淘宝提前收款好用吗编辑：程序博客网时间：2024/06/10 18:19

SpringBoot连接数据库
官网介绍
我们这一篇就讲解一如何连接数据库。
1.我们新建user表，字段user_id,user_name;
参看：http://blog.csdn.net/neruda1991/article/details/51885330
建表语句如下：
CREATE TABLEuser(use_namevarchar(50) DEFAULT NULL,user_idbigint(20) NOT NULL AUTO_INCREMENT, PRIMARY KEY (user_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2添加相关依赖，pom.xml如下

<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0" 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">    <modelVersion>4.0.0</modelVersion>    <groupId>com.baiguomin</groupId>    <artifactId>demo</artifactId>    <version>0.0.1-SNAPSHOT</version>    <packaging>jar</packaging>    <name>demo</name>    <description>Demo project for Spring Boot</description>    <parent>        <groupId>org.springframework.boot</groupId>        <artifactId>spring-boot-starter-parent</artifactId>        <version>1.3.6.RELEASE</version>        <relativePath/> <!-- lookup parent from repository -->    </parent>    <properties>        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>        <java.version>1.8</java.version>    </properties>    <dependencies>        <dependency>            <groupId>org.springframework.boot</groupId>            <artifactId>spring-boot-starter</artifactId>        </dependency>        <dependency>            <groupId>org.springframework.boot</groupId>            <artifactId>spring-boot-starter-test</artifactId>            <scope>test</scope>        </dependency>        <dependency>            <groupId>org.springframework.boot</groupId>            <artifactId>spring-boot-starter-web</artifactId>        </dependency>        <dependency>            <groupId>org.springframework.boot</groupId>            <artifactId>spring-boot-starter-jdbc</artifactId>            </dependency>        <dependency>            <groupId>mysql</groupId>            <artifactId>mysql-connector-java</artifactId>        </dependency>    </dependencies>    <build>        <plugins>            <plugin>                <groupId>org.springframework.boot</groupId>                <artifactId>spring-boot-maven-plugin</artifactId>            </plugin>        </plugins>    </build></project>

项目骨架图
项目代码在稍后的github仓库上。
其中application.properties文件中：

spring.datasource.url=jdbc:mysql://localhost/demospring.datasource.username=rootspring.datasource.password=spring.datasource.driver-class-name=com.mysql.jdbc.Driver

springBoot回去自动扫描该文件，并把spring.datasource开头的作为默认的datasource的注解。

这样子，我们启动项目，访问http://localhost:8080/hello
就能够从数据库中看到根据用户id查到的用户名。
代码地址：https://github.com/baiguomin/SpringBoot-MyBatis-EhCache-Druid

0 0