idea从零搭建简单的springboot+Mybatis

需用到的sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost root
Source Server Version : 80012
Source Host           : localhost:3306
Source Database       : demo

Target Server Type    : MYSQL
Target Server Version : 80012
File Encoding         : 65001

Date: 2018-12-11 14:58:41
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户名',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `salt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '随机盐',
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '简介',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '头像',
  `dept_id` int(11) DEFAULT NULL COMMENT '部门ID',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '0' COMMENT '0-正常，1-删除',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `user_idx1_username` (`username`),
  UNIQUE KEY `user_idx2_phone` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES ('1', 'admin', '$2a$10$vg5QNHhCknAqevx9vM2s5esllJEzF/pa8VZXtFYHhhOhUcCw/GWyS', null, '17034642111', null, '1', '2018-04-20 07:15:18', '2018-05-11 17:12:00', '0');
INSERT INTO `sys_user` VALUES ('4', 'pig', '$2a$10$vg5QNHhCknAqevx9vM2s5esllJEzF/pa8VZXtFYHhhOhUcCw/GWyS', null, '17034642118', null, '1', '2018-04-22 11:39:07', '2018-05-10 18:01:11', '0');

首先打开idea创建项目

选好jdk版本点击next

根据自己需求修改各个参数点击next

选中SQL的依赖

然后选择web依赖点击next

finish

然后新建各个包

在application.properties

#数据库地址及库
spring.datasource.url=jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false
#数据库账号密码
spring.datasource.username=root
spring.datasource.password=root
#驱动
spring.datasource.driverClassName=com.mysql.jdbc.Driver

#mapper扫描地址
mybatis.mapper-locations= classpath*:mapper/**/*Mapper.xml

#tomcat端口号及编码
server.port=8011
server.tomcat.uri-encoding=UTF-8

这里启动时会报个错，这个错目前好像是springboot版本过于新，导致jdbc的驱动与以前不一样，所以我更改了springboot版本（下方红色为报错信息） 记得构建下

更改后在controler中创建一个java类

controller代码

package com.example.demo.controller;

import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController
public class DemoController {

    @RequestMapping("hello")
    public String test(){
        return "hello";
    }
}

创建后启动进入网址：http://localhost:8011/hello

进入成功

到这里就是简单的idea搭建springboot项目了，接下来整合mybaits

新建各个类

/* 
 * Copyright (c) 2015, QUANRONG E-COMMDERCE LTD. All rights reserved.
 */
package com.example.demo.domain;

import java.util.Date;

/**
 * 用户Entity
 * @author qr
 * @version 2013-12-05
 */
public class User {

    private static final long serialVersionUID = 1L;

    private Long id;//租户id
    private String username;//用户名
    private String password;//租户id
    private String salt;//随机盐
    private String phone;//简介
    private String avatar;//头像
    private String deptid;//部门ID
    private Date createTime;//创建时间
    private Date updateTime;//修改时间
    private String delFlag;//0-正常，1-删除',

    public Long getId() {
        return id;
    }

    public void setId(Long 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 getSalt() {
        return salt;
    }

    public void setSalt(String salt) {
        this.salt = salt;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getAvatar() {
        return avatar;
    }

    public void setAvatar(String avatar) {
        this.avatar = avatar;
    }

    public String getDeptid() {
        return deptid;
    }

    public void setDeptid(String deptid) {
        this.deptid = deptid;
    }

    public Date getCreateTime() {
        return createTime;
    }

    public void setCreateTime(Date createTime) {
        this.createTime = createTime;
    }

    public Date getUpdateTime() {
        return updateTime;
    }

    public void setUpdateTime(Date updateTime) {
        this.updateTime = updateTime;
    }

    public String getDelFlag() {
        return delFlag;
    }

    public void setDelFlag(String delFlag) {
        this.delFlag = delFlag;
    }
}

controller代码修改为（如果自己编写代码注意注解别忘记加上）

package com.example.demo.controller;

import com.example.demo.domain.User;
import com.example.demo.service.HelloService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
public class DemoController {

@Autowired
private HelloService helloService;


    @RequestMapping("hello")
    @ResponseBody
    public  List<User> test(){
        List<User> users = helloService.selectUser();
        return users;
    }
}

service

package com.example.demo.service;

import com.example.demo.domain.User;

import java.util.List;

public interface HelloService {
    List<User> selectUser();
}

serviceImpl（如果自己编写代码注意注解别忘记加上）

package com.example.demo.service.Impl;

import com.example.demo.domain.User;
import com.example.demo.mapper.HelloDao;
import com.example.demo.service.HelloService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class HelloServiceImpl implements HelloService {
    @Autowired
    private HelloDao helloDao;

    @Override
    public List<User> selectUser() {
        return helloDao.selectUser();
    }
}

dao（如果自己编写代码注意注解别忘记加上）

package com.example.demo.mapper;

import com.example.demo.domain.User;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface HelloDao {
     List<User> selectUser();
}

 xml（记得修改mapper的namespace为对应dao的全路径 还有resultType的全路径）

<?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.mapper.HelloDao">

    <select id="selectUser" resultType="com.example.demo.domain.User">
        SELECT
        user_id as 'id',
        username,
        password,
        salt,
        phone,
        avatar,
        dept_id as  'deptId',
        create_time AS 'createTime',
        update_time AS 'updateTime',
        del_flag AS 'delFlag'
        FROM sys_user;
    </select>

</mapper>

最后在启动项加上扫描的包的地址

然后大功告成 访问地址：http://localhost:8011/hello