表现层
@WebServlet("/addBrandServlet")
public class addBrandServlet extends HttpServlet {
private BrandService brandService = new BrandService();
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
// 获取所有参数
Map<String, String[]> parameterMap = request.getParameterMap();
Brand brand = new Brand();
// 有一个工具类可以将数据一次性全部封装进实体类中
try {
BeanUtils.populate(brand,parameterMap);
} catch (Exception e) {
e.printStackTrace();
}
System.out.println(brand);
// 调用业务逻辑层操作数据库
brandService.addBrand(brand);
// 如果使用请求转发的话,在前端页面点击刷新就会执行一次数据库添加
// 所以这里使用重定向
// 这里会重新调用一次查询,并且将更新的数据展示在控制台
response.sendRedirect(request.getContextPath()+"/selectAllServlet");
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
}
业务逻辑层
public class BrandService {
// 业务逻辑层操作数据库添加数据
public void addBrand(Brand brand){
SqlSessionFactory sqlSessionFactory = SqlSessionFactoryUtils.getSqlSessionFactory();
SqlSession sqlSession = sqlSessionFactory.openSession(true);
BrandMapper mapper = sqlSession.getMapper(BrandMapper.class);
mapper.addBrand(brand);
sqlSession.close();
}
}
数据访问层
public interface BrandMapper {
// 添加数据
void addBrand(Brand brand);
}
数据库操作
<?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.cyf.mapper.BrandMapper">
<resultMap id="brand" type="com.cyf.pojo.Brand">
<result column="brand_name" property="brandName"/>
<result column="company_name" property="companyName"/>
</resultMap>
<insert id="addBrand" >
insert into tb_brand() values (null,#{brandName},#{companyName},#{ordered},#{description},#{status})
</insert>
</mapper>
前端页面
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>添加品牌</title>
</head>
<body>
<h3>添加品牌</h3>
<form action="/brand_demo/addBrandServlet" method="post">
品牌名称:<input type="text" name="brandName" onblur="checkName()" id="brandName"><span id="brandName_err" style=" display: none">请输入品牌名</span><br>
企业名称:<input name="companyName"><br>
排序:<input name="ordered"><br>
描述信息:<textarea rows="5" cols="20" name="description"></textarea><br>
状态:
<input type="radio" name="status" value="0">禁用
<input type="radio" name="status" value="1">启用<br>
<input type="submit" value="提交">
</form>
</body>
</html>