关于Mybatis中使用Mysql存储过程的方法

##1.有学生表student（id,name,age,money）
##2.创建查询学生表信息的存储过程：

delimiter |
 create Procedure showAllstu()
 BEGIN
  SELECT * FROM student ORDER BY id DESC LIMIT 6;
 END
delimiter

##2.创建(通过学生id)删除记录的存储过程：
```
delimiter |
 create Procedure delById(d int(11))
 BEGIN
  delete from student where id=d;
 END
delimiter

##3.maven中创建项目：（略）

 //pox.xml 配置：
 
  4.0.0
  com.metar
  Mybatis-mysql
  war
  1.0
  Mybatis-mysql Maven Webapp
  http://maven.apache.org
  
  
   junit
   junit
   4.12
   test
  
  
   org.projectlombok
   lombok
   1.16.20
   provided
  
   
    org.mybatis
    mybatis
    3.4.6
   
   
    mysql
    mysql-connector-java
    6.0.6
   
   
   ch.qos.logback
   logback-classic
   1.2.3
   test
   
  
  
   ${project.artifactId}
   src/test/java
   src/main/java
   
   
    
     src/main/java
     
      **/*.xml
      **/*.properties
     
    
    
     src/main/resources
     
      **/*.xml
      **/*.properties
     
    
   
  
 

##4.链接数据库入口配置(略)，配置：mybatis-config.xml:

 <?xml version="1.0" encoding="UTF-8" ?>
 
 
  
  
  
  
   
  
  
   
   
   
   
  
  
   
    
    
     
     
     
     
    
   
  
  
   
   
  
 

##5.创建实体类对象：

 //包：com/fz/entity/Student
 @Data
 public class Student {
  private int id;
  private String name;
  private int age;
  private double money;
 }

 ##6.创建StudentMapper 接口类和StudentMapper.xml配置；

 // StudentMapper 接口类 
 public interface StudentMapper {
  //存储过程查询6条记录；
  public List query();
  //存储过程删除一条记录（通过id）
  public int delById(int id);
 }
 //StudentMapper.xml配置
 ```
 <?xml version="1.0" encoding="UTF-8" ?>
 
 
  
   {call showAllstu()}
  
  
   {call delById(#{id})}
  
 

 ##7.测试 类：
 
 //test/java/com/Demo01
 package com;
 import com.fz.entity.Student;
 import com.fz.mapper.StudentMapper;
 import org.apache.ibatis.io.Resources;
 import org.apache.ibatis.session.SqlSession;
 import org.apache.ibatis.session.SqlSessionFactory;
 import org.apache.ibatis.session.SqlSessionFactoryBuilder;
 import org.junit.After;
 import org.junit.Before;
 import org.junit.Test;
 import java.io.IOException;
 import java.io.InputStream;
 import java.util.List;
 public class Demo01 {
   protected SqlSessionFactory sf;
   protected SqlSession ss;
   @Test
   public void test(){
    StudentMapper sdd = this.ss.getMapper(StudentMapper.class);
    List atd = sdd.query();
    for (Student sd:atd){
     System.out.println(sd);
    }
    sdd.delById(18);
   }
   @Before
   public void init(){
    InputStream is=null;
    try {
     is= Resources.getResourceAsStream("mybatis-config.xml");
     this.sf=new SqlSessionFactoryBuilder().build(is);
     this.ss=this.sf.openSession();
    } catch (IOException e) {
     e.printStackTrace();
    }
   }
   @After
   public void close(){
    this.ss.commit();
    this.ss.close();
   }
 }

create procedure sp_name()
begin
.........
end