查询姓名为“{自己姓名}”的学生名单
查询id为自己的{id} 的学生名单 （课堂完成）
-----------------课后--------------------------
插入id为45，学号为：21121145，姓名为“{自己姓名}2”
<insert id="insertAuser" parameterType="MyUser" >
insert into student(id, number, name) values (#{id},#{number}, #{name})
</insert>
@RequestMapping("/insertAuser/{id} {number} {name}")//第一种
public void insertAuser(@PathVariable Integer id,@PathVariable String number, @PathVariable String name){
myUserPository.insertAuser(id, number, name);
}
@RequestMapping("/insertAuser") //第二种
public void insertAuser(MyUser myUser){
myUser.setId(54);
myUser.setName("li");
myUser.setNumber("123");
myUserPository.insertAuser(myUser);
}
更新id为19，的姓名为“{自己姓名}3”
删除id为45的学生
-------------------------------参考以下语句-----------------------------------
<!-- 根据uid查询一个用户信息 -->
<select id="selectUserById" parameterType="Integer" resultType="MyUser">
select * from user where uid = #{uid}
</select>
<!-- 添加一个用户 ，#{uname}为MyUser的属性值-->
<insert id="addUser" parameterType="MyUser">
insert into user (uname,usex) values(#{uname},#{usex})
</insert>
<!-- 修改一个用户 -->
<update id="updateUser" parameterType="MyUser">
update user set uname = #{uname},usex = #{usex} where uid = #{uid}
</update>
<!-- 删除一个用户 -->
<delete id="deleteUser" parameterType="Integer">
delete from user where uid = #{uid}
</delete>
<!-- 查询陈姓男性用户信息 -->
<select id="testMapSelect" resultType="MyUser" parameterType="map">
select * from user
where uname like concat('%',#{u_name},'%')
and usex = #{u_sex}
</select>
<!-- 通过Java Bean传递参数查询陈姓男性用户信息，#{uname}的uname为参数MyUser的属性-->
<select id="selectAllUserByJavaBean" resultType="MyUser" parameterType="MyUser">
select * from user
where uname like concat('%',#{uname},'%')
and usex = #{usex}
</select>
<!-- 通过@Param注解传递参数查询陈姓男性用户信息，这里不需要定义参数类型-->
<select id="selectAllUserByParam" resultType="MyUser">
select * from user
where uname like concat('%',#{puname},'%')
and usex = #{pusex}
</select>
--------------------------------参考以下控制器代码----------------------------
@Autowired
private UserMapper userMapper;
@RequestMapping("/test")
public String test() {
// 查询一个用户
MyUser mu = userMapper.selectUserById(1);
System.out.println(mu);
// 添加一个用户
MyUser addmu = new MyUser();
addmu.setUname("陈恒");
addmu.setUsex("男");
userMapper.addUser(addmu);
// 修改一个用户
MyUser updatemu = new MyUser();
updatemu.setUid(1);
updatemu.setUname("张三");
updatemu.setUsex("女");
userMapper.updateUser(updatemu);
// 删除一个用户
userMapper.deleteUser(3);
// 查询所有用户
List<MyUser> listMu = userMapper.selectAllUser();
for (MyUser myUser : listMu) {
System.out.println(myUser);
}
return "test";
}
// 通过MyUser封装参数，查询所有陈姓男性用户。
@RequestMapping("/selectAllUserByJavaBean")
public String selectAllUserByJavaBean(Model model) {
MyUser mu = new MyUser();
mu.setUname("陈");
mu.setUsex("男");
List<MyUser> unameAndUsexList = userMapper.selectAllUserByJavaBean(mu);
model.addAttribute("unameAndUsexList", unameAndUsexList);
return "showUnameAndUsexUser";
}
