Spring5-Mybatis整合

1、导入maven依赖
 
        8
        8
        5.2.8.RELEASE
    
 

        

            org.springframework

            spring-context

            ${spring.version}

        

        

        

            org.springframework

            spring-jdbc

            ${spring.version}

        

        

        

            org.mybatis

            mybatis-spring

            2.0.0

        

        

        

            org.mybatis

            mybatis

            3.5.1

        

        

        

            mysql

            mysql-connector-java

            8.0.25

        

    

2、编写实体类

public class SysUser {
        private Long userId;        //用户编号

        private String username;    //用户名

        private String password;    //密码

        private Long employeeId;    //员工编号

        private Integer salt;   //盐值

        public Long getUserId() {
            return userId;
        }

        public void setUserId(Long userId) {
            this.userId = userId;
        }

        public String getUsername() {
            return username;
        }

        public void setUsername(String username) {
            this.username = username == null ? null : username.trim();
        }

        public String getPassword() {
            return password;
        }

        public void setPassword(String password) {
            this.password = password == null ? null : password.trim();
        }

        public Long getEmployeeId() {
            return employeeId;
        }

        public void setEmployeeId(Long employeeId) {
            this.employeeId = employeeId;
        }

        public Integer getSalt() {
            return salt;
        }

        public void setSalt(Integer salt) {
            this.salt = salt;
        }

    @Override
    public String toString() {
        return "SysUser{" +
                "userId=" + userId +
                ", username='" + username + ''' +
                ", password='" + password + ''' +
                ", employeeId=" + employeeId +
                ", salt=" + salt +
                '}';
    }
}

3、编写Mapper即dao层

import Pojo.SysUser;
public interface SysUserMapper {
    public SysUser selectUserById(int user_id);
    public void deleteUserById(int user_id);
}

4、编写service以及serviceimpl

@Service
public interface SysUserService {
    public SysUser select(int user_id);
    public void deleteUserById(int user_id);
}

@Repository
public class SysUserServiceimpl implements SysUserService {
    @Autowired
    SysUserMapper userMapper;
    @Override
    public SysUser select(int user_id) {
        return userMapper.selectUserById(user_id);
    }

    @Override
    public void deleteUserById(int user_id) {
        userMapper.deleteUserById(user_id);
    }
}

5、编写mapper.xml

    
        delete from sys_user where user_id=#{user_id}
    
    
    
        select * from sys_user where user_id=#{user_id}
    

db.properties文件
jdbc.driver=com.mysql.cj.jdbc.Driver

jdbc.url=jdbc:mysql://localhost:3306/neuedu-oa

jdbc.username=root

jdbc.password=123456

spring-mybatis.xml



    

    

    

    

    

    

        

        

        

        

    

    

    

        

        
        
        
            
                
            
        
    

    

    

        

        

    

public static void main(String[] args) {
        ApplicationContext act=new ClassPathXmlApplicationContext("spring-mybatis.xml");
        SysUserServiceimpl userService=(SysUserServiceimpl)act.getBean("sysUserServiceimpl");
        System.out.println(userService.select(1).toString());
    }

输出：
SysUser{userId=1, username='m8', password='f57e762e3fb7e1e3ec8ec4db6a1248e1', employeeId=1, salt=188}

• 导入maven相关依赖
• 编写pojo类、dao层、service层、serviceimpl层并加入容器中
• 编写相关mapper.xml、以及编写spring-mybatis.xml的文件、导入db.properties文件相关配置属性到spring-mybatis.xml中
• 编写测试类