黑马程序员javaweb增删改查笔记brand

#黑马程序员javaweb增删改查笔记brand| 来源: 网络整理| 查看: 265

浅浅记录一下ba 中间出现了不少bug 感谢其他小伙伴的解答

mapper:BrandMapper--->

package com.itheima.mapper; import com.itheima.pojo.Brand; import org.apache.ibatis.annotations.*; import java.util.List; public interface BrandMapper { /** * 查询所有 * @return */ @Select("select * from tb_brand") @ResultMap("brandResultMap") List selectAll(); /** * 添加 * @param brand */ @Insert("insert into tb_brand values (null,#{brandName},#{companyName},#{ordered},#{description},#{status})") void add(Brand brand); /** * 修改（回显）根据id 查询 * @return */ @ResultMap("brandResultMap") @Select("select * from tb_brand where id=#{id}") Brand selectByIdBrand(int id); /** * 修改 * @param brand */ @Update( "update tb_brand set brand_name=#{brandName},company_name=#{companyName},ordered=#{ordered},description=#{description},STATUS=#{status} where id = #{id}") void update(Brand brand); /** * 删除 */ @Delete("delete from tb_brand where id=#{id}") void deleteById(Brand brand); }

pojo:Brand--->

package com.itheima.pojo; /** * 品牌实体类 */ public class Brand { // id 主键 private Integer id; // 品牌名称 private String brandName; // 企业名称 private String companyName; // 排序字段 private Integer ordered; // 描述信息 private String description; // 状态：0：禁用 1：启用 private Integer status; public Brand() { } public Brand(Integer id, String brandName, String companyName, String description) { this.id = id; this.brandName = brandName; this.companyName = companyName; this.description = description; } public Brand(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; } public void setId(Integer id) { this.id = id; } public String getBrandName() { return brandName; } public void setBrandName(String brandName) { this.brandName = brandName; } public String getCompanyName() { return companyName; } public void setCompanyName(String companyName) { this.companyName = companyName; } public Integer getOrdered() { return ordered; } public void setOrdered(Integer ordered) { this.ordered = ordered; } public String getDescription() { return description; } public void setDescription(String description) { this.description = description; } public Integer getStatus() { return status; } public void setStatus(Integer status) { this.status = status; } @Override public String toString() { return "Brand{" + "id=" + id + ", brandName='" + brandName + '\'' + ", companyName='" + companyName + '\'' + ", ordered=" + ordered + ", description='" + description + '\'' + ", status=" + status + '}'; } }

service:BrandService--->

package com.itheima.service; import com.itheima.mapper.BrandMapper; import com.itheima.pojo.Brand; import com.itheima.util.SqlSessionFactoryUtils; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import java.util.List; public class BrandService { SqlSessionFactory factory = SqlSessionFactoryUtils.getSqlSessionFactory(); /** * 查询 * @return */ public List selectAll(){ //1.调用BrandMapper SqlSession sqlSession = factory.openSession(); BrandMapper mapper = sqlSession.getMapper(BrandMapper.class); List brands = mapper.selectAll(); sqlSession.close(); return brands; } /** * 添加 */ public void add(Brand brand){ SqlSession sqlSession = factory.openSession(); BrandMapper mapper = sqlSession.getMapper(BrandMapper.class); mapper.add(brand); sqlSession.commit(); sqlSession.close(); } /** * 根据id 查询 * @param id * @return */ public Brand selectById(int id){ SqlSession sqlSession = factory.openSession(); BrandMapper mapper = sqlSession.getMapper(BrandMapper.class); Brand brand = mapper.selectByIdBrand(id); sqlSession.close(); return brand; } /** * 修改 */ public void update(Brand brand){ SqlSession sqlSession = factory.openSession(); BrandMapper mapper = sqlSession.getMapper(BrandMapper.class); mapper.update(brand); sqlSession.commit(); sqlSession.close(); } /** * 删除 * @param * @return */ public void deleteById(Brand brand){ SqlSession sqlSession = factory.openSession(); BrandMapper mapper = sqlSession.getMapper(BrandMapper.class); mapper.deleteById(brand); sqlSession.commit(); sqlSession.close(); } }

util:SqlSessionFactoryUtils--->

package com.itheima.util; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import java.io.IOException; import java.io.InputStream; public class SqlSessionFactoryUtils { private static SqlSessionFactory sqlSessionFactory; static { //静态代码块会随着类的加载而自动执行，且只执行一次 try { String resource = "mybatis-config.xml"; InputStream inputStream = Resources.getResourceAsStream(resource); sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); } catch (IOException e) { e.printStackTrace(); } } public static SqlSessionFactory getSqlSessionFactory(){ return sqlSessionFactory; } }

web:AddServlet--->

package com.itheima.web; import com.itheima.pojo.Brand; import com.itheima.service.BrandService; import javax.servlet.*; import javax.servlet.http.*; import javax.servlet.annotation.*; import java.io.IOException; @WebServlet("/AddServlet") public class AddServlet extends HttpServlet { private BrandService service = new BrandService(); @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //处理Post请求的乱码问题 request.setCharacterEncoding("utf-8"); //接受表单提交的数据，封装为一个Brand对象 String brandName = request.getParameter("brandName"); String companyName = request.getParameter("companyName"); String ordered = request.getParameter("ordered"); String description = request.getParameter("description"); String status = request.getParameter("status"); //封装对象 Brand brand = new Brand(); brand.setBrandName(brandName); brand.setCompanyName(companyName); brand.setOrdered(Integer.parseInt(ordered)); brand.setDescription(description); brand.setStatus(Integer.parseInt(status)); //调用service 完成添加 service.add(brand); //转发到查询所有Servlet request.getRequestDispatcher("selectAllServlet").forward(request,response); } @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doGet(request, response); } }

deleteServlet-->

selectAllServlet-->

selectByIdServlet-->

updateServlet-->

package com.itheima.web; import com.itheima.pojo.Brand; import com.itheima.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; @WebServlet("/updateServlet") public class updateServlet extends HttpServlet { private BrandService service = new BrandService(); @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //处理Post请求的乱码问题 request.setCharacterEncoding("utf-8"); //接受表单提交的数据，封装为一个Brand对象 String id = request.getParameter("id"); String brandName = request.getParameter("brandName"); String companyName = request.getParameter("companyName"); String ordered = request.getParameter("ordered"); String description = request.getParameter("description"); String status = request.getParameter("status"); //封装对象 Brand brand = new Brand(); brand.setId(Integer.parseInt(id)); brand.setBrandName(brandName); brand.setCompanyName(companyName); brand.setOrdered(Integer.parseInt(ordered)); brand.setDescription(description); brand.setStatus(Integer.parseInt(status)); //调用service 完成修改 service.update(brand); //转发到查询所有Servlet request.getRequestDispatcher("selectAllServlet").forward(request,response); } @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doGet(request, response); } }

resources:BrandMapper.xml--->

mybatis-config.xml-->

webapp:addBrand.jsp-->

添加品牌添加品牌品牌名称：企业名称：排序：描述信息：状态：禁用启用

brand.jsp--->

Title 序号品牌名称企业名称排序品牌介绍状态操作 ${status.count} ${brand.brandName} ${brand.companyName} ${brand.ordered} ${brand.description} 启用禁用修改删除 document.getElementById("add").onclick = function (){ location.href="/brand-demo0/addBrand.jsp" }

index.html--->

Title 查询所有

update.jsp-->

修改品牌修改品牌品牌名称：企业名称：排序：描述信息：${brand.description} 状态：禁用启用禁用启用

搞定！

【本文地址】

公司简介

联系我们