文章目录
添加数据
流程图
编写BrandMapper接口
package com.taotao.mapper;
import com.taotao.pojo.Brand;
import org.apache.ibatis.annotations.ResultMap;
import org.apache.ibatis.annotations.Select;
import java.util.List;
/**
* create by 刘鸿涛
* 2022/3/29 16:12
*/
public interface BrandMapper {
//查询所有
List<Brand> selectAll();
//添加、新增数据
void add(Brand brand);
}
编写BrandMapper.xml
可以再BrandMapper.java中生成statement，alt + enter自动识别
<?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="com.taotao.mapper.BrandMapper">
<!-- 查询所有功能-->
<select id="selectAll" resultMap="brandResultMap">
select *
from tb_brand
</select>
<resultMap id="brandResultMap" type="brand">
<result column="brandName" property="brand_name"></result>
<result column="companyName" property="company_name"></result>
</resultMap>
<!-- 添加功能-->
<insert id="add" >
insert into tb_brand
# (brandName,companyName,ordered,description,status)
values (#{id},#{brand_name},#{company_name},#{ordered},#{description},#{status});
</insert>
</mapper>
编写BrandService.java
package com.taotao.service;
import com.taotao.mapper.BrandMapper;
import com.taotao.pojo.Brand;
import com.taotao.util.SqlSessionfactoryUtils;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import java.util.List;
/**
* create by 刘鸿涛
* 2022/3/29 16:59
*/
@SuppressWarnings({"all"})
public class BrandService {
SqlSessionFactory factory = SqlSessionfactoryUtils.getSqlSessionFactory();
/**
* 查询所有
* @return
*/
public List<Brand> selectAll(){
//调用BrandMapper.selectAll()
//2.获取sqlSession
SqlSession sqlSession = factory.openSession();
//3.获取BrandMapper
BrandMapper mapper = sqlSession.getMapper(BrandMapper.class);
//4.调用方法
List<Brand> brands = mapper.selectAll();
//5.关闭资源
sqlSession.close();
return brands;
}
/**
* 添加数据
*/
public void add(Brand brand){
//调用BrandMapper.add(Brand brand);
//2.获取sqlSession
SqlSession sqlSession = factory.openSession();
//3.获取BrandMapper
BrandMapper mapper = sqlSession.getMapper(BrandMapper.class);
//4.调用方法
mapper.add(brand);
//5.提交事务
sqlSession.commit();
//6.释放资源
sqlSession.close();
}
}
点击“新增”跳转到JSP表单
编写index.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<a href="/brand_demo/selectAllServlet">查询所有</a>
</body>
</html>
编写brand.jsp
点击“新增”，转到addBrand.jsp
<%--
Created by IntelliJ IDEA.
User: guigui
Date: 2022/3/29
Time: 10:32
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ page isELIgnored="false" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<input type="button" value="新增" id="add"><br>
<hr>
<table border="1" cellspacing="0" width="800">
<tr>
<th>序号</th>
<th>品牌名称</th>
<th>公司名称</th>
<th>价格</th>
<th>描述</th>
<th>状态</th>
</tr>
<c:forEach items="${brands}" var="brand" varStatus="status">
<tr align="center">
<td>${brand.id}</td>
<td>${brand.brand_name}</td>
<td>${brand.company_name}</td>
<td>${brand.ordered}</td>
<td>${brand.description}</td>
<c:if test="${brand.status == 1}">
<td>启用</td>
</c:if>
<c:if test="${brand.status != 1}">
<td>禁用</td>
</c:if>
</tr>
</c:forEach>
<script>
document.getElementById("add").onclick = function (){
location.href = "/brand_demo/addBrand.jsp";
}
</script>
</table>
</body>
</html>
编写addBrand.jsp
<%--
Created by IntelliJ IDEA.
User: guigui
Date: 2022/3/31
Time: 12:43
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%--<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>--%>
<%--<%@ page isELIgnored="false" %>--%>
<html>
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<h3>添加品牌</h3>
<form action="/brand_demo/AddServlet" method="post" id="aa">
<%-- 序号：<input type="text" name="id"><br>--%>
品牌名称：<input type="text" name="brand_name"><br>
企业名称：<input type="text" name="company_name"><br>
排序：<input type="text" name="ordered"><br>
描述信息：<input type="text" name="description">
状态：<input type="radio" name="status" value="0">禁用
<input type="radio" name="status" value="1" >启用
<input type="submit" >
</form>
</body>
</html>
升级addBrand.jsp表单页面
<%--
Created by IntelliJ IDEA.
User: guigui
Date: 2022/3/31
Time: 12:43
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%--<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>--%>
<%--<%@ page isELIgnored="false" %>--%>
<html>
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<style>
* {
margin: 0; /*外边距*/
padding: 0; /*内边距 */
font-family: "微软雅黑 Light";
} /*清除所有默认样式*/
:root,form { /*选择最外层标签HTML*/
height: 70%;
display: flex; /*改变元素*/
align-items: center; /*垂直方向对齐方式*/
justify-content: center; /*水平方向子项的对齐和分布方式*/
}
form {
flex-direction: column; /*控制子项整体布局方向（从上到下）*/
padding: 40px; /*上内边距*/
width: 300px; /*盒子模型宽*/
box-shadow: 0 15px 20px rgba(0, 0, 0, 0.5); /*应用阴影 a是alpha “透明 ”的意思*/
}
.form-title {
margin-bottom: 20px; /*下外边距*/
}
.form-input,
.form-radio,
.form-button {
width: 100%;
margin-bottom: 20px; /*下外边距*/
}
.form-input input { /*两个选择器具有包含关系*/
padding-left: 10px;
height: 40px;
width: 100%;
box-sizing: border-box; /*盒子边框*/
border: 2px solid rgba(0, 0, 0, 0.82); /*边框线宽度，样式（实线），颜色*/
}
.form-radio,
.form-button {
height: 40px;
display: flex; /*控制元素类型*/
align-items: center;
justify-content: space-between;
}
.form-radio-choose {
display: flex;
align-items: center;
}
.form-radio-choose input {
margin-right: 20px; /*右外边距*/
height: 30px;
width: 30px;
}
.form-button {
justify-content: center;
background-color: black;
color: white;
}
</style>
<%--<body>--%>
<%-- <h3>添加品牌</h3>--%>
<%-- <form action="/brand_demo/AddServlet" method="post" id="aa">--%>
<%--<%– 序号：<input type="text" name="id"><br>–%>--%>
<%-- 品牌名称：<input type="text" name="brand_name"><br>--%>
<%-- 企业名称：<input type="text" name="company_name"><br>--%>
<%-- 排序：<input type="text" name="ordered"><br>--%>
<%-- 描述信息：<input type="text" name="description">--%>
<%-- 状态：<input type="radio" name="status" value="0">禁用--%>
<%-- <input type="radio" name="status" value="1" >启用--%>
<%-- <input type="submit" >--%>
<%-- </form>--%>
<%-- </body>--%>
<body>
<form action="/brand_demo/AddServlet" method="post">
<div class="form-title">
<h2>
Add Data
</h2>
</div> <!--块容器标记实现网页的规划和布局-->
<div class="form-input">
<input type="text" placeholder="Brand Name：" name="brand_name">
</div>
<div class="form-input">
<input type="text" placeholder="Company Name：" name="company_name">
</div>
<div class="form-input">
<input type="text" placeholder="Price：" name="ordered">
</div>
<div class="form-input">
<input type="text" placeholder="Remarks：" name="description">
</div>
<div class="form-radio">
<div class="form-radio-title">Status:</div>
<div class="form-radio-choose">
<input type="radio" checked="checked" value="1" name="status" />On
</div>
<div class="form-radio-choose">
<input type="radio" value="0" name="status"/>Off
</div>
</div>
<div class="form-button">
<%-- <input type="radio" name="status" value="0">禁用--%>
<%-- <input type="radio" name="status" value="1" >启用--%>
<input class="form-button" type="submit" value="Submit">
</div>
<%-- <div class="form-button">--%>
<%--<%– <p>重置</p>–%>--%>
<%-- </div>--%>
</form>
</body>
</html>
编写AddServlet
com.taotao.web.AddServlet.java
package com.taotao.web;
import com.taotao.pojo.Brand;
import com.taotao.service.BrandService;
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 java.io.IOException;
/**
* create by 刘鸿涛
* 2022/3/31 12:02
*/
@WebServlet("/AddServlet")
public class AddServlet extends HttpServlet {
private BrandService service = new BrandService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//1.调用BrandService完成添加
String brandName = req.getParameter("brand_name");
String companyName = req.getParameter("company_name");
String ordered = req.getParameter("ordered");
String description = req.getParameter("description");
String status = req.getParameter("status");
//封装为一个Brand对象
Brand brand = new Brand();
brand.setBrand_name(brandName);
brand.setCompany_name(companyName);
brand.setOrdered(Integer.parseInt(ordered));
brand.setDescription(description);
brand.setStatus(Integer.parseInt(status));
//2.调用add方法，传入brand对象
service.add(brand);
//3.存入到requset域中
// req.setAttribute("brands",brand);
//4.转发到查询所有servlet中
req.getRequestDispatcher("/selectAllServlet").forward(req,resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//处理Post请求的乱码问题
req.setCharacterEncoding("utf-8");
this.doGet(req, resp);
}
}
测试运行
虽然中途遇到无数个bug，但是依然完美运行
解决的bug有form写成from的，导致提交表单无响应
网页提交404，路径指引错误
post请求中文乱码，在servlet，post请求里设置去utf-8字符编码即可
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
