JavaWeb 品牌管理系统 (四层架构模型实现品牌增删改查)

项目简介

1.四层架构的模型图

2.步骤

1.创建数据库(创建表)
  2.导入需要的jar包（导入WebContent目录下的WEB-INF下的bin目录里面）
  3.创建包：  com.yfh.pojo（装实体类）
             com.yfh.web（装dao类
             com.yfh.service（装service类
             com.yfh.servlet（装servlet类）
             com.yfh.util（装工具类）
  4.创建JDBC工具类（使用Druid数据库连接池
  5.配置数据库及连接池参数（放于src下）
  6.实体类层：用来封装属性及其getset方法 toString方法，有参构造方法，无参构造方法等。
  7.Dao层:对数据库的增删改查方法的封装（操作数据库）也是属于业务逻辑
  8.Servlet（Controller）：流程控制
  9.Service：处理业务逻辑
  10.jsp（View）页面（位于WebContent目录下）
复制代码

项目实现

项目包预览

环境搭建

创建新的模块 brand_demo，并在 pom.xml 文件引入坐标

<projectxmlns="http://maven.apache.org/POM/4.0.0"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"><modelVersion>4.0.0</modelVersion><groupId>org.example</groupId><artifactId>brand-demo</artifactId><packaging>war</packaging><version>1.0-SNAPSHOT</version><name>brand-demo Maven Webapp</name><url>http://maven.apache.org</url><dependencies><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>3.8.1</version><scope>test</scope></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.34</version></dependency><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.5.5</version></dependency><dependency><groupId>jstl</groupId><artifactId>jstl</artifactId><version>1.2</version></dependency><dependency><groupId>javax.servlet</groupId><artifactId>servlet-api</artifactId><version>2.5</version><scope>provided</scope></dependency><dependency><groupId>javax.servlet</groupId><artifactId>javax.servlet-api</artifactId><version>3.1.0</version><scope>provided</scope></dependency><dependency><groupId>taglibs</groupId><artifactId>standard</artifactId><version>1.1.2</version></dependency></dependencies><build><finalName>brand-demo</finalName></build></project>复制代码

在 com.yfh 包下创建三层架构的包结构，并将创建（若现成的则导入）数据库表 tb_brand

在 com.yfh.pojo 包下创建实体类 Brand

/**
* 品牌实体类
*/publicclassBrand {
    // id 主键private Integer id;
    // 品牌名称private String brandName;
    // 企业名称private String companyName;
    // 排序字段private Integer ordered;
    // 描述信息private String description;
    // 状态：0：禁用  1：启用private Integer status;


    publicBrand() {
    }

    publicBrand(Integer id, String brandName, String companyName, String description) {
        this.id = id;
        this.brandName = brandName;
        this.companyName = companyName;
        this.description = description;
    }

    publicBrand(Integer id, String brandName, String companyName, Integer ordered, String description, Integer status) {
        this.id = id;
        this.brandName = brandName;
        this.companyName = companyName;
        this.ordered = ordered;
        this.description = description;
        this.status = status;
    }

    public Integer getId() {
        return id;
    }

    publicvoidsetId(Integer id) {
        this.id = id;
    }

    public String getBrandName() {
        return brandName;
    }

    publicvoidsetBrandName(String brandName) {
        this.brandName = brandName;
    }

    public String getCompanyName() {
        return companyName;
    }

    publicvoidsetCompanyName(String companyName) {
        this.companyName = companyName;
    }

    public Integer getOrdered() {
        return ordered;
    }

    publicvoidsetOrdered(Integer ordered) {
        this.ordered = ordered;
    }

    public String getDescription() {
        return description;
    }

    publicvoidsetDescription(String description) {
        this.description = description;
    }

    public Integer getStatus() {
        return status;
    }

    publicvoidsetStatus(Integer status) {
        this.status = status;
    }

    @Overridepublic String toString() {
        return"Brand{" +
            "id=" + id +
            ", brandName='" + brandName + '\'' +
            ", companyName='" + companyName + '\'' +
            ", ordered=" + ordered +
            ", description='" + description + '\'' +
            ", status=" + status +
            '}';
    }
}

复制代码

准备 MyBatis 基础环境

在 com.yfh.mapper 创建 BrandMapper

publicinterfaceBrandMapper {
}
复制代码

在 resources 文件夹下添加 Mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configurationPUBLIC"-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration><typeAliases><packagename="com.yfh.pojo"/></typeAliases><environmentsdefault="development"><environmentid="development"><transactionManagertype="JDBC"/><dataSourcetype="POOLED"><propertyname="driver"value="com.mysql.jdbc.Driver"/><propertyname="url"value="jdbc:mysql:///test?useSSL=false&amp;useServerPrepStmts=true"/><propertyname="username"value="root"/><propertyname="password"value="root"/></dataSource></environment></environments><mappers><packagename="com.yfh.mapper"/></mappers></configuration>复制代码

在 resources 文件夹下创建 com.yfh.mapper 包，并在该包下创建 BrandMapper.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapperPUBLIC"-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="com.yfh.mapper.BrandMapper"><resultMapid="brandResultMap"type="brand"><resultcolumn="brand_name"property="brandName"></result><resultcolumn="company_name"property="companyName"></result></resultMap></mapper>复制代码

查询所有功能实现

实现 Dao 层，通过 select * from tb_brand 实现查询表中的所有内容

publicinterfaceBrandMapper {

    /**
* 查询所有
* @return
*/@Select("select * from tb_brand")@ResultMap("brandResultMap")
    List<Brand> selectAll();
}

复制代码

在实现 Service 层之前将 SqlSessionFactory 类导入到 com.yfh.util 包下

publicclassSqlSessionFactoryUtils {

    privatestatic SqlSessionFactory sqlSessionFactory;

    static {
        //静态代码块会随着类的加载而自动执行，且只执行一次try {
            Stringresource="mybatis-config.xml";
            InputStreaminputStream= Resources.getResourceAsStream(resource);
            sqlSessionFactory = newSqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }


    publicstatic SqlSessionFactory getSqlSessionFactory(){
        return sqlSessionFactory;
    }
}

复制代码

实现 Service 层，创建 BrandService 类，实现查询所有的逻辑功能 （基本步骤：建立sql会话，通过sql会话获取mapper对象，最后调用存储在一个变量后返回，注意查询完之后一定要关闭会话）

/**
  * 查询所有
  * @return
  */public List<Brand> selectAll(){
    //调用BrandMapper.selectAll()
	SqlSessionFactoryfactory= SqlSessionFactoryUtils.getSqlSessionFactory();

    //1.获取SqlSessionSqlSessionsqlSession= factory.openSession();

    //2.获取BrandMapperBrandMappermapper= sqlSession.getMapper(BrandMapper.class);

    //3.调用方法
    List<Brand> brands = mapper.selectAll();
    sqlSession.close();
    return brands;
}

复制代码

实现 web 层之写好 index.html 页面

<!DOCTYPE html><htmllang="en"><head><metacharset="UTF-8"><title>Title</title></head><body><ahref="/brand-demo/selectAllServlet">查询所有</a></body></html>复制代码

实现 web 层之实现 SelectAllServlet 类实现页面交互

@WebServlet("/selectAllServlet")publicclassSelectAllServletextendsHttpServlet {

        privateBrandServiceservice=newBrandService();

        @OverrideprotectedvoiddoGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {

            //1. 调用BrandService完成查询
            List<Brand> brands = service.selectAll();

            //2.存入request域中
            request.setAttribute("brands",brands);

            //3.转发到brand.jsp
            request.getRequestDispatcher("/brand.jsp").forward(request,response);
        }

        @OverrideprotectedvoiddoPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
            this.doGet(request,response);
        }
    }

复制代码

实现 web 层之在 webapp 包下实现 brand.jsp 页面

<%--
  Created by IntelliJ IDEA.
  User: yy
  Date: 2023/1/10
  Time: 00:41
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html><head><title>Title</title></head><body><ahref="addBrand.jsp"><button>新增</button></a><hr><tableborder="1"cellpadding="0"width="100%"align="center"><tralign="center"><td>序号</td><td>品牌名称</td><td>企业名称</td><td>排序</td><td>品牌介绍</td><td>状态</td><td>操作</td></tr><c:forEachitems="${brands}"var="brand"varStatus="status"><tralign="center"><td>${status.count}</td><td>${brand.brandName}</td><td>${brand.companyName}</td><td>${brand.ordered}</td><td>${brand.description}</td><c:iftest="${brand.status == 1}"><td>启用</td></c:if><c:iftest="${brand.status != 1}"><td>禁用</td></c:if><td><ahref="/selectByIdServlet?id=${brand.id}">编辑</a><ahref="/deleteByIdServlet?id=${brand.id}">删除</a></td></tr></c:forEach></table></body></html>复制代码

查询所有页面效果

添加数据功能实现

实现 Dao 层，通过 insert into tb_brand values(null,brand_name,company_name,ordered,description,status) 实现添加数据

publicinterfaceBrandMapper {

    /**
* 添加数据
* @param brand
*/@Insert("insert into tb_brand values(null,#{brandName},#{companyName},#{ordered},#{description},#{status})")voidadd(Brand brand);
}

复制代码

实现 Service 层，在 BrandService 类，实现查询所有的逻辑功能 （基本步骤：建立sql会话，通过sql会话获取mapper对象，最后调用并commit，注意查询完之后一定要关闭会话）

/**
  * 添加数据
  * @param brand
  */publicvoidadd(Brand brand){
    //调用BrandMapper.selectAll()
	SqlSessionFactoryfactory= SqlSessionFactoryUtils.getSqlSessionFactory();
	
    //1.获取SqlSessionSqlSessionsqlSession= factory.openSession();

    //2.获取brandMapperBrandMappermapper= sqlSession.getMapper(BrandMapper.class);

    //3.调用方法
    mapper.add(brand);
    sqlSession.commit();
    sqlSession.close();
}

复制代码

实现 web 层之在 brand.jsp 的头部添加添加 “按钮”

<inputtype="button"value="新增"id="add"><br>复制代码

实现 web 层之在 brand.jsp 的下面实现添加按钮的 js 脚本

<script>document.getElementById("add").onclick = function (){
        location.href = "/brand-demo/addBrand.jsp";
    }
</script>复制代码

实现 web 层之写好 addBrand.jsp 页面

<%--
  Created by IntelliJ IDEA.
  User: yy
  Date: 2023/1/10
  Time: 13:52
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html><head><title>添加品牌</title></head><body><h3>添加品牌</h3><formaction="/addServlet"method="post">
        品牌名称：<inputtype="text"name="brandName"><br>
        企业名称：<inputtype="text"name="companyName"><br>
        排序：<inputtype="number"name="ordered"><br>
        描述信息：<textareaname="description"rows="1"cols="20"></textarea><br>
        状态：
        <inputtype="radio"name="status"value="0"> 禁用
        <inputtype="radio"name="status"value="1"> 启用 <br><buttontype="submit">提交</button></form></body></html>复制代码

实现 web 层之实现 AddServlet 类实现页面交互

@WebServlet("/addServlet")publicclassAddServletextendsHttpServlet {

        privateBrandServiceservice=newBrandService();

        @OverrideprotectedvoiddoGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {

            //处理POST请求的编码处理问题
            request.setCharacterEncoding("utf-8");

            //1.接收表单提交的数据，封装为一个Brand对象StringbrandName= request.getParameter("brandName");
            StringcompanyName= request.getParameter("companyName");
            Stringordered= request.getParameter("ordered");
            Stringdescription= request.getParameter("description");
            Stringstatus= request.getParameter("status");

            Brandbrand=newBrand();
            brand.setBrandName(brandName);
            brand.setCompanyName(companyName);
            brand.setOrdered(Integer.parseInt(ordered));
            brand.setDescription(description);
            brand.setStatus(Integer.parseInt(status));

            //2.调用Service，完成添加
            service.add(brand);

            //3.转发到查询所有Servlet
            request.getRequestDispatcher("selectAllServlet").forward(request,response);
        }

        @OverrideprotectedvoiddoPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
            this.doGet(request,response);
        }
    }

复制代码

添加数据页面效果

修改数据功能实现

回显数据

实现 Dao 层，通过 select * from tb_brand where id=#{id} 实现添加数据

publicinterfaceBrandMapper {

    /**
* 根据id查询
* @param id
* @return
*/@Select("select * from tb_brand where id=#{id}")@ResultMap("brandResultMap")
    Brand selectById(int id);
}

复制代码

实现 Service 层，创建 BrandService 类，实现根据id查询逻辑功能 （基本步骤：建立sql会话，通过sql会话获取mapper对象，最后调用存储在一个变量后返回，注意查询完之后一定要关闭会话）；

/**
 * 根据id查询
 * @param id
 * @return
 */public Brand selectById(int id){
    //调用BrandMapper.selectById(id)SqlSessionFactoryfactory= SqlSessionFactoryUtils.getSqlSessionFactory();

    //1.获取SqlSessionSqlSessionsqlSession= factory.openSession();

    //2.获取BrandMapperBrandMappermapper= sqlSession.getMapper(BrandMapper.class);
    
    //3.调用方法Brandbrand= mapper.selectById(id);
    sqlSession.close();
    return brand;
}

复制代码

修改数据

实现 Dao 层，通过 update tb_brand set brand_name=#{brandName},company_name=#{companyName},ordered=#{ordered},description=#{description},status=#{status} where id=#{id} 实现修改数据

@Update("update tb_brand set brand_name=#{brandName},company_name=#{companyName},ordered=#{ordered},description=#{description},status=#{status} where id=#{id}")@ResultMap("brandResultMap")voidupdate(Brand brand);
复制代码

实现 Service 层，创建 BrandService 类，调用修改数据功能 （基本步骤：建立sql会话，通过sql会话获取mapper对象，注意查询完之后一定要关闭会话）；

/**
 * 修改数据
 * @param brand
 */publicvoidupdate(Brand brand){
    //调用BrandMapper.update(brand)
	SqlSessionFactoryfactory= SqlSessionFactoryUtils.getSqlSessionFactory();
	
    //1. 获取SqlSessionSqlSessionsqlSession= factory.openSession();

    //2.获取BrandMapperBrandMappermapper= sqlSession.getMapper(BrandMapper.class);

    //3.调用方法
    mapper.update(brand);
    sqlSession.commit();
    sqlSession.close();
}

复制代码

实现 web 层之在 brand.jsp 页面把修改链接添加链接地址

实现 web 层之在 brand.jsp 页面把修改链接添加链接地址
复制代码

实现 web 层之在 updata.jsp 页面回显数据，注意回显的数据回传回id，需要把id隐藏起来，这是不需要展现给用户来看的；

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%--
  Created by IntelliJ IDEA.
  User: yy
  Date: 2023/1/10
  Time: 15:17
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %>
<html><head><title>编辑</title></head><body><h3>编辑品牌</h3><formaction="/upDateServlet"method="post"><inputtype="text"name="id"value="${brand.id}">
    品牌名称：<inputtype="text"name="brandName"value="${brand.brandName}"><br>
    企业名称：<inputtype="text"name="companyName"value="${brand.companyName}"><br>
    排序：<inputtype="text"name="ordered"value="${brand.ordered}"><br>
    描述信息：<textareaname="description"rows="1"cols="20">${brand.description}</textarea><br>
    状态：
   <c:iftest="${brand.status == 0}"><inputtype="radio"name="status"value="0"checked> 禁用
       <inputtype="radio"name="status"value="1"> 启用 <br></c:if><c:iftest="${brand.status == 1}"><inputtype="radio"name="status"value="0"> 禁用
        <inputtype="radio"name="status"value="1"checked> 启用 <br></c:if><buttontype="submit">提交</button></form></body></html>复制代码

实现 web 层之实现 UpdateServlet 类实现页面交互

@WebServlet("/updateServlet")publicclassUpdateServletextendsHttpServlet {

        privateBrandServiceservice=newBrandService();

        @OverrideprotectedvoiddoGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {

            //处理POST请求的编码处理问题
            request.setCharacterEncoding("utf-8");

            //1.接收表单提交的数据，封装为一个Brand对象Stringid= request.getParameter("id");
            StringbrandName= request.getParameter("brandName");
            StringcompanyName= request.getParameter("companyName");
            Stringordered= request.getParameter("ordered");
            Stringdescription= request.getParameter("description");
            Stringstatus= request.getParameter("status");

            Brandbrand=newBrand();
            brand.setId(Integer.parseInt(id));
            brand.setBrandName(brandName);
            brand.setCompanyName(companyName);
            brand.setOrdered(Integer.parseInt(ordered));
            brand.setDescription(description);
            brand.setStatus(Integer.parseInt(status));

            //2.调用Service，完成修改
            service.update(brand);

            //3.转发到SelectAllServlet
            request.getRequestDispatcher("selectAllServlet").forward(request,response);
        }

        @OverrideprotectedvoiddoPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
            this.doGet(request,response);
        }
    }

复制代码

删除数据（额外添加的功能）

实现 Dao 层，通过 delete from tb_brand where id=#{id} 实现删除数据

/**
  * 根据id删除数据
  * @param id
  */@Delete("delete from tb_brand where id=#{id}")@ResultMap("brandResultMap")voiddeleteById(int id);

复制代码

实现 Service 层，创建 BrandService 类，调用删除数据功能 （基本步骤：建立sql会话，通过sql会话获取mapper对象，注意查询完之后一定要关闭会话）；

/**
 * 根据id删除数据
 * @param id
 */publicvoiddelete(int id){
    //调用BrandMapper.delete(id)
	SqlSessionFactoryfactory= SqlSessionFactoryUtils.getSqlSessionFactory();

    //1.获取SqlSessionSqlSessionsqlSession= factory.openSession();

    //2.获取BrandMapperBrandMappermapper= sqlSession.getMapper(BrandMapper.class);

    //3.调用方法
    mapper.deleteById(id);
    sqlSession.commit();
    sqlSession.close();
}

复制代码

实现 web 层之在 brand.jsp 页面把删除链接添加链接地址

<a href="/brand-demo/deleteByIdServlet?id=${brand.id}">删除</a>
复制代码

实现 web 层之实现 DeleteByIdServlet 类实现页面交互

@WebServlet("/deleteByIdServlet")publicclassDeleteByIdServletextendsHttpServlet {

    privateBrandServiceservice=newBrandService();

    @OverrideprotectedvoiddoGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {

        //1.接收需要删除数据的idStringid= request.getParameter("id");

        //2.调用Service
        service.delete(Integer.parseInt(id));

        //3.转发至SelectAllServlet
        request.getRequestDispatcher("selectAllServlet").forward(request,response);
    }

    @OverrideprotectedvoiddoPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
        this.doGet(request,response);
    }
}

作者：遐想

链接：https://juejin.cn/post/7201282972967911482