springboot-day02-整合mybatis与简单使用

前言：该文章是紧接上一篇文章springboot-day01-引入如何读取配置文件以及helloWorld

1.springboot整合mybatis

1.添加jar包依赖

<?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.example</groupId>
    <artifactId>demo</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <packaging>jar</packaging>

    <name>demo</name>
    <description>Demo project for Spring Boot</description>
    <!--设置spring boot的parent-->
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>1.5.9.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.7</java.version>
    </properties>

    <dependencies>
        <!--添加依赖 可以访问html页面-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
    <!--    spring boot的web支持-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!--mybatis-spring桥梁-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>
        <!--mysql驱动包-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <!--aop-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-aop</artifactId>
        </dependency>
        <!--jdbc-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>


</project>

 2.在application.properties添加数据库连接信息

 代码

##########################数据库连接信息###################################
spring.datasource.url=jdbc:mysql://localhost:3306/station
spring.datasource.username=root
spring.datasource.password=admin
spring.datasource.driverClassName=com.mysql.jdbc.Driver
spring.jpa.database = mysql

 3.创建标准web目录结构

                              

4.创建数据库表User

     .

5.创建User实体 USer.java

package com.example.demo.model;

/**
 * Created by Administrator on 2017/12/20.
 */
public class User {
    private Integer id;
    private String userName;
    private String password;
    private String qq;
    private String wx;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getQq() {
        return qq;
    }

    public void setQq(String qq) {
        this.qq = qq;
    }

    public String getWx() {
        return wx;
    }

    public void setWx(String wx) {
        this.wx = wx;
    }
}

6.创建dao接口

package com.example.demo.dao;

import com.example.demo.model.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

/**
 * Created by Administrator on 2017/12/20.
 */
//声明是一个Mapper,与springbootApplication中的@MapperScan二选一写上即可
@Mapper     
@Repository
public interface UserMapper {
    /**
     * 根据名称获取一个用户
     * @param name
     * @return
     */
    User getUserByName(String name);
}

 7.创建service接口

package com.example.demo.service;

import com.example.demo.model.User;
import org.springframework.stereotype.Service;


/**
 * Created by Administrator on 2017/12/20.
 */
@Service
public interface IUserService {
    /**
     * 根据名称获取一个用户
     * @param name
     * @return
     */
    User getUserByName(String name);
}

 8.编辑service实现类

package com.example.demo.service.impl;

import com.example.demo.dao.UserMapper;
import com.example.demo.model.User;
import com.example.demo.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * Created by Administrator on 2017/12/20.
 */
@Service
public class UserService implements IUserService {
    @Autowired
    private UserMapper userMapper;
    
    @Override
    public User getUserByName(String name) {
        return userMapper.getUserByName(name);
    }
}

 9.编辑UserControlle控制层

package com.example.demo.controller;

import com.example.demo.model.User;
import com.example.demo.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

/**
 * Created by Administrator on 2017/12/20.
 */
@Controller
@RequestMapping("/")
public class UserController {
    @Autowired
    private IUserService userService;

    /**
     * 获取用户
     * @return
     */
    @RequestMapping("/getUser")
    @ResponseBody
    public User getUserByName(){
        User user= userService.getUserByName("姿势帝");
        System.out.println("id="+user.getId()+"   userName="+user.getUserName()+"   qq="+user.getQq());
        return user;
    }
}

10.将sql写到xml配置文件中,添加映射

     userMapper.xml代码

<?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="com.example.demo.dao.UserMapper" >

    <select id="getUserByName"  resultType="User">
      SELECT id,user_name userName,`password`,qq,wx FROM `user` WHERE user_name=#{userName}
    </select>

</mapper>

 11.非常重要--在application.properties添加mybatis相关配置

#Mybatis xml文件扫描
mybatis.mapper-locations=classpath*:mapper/*.xml
#起别名。可省略写mybatis的xml中的resultType的全路径
mybatis.type-aliases-package=com.example.demo.model

 12.重启项目并访问

  

     

  基于springboot的ssm整合以及简单使用已完成,很简单吧! 下章我们基于这个结构完成页面上的 CRUD+高级查询+分页

下一章见!

有问题或获取源码请留言,或加 QQ:851298348 加QQ时请注明博客springboot