Mybatis如何傳入多個參數(shù)(實體類型和基本類型)

更新時間：2022年06月22日 08:55:38 作者：小小平不平凡

這篇文章主要介紹了Mybatis如何傳入多個參數(shù)(實體類型和基本類型)，具有很好的參考價值，希望對大家有所幫助。如有錯誤或未考慮完全的地方，望不吝賜教

Mybatis傳入多個參數(shù)

1.ProjectController類

Integer oldUserId = getUserIdByUserName(oldUserName);
? ? ? ??
ProjectAndUser projectAndUser = new ProjectAndUser();
projectAndUser.setProjectId(project.getId());
projectAndUser.setUserId(newUserId);
projectAndUser.setAccessLevel(1);
projectAndUserService.update(projectAndUser, oldUserId);

2.ProjectAndUserService接口

public interface ProjectAndUserService extends BaseService<ProjectAndUser> {
? ? public boolean update(ProjectAndUser projectAndUser, Integer oldUserId);
}

3.ProjectAndUserServiceImpl實現(xiàn)類

@Service
public class ProjectAndUserServiceImpl extends BaseServiceImpl<ProjectAndUser> implements ProjectAndUserService {
? ? @Autowired
? ? ProjectAndUserMapper projectAndUserMapper;
? ? @Override
? ? protected BaseMapper<ProjectAndUser> getMapper() {
? ? ? ? return projectAndUserMapper;
? ? }
?? ?public boolean update(ProjectAndUser projectAndUser, Integer oldUserId){
? ? ? ? return projectAndUserMapper.update(projectAndUser, oldUserId);
? ? }
}

4.ProjectAndUserMapper接口

通過使用@Param注解，實現(xiàn)傳入多個參數(shù)

@Mapper
public interface ProjectAndUserMapper extends BaseMapper<ProjectAndUser> {
? ? public boolean update(@Param("projectAndUser") ProjectAndUser projectAndUser, @Param("oldUserId") Integer oldUserId);
}

5.ProjectAndUserMapper.xml

因為傳入的參數(shù)包括實體類對象，因此使用實體類對象的屬性時需要采用projectAndUser.projectId的形式

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.taobao.rigel.rap.mapper.ProjectAndUserMapper">
?? ?<resultMap id="ProjectAndUserMap" type="com.taobao.rigel.rap.model.ProjectAndUser">
?? ??? ?<result column="project_id" property="projectId"/>
?? ??? ?<result column="user_id" property="userId"/>
?? ??? ?<result column="access_level" property="accessLevel"/>
?? ?</resultMap>
?? ?<update id="update">
?? ??? ?update tb_project_and_user_new set user_id=#{projectAndUser.userId} where project_id=#{projectAndUser.projectId} and user_id=#{oldUserId} and access_level=#{projectAndUser.accessLevel}
?? ?</update>
</mapper>