3.CRM实现用户的添加，修改，删除

1.dao层

public interface UserDao {    /**     * 修改用户     * @param user     * @return     */    public int update(User user);    /**     * 添加用户     * @param user     * @return     */    public int add(User user);    /**     * 删除用户     * @param id     * @return     */    public int delete(Integer id);}

2.service层复制dao层代码

public interface UserService {    /**     * 修改用户     * @param user     * @return     */    public int update(User user);    /**     * 添加用户     * @param user     * @return     */    public int add(User user);    /**     * 删除用户     * @param id     * @return     */    public int delete(Integer id);}

3.service层的实现类

@Service("userService")public class UserServiceImpl implements UserService{    @Resource    private UserDao userDao;    @Override    public int update(User user) {        return userDao.update(user);    }    @Override    public int add(User user) {        return userDao.add(user);    }    @Override    public int delete(Integer id) {        return userDao.delete(id);    }}

4.Controller层

@Controller@RequestMapping("/user")public class UserController {    @Resource    private UserService userService;    /**     * 添加或者修改用户     * @param user     * @param response     * @return     * @throws Exception     */    @RequestMapping("/save")    public String save(User user,HttpServletResponse response)throws Exception{        int resultTotal=0; // 操作的记录条数        if(user.getId()==null){            resultTotal=userService.add(user);        }else{            resultTotal=userService.update(user);        }        JSONObject result=new JSONObject();        if(resultTotal>0){            result.put("success", true);        }else{            result.put("success", false);        }        ResponseUtil.write(response, result);        return null;    }    /**     * 删除用户     * @param ids     * @param response     * @return     * @throws Exception     */    @RequestMapping("/delete")    public String delete(@RequestParam(value="ids")String ids,HttpServletResponse response)throws Exception{        String []idsStr=ids.split(",");        for(int i=0;i<idsStr.length;i++){            userService.delete(Integer.parseInt(idsStr[i]));        }        JSONObject result=new JSONObject();        result.put("success", true);        ResponseUtil.write(response, result);        return null;    }}

5.配置UserMapper.xml

<insert id="add" parameterType="User">        insert into t_user values(null,#{userName},#{password},#{trueName},#{email},#{phone},#{roleName})    </insert>    <update id="update" parameterType="User">        update t_user        <set>            <if test="userName!=null and userName!='' ">                userName=#{userName},            </if>            <if test="password!=null and password!='' ">                password=#{password},            </if>            <if test="trueName!=null and trueName!='' ">                trueName=#{trueName},            </if>            <if test="email!=null and email!='' ">                email=#{email},            </if>            <if test="phone!=null and phone!='' ">                phone=#{phone},            </if>            <if test="roleName!=null and roleName!='' ">                roleName=#{roleName},            </if>        </set>        where id=#{id}    </update>    <delete id="delete" parameterType="Integer">        delete from t_user where id=#{id}    </delete>

6.jsp页面

<%@ page language="java" contentType="text/html; charset=UTF-8"    pageEncoding="UTF-8"%><script type="text/javascript"> var url; function searchUser(){     $("#dg").datagrid('load',{        "userName":$("#s_userName").val()      }); } function openUserAddDialog(){     $("#dlg").dialog("open").dialog("setTitle","添加用户信息");     url="${pageContext.request.contextPath}/user/save.do"; } function openUserModifyDialog(){     var selectedRows=$("#dg").datagrid("getSelections");     if(selectedRows.length!=1){         $.messager.alert("系统提示","请选择一条要编辑的数据！");         return;     }     var row=selectedRows[0];     $("#dlg").dialog("open").dialog("setTitle","编辑用户信息");     $("#fm").form("load",row);     url="${pageContext.request.contextPath}/user/save.do?id="+row.id; } function saveUser(){     $("#fm").form("submit",{        url:url,        onSubmit:function(){            if($("#roleName").combobox("getValue")==""){                $.messager.alert("系统提示","请选择用户角色！");                return false;            }            return $(this).form("validate");        },        success:function(result){            var result=eval('('+result+')');            if(result.success){                $.messager.alert("系统提示","保存成功！");                resetValue();                $("#dlg").dialog("close");                $("#dg").datagrid("reload");            }else{                $.messager.alert("系统提示","保存失败！");                return;            }        }     }); } function resetValue(){     $("#userName").val("");     $("#password").val("");     $("#trueName").val("");     $("#email").val("");     $("#phone").val("");     $("#roleName").combobox("setValue",""); } function closeUserDialog(){     $("#dlg").dialog("close");     resetValue(); } function deleteUser(){     var selectedRows=$("#dg").datagrid("getSelections");     if(selectedRows.length==0){         $.messager.alert("系统提示","请选择要删除的数据！");         return;     }     var strIds=[];     for(var i=0;i<selectedRows.length;i++){         strIds.push(selectedRows[i].id);     }     var ids=strIds.join(",");     $.messager.confirm("系统提示","您确定要删除这<font color=red>"+selectedRows.length+"</font>条数据吗？",function(r){        if(r){            $.post("${pageContext.request.contextPath}/user/delete.do",{ids:ids},function(result){                if(result.success){                     $.messager.alert("系统提示","数据已成功删除！");                     $("#dg").datagrid("reload");                }else{                    $.messager.alert("系统提示","数据删除失败，请联系系统管理员！");                }            },"json");        }      }); }</script><title>Insert title here</title></head><body style="margin: 1px"> <table id="dg" title="用户管理" class="easyui-datagrid"   fitColumns="true" pagination="true" rownumbers="true"   url="${pageContext.request.contextPath}/user/list.do" fit="true" toolbar="#tb">   <thead>    <tr>        <th field="cb" checkbox="true" align="center"></th>        <th field="id" width="50" align="center">编号</th>        <th field="userName" width="50" align="center">用户名</th>        <th field="password" width="50" align="center">密码</th>        <th field="trueName" width="50" align="center">真实姓名</th>        <th field="email" width="50" align="center">邮件</th>        <th field="phone" width="50" align="center">联系电话</th>        <th field="roleName" width="50" align="center">角色</th>    </tr>   </thead> </table> <div id="tb">    <div>        <a href="javascript:openUserAddDialog()" class="easyui-linkbutton" iconCls="icon-add" plain="true">添加</a>        <a href="javascript:openUserModifyDialog()" class="easyui-linkbutton" iconCls="icon-edit" plain="true">修改</a>        <a href="javascript:deleteUser()" class="easyui-linkbutton" iconCls="icon-remove" plain="true">删除</a>    </div>    <div>        &nbsp;用户名：&nbsp;<input type="text" id="s_userName" size="20" onkeydown="if(event.keyCode==13) searchUser()"/>        <a href="javascript:searchUser()" class="easyui-linkbutton" iconCls="icon-search" plain="true">搜索</a>    </div> </div> <div id="dlg" class="easyui-dialog" style="width:620px;height:250px;padding: 10px 20px"   closed="true" buttons="#dlg-buttons">   <form id="fm" method="post">    <table cellspacing="8px">        <tr>            <td>用户名：</td>            <td><input type="text" id="userName" name="userName" class="easyui-validatebox" required="true"/>&nbsp;<font color="red">*</font></td>            <td>&nbsp;&nbsp;&nbsp;&nbsp;</td>            <td>密码</td>            <td><input type="text" id="password" name="password" class="easyui-validatebox" required="true"/>&nbsp;<font color="red">*</font></td>        </tr>        <tr>            <td>真实姓名：</td>            <td><input type="text" id="trueName" name="trueName" class="easyui-validatebox" required="true"/>&nbsp;<font color="red">*</font></td>            <td>&nbsp;&nbsp;&nbsp;&nbsp;</td>            <td>邮箱：</td>            <td><input type="text" id="email" name="email" class="easyui-validatebox" validType="email" required="true"/>&nbsp;<font color="red">*</font></td>        </tr>        <tr>            <td>联系电话：</td>            <td><input type="text" id="phone" name="phone" class="easyui-validatebox" required="true"/>&nbsp;<font color="red">*</font></td>            <td>&nbsp;&nbsp;&nbsp;&nbsp;</td>            <td>用户角色</td>            <td>                <select class="easyui-combobox" id="roleName" name="roleName" style="width: 154px" editable="false" panelHeight="auto">                    <option value="">请选择角色...</option>                    <option value="系统管理员">系统管理员</option>                    <option value="销售主管">销售主管</option>                    <option value="客户经理">客户经理</option>                    <option value="高管">高管</option>                </select>                &nbsp;<font color="red">*</font>            </td>        </tr>    </table>   </form> </div> <div id="dlg-buttons">    <a href="javascript:saveUser()" class="easyui-linkbutton" iconCls="icon-ok">保存</a>    <a href="javascript:closeUserDialog()" class="easyui-linkbutton" iconCls="icon-cancel">关闭</a> </div></body></html>