第九次作业已完成

<?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.workspace.Mapper.ComponentMapper">
    <select id="selectall" resultType="com.workspace.Pojo.Component">
    select * from component
    </select>
    <select id="SelectPart" resultType="com.workspace.Pojo.Component">
        select * from component where CNo=#{cno}
    </select>
    <update id="Update" >
        update Component set BName=#{bname},BNO=#{bno},User=#{user} where BNo=#{bno}
    </update>
    <insert id="Insert">
        insert into Component values (#{bname},#{bno},#{user})
    </insert>
    <delete id="Delete">
        delete from Component where BNo=#{bno}
    </delete>
</mapper>