Springboot连接数据库

一.添加依赖

    <properties>
        <mybatis-spring-boot>1.2.0</mybatis-spring-boot>
        <mysql-connector>5.1.39</mysql-connector>
    </properties>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>${mybatis-spring-boot}</version>
        </dependency>
        <!-- MySQL 连接驱动依赖 -->
        <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>${mysql-connector}</version>
       </dependency>
　　　　　<!--Oracle连接驱动依赖-->
        <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc6</artifactId>
            <version>11.2.0.1.0</version>
        </dependency>

二.修改application.properties设置

## 数据源配置
spring.datasource.url=jdbc:oracle:thin:@ip:/database
spring.datasource.username=
spring.datasource.password=
spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver

## Mybatis 配置
mybatis.typeAliasesPackage=org.spring.springboot.domain
mybatis.mapperLocations=classpath:mapper/*.xml

三.编写Controller Service ServiceImpl Dao Mapper

其中Controller 注入Service接口

　　ServiceImpl注入Dao

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="org.spring.springboot.dao.CfUserDao">
    <resultMap id="BaseResultMap" type="org.spring.springboot.domain.CfUser">
        <result column="userid" property="userid" />
        <result column="usercode" property="usercode" />
        <result column="loginname" property="loginname" />
        <result column="password" property="password" />
        <result column="companyid" property="companyid" />
        <result column="employeeid" property="employeeid" />
        <result column="recordstatus" property="recordstatus" />
        <result column="modifyuserid" property="modifyuserid" />
        <result column="modifydate" property="modifydate" />
        <result column="userno" property="userno" />
        <result column="version" property="version" />
        <result column="ucuserid" property="ucuserid" />
        <result column="myuserid" property="myuserid" />
        <result column="usertype" property="usertype" />
        <result column="employeename" property="employeename" />
        <result column="privclassnames" property="privclassnames" />
    </resultMap>

    <parameterMap id="CfUser" type="org.spring.springboot.domain.CfUser"/>

    <sql id="Base_Column_List">
        <!--
          WARNING - @mbg.generated
        -->
        USERID, USERCODE, LOGINNAME, PASSWORD, COMPANYID, EMPLOYEEID, RECORDSTATUS, MODIFYUSERID,
        MODIFYDATE, USERNO, VERSION, UCUSERID, MYUSERID, USERTYPE, EMPLOYEENAME, PRIVCLASSNAMES
    </sql>

    <select id="selectByName" parameterType="long" resultMap="BaseResultMap">
        select
        *
        from cf_user
        where userid = #{userid}
    </select>

</mapper>