Spring Boot结合Mybatis的项目搭建及数据库增删改查操作

引入依赖

 
            org.mybatis
            mybatis
            3.3.0
        
        
            mysql
            mysql-connector-java
            8.0.15
        
        
            log4j
            log4j
            1.2.16
        
        
            org.slf4j
            slf4j-api
            1.6.1
        
        
            org.slf4j
            slf4j-nop
            1.6.4
        
        
            org.junit.jupiter
            junit-jupiter-api
            5.8.2
            test
        

在pom.xml文件build标签中添加

            
            
                src/main/java
                
                    **
    public Student getStudentById(int id);

    
    public Integer insertStudent(Student student);


    
    public boolean updateStudent(Student student);

test 

 //1: 查询操作调用实际方法实现操作
            Student student = mapper.getStudentById(1);
            System.out.println(student);


            //2： 添加操作
            Student student = new Student();
            student.setLastname("t");
            student.setEmail("t@qq.com");
            Integer rows = mapper.insertStudent(student);
            System.out.println(rows);


            //3:修改操作
            Student student = new Student();
            student.setLastname("to");
            student.setEmail("t@163.com");
            boolean isupdate = mapper.updateStudent(student);
            System.out.println(isupdate);

mapper.xml

 
    
        select * from tbl_employee where id = #{id}
    
    
    
    
        UPDATE tbl_employee SET lastname=#{lastname},email=#{email},gender=#{gender} WHERe id=#{id}
    
    

 运行test刷新数据库就会看到结果