81,094
社区成员
发帖
与我相关
我的任务
分享
mapper.xml SQL代码
<select id="selectByIdList" resultType="java.util.HashMap" parameterType="java.lang.Integer">
select s.id,u.name,u.password,s.name from user u join student s
on u.id=s.id where u.id in
<foreach collection="array" item="id" index="index"
open="(" close=")" separator=",">
#{id}
</foreach>
</select>
测试代码。。
@Test
public void testUser() {
List list = new ArrayList();
User user = new User();
user.setAddress("123");
user.setAge(123);
user.setId(123);
user.setName("123");
user.setPw("123");
Integer[] ids = { Integer.valueOf(1) };
int result = this.userService.register(user).intValue();
List<HashMap> map = (List<HashMap>) this.userService.selectByIdList(ids);
if (result >= 0) {
System.out.println(map);
System.out.println("插入用户成功主键" + user.getId());
} else {
System.out.println("失败");
}
}