利用spring整合mybatis做 student crud

1.首先我们先导入相关依赖。

    
        org.springframework.boot
        spring-boot-starter
    
    
        org.springframework.boot
        spring-boot-starter-web
    

    
        org.springframework.boot
        spring-boot-starter-data-jdbc
    
    
        mysql
        mysql-connector-java
        5.1.45
    

    
        com.baomidou
        mybatis-plus
        3.3.2
    

    
    
        commons-dbcp
        commons-dbcp
        1.4
    
    
        commons-pool
        commons-pool
        1.6
    

    
        org.springframework.boot
        spring-boot-starter-test
        test
    

2.我们进行spring事务配置（配置sqlSessionFactory,扫描映射文件(mapper动态代理)，配置事务管理器，开启注解）

    

    
    
        
        
        
        
        
        
        
        
        
        
        
    
    
    
        
        
        
         
Student：
 
package com.hxci.jiangyunsong.pojo;

public class Student {
    private Integer id;
    private String username;
    private String sno;

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }



    public Integer getId() {
        return id;
    }

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


    public String getSno() {
        return sno;
    }

    public void setSno(String sno) {
        this.sno = sno;
    }

    @Override
    public String toString() {
        return "Student{" +
                "id=" + id +
                ", username='" + username + ''' +
                ", sno='" + sno + ''' +
                '}';
    }
}
 
7.创建service包，在service包里创建一个接口CustomerService和CustomerServiceImpl实现类
 
CustomerService：
 
package com.hxci.jiangyunsong.service;

import com.hxci.jiangyunsong.pojo.Customer;
import com.hxci.jiangyunsong.pojo.Student;

import java.util.List;

public interface CustomerService {

     List query();

    void add(Customer customer,Student student);

    void delete(Integer id);

    void update(Customer customer,Student student);


    Customer queryById(Integer id);

}
 
CustomerServiceImpl：
 
package com.hxci.jiangyunsong.service.impl;

import com.hxci.jiangyunsong.dao.CustomerDao;
import com.hxci.jiangyunsong.dao.StudentDao;
import com.hxci.jiangyunsong.pojo.Customer;
import com.hxci.jiangyunsong.pojo.Student;
import com.hxci.jiangyunsong.service.CustomerService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;
@Service
public class CustomerServiceImpl  implements CustomerService   {

    @Autowired
    CustomerDao dao ;
    @Autowired
    StudentDao studentDao ;

    public List query() {
        List list = dao.query();
        return list;
    }


    public void add(Customer customer) {
        dao.add(customer);
    }


    @Transactional
    public void add(Customer customer,Student student) {
        dao.add(customer);
        studentDao.add(student);
    }




    @Transactional
    public void update(Customer customer,Student student) {
        dao.update(customer);
        studentDao.update(student);
    }

    @Transactional
    public void delete(Integer id) {
        dao.delete(id);
        studentDao.delete(id);
    }

    @Transactional
    public Customer queryById(Integer id){

        Customer queryById=dao.queryById(id);
        return queryById;
    }


}
 
8.创建一个Test测试类，实现增删改查
 
package com.hxci.jiangyunsong;

import com.hxci.jiangyunsong.controller.CustomerController;
import com.hxci.jiangyunsong.pojo.Customer;
import com.hxci.jiangyunsong.pojo.Student;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class TestDemo {
    public static void main(String[] args) {
        ApplicationContext context =
                new ClassPathXmlApplicationContext("classpath:spring-mybatis.xml");

        for (String beanName : context.getBeanDefinitionNames()) {
            System.out.println(beanName + ":" + context.getBean(beanName));
        }

        CustomerController controller = (CustomerController)context.getBean("customerController");
        //添加
        


        


       

       //查询一条

       

        Customer customer = new Customer();
        controller.queryById(2);


    }
}