第19讲.综合案例

作者: 祥祺 | 来源:发表于2020-02-18 15:04 被阅读0次

第19讲.综合案例
2018-04-22
时间管理100讲之第39讲：（案例）从体育差等生到跑马拉松
19.综合案例3
D20读书笔记～关键对话第10、11章
第19讲
[读书笔记] 硅谷产品实战36讲（1）权衡取舍
15-HTTPDNS：网络世界的地址簿
【啃书系列19】漫谈日记、游记和随笔
综合案例

项目准备

前台CRUD
前台高级查询和分页
创建系统默认账户：Listener
用户登录：session
用户注销：session
登录检查：Filter
验证码：session
记住我：Cookie
添加商品图片：文件上传

完整代码如下：

dao

IEmployeeDAO:

package cn.wolfcode.crud.dao;

import cn.wolfcode.crud.domain.Employee;

public interface IEmployeeDAO {
    /**
     * 增加操作
     * 
     * @param employee
     *            对象
     */
    void insert(Employee employee);

    /**
     * 查询单条信息
     * 
     * @param name
     *            行数
     * @return 对象
     */
    Employee selectByName(String name);

    /**
     * 验证用户名和密码
     * 
     * @param employee1
     * @return
     */
    Employee selectByNameAndPwd(Employee employee1);

}

IProductDAO:

package cn.wolfcode.crud.dao;

import java.util.List;

import cn.wolfcode.crud.domain.Product;
import cn.wolfcode.crud.query.QueryObject;

public interface IProductDAO {
    /**
     * 增加操作
     * 
     * @param product
     *            对象
     */
    void insert(Product product);

    /**
     * 删除操作
     * 
     * @param id
     *            行数
     */
    void delete(Long id);

    /**
     * 更新操作
     * 
     * @param product
     *            对象
     */
    void update(Product product);

    /**
     * 查询单条信息
     * 
     * @param id
     *            行数
     * @return 对象
     */
    Product get(Long id);

    /**
     * 查询全部信息
     * 
     * @return list集合中
     */
    List<Product> getList();

    /**
     * 根据条件获取总条数
     * 
     * @param qo
     * @return
     */
    int queryForTotalCount(QueryObject qo);

    /**
     * 根据条件获取数据
     * 
     * @param qo
     * @return
     */
    List<Product> queryForListData(QueryObject qo);
}

dao.impl

EmployeeDAOImpl:

package cn.wolfcode.crud.dao.impl;

import org.apache.ibatis.session.SqlSession;

import cn.wolfcode.crud.dao.IEmployeeDAO;
import cn.wolfcode.crud.domain.Employee;
import cn.wolfcode.crud.util.MybatisUtil;

public class EmployeeDAOImpl implements IEmployeeDAO {

    @Override
    public void insert(Employee employee) {
        SqlSession session = MybatisUtil.getSession();
        session.insert("cn.wolfcode.crud.mapper.EmployeeMapper.insert", employee);
        session.close();
    }

    @Override
    public Employee selectByName(String name) {
        SqlSession session = MybatisUtil.getSession();
        Employee employee = session.selectOne("cn.wolfcode.crud.mapper.EmployeeMapper.selectByName", name);
        session.close();
        return employee;
    }

    @Override
    public Employee selectByNameAndPwd(Employee employee1) {
        SqlSession session = MybatisUtil.getSession();
        Employee employee = session.selectOne("cn.wolfcode.crud.mapper.EmployeeMapper.selectByNameAndPwd", employee1);
        session.close();
        return employee;
    }

}

ProductDAOImpl:

package cn.wolfcode.crud.dao.impl;

import java.util.List;

import org.apache.ibatis.session.SqlSession;

import cn.wolfcode.crud.dao.IProductDAO;
import cn.wolfcode.crud.domain.Product;
import cn.wolfcode.crud.query.QueryObject;
import cn.wolfcode.crud.util.MybatisUtil;

public class ProductDAOImpl implements IProductDAO {
    @Override
    public void insert(Product product) {
        SqlSession session = MybatisUtil.getSession();
        session.insert("cn.wolfcode.crud.mapper.ProductMapper.insert", product);
        session.close();
    }

    @Override
    public void delete(Long id) {
        SqlSession session = MybatisUtil.getSession();
        session.delete("cn.wolfcode.crud.mapper.ProductMapper.delete", id);
        session.close();
    }

    @Override
    public void update(Product product) {
        SqlSession session = MybatisUtil.getSession();
        session.update("cn.wolfcode.crud.mapper.ProductMapper.update", product);
        session.close();
    }

    @Override
    public Product get(Long id) {
        SqlSession session = MybatisUtil.getSession();
        Product p = session.selectOne("cn.wolfcode.crud.mapper.ProductMapper.get", id);
        session.close();
        return p;
    }

    @Override
    public List<Product> getList() {
        SqlSession session = MybatisUtil.getSession();
        List<Product> list = session.selectList("cn.wolfcode.crud.mapper.ProductMapper.getList");
        session.close();
        return list;
    }

    @Override
    public int queryForTotalCount(QueryObject qo) {
        SqlSession session = MybatisUtil.getSession();
        int count = session.selectOne("cn.wolfcode.crud.mapper.ProductMapper.queryForTotalCount", qo);
        session.close();
        return count;
    }

    @Override
    public List<Product> queryForListData(QueryObject qo) {
        SqlSession session = MybatisUtil.getSession();
        List<Product> list = session.selectList("cn.wolfcode.crud.mapper.ProductMapper.queryForListData", qo);
        session.close();
        return list;
    }

}

domain

Product:

package cn.wolfcode.crud.domain;

import lombok.Getter;
import lombok.Setter;
import lombok.ToString;

@Getter@Setter@ToString
public class Product {
    private Long id;
    private String productName;
    private Long dirId;
    private Double salePrice;
    private String supplier;
    private String brand;
    private Double cutoff;
    private Double costPrice;
    private String imagePath;// 商品图片的路径
    //增加属性 商品分类的名称
    public String getDirName() {
        if (dirId == 1) {
            return "鼠标";
        } else if (dirId == 2) {
            return "无线鼠标";
        } else if (dirId == 3) {
            return "有线鼠标";
        } else {
            return "游戏鼠标";
        }
    }
}

Employee:

package cn.wolfcode.crud.domain;

import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;
import lombok.ToString;

@Getter
@Setter
@NoArgsConstructor
@ToString
public class Employee {
    private Long id;
    private String name;
    private String password;
    private String email;
    private boolean admin;
}

mapper

ProductMapper.xml:

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.wolfcode.crud.mapper.ProductMapper">
    <insert id="insert">
        insert into
        product(productName,dir_id,salePrice,supplier,
        brand,cutoff,costPrice,imagePath)
        values(#{productName},#{dirId},#{salePrice},#{supplier},#{brand},
        #{cutoff},#{costPrice},#{imagePath})
    </insert>
    <delete id="delete">
        delete from product where id=#{id}
    </delete>
    <update id="update">
        update product set
        productName=#{productName},dir_id=#{dirId},
        salePrice=#{salePrice},imagePath=#{imagePath} 
        ,supplier=#{supplier},brand=#{brand},cutoff=#{cutoff},
        costPrice=#{costPrice}
        where id=#{id}
    </update>
    <resultMap type="product" id="map">
        <id column="id" property="id" />
        <result column="productName" property="productName" />
        <result column="dir_id" property="dirId" />
        <result column="salePrice" property="salePrice" />
        <result column="supplier" property="supplier" />
        <result column="brand" property="brand" />
        <result column="cutoff" property="cutoff" />
        <result column="costPrice" property="costPrice" />
        <result column="imagePath" property="imagePath" />
    </resultMap>
    <select id="get" resultMap="map">
        select * from product where id=#{id}
    </select>
    <select id="getList" resultMap="map">
        select * from product
    </select>

    <select id="queryForTotalCount" resultType="int">
        select count(*) from product
       <include refid="condition"/>
    </select>

    <sql id="condition">
        <where>
            <if test="keyword != null and keyword != '' ">
                and (productName like concat('%',#{keyword},'%') or 
                brand like concat('%',#{keyword},'%'))
            </if>
            <if test="minPrice != null">
                and salePrice &gt;= #{minPrice}
            </if>
            <if test="maxPrice != null">
                and salePrice &lt;=#{maxPrice}
            </if>
        </where>
    </sql>

    <select id="queryForListData" resultMap="map">
        select * from product
         <include refid="condition"/>
         limit #{startIndex},#{pageSize}
    </select>
</mapper>

EmployeeMapper.xml:

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.wolfcode.crud.mapper.EmployeeMapper">
    <insert id="insert">
        insert into
        employee(name,password,email,admin)
        values(#{name},#{password},#{email},#{admin})
    </insert>
     
     <select id="selectByName" resultType="employee">
        select * from employee where name = #{name}
     </select>
     
     <select id="selectByNameAndPwd" resultType="employee">
      select * from employee where name = #{name} and password= #{password}
     </select> 
</mapper>

query

PageResult:

package cn.wolfcode.crud.query;

import java.util.Collections;
import java.util.List;

import lombok.Getter;

@Getter
public class PageResult {
    private int currentPage; // 当前页
    private int pageSize; // 每页数量
    private int prevPage; // 上一页
    private int nextPage; // 下一页
    private int endPage; // 末页
    private int totalCount; // 总条数
    private List<?> data; // 当前页的数据

    public PageResult(int pageSize) {
        this(1, pageSize, 0, Collections.EMPTY_LIST);
    }

    public PageResult(int currentPage, int pageSize, int totalCount, List<?> data) {
        this.currentPage = currentPage;
        this.pageSize = pageSize;
        this.data = data;
        this.totalCount = totalCount;
        // 表示总共一页
        if (totalCount < pageSize) {
            endPage = 1;
            prevPage = 1;
            nextPage = 1;
            return;
        }
        endPage = totalCount % pageSize == 0 ? totalCount / pageSize : totalCount / pageSize + 1;
        prevPage = currentPage - 1 >= 1 ? currentPage - 1 : 1;
        nextPage = currentPage + 1 < endPage ? currentPage + 1 : endPage;
    }
}

ProductQueryObject:

package cn.wolfcode.crud.query;

import lombok.Getter;
import lombok.Setter;

@Getter
@Setter
public class ProductQueryObject extends QueryObject {
    private String keyword; // 关键字
    private Double minPrice;// 最低价
    private Double maxPrice;// 最高价
}

QueryObject:

package cn.wolfcode.crud.query;

import lombok.Getter;
import lombok.Setter;

@Getter
@Setter
public class QueryObject {
    private int currentPage = 1; // 当前页
    private int pageSize = 5; // 每页显示的数量

    public int getStartIndex() {
        return (currentPage - 1) * pageSize;
    }

}

service

IProductService:

package cn.wolfcode.crud.service;

import java.util.List;

import cn.wolfcode.crud.domain.Product;

public interface IProductService {
    void insertService(Product product);

    void deleteService(Long id);

    void updateService(Product product);

    Product getService(Long id);

    List<Product> getListService();
}

IEmployeeService:

package cn.wolfcode.crud.service;

import cn.wolfcode.crud.domain.Employee;

public interface IEmployeeService {
    void insertEmployee(Employee employee);

    Employee selectEmployeeByName(String name);

    Employee selectEmpByNameAndPwd(Employee employee);

}

service.impl

ProductServiceImpl:

package cn.wolfcode.crud.service.impl;

import java.util.List;

import cn.wolfcode.crud.dao.IProductDAO;
import cn.wolfcode.crud.dao.impl.ProductDAOImpl;
import cn.wolfcode.crud.domain.Product;
import cn.wolfcode.crud.query.PageResult;
import cn.wolfcode.crud.query.QueryObject;
import cn.wolfcode.crud.service.IProductService;

public class ProductServiceImpl implements IProductService {

    IProductDAO dao = new ProductDAOImpl();

    @Override
    public void insertService(Product product) {
        dao.insert(product);
    }

    @Override
    public void deleteService(Long id) {
        dao.delete(id);
    }

    @Override
    public void updateService(Product product) {
        dao.update(product);
    }

    @Override
    public Product getService(Long id) {
        Product product = dao.get(id);
        return product;
    }

    @Override
    public List<Product> getListService() {
        List<Product> list = dao.getList();
        return list;
    }

    public PageResult query(QueryObject qo) {
        int totalCount = dao.queryForTotalCount(qo);
        if (totalCount == 0) {
            return new PageResult(qo.getPageSize());
        }
        List<Product> products = dao.queryForListData(qo);
        return new PageResult(qo.getCurrentPage(), qo.getPageSize(), totalCount, products);
    }

}

EmployeeServiceImpl:

package cn.wolfcode.crud.service.impl;

import cn.wolfcode.crud.dao.IEmployeeDAO;
import cn.wolfcode.crud.dao.impl.EmployeeDAOImpl;
import cn.wolfcode.crud.domain.Employee;
import cn.wolfcode.crud.service.IEmployeeService;

public class EmployeeServiceImpl implements IEmployeeService {

    IEmployeeDAO dao = new EmployeeDAOImpl();

    @Override
    public void insertEmployee(Employee employee) {
        dao.insert(employee);
    }

    @Override
    public Employee selectEmployeeByName(String name) {
        Employee employee = dao.selectByName(name);
        return employee;
    }

    @Override
    public Employee selectEmpByNameAndPwd(Employee employee1) {
        Employee employee = dao.selectByNameAndPwd(employee1);
        return employee;
    }

}

test

ProductServiceTest:

package cn.wolfcode.crud.test;

import java.util.List;

import org.junit.Test;

import cn.wolfcode.crud.domain.Product;
import cn.wolfcode.crud.service.IProductService;
import cn.wolfcode.crud.service.impl.ProductServiceImpl;

public class ProductServiceTest {
    IProductService dao = new ProductServiceImpl();
    @Test
    public void testInsertService() {
        Product p = new Product();
        p.setProductName("苹果");
        p.setDirId(2L);
        p.setSalePrice(Double.valueOf(121));
        p.setSupplier("苹果");
        p.setBrand("苹果");
        p.setCutoff(Double.valueOf(0.9));
        p.setCostPrice(Double.valueOf(3434));
        dao.insertService(p);
    }

    @Test
    public void testDeleteService() {
        dao.deleteService(23L);
    }

    @Test
    public void testUpdateService() {
        Product p = new Product();
        p.setProductName("苹果aaaa");
        p.setDirId(2L);
        p.setSalePrice(Double.valueOf(121));
        p.setSupplier("苹果sdfg");
        p.setBrand("苹果sdf");
        p.setCutoff(Double.valueOf(0.9));
        p.setCostPrice(Double.valueOf(3434));
        p.setId(23L);
        dao.updateService(p);
    }

    @Test
    public void testGetService() {
        Product p = dao.getService(9L);
        System.out.println(p);
    }

    @Test
    public void testGetListService() {
        List<Product> list = dao.getListService();
        for (Product p : list) {
            System.out.println(p);
        }
    }

}

util

MybatisUtil:

package cn.wolfcode.crud.util;

import java.io.IOException;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class MybatisUtil {
    private static SqlSessionFactory factory;

    private MybatisUtil() {
    }
    static {
        try {
            factory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsStream("mybatis-config.xml"));
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    public static SqlSession getSession() {
        return factory.openSession(true);
    }
}

StringUtil:

package cn.wolfcode.crud.util;

public final class StringUtil {
    //判断字符串
    public static  boolean hasLength(String str) {
        return str != null && str.trim().length() != 0;
    }
}

UploadUtil:

package cn.wolfcode.crud.util;

import java.io.File;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.UUID;

import javax.servlet.http.HttpServletRequest;

import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.FileItemFactory;
import org.apache.commons.fileupload.FileUploadBase.FileSizeLimitExceededException;
import org.apache.commons.fileupload.FileUploadBase.SizeLimitExceededException;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;

public final class UploadUtil {

    // 用来处理上传功能
    public static Map<String, String> upload(HttpServletRequest req) {
        // 定义Map集合
        Map<String, String> map = new HashMap<>();

        // 用来判断request是否符合文件上传的请求
        boolean isMultipart = ServletFileUpload.isMultipartContent(req);
        // isMultipart 如果为true 表示请求是文件上传
        if (isMultipart) {
            try {
                // 创建一个磁盘工厂对象
                FileItemFactory factory = new DiskFileItemFactory();
                // 创建文件上传处理器
                ServletFileUpload upload = new ServletFileUpload(factory);
                // 设置上传文件大小的限制了
                // 限制上传单个文件的大小
                upload.setFileSizeMax(1024 * 1024 * 4);
                // 解析请求
                @SuppressWarnings("unchecked")
                List<FileItem> items = upload.parseRequest(req);

                for (FileItem fileItem : items) {
                    // 通过调用isFormField 来判断是否是普通字段
                    if (fileItem.isFormField()) {
                        // 获取普通字段的名称
                        String name = fileItem.getFieldName();
                        // 获取普通字段的内容
                        // 解决中文乱码的问题 通过调用getString(String encoding)方法 来解决
                        String value = fileItem.getString("utf-8");
                        map.put(name, value);
                    } else {
                        // 获取上传文件的名称
                        String fileName = fileItem.getName();
                        System.out.println(fileName);
                        // 把上传的文件写入指定的路径
                        if (fileName != null && fileName.trim().length() != 0) {
                            // fileItem.write(new File("F:/", fileName));
                            // 获取upload文件夹的真实路径
                            String realPath = req.getServletContext().getRealPath("/upload");
                            // 修改上传文件的名称 chengxuyuan.png
                            // 使用UUID 产生随机字符串
                            String randomStr = UUID.randomUUID().toString();
                            // 获取文件的后缀
                            String extName = fileName.substring(fileName.lastIndexOf("."));
                            // 拼接 文件的名称
                            String newFileName = randomStr + extName;
                            // 上传文件的类型约束
                            String contentType = fileItem.getContentType();
                            if (contentType.startsWith("image/")) {
                                File file = new File(realPath, newFileName);
                                map.put("imagePath", "/upload/" + newFileName);
                                fileItem.write(file);
                            } else {
                                System.out.println("文件类型不符合");
                            }

                        }
                    }
                }

            } catch (FileSizeLimitExceededException e) {
                System.out.println("单个文件上传过大");
            } catch (SizeLimitExceededException e) {
                System.out.println("所有文件的大小总和上传过大");
            } catch (Exception e) {
                e.printStackTrace();
            }
        }

        return map;
    }

}

web

web.servlet

LoginServlet:

package cn.wolfcode.crud.web.servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import cn.wolfcode.crud.domain.Employee;
import cn.wolfcode.crud.service.IEmployeeService;
import cn.wolfcode.crud.service.impl.EmployeeServiceImpl;
import cn.wolfcode.crud.util.StringUtil;

@WebServlet("/login")
public class LoginServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
    private IEmployeeService service = new EmployeeServiceImpl();

    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        // 设值编码格式
        req.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=UTF-8");
        // 获取表单提交的登录信息
        String name = req.getParameter("name");
        String pwd = req.getParameter("password");
        String rememberMe = req.getParameter("rememberMe");

        if (StringUtil.hasLength(rememberMe)) {
            // 如果勾选了记住账号按钮,则我们把账号存放到cookie中
            // 保存账号信息到Cookie中
            Cookie cookie = new Cookie("name", name);
            Cookie checkBoxStatus = new Cookie("rememberMe", "on");
            resp.addCookie(cookie);
            resp.addCookie(checkBoxStatus);
        } else {
            // 如果没有勾选记住账号按钮,则我们把之前存在cookie中的账号信息清除
            Cookie cookie = new Cookie("name", "");
            resp.addCookie(cookie);
            Cookie checkBoxStatus = new Cookie("rememberMe", null);
            resp.addCookie(checkBoxStatus);
        }

        // 验证验证码的正确性
        // 获取表单提交过来的验证码
        String randomCode = req.getParameter("randomCode");
        // 获取session中保存的验证码
        String sessionCode = (String) req.getSession().getAttribute("RANDOMCODE_IN_SESSION");
        if (!StringUtil.hasLength(randomCode) || !StringUtil.hasLength(sessionCode)) {
            // 表示两个验证码其中有一个是缺失的
            req.setAttribute("errorMsg", "验证码不能为空");
            req.getRequestDispatcher("/login.jsp").forward(req, resp);
            return;
        }

        if (!randomCode.equals(sessionCode)) {
            req.setAttribute("errorMsg", "验证码错误");
            req.getRequestDispatcher("/login.jsp").forward(req, resp);
            return;
        }
        // 封装信息
        Employee employee = new Employee();
        employee.setName(name);
        employee.setPassword(pwd);

        Employee employeeResult = service.selectEmpByNameAndPwd(employee);
        // 如果查询到了用户信息 把信息存入session中
        if (employeeResult != null) {
            req.getSession().setAttribute("EMP_IN_SESSION", employeeResult);
            resp.sendRedirect("/product");
            return;
        }

        if (employeeResult == null) {
            req.setAttribute("errorMsg", "账号或者密码错误");
            req.getRequestDispatcher("/login.jsp").forward(req, resp);
            return;
        }

    }

}

LogoutServlet:

package cn.wolfcode.crud.web.servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@WebServlet("/logout")
public class LogoutServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;

    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        // 请求用户信息从session中
        // 方式一: remove 掉指定的session
        req.getSession().removeAttribute("EMP_IN_SESSION");
        // 方式二: 通过销毁session
        // req.getSession().invalidate();
        // 重定向到登录
        resp.sendRedirect("/login.jsp");
    }

}

ProductServlet:

package cn.wolfcode.crud.web.servlet;

import java.io.IOException;
import java.lang.reflect.InvocationTargetException;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.beanutils.BeanUtils;

import cn.wolfcode.crud.domain.Product;
import cn.wolfcode.crud.query.PageResult;
import cn.wolfcode.crud.query.ProductQueryObject;
import cn.wolfcode.crud.service.impl.ProductServiceImpl;
import cn.wolfcode.crud.util.StringUtil;
import cn.wolfcode.crud.util.UploadUtil;

@WebServlet("/product")
public class ProductServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;

    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        // 设值编码格式
        req.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=UTF-8");
        // 获取参数,根据参数判断出要执行那一个方法
        String cmd = req.getParameter("cmd");
        if (cmd == null) {
            cmd = "";
        }
        switch (cmd) {
        case "input":
            inputService(req, resp);

            break;
        case "delete":
            deleteService(req, resp);

            break;
        case "saveOrUpdate":
            saveService(req, resp);

            break;

        default:
            listService(req, resp);
            break;
        }
    }

    // 创建一个业务层的对象来调用操作数据库
    private ProductServiceImpl service = new ProductServiceImpl();

    private void listService(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        // 获取高级查询的条件
        String keyword = req.getParameter("keyword");
        String minPrice = req.getParameter("minPrice");
        String maxPrice = req.getParameter("maxPrice");
        String currentPage = req.getParameter("currentPage");
        ProductQueryObject qo = new ProductQueryObject();
        if (StringUtil.hasLength(minPrice)) {
            qo.setMinPrice(Double.valueOf(minPrice));
        }
        if (StringUtil.hasLength(maxPrice)) {
            qo.setMaxPrice(Double.valueOf(maxPrice));
        }
        if (StringUtil.hasLength(currentPage)) {
            qo.setCurrentPage(Integer.valueOf(currentPage));
        }
        qo.setKeyword(keyword);
        // 在页面上回显查询条件
        req.setAttribute("qo", qo);
        PageResult result = service.query(qo);
        req.setAttribute("result", result);
        req.getRequestDispatcher("/WEB-INF/views/product/list.jsp").forward(req, resp);
    }

    @Deprecated
    private void listService_bak(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {
        List<Product> list = service.getListService();
        req.setAttribute("list", list);
        req.getRequestDispatcher("/WEB-INF/views/product/list.jsp").forward(req, resp);
    }

    private void saveService(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        Map<String, String> map = UploadUtil.upload(req);
        Product product = new Product();
        try {
            BeanUtils.copyProperties(product, map);
            // 根据ID判断是添加还是更新数据然后调用业务层方法
            if (product.getId() != 0) {
                service.updateService(product);
            } else {
                // 新增操作不用ID
                service.insertService(product);
            }
            resp.sendRedirect("/product");

        } catch (IllegalAccessException e) {
            e.printStackTrace();
        } catch (InvocationTargetException e) {
            e.printStackTrace();
        }

    }

    private void deleteService(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        String id = req.getParameter("id");
        if (StringUtil.hasLength(id)) {
            service.deleteService(Long.valueOf(id));
        }
        resp.sendRedirect("/product");
    }

    private void inputService(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        // 获取ID判断
        String id = req.getParameter("id");
        if (id != null) {
            // 有ID证明是更新操作.此时我们要获取数据并回响数据给到界面给用户修改
            Product p = service.getService(Long.valueOf(id));
            // 把数据信息共享到作用域
            req.setAttribute("p", p);
        }
        // 请求转发到input.jsp
        req.getRequestDispatcher("/WEB-INF/views/product/input.jsp").forward(req, resp);
    }

}

web.listener

SystemAdminListener:

package cn.wolfcode.crud.web.listener;

import javax.servlet.ServletContextEvent;
import javax.servlet.ServletContextListener;

import cn.wolfcode.crud.domain.Employee;
import cn.wolfcode.crud.service.IEmployeeService;
import cn.wolfcode.crud.service.impl.EmployeeServiceImpl;

public class SystemAdminListener implements ServletContextListener {
    IEmployeeService service = new EmployeeServiceImpl();

    @Override
    public void contextInitialized(ServletContextEvent event) {
        // 先查询数据库中是否已经存在了管理员账号
        String name = "admin";
        String password = "123456";
        Employee employee = service.selectEmployeeByName(name);
        // 存在
        // 不存在
        if (employee == null) {
            // 新增一个管理员信息到数据库
            Employee employee2 = new Employee();
            employee2.setName(name);
            employee2.setPassword(password);
            employee2.setAdmin(true);
            employee2.setEmail("admin@wolfcode.cn");
            service.insertEmployee(employee2);
        }
    }

    @Override
    public void contextDestroyed(ServletContextEvent arg0) {
    }

}

RandomCodeServlet:

package cn.wolfcode.crud.web.servlet;

import java.awt.Color;
import java.awt.Font;
import java.awt.Graphics;
import java.awt.image.BufferedImage;
import java.io.IOException;
import java.util.Random;
import java.util.UUID;

import javax.imageio.ImageIO;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@WebServlet("/randomCode")
public class RandomCodeServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;

    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        // 生成随机数
        String randomCode = UUID.randomUUID().toString().substring(0, 5);

        // 把随机数放进Session中
        req.getSession().setAttribute("RANDOMCODE_IN_SESSION", randomCode);

        // 创建图片对象
        int width = 80;
        int height = 30;
        int imageType = BufferedImage.TYPE_INT_RGB;
        BufferedImage image = new BufferedImage(width, height, imageType);

        // 画板
        Graphics g = image.getGraphics();
        g.setColor(Color.WHITE);
        // 绘制一个实心的矩形
        g.fillRect(1, 1, width - 2, height - 2);

        // 把随机数画进图片中
        g.setColor(Color.BLACK);// 设置随机数的颜色
        Font font = new Font("宋体", Font.BOLD + Font.ITALIC, 20);
        g.setFont(font);// 设置随机数的字体和大小
        g.drawString(randomCode, 10, 24);
        // 干扰线
        g.setColor(Color.GRAY);
        Random r = new Random();
        for (int i = 0; i < 100; i++) {
            g.fillRect(r.nextInt(width), r.nextInt(height), 2, 2);
        }

        // 关闭
        g.dispose();
        // 把图片对象以流的方式保存出去
        ImageIO.write(image, "jpg", resp.getOutputStream());
    }
}

web.filter

CheckLoginFilter:

package cn.wolfcode.crud.web.filter;

import java.io.IOException;

import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class CheckLoginFilter implements Filter {

    private FilterConfig config;

    @Override
    public void destroy() {
    }

    @Override
    public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain)
            throws IOException, ServletException {
        // 强转参数
        HttpServletRequest req = (HttpServletRequest) request;
        HttpServletResponse resp = (HttpServletResponse) response;
        // 获取配置的init-param参数
        String parameter = config.getInitParameter("check");
        String[] checkArray = parameter.split(",");
        for (String check : checkArray) {
            String uri = req.getRequestURI();
            if (uri.contains(check)) {
                // 能进入到if判断体中,表示不能放行
                // 验证用户是否登录
                // 1.从session中获取用户信息
                Object emp = req.getSession().getAttribute("EMP_IN_SESSION");
                // 2.如果没有获取到用户信息
                if (emp == null) {
                    resp.sendRedirect("/login.jsp");
                    return;
                }
            }
        }
        // 放行
        chain.doFilter(request, response);
    }

    @Override
    public void init(FilterConfig config) throws ServletException {
        this.config = config;
    }

}

resources

mybatis-config.xml:

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <properties resource="db.properties"></properties>
    <typeAliases>
        <package name="cn.wolfcode.crud.domain" />
    </typeAliases>
    <environments default="dev">
        <environment id="dev">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="${driverClassName}" />
                <property name="url" value="${url}" />
                <property name="username" value="${username}" />
                <property name="password" value="${password}" />
            </dataSource>
        </environment>
    </environments>
<mappers>
<mapper resource="cn/wolfcode/crud/mapper/ProductMapper.xml"/>
<mapper resource="cn/wolfcode/crud/mapper/EmployeeMapper.xml"/>
</mappers>
</configuration>

webapp

<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<html>
<head>
    <meta charset="UTF-8">
    <title>叩丁狼客户管理系统->用户登录</title>
    <link rel="stylesheet" href="/css/core.css" type="text/css"/>
    <link rel="stylesheet" href="/js/plugins/bootstrap/css/bootstrap.css" type="text/css"/>
    <script src="/js/plugins/jquery/jquery-2.1.4.min.js" type="text/javascript"></script>
    <script src="/js/plugins/bootstrap/js/bootstrap.js" type="text/javascript"></script>
    <style type="text/css">
        body {
            background-color: #FFFFFF;
        }

        .cm-container {
            margin-top: 160px;
        }

        .login {
            width: 360px;
            height: 300px;
            margin: 0px auto;
        }
    </style>

    <script>
        function changeCode() {
            document.getElementById("randomCode").src = "/randomCode;" + new Date().getTime();
        }
    </script>
</head>
<body>
<div class="container cm-container">
    <h3 class="text-center"><font style="color: #337ab7;">叩丁狼客户管理系统(系统管理平台)</font></h3>
    <hr/>

    <div class="login">
        <span style="color: red" class="col-sm-3"></span>
        <span style="color: red" class="col-sm-9">${errorMsg}</span>
        <form class="form-horizontal" action="/login" method="post">
            <div class="form-group">
                <label for="inputEmail3" class="col-sm-3 control-label">用户名</label>
                <div class="col-sm-9">
                    <input type="text" name="name" class="form-control" id="inputEmail3"
                           value="${cookie.name.value}">
                </div>
            </div>
            <div class="form-group">
                <label for="inputPassword3" 
                class="col-sm-3 control-label">密&nbsp;&nbsp;&nbsp;码</label>
                <div class="col-sm-9">
                    <input type="password" name="password" 
                    class="form-control" id="inputPassword3">
                </div>
            </div>
             <div class="form-group">
                <label for="inputPassword3" class="col-sm-3 control-label">验证码</label>
                <div class="col-sm-5">
                    <input name="randomCode" class="form-control">

                </div>
                <div class="col-sm-4">

                    <img src="/randomCode" alt="验证码" id="randomCode" onclick="changeCode();"/>
                </div>
            </div> 
          <div class="form-group">
                <label for="inputPassword3" class="col-sm-3 control-label"></label>
                <div class="col-sm-9">
                    <div class="checkbox">
                        <label>
                            <input type="checkbox" name="rememberMe"
                                ${empty cookie.rememberMe.value?"":"checked='checked'"}> 记住账号
                        </label>
                    </div>
                </div>
            </div>    
            <div class="form-group">
                <label for="inputPassword3" class="col-sm-3 control-label"></label>
                <div class="col-sm-9">
                    <button type="submit" class="btn btn-default">登录</button>
                </div>
            </div>
        </form>
    </div>
</div>

<%--清楚session中的错误信息--%>
<%session.removeAttribute("errorMsg");%>
</body>
</html>

webapp/WEB-INF/views/product

input.jsp:

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>

<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>叩丁狼教育-JavaWEB综合案例</title>
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <%@include file="../common/header.jsp"%>
</head>
<body>

<div class="container " style="margin-top: 20px">
    <%@include file="../common/top.jsp"%>
    <br/>
    <br/>
    <div class="row">
        <div class="col-sm-3">
            <%@include file="../common/menu.jsp"%>
        </div>
        <div class="col-sm-9">
            <div class="row col-sm-10">
                <form class="form-horizontal" action="/product?cmd=saveOrUpdate" method="post" enctype="multipart/form-data" id="editForm">
                    <input type="hidden" value="${p.id}" name="id">
                    <div class="form-group" >
                        <label for="name" class="col-sm-2 control-label">商品名称：</label>
                        <div class="col-sm-6">
                        <input type="text" class="form-control" id="name" name="productName" value="${p.productName}" placeholder="请输入商品的名称">
                        </div>
                    </div>
                    
                    <div class="form-group" >
                        <label for="name" class="col-sm-2 control-label">商品分类：</label>
                        <div class="col-sm-6">
                         <select name="dirId" class="form-control">
                            <option value="1"  ${p.dirId== 1 ? "selected='selected'" : "" } >鼠标</option>
                            <option value="2"  ${p.dirId== 2 ? "selected='selected'" : "" } >无线鼠标</option>
                            <option value="3"  ${p.dirId== 3 ? "selected='selected'" : "" } >有线鼠标</option>
                            <option value="4"  ${p.dirId== 4 ? "selected='selected'" : "" } >游戏鼠标</option>
                         </select>
                        </div>
                    </div>
                    
                    <div class="form-group" >
                        <label for="name" class="col-sm-2 control-label">商品售价：</label>
                        <div class="col-sm-6">
                        <input type="text" class="form-control" id="name" name="salePrice" value="${p.salePrice}" placeholder="请输入商品的售价">
                        </div>
                    </div>
                    
                    <div class="form-group" >
                        <label for="name" class="col-sm-2 control-label">商品供应商：</label>
                        <div class="col-sm-6">
                        <input type="text" class="form-control" id="name" name="supplier" value="${p.supplier}" placeholder="请输入商品的供应商">
                        </div>
                    </div>
                    
                    
                    <div class="form-group" >
                        <label for="name" class="col-sm-2 control-label">商品品牌：</label>
                        <div class="col-sm-6">
                        <input type="text" class="form-control" id="name" name="brand" value="${p.brand}" placeholder="请输入商品的品牌">
                        </div>
                    </div>
                    
                    
                    <div class="form-group" >
                        <label for="name" class="col-sm-2 control-label">商品折扣：</label>
                        <div class="col-sm-6">
                        <input type="text" class="form-control" id="name" name="cutoff" value="${p.cutoff}" placeholder="请输入商品的折扣">
                        </div>
                    </div>
                    
                    <div class="form-group" >
                        <label for="name" class="col-sm-2 control-label">商品成本：</label>
                        <div class="col-sm-6">
                        <input type="text" class="form-control" id="name" name="costPrice" value="${p.costPrice}" placeholder="请输入商品的成本">
                        </div>
                    </div> 
                    
                    <div class="form-group" >
                        <label for="name" class="col-sm-2 control-label">商品图片：</label>
                        <div class="col-sm-6">
                        <input type="file"    name="imagePath" >
                        </div>
                    </div> 
                    
                    <div class="form-group">
                        <div class="col-sm-offset-1 col-sm-6">
                            <button id="btn_submit" type="submit" class="btn btn-default">保存</button>
                            <button type="reset" class="btn btn-default">重置</button>
                        </div>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>
</body>
</html>

list.jsp:

<%@ page contentType="text/html;charset=UTF-8" language="java"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>叩丁狼教育-JavaWEB综合案例</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<%@include file="../common/header.jsp"%>

<script type="text/javascript">
        function goPage(currentPage) {
            //为表单中的currentPage输入框设值
            document.getElementById("currentPage").value = currentPage;
            //提交表单
            document.forms[0].submit();
        }
    </script>
</head>
<body>
    <form class="form-inline" id="searchForm" action="/product"
        method="post">
        <div class="container " style="margin-top: 20px">
            <%@include file="../common/top.jsp"%>
            <br /> <br />
            <div class="row">
                <div class="col-sm-3">
                    <%@include file="../common/menu.jsp"%>
                </div>
                <div class="col-sm-9">
                    <div class="row"></div>
                    <!--高级查询--->
                    <input type="hidden" name="currentPage" id="currentPage" />
                     关键字:<input
                        type="text" name="keyword" value="${qo.keyword }"> 
                    售价: <input
                        type="text" name="minPrice" value="${qo.minPrice }" /> 
                     - <input
                        type="text" name="maxPrice" value="${qo.maxPrice }"> <input
                        type="button" onclick="goPage(1);" value="查询">
                        <a href="/product?cmd=input" class="btn btn-success">添加</a>
                    <table class="table table-striped table-hover">
                        <thead>
                            <tr>
                                <th>序号</th>
                                <th>商品名称</th>
                                <th>商品分类</th>
                                <th>商品售价</th>
                                <th>商品供应商</th>
                                <th>商品品牌</th>
                                <th>商品折扣</th>
                                <th>商品成本价</th>
                                <th>商品缩略图</th>
                                <th>操作</th>
                            </tr>
                        </thead>
                        <c:forEach items="${result.data}" var="entity" varStatus="vs">
                            <tr>
                                <td>${vs.count}</td>
                                <td>${entity.productName}</td>
                                <td>${entity.dirName}</td>
                                <td>${entity.salePrice}</td>
                                <td>${entity.supplier}</td>
                                <td>${entity.brand}</td>
                                <td>${entity.cutoff}</td>
                                <td>${entity.costPrice}</td>
                                <td><img alt="图片失败" width="80px"  src="${entity.imagePath}"></td>
                                <td><a class="btn btn-info btn-xs"
                                    href="/product?cmd=input&id=${entity.id}"> <span
                                        class="glyphicon glyphicon-pencil"></span>编辑
                                </a> <a href="/product?cmd=delete&id=${entity.id}"
                                    class="btn btn-danger btn-xs"> <span
                                        class="glyphicon glyphicon-trash"></span>删除
                                </a></td>
                            </tr>
                        </c:forEach>
                    </table>
                    <div style="text-align: center;">
                        <a href="javascript:;" onclick="goPage(1)">首页</a> <a
                            href="javascript:;" onclick="goPage(${result.prevPage})">上一页</a>
                        <a href="javascript:;" onclick="goPage(${result.nextPage})">下一页</a>
                        <a href="javascript:;" onclick="goPage(${result.endPage})">尾页</a>
                        当前页: ${result.currentPage} / ${result.endPage} 共
                        ${result.totalCount} 条数据
                    </div>
                </div>
            </div>
        </div>
    </form>
</body>
</html>

第19讲.综合案例
项目准备完整代码如下： dao IEmployeeDAO: IProductDAO: dao.impl Empl...
2018-04-22
【第19讲】大学生思维创新与拓展 4月21日下午3点半，由校团委主办的第19期青春之约大讲坛在综合楼四楼报告厅...
时间管理100讲之第39讲：（案例）从体育差等生到跑马拉松
时间管理100讲之第39讲：（案例）从体育差等生到跑马拉松如何将运动放到我们生活的24小时当中？综合的看起，我...
19.综合案例3
HTML: JS:
D20读书笔记～关键对话第10、11章
第10章案例分析主要是对一些常见的复杂案例进行剖析，告诉人们如何应对。此处不多做叙述。第11章综合应用关...
第19讲
19. 螺线管、螺线环、导线圆柱、导电板的磁场：安培环路定理知识点类比法理解静电场的高斯定理和静磁场的安培环路...
[读书笔记] 硅谷产品实战36讲（1）权衡取舍
目录第10讲什么是最小化可行产品（MVP）？第11讲案例：产品发布之前出了乱子，如何权衡取舍？第...
15-HTTPDNS：网络世界的地址簿
本人在“极客时间”上购买了一套“趣谈网络协议”的课程，本文为该课程第19讲（第19讲 HTTPDNS）的课程笔记。...
【啃书系列19】漫谈日记、游记和随笔
今天，为大家分享《72堂写作课》，第19讲日记，第20讲游记，第21讲随笔。一、日记日记，是以时间为单位，将我...
综合案例
来自拉钩教育-JAVA就业集训营 1.商城案例表设计通过对商城项目的部分表关系进行分析,完成数据库表的设计 1....