Java EE 用户删除和修改功能

删除和修改基于查询和插入，查询和插入获取http://t.csdn.cn/Hqu9c

一、案例演示

点击删除即可删除对应用户，点击修改则弹出右侧的修改页面，因为我建的user表没设id，所有我们通过用户名来修改对应用户，修改完成点击修改按钮，在重新查找就会发现用户被修改

二、实现步骤

1、View层

1.1、demo02_loginall.jsp

利用以前的查找和插入页面，在查找成功后的页面进行修改和删除，这里我们只需要加上修改的内容页面

<%--修改--%>
<div id="update" class="update" style="float: right;margin-top: -500px;background: deepskyblue;width: 500px;height: 500px">
div>
1
2
3

1.2、js_loginall_demo02.js

function selectUserAndLogin(){
    var params =$form.serialize();
    params = decodeURIComponent(params,true);
    $.ajax({
        url:"http://localhost:8080/javaee_war_exploded/selectUserAndLogin",
        type:"post",
        data:params,
        dataType:"json",
        success:function (data){
            var str="用户名 姓名性别年龄电话密码操作---";
            $.each(data,function (index,obj){
                str+=""+obj.name+""+obj.username+""+obj.sex+""+obj.age+""+obj.telephone+""+obj.loginVo.password+"" +
                    "删除" +
                    "修改";
            })
            $('#show').empty();
            $('#show').append(str);
        },
        error:function (){
            alert("error");
        }
    })
}
function deleteuser(infor){
    console.log(infor)
    serialize="name"+"="+infor;
    $.ajax({
        url:"http://localhost:8080/javaee_war_exploded/deleteuser",
        type:"get",
        data:serialize,
        dataType:"json",
        success:function (data){
            if(data.count==1){
                alert("删除成功")
            }else {
                alert("删除失败")
            }
        },
        error:function (){
            alert("error");
        }
    })
}
function updateuser(name,username,sex,age,telephone){

    str="用户名:
" +
        "姓名:
" +
        "性别:
" +
        "年龄:
" +
        "手机号:
" +
        ""
    $('#update').empty();
    $('#update').append(str);
}
function updateuser2(){
    console.log();
    var name=document.getElementById("name1").value;
    var username=document.getElementById("username1").value;
    var sex=document.getElementById("sex1").value;
    var age=document.getElementById("age1").value;
    var telephone=document.getElementById("telephone1").value;
    serialize="name"+"="+name+"&"+"username"+"="+username+"&"+"sex"+"="+sex+"&"+"age"+"="+age+"&"+"telephone"+"="+telephone;
    params=decodeURIComponent(serialize,true);
    $.ajax({
        url:"http://localhost:8080/javaee_war_exploded/updateuser",
        type:"get",
        data:params,
        dataType:"json",
        success:function (data){
            if(data.count==1){
                alert("修改成功")
            }else {
                alert("修改失败")
            }
        },
        error:function (){
            alert("error");
        }
    })
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80

2、Controller层

2.1、UserController.java

   @RequestMapping( "/deleteuser")
    @ResponseBody
    public String deleteuser(String name) throws JsonProcessingException {
        System.out.println(name);
        int i=userService.deleteuser(name);
        HashMap<String,String> map=new HashMap<>();
        map.put("count",i+"");
        ObjectMapper mapper=new ObjectMapper();
        String json=mapper.writeValueAsString(map);
        return json;
    }

    @RequestMapping(value = "/updateuser",produces = "application/json;charset=utf-8")
    @ResponseBody
    public String updateuser(User user) throws JsonProcessingException {
        System.out.println(user.getUsername());
        int i=userService.updateuser(user);
        HashMap<String,String> map=new HashMap<>();
        map.put("count",i+"");
        ObjectMapper mapper=new ObjectMapper();
        String json=mapper.writeValueAsString(map);
        return json;
    }
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

3、Service层

3.1、UserService.java

    public int deleteuser(String name);
    public int updateuser(User user);
1
2

3.2、UserImplement.java

    @Override
    public int deleteuser(String name) {
        return mapper.deleteuser(name);
    }

    @Override
    public int updateuser(User user) {
        return mapper.updateuser(user);
    }
1
2
3
4
5
6
7
8
9

4、Dao层

4.1、UserMapper.java

    public int deleteuser(@Param("name") String name);
    public int updateuser(User user);
1
2

4.2、UserMapper.xml

    <update id="updateuser" parameterType="User" >
        update user set username =#{username} , sex=#{sex} , age=#{age} , telephone=#{telephone} where name=#{name}
    update>

    <delete id="deleteuser" parameterType="String">
        delete from user where name=#{name}
    delete>
1
2
3
4
5
6
7
8