springboot mybatis 整合

新建项目在上一篇.

第二步:创建表和相应的实体类

实体类:user.java

package com.qtt.im.entity;

import java.io.Serializable;

public class User implements Serializable {

    private Long id;

    private String loginName;

    private String pass;

    private String mobile;

    private String email;

    private String name;

    public Long getId() {

        return id;

    }

    public void setId(Long id) {

        this.id = id;

    }

    public String getLoginName() {

        return loginName;

    }

    public void setLoginName(String loginName) {

        this.loginName = loginName;

    }

    public String getPass() {

        return pass;

    }

    public void setPass(String pass) {

        this.pass = pass;

    }

    public String getMobile() {

        return mobile;

    }

    public void setMobile(String mobile) {

        this.mobile = mobile;

    }

    public String getEmail() {

        return email;

    }

    public void setEmail(String email) {

        this.email = email;

    }

    public String getName() {

        return name;

    }

    public void setName(String name) {

        this.name = name;

    }

}

第三步:创建写mapper接口,Service,controller

以一个查询为例:

UserMapper.java(此接口用于xml文件和service之间的连接)

package com.qtt.im.mapper;

import com.qtt.im.entity.User;

import org.apache.ibatis.annotations.Mapper;

@Mapper

public interface UserMapper {

    public User getUserList();

}

UserService.java

package com.qtt.im.service;

import com.qtt.im.entity.User;

public interface UserService {

    public User getUserList();

}

UserServiceImpl.java(usermapper会报错,但是不影响运行)

package com.qtt.im.service.impl;

import com.qtt.im.entity.User;

import com.qtt.im.mapper.UserMapper;

import com.qtt.im.service.UserService;

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

import org.springframework.stereotype.Service;

@Service

public class UserServiceImpl implements UserService {

    @Autowired

    private UserMapper usermapper;

    public User getUserList() {

        return usermapper.getUserList();

    }

}

UserController.java

package com.qtt.im.controller;

import com.qtt.im.entity.User;

import com.qtt.im.service.UserService;

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

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

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

@RestController

@RequestMapping(value="/user")

public class UserController {

    @Autowired

    private UserService userService;

    @RequestMapping("/getUserList")

    public User getUserList(){

        User userList = userService.getUserList();

        return userList;

    }

}

所用的注解可以自己网上查询.

第四步:可以添加一些过滤器

MyFilter.java

package com.qtt.im.filter;

import javax.servlet.*;

import javax.servlet.http.HttpServletRequest;

import java.io.IOException;

public class MyFilter implements Filter {

    @Override

    public void init(FilterConfig filterConfig) throws ServletException {

    }

    @Override

    public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {

        HttpServletRequest request = (HttpServletRequest) servletRequest;

        System.out.println("this is my filter url:"+request.getRequestURI());

        filterChain.doFilter(servletRequest,servletResponse);

    }

    @Override

    public void destroy() {

    }

}

WebConfiguration.java

package com.qtt.im.filter;

import org.apache.catalina.filters.RemoteIpFilter;

import org.springframework.boot.web.servlet.FilterRegistrationBean;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

@Configuration

public class WebConfiguration {

    @Bean

    public RemoteIpFilter remoteIpFilter(){

        return  new RemoteIpFilter();

    }

    @Bean

    public FilterRegistrationBean testFilterRegistration(){

        FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean();

        filterRegistrationBean.setFilter(new MyFilter());

        filterRegistrationBean.addUrlPatterns("/*");

        filterRegistrationBean.addInitParameter("paramName","paramValue");

        filterRegistrationBean.setName("MyFilter");

        filterRegistrationBean.setOrder(1);

        return filterRegistrationBean;

    }

}

第五步:编写一个程序入口

Application.java

package com.qtt.im;

import org.mybatis.spring.annotation.MapperScan;

import org.springframework.boot.SpringApplication;

import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication

@MapperScan("com.qtt.im.mapper")

public class Application {

    public static void  main(String[] args){

        SpringApplication.run(Application.class,args);

    }

}

java代码部分的结构图如下:

第六步:创建写sql语句的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.qtt.im.mapper.UserMapper" >

    <select id="getUserList" resultType="com.qtt.im.entity.User" >

        SELECT id,loginName FROM im_user;

    </select>

</mapper>

其中 namespace:是java部分的userMapper接口.resultType:是实体类.返回类型.

第七步:创建配置文件

application.proterties

spring.datasource.url=jdbc:mysql://localhost:3306/sdt?useUnicode=true&characterEncoding=utf-8         (sdt是数据库)

mybatis.type-aliases-package=com.qtt.im.mapper                                                 (mapper接口扫描)

spring.datasource.driver-class-name =  com.mysql.jdbc.Driver                                    (驱动)

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource

spring.datasource.username=root                                                                 (用户名)

spring.datasource.password=qintongtong                                                          (密码)

mybatis.mapper-locations=classpath*:/mappers/**Mapper.xml                                       (xml文件)

log4j.properties

log4j.rootLogger=WARN, CONSOLE

log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender

log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout

log4j.appender.CONSOLE.layout.ConversionPattern=%d{HH:mm:ss,SSS} [%t] %-5p %C{1} : %m%n

配置文件的结构图如下: