Spring与Mybatis的整合（列举登入注册案例）

在mybatis-config.xml中，我们只需要写类的别名和引用的Mapper

在ApplicationContext.xml中，我们要配置数据库连接池，和sqlSessionFactory对象，以及Mapper对象。

接口UserMapper.java

public interface UserMapper {
    //根据账号密码查询用户
    User queryUserByAccAndPwd(@Param("user") User user);

    //新增用户
    int addUser(@Param("user") User user);
}

映射UserMapper.xml

    
        select * from `user_info` where user_id = #{user.userId} and user_pwd = #{user.userPwd}
    

    
        insert into `user_info` values (null,#{user.userPwd},#{user.userName},#{user.phone},
        #{user.email},#{user.sex},#{user.academicId},#{user.occupationId},0,default ,default ,default )
    

接口

public interface UserService {
    //根据账号密码查询用户
    User queryUserByAccAndPwdService(User user);

    //新增用户
    int add(User user);
}

实现（实现类要打上@Service注解才能被spring识别）

@Service
public class UserServiceImpl implements UserService {
    //自动注入mapper
    @Autowired
    private UserMapper userMapper;

    //根据账号密码查询用户
    @Override
    public User queryUserByAccAndPwdService(User user) {
        return userMapper.queryUserByAccAndPwd(user);
    }

    //新增用户
    @Override
    public int add(User user) {
        return userMapper.addUser(user);
    }
}

        //调用服务
        UserService userService = ServiceFactory.getBean(UserService.class);
        userService.add(user);

@Data
public class User {
    private int userId;
    private String userPwd;
    private String userName;
    private String phone;
    private String email;
    private String sex;
    private int academicId;
    private int occupationId;
    private int integralId;
    private int status;
    private String createTime;
    private String updateTime;
}