客户关系管理增删改

servlet：

package cn.itcast.cstm.web.servlet;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import cn.itcast.commons.CommonUtils;
import cn.itcast.cstm.domain.Customer;
import cn.itcast.cstm.service.CustomerService;
import cn.itcast.servlet.BaseServlet;

/**
 * Web层
 * @author cxf
 *
 */
public class CustomerServlet extends BaseServlet {
    private CustomerService customerService = new CustomerService();
    
    /**
     * 添加客户
     */
    public String add(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        /*
         * 1. 封装表单数据到Customer对象
         * 2. 补全：cid，使用uuid
         * 3. 使用service方法完成添加工作
         * 4. 向request域中保存成功信息
         * 5. 转发到msg.jsp
         */
        Customer c = CommonUtils.toBean(request.getParameterMap(), Customer.class);
        c.setCid(CommonUtils.uuid());
        customerService.add(c);
        request.setAttribute("msg", "恭喜，添加客户成功！");
        return "f:/msg.jsp";
    }
    
    /**
     * 查询所有
     * @param request
     * @param response
     * @return
     * @throws ServletException
     * @throws IOException
     */
    public String findAll(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        /*
         * 1. 调用service得到所有客户
         * 2. 保存到request域
         * 3. 转发到list.jsp
         */
        request.setAttribute("cstmList", customerService.findAll());
        return "f:/list.jsp";
    }
    
    /**
     * 编辑之前的加载工作
     * @param request
     * @param response
     * @return
     * @throws ServletException
     * @throws IOException
     */
    public String preEdit(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        /*
         * 1. 获取cid
         * 2. 使用cid来调用service方法，得到Customer对象
         * 3. 把Customer保存到request域中
         * 4. 转发到edit.jsp显示在表单中
         */
        String cid = request.getParameter("cid");
        Customer cstm = customerService.load(cid);
        request.setAttribute("cstm", cstm);
        return "f:/edit.jsp";
    }
    
    /**
     * 编辑方法
     * @param request
     * @param response
     * @return
     * @throws ServletException
     * @throws IOException
     */
    public String edit(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        /*
         * 1. 封装表单数据到Customer对象中
         * 2. 调用service方法完成修改
         * 3. 保存成功信息到request域
         * 4. 转发到msg.jsp显示成功信息
         */
        // 已经封装了cid到Customer对象中
        Customer c = CommonUtils.toBean(request.getParameterMap(), Customer.class);
        customerService.edit(c);
        request.setAttribute("msg", "恭喜，编辑客户成功！");
        return "f:/msg.jsp";
    }
    
    public String query(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        /*
         * 1. 封装表单数据到Customer对象中，它只有四个属性（cname、gender、cellphone、email）
         *   它就是一个条件
         * 2. 使用Customer调用service方法，得到List<Customer>
         * 3. 保存到request域中
         * 4. 转发到list.jsp
         */
        Customer criteria = CommonUtils.toBean(request.getParameterMap(), Customer.class);
        List<Customer> cstmList = customerService.query(criteria);
        request.setAttribute("cstmList", cstmList);
        return "/list.jsp";
    }
}

DAO:

DAO:

package cn.itcast.cstm.dao;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import cn.itcast.cstm.domain.Customer;
import cn.itcast.jdbc.TxQueryRunner;

/**
 * 持久层
 * 
 * @author cxf
 * 
 */
public class CustomerDao {
    private QueryRunner qr = new TxQueryRunner();

    /**
     * 添加客户
     * 
     * @param c
     */
    public void add(Customer c) {
        try {
            String sql = "insert into t_customer values(?,?,?,?,?,?,?)";
            Object[] params = { c.getCid(), c.getCname(), c.getGender(),
                    c.getBirthday(), c.getCellphone(), c.getEmail(),
                    c.getDescription()};
            qr.update(sql, params);
        } catch(SQLException e) {
            throw new RuntimeException(e);
        }
    }
    
    /**
     * 查询所有
     * @return
     */
    public List<Customer> findAll() {
        try {
            String sql = "select * from t_customer";
            return qr.query(sql, new BeanListHandler<Customer>(Customer.class));
        } catch(SQLException e) {
            throw new RuntimeException(e);
        }
    }

    /**
     * 加载客户
     * @param cid
     * @return
     */
    public Customer load(String cid) {
        try {
            String sql = "select * from t_customer where cid=?";
            return qr.query(sql, new BeanHandler<Customer>(Customer.class), cid);
        } catch(SQLException e) {
            throw new RuntimeException(e);
        }
    }

    /**
     * 编辑客户
     * @param c
     */
    public void edit(Customer c) {
        try {
            String sql = "update t_customer set cname=?,gender=?,birthday=?," +
                    "cellphone=?,email=?,description=? where cid=?";
            Object[] params = {c.getCname(), c.getGender(),
                    c.getBirthday(), c.getCellphone(), c.getEmail(),
                    c.getDescription(), c.getCid()};
            qr.update(sql, params);
        } catch(SQLException e) {
            throw new RuntimeException(e);
        }
    }

    /**
     * 多条件组合查询
     * @param criteria
     * @return
     */
    public List<Customer> query(Customer criteria) {
        try {
            /*
             * 1. 给出sql模板
             * 2. 给出参数
             * 3. 调用query方法，使用结果集处理器：BeanListHandler
             */
            /*
             * 一、　给出sql模板
             * 二、　给出参数！
             */
            /*
             * 1. 给出一个sql语句前半部
             */
            StringBuilder sql = new StringBuilder("select * from t_customer where 1=1");
            /*
             * 2. 判断条件，完成向sql中追加where子句
             */
            /*
             * 3. 创建一个ArrayList，用来装载参数值
             */
            List<Object> params = new ArrayList<Object>();
            String cname = criteria.getCname();
            if(cname != null && !cname.trim().isEmpty()) {
                sql.append(" and cname like ?");
                params.add("%" + cname + "%");
            }
            
            String gender = criteria.getGender();
            if(gender != null && !gender.trim().isEmpty()) {
                sql.append(" and gender=?");
                params.add(gender);
            }
            
            String cellphone = criteria.getCellphone();
            if(cellphone != null && !cellphone.trim().isEmpty()) {
                sql.append(" and cellphone like ?");
                params.add("%" + cellphone + "%");
            }
            
            String email = criteria.getEmail();
            if(email != null && !email.trim().isEmpty()) {
                sql.append(" and email like ?");
                params.add("%" + email + "%");
            }
            
            /*
             * 三、执行query
             */
            return qr.query(sql.toString(), 
                    new BeanListHandler<Customer>(Customer.class), 
                    params.toArray());
        } catch(SQLException e) {
            throw new RuntimeException(e);
        }
    }
}

jsp：添加：

<form action="<c:url value='/CustomerServlet'/>" method="post">

<input type="hidden" name="method" value="add"/>

编辑：

注意要把cid传过去：

<%--
要调用CustomerServlet#edit
要传递cid
 --%>
<form action="<c:url value='/CustomerServlet'/>" method="post">
    <input type="hidden" name="method" value="edit"/>
    <input type="hidden" name="cid" value="${cstm.cid }"/>

list.jsp

<c:forEach items="${requestScope.cstmList}" var="cstm">
    <tr>
        <td>${cstm.cname }</td>
        <td>${cstm.gender }</td>
        <td>${cstm.birthday }</td>
        <td>${cstm.cellphone }</td>
        <td>${cstm.email }</td>
        <td>${cstm.description }</td>
        <td>
            <a href="<c:url value='/CustomerServlet?method=preEdit&cid=${cstm.cid }'/>">编辑</a>
            <a href="<c:url value='/msg.jsp'/>">删除</a>
        </td>
    </tr>
</c:forEach>

msg.jsp

  <h1 style="color:green;" align="center">${msg }</h1>

query.jsp

<h3 align="center">高级搜索</h3>
<form action="<c:url value='/CustomerServlet'/>" method="post">
    <input type="hidden" name="method" value="query"/>

top.jsp

<body style="text-align: center;">
      <h1>客户关系管理系统</h1>
    <a href="<c:url value='/add.jsp'/>">添加客户</a> 　|　
    <a href="<c:url value='/CustomerServlet?method=findAll'/>">查询客户</a>　|　
    <a href="<c:url value='/query.jsp'/>">高级搜索</a>　　
  </body>