MyBaits使用接口代理进行增删改查

梦里梦外; 2022-07-15 09:11 193阅读 0赞

> 使用接口代理可以减少语句并且提高开发效率，并且是代码更加整洁规范，减少侵入

*  使用接口代理  
    
    
     *  使用接口是mapper标签的namespace必须为接口的限定名(完整类名)
     *  要求接口抽象方法名和xml文件中的操作的ID名称相同
     *  要求接口抽象方法的参数和xml文件中的参数类型相同
     *  要求接口抽象方法的返回值类型和xml文件中的返回值类型相同

--------------------

*  xml配置文件

<mapper namespace="dao.PresidentDao">
        <insert id="insertPresident" parameterType="President">
            insert into president
            values(#{id},#{name},#{sex},#{salary})
        </insert>
    
        <update id="updatePresident" parameterType="President">
            update president
            set name=#{name} where id=#{id}
        </update>
        <delete id="deletePresident" parameterType="int">
            delete from president where id = #{id}
    
        </delete>
    
        <select id="selectAllPresident" resultType="President">
            select * from
            president
        </select>
    </mapper>

*  接口

public interface PresidentDao {
        public void insertPresident(President p);
        public void updatePresident(President p);
        public void deletePresident(int id);
        public List<President> selectAllPresident();
    }

*  增删改查操作

SqlSession session = MyBatisUtil.openSession();
    PresidentDao dao = session.getMapper(PresidentDao.class);
    
    //insert President p = new President(1, "Obma", "M", 8888.88);
    dao.insertPresident(p);
    session.commit();
    
    //update President p1 = new President(1, "Trump", "M", 8888.88);
    dao.updatePresident(p1);
    session.commit();
    
    //delete dao.deletePresident(1);
    session.commit();
    
    //select List<President> list = dao.selectAllPresident();
    
    session.close();