SpringBoot学习笔记(六、Mybatis)

Mybatis这个框架式当下比较流行的框架,SpringBoot整合Mybatis其实和整合JPA是比较相似的,有区别的只是数据操作的部分。

1、引入相应依赖

mybatis-spring-boot-starter

         <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
         </dependency>

pagehelper

  <dependency>
           <groupId>com.github.pagehelper</groupId>
           <artifactId>pagehelper</artifactId>
           <version>4.1.6</version>
         </dependency>

完整pom.xml

<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>edu.hpu</groupId>
  <artifactId>SpringBoot</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <name>SpringBoot</name>
  <!-- Spring Boot 启动父依赖 -->
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>1.3.3.RELEASE</version>
    </parent>
    <dependencies>
        <!-- Spring Boot web依赖 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!-- Junit -->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>
        <!-- 添加servlet依赖 -->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
        </dependency>
        
        <!--添加 jstl依赖 -->
        <dependency>
           <groupId>javax.servlet</groupId>
           <artifactId>jstl</artifactId>
        </dependency>
        
        <!-- tomcat的支持 -->
        <dependency>
           <groupId>org.apache.tomcat.embed</groupId>
           <artifactId>tomcat-embed-jasper</artifactId>
        </dependency>
        
        <!-- 热部署依赖 -->
        <dependency>
           <groupId>org.springframework.boot</groupId>
           <artifactId>spring-boot-devtools</artifactId>
            <optional>true</optional> <!-- 这个需要为 true 热部署才有效 -->
        </dependency>
        
        <!-- 添加对mysql的支持 -->
        <dependency>
           <groupId>mysql</groupId>
           <artifactId>mysql-connector-java</artifactId>
           <version>5.1.21</version>
        </dependency>
        
         <!--mybatis支持  -->
         <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
         </dependency>
         
         <!-- pagehelper -->
         <dependency>
           <groupId>com.github.pagehelper</groupId>
           <artifactId>pagehelper</artifactId>
           <version>4.1.6</version>
         </dependency>
    </dependencies>
    
    <properties>
      <java.version>1.8</java.version>
    </properties>
    
    <build>
       <plugins>
           <plugin>
              <groupId>org.springframework.boot</groupId>
              <artifactId>spring-boot-maven-plugin</artifactId>
           </plugin>
       </plugins>
    </build>
</project>

2、application.properties

除了数据源相关的配置,和Mybatis相关的还要指明从哪里去找xml配置文件,同时指定别名

spring.mvc.view.prefix=/WEB-INF/jsp/
spring.mvc.view.suffix=.jsp
spring.datasource.url=jdbc:mysql://localhost:3306/springbootjpa?characterEncoding=UTF-8
spring.datasource.username=root
spring.datasource.password=xing0515
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

mybatis.mapper-locations=classpath:edu/hpu/springboot/mapper/*.xml
mybatis.type-aliases-package=edu.hpu.springboot.pojo

3、数据

懒得再建了,还是用之前的

create database springbootjpa;
use springbootjpa; 
CREATE TABLE category_ ( 
 id int(11) NOT NULL AUTO_INCREMENT,
 name varchar(30), PRIMARY KEY (id) ) DEFAULT CHARSET=UTF8;

相应的实体类

package edu.hpu.springboot.pojo;

public class Category {
   private int id;
   private String name;

    public int getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }
   
}

4、PageHelperConfig

新建一个包edu.hpu.springboot.config,包下新建一个类 PageHelperConfig,这个类是干什么的,管分页的。

注解@Configuration 表示PageHelperConfig 这个类是用来做配置的。

注解@Bean 表示启动PageHelper这个拦截器。

import org.springframework.context.annotation.Configuration;

import com.github.pagehelper.PageHelper;

@Configuration
public class PageHelperConfig {
    @Bean
    public PageHelper pageHelper() {
        PageHelper pageHelper = new PageHelper();
        Properties p = new Properties();
        p.setProperty("offsetAsPageNum", "true");  //将RowBounds第一个参数offset当成pageNum页码使用.
        p.setProperty("rowBoundsWithCount", "true");  //使用RowBounds分页会进行count查询
        p.setProperty("reasonable", "true");                       //启用合理化时,如果pageNum<1会查询第一页,如果pageNum>pages会查询最后一页
        pageHelper.setProperties(p);
        return pageHelper;
    }

}

5、CategoryMapper

新建一个edu.hpu.springboot.mapper包,包下新建一个接口CategoryMapper

package edu.hpu.springboot.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;


import edu.hpu.springboot.pojo.Category;
@Mapper
public interface CategoryMapper {
    List<Category> findAll();
    public int save(Category category);
    public void delete(int id);
    public Category get(int id);
    public int update(Category category);
}

6、Category.xml

在edu.hpu.springboot.mapper下新建Category.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="edu.hpu.springboot.mapper.CategoryMapper">
        <select id="findAll" resultType="Category">
            select * from category_
        </select>   
        
        <insert id="save" parameterType="Category">
          insert into category_ ( name ) values (#{name})
        </insert>
        
        <delete id="delete" parameterType="int">
           delete from category_ where id= #{id}
        </delete>
        
        <select id="get" parameterType="int" resultType="Category">
          select * from category_ where id= #{id}
        </select>
        
        <update id="update" parameterType="Category">
           update category_ set name=#{name} where id=#{id}
        </update>
    </mapper>

7、CategoryController

package edu.hpu.springboot.web;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;

import edu.hpu.springboot.mapper.CategoryMapper;
import edu.hpu.springboot.pojo.Category;

@Controller
public class CategoryController {
   @Autowired
   CategoryMapper categoryMapper;
   
   @RequestMapping("/listCategory")
   public String listCategory(Model m,@RequestParam(value = "start", defaultValue = "0") int start,@RequestParam(value = "size", defaultValue = "5") int size) throws Exception {
       PageHelper.startPage(start,size,"id desc");
       List<Category> cs=categoryMapper.findAll();
       PageInfo<Category> page = new PageInfo<>(cs);
       m.addAttribute("page", page);         
       return "listCategory";
   }
   
   @RequestMapping("/addCategory")
   public String listCategory(Category c) throws Exception {
    categoryMapper.save(c);
    return "redirect:listCategory";
   }
   @RequestMapping("/deleteCategory")
   public String deleteCategory(Category c) throws Exception {
    categoryMapper.delete(c.getId());
    return "redirect:listCategory";
   }
   @RequestMapping("/updateCategory")
   public String updateCategory(Category c) throws Exception {
    categoryMapper.update(c);
    return "redirect:listCategory";
   }
   @RequestMapping("/editCategory")
   public String listCategory(int id,Model m) throws Exception {
    Category c= categoryMapper.get(id);
    m.addAttribute("c", c);
    return "editCategory";
   }
}

8、listCategory.jsp与editCategory.jsp

listCategory.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
 <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>   
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>查看分类</title>
</head>
<body>
    <div style="width: 500px; margin: 20px auto; text-align: center">
        <table align='center' border='1' cellspacing='0'>
            <tr>
                <td>id</td>
                <td>name</td>
                <td>编辑</td>
                <td>删除</td>
            </tr>
            <c:forEach items="${page.list}" var="c" varStatus="st">
                <tr>
                    <td>${c.id}</td>
                    <td>${c.name}</td>
                    <td><a href="editCategory?id=${c.id}">编辑</a></td>
                    <td><a href="deleteCategory?id=${c.id}">删除</a></td>
                </tr>
            </c:forEach>

        </table>
        <br>
        <div>
            <a href="?start=1">[首 页]</a> <a href="?start=${page.pageNum-1}">[上一页]</a>
            <a href="?start=${page.pageNum+1}">[下一页]</a> <a
                href="?start=${page.pages}">[末 页]</a>
        </div>
        <br>
        <form action="addCategory" method="post">

            name: <input name="name"> <br>
            <button type="submit">提交</button>

        </form>
    </div>
    </html>

editCategory.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>修改</title>
</head>
<body>
    <div style="margin: 0px auto; width: 500px">

        <form action="updateCategory" method="post">

            name: <input name="name" value="${c.name}"> <br> <input
                name="id" type="hidden" value="${c.id}">
            <button type="submit">提交</button>

        </form>
    </div>
</body>
</html>

整个项目结构一览(忽略掉那个红叉,不影响)

SpringBoot学习笔记(六、Mybatis)跑一下

SpringBoot学习笔记(六、Mybatis)SpringBoot学习笔记(六、Mybatis)关于Mybatis,还可以使用注解的方式,就是不用xml配置,在接口相应语句上添加注解,比如

  @Select("select * from category_ ")
    List<Category> findAll();


上一篇:Mybatis学习第四天:Mybatis延迟加载懒加载,一级缓存,二级缓存,注解开发


下一篇:ubuntu qt安装及快捷方式建立与opencv配置