请问老师通过点击各个分类查找并显示相应的类的图书的逻辑代码需要在book.xml中书写吗

<br>

//        private Book showPartBook(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {<br>//           String category=req.getParameter("category");<br>//            HttpSession session = req.getSession();<br>//            session.setAttribute("list", bookList);<br>//            List<Book> list=new ArrayList<Book>();<br>//           for(Book b:list){<br>//               if(b.getCategoryId().equals(category.categoryId)){<br>//                list.add(b);<br>//<br>//               }<br>//           }<br>//            return (Book) list;<br>             //req.setAttribute("bookList",list);<br>//            req.getRequestDispatcher("/WEB-INF/jsp/book.jsp").forward(req, resp);<br>//        }<br><br><br>book.xml:<br><?xml version="1.0" encoding="UTF-8"?><br><br><!DOCTYPE mapper SYSTEM "http://mybatis.org/dtd/mybatis-3-mapper.dtd" PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"/><br><br><!--namespace与包名类名一致--><br><br>        <mapper namespace="com.imooc.oa.dao.BookDao"><br><br>    <!--id与方法名对应 parameterType与方法参数类型对应 resultType与方法返回类型对应--><br><br>        <select resultType="com.imooc.oa.entity.Book" parameterType="Integer" id="selectById">select * from book </select><br>    <select resultType="com.imooc.oa.entity.Book" parameterType="Integer" id="selectById">select * from book where category_id=#{value} </select><br>   <insert id="insert" parameterType="com.imooc.oa.entity.Book" useGenerateKeys="true" keyProperty="id" keyColumn="id"><br>        INSERT INTO (category_id,name,level,price,img_path,create_time,update_time)<br>        VALUES(#{categoryId},#{name},#{level},#{price},#{imgPath},#{createTime},#{updateTime})<br>        </insert><br></mapper><br>

qq_慕神0589333 2021-06-21

源自：慕课OA系统实现 9-2 项目作业

收起

1回答

好帮手慕小班回答被采纳获得+3积分 2021-06-21 15:46:25

同学你好，通过各个分类查找图书对应的类就是根据分类id查询对应分类的图书，这是一个查询方法，所以需要在book.xml中添加这样的方法实现。

祝学习愉快~

收起回答

qq_慕神0589333 提问者 #1

如上这段查询全部图书信息和通过分类id查询图书信息都要写吧

<select resultType="com.imooc.oa.entity.Book" parameterType="Integer" id="selectById">select * from book </select><br>
    <select resultType="com.imooc.oa.entity.Book"
parameterType="Integer" id="selectById">select * from book where 
category_id=#{value} </select>